C_PFMGoodsMovementDocumentDEX

Material flow data extractor for PFM | view: CPFMGDSMVTDDEX | TRAN | Extraction: Full only | Component: Sus. Mgmt : foot print mgmt - Integration with S4
Tables used: MATDOCMARA
Column Name Description
MaterialDocumentKey1 Key field 1
MaterialDocumentKey2 Key field 2
MaterialDocumentKey3 Key field 3
MaterialDocumentKey4 Key field 4
MaterialDocumentKey5 Key field 5
MaterialDocumentKey6 Key field 6
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
TotalGoodsMvtAmtInCCCrcy Amount in Local Currency
GoodsMovementStkAmtInCCCrcy Amount in Local Currency with Sign of Stock Quantity
GoodsMvtCnsmpnAmtInCCCrcy Amount in Local Currency with Sign of Consumption Quantity
Column Name Description
📏 Base Unit of Measure (MaterialBaseUnit):
MatlStkChangeQtyInBaseUnit Stock Quantity
MatlCnsmpnQtyInMatlBaseUnit Consumption Quantity
QuantityInBaseUnit Quantity
Column Name Description
DocumentDate Document Date in Document
CreationDate Day On Which Accounting Document Was Entered
CreationTime Time of Entry
PostingDate Posting Date in the Document
Column Name Description
InventoryStockType Stock Type of Goods Movement (Stock Identifier) Show values
IsReversalMovementType Has Reversal Movement Type Show values
StockChangeCategory Stock Change Category Show values
IsCrossPlantTransfer Is Cross Plant Transfer Show values
Column Name Description Domain name
MaterialDocument Number of Material Document BELNR
MaterialDocumentItem Material Document Item MBLPO
MaterialDocumentYear Material Document Year GJAHR
Plant Plant WERKS
StorageLocation Storage location LGORT
Material Material Number MATNR
InventorySpecialStockType Special Stock Type SOBKZ
StockOwner Additional Supplier for Special Stock LIFNR
CompanyCode Company Code BUKRS
IssuingOrReceivingPlant Transfer Plant WERKS
IssuingOrReceivingStorageLoc Receiving/issuing storage location LGORT
CalendarQuarter Quarter (1 - 4)
CalendarMonth Month (1 - 12)
CalendarWeek Calendar Week (1 - 53)
SalesOrder Sales Order Number VBELN
PurchaseOrder Purchase order number EBELN
ProjectNetwork Network Number for Account Assignment AUFNR
DeliveryDocument Delivery VBELN
WBSElementInternalID WBS Element
ManufacturingOrder Manufacturing Order AUFNR
InvtryMgmtReferenceDocument Document No. of a Reference Document BELNR
GoodsMovementType Movement type (inventory management) BWART
Supplier Vendor's account number LIFNR
Customer Account number of customer KUNNR
Master Data Relations Join Conditions
Material Group
  • Material Group
  • Client
  • C_PFMGOODSMOVEMENTDOCUMENTDEX.MATERIALGROUP == T023.MATKL
  • C_PFMGOODSMOVEMENTDOCUMENTDEX.MANDT == T023.MANDT