C_RDPGoodsMovementDocumentDEX

Goods Movement Extractor for RDP | view: CRDPGDSMVTDDEX | TRAN | Extraction: Full or Incremental | Component: Sustainability - RDP integration with S4
Tables used: MATDOCMARAADCPADRCKNA1T001WMARALFA1
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
Column Name Description
📏 Base Unit of Measure (MaterialBaseUnit):
QuantityInBaseUnit Quantity
MatlStkChangeQtyInBaseUnit Stock Quantity
📏 Unit of entry (EntryUnit):
QuantityInEntryUnit Quantity in unit of entry
Column Name Description
PostingDate Posting Date in the Document
CreationDate Day On Which Accounting Document Was Entered
CreationTime Time of Entry
ManufactureDate Date of Manufacture
Column Name Description
GoodsMovementIsCancelled Item has been Cancelled Show values
IsReversalMovementType Has Reversal Movement Type Show values
GoodsMovementRefDocType Goods movement ref doc type Show values
MaterialCategory Product Category Show values
StockChangeCategory Stock Change Category Show values
IsCrossPlantTransfer Is Cross Plant Transfer Show values
Column Name Description Domain name
StockIdentifyingMaterial Material in Respect of Which Stock is Managed MATNR
Plant Plant WERKS
InventorySpecialStockType Special Stock Type SOBKZ
CompanyCode Company Code BUKRS
CalendarQuarter Quarter (1 - 4)
CalendarMonth Month (1 - 12)
CalendarWeek Calendar Week (1 - 53)
CalendarDayOfYear Day of Year (1 - 366)
MaterialDocument Number of Material Document BELNR
MaterialDocumentYear Material Document Year GJAHR
MaterialDocumentItem Material Document Item MBLPO
MaterialDocumentLine Unique Identification of Document Line MB_LINE_ID
SalesOrder Sales Order Number VBELN
PurchaseOrder Purchase order number EBELN
InvtryMgmtReferenceDocument Document No. of a Reference Document BELNR
ManufacturingOrder Manufacturing Order AUFNR
AccountingDocExternalReference Reference Document Number XBLNR1
DeliveryDocument Delivery VBELN
GoodsMovementType Movement type (inventory management) BWART
Material Material Number MATNR
Batch Batch Number CHARG
Supplier Vendor's account number LIFNR
Customer Account number of customer KUNNR
GoodsRecipientName Goods Recipient WEMPF
IssgOrRcvgMaterial Transfer Material MATNR
IssgOrRcvgBatch Transfer Batch CHARG
IssuingOrReceivingPlant Transfer Plant WERKS
AccountingDocumentType Document Type BLART
InventoryTransactionType Transaction/Event Type VGART
PlantAddressID Address ADRNR
IssgOrRcvgPlantAddressID Address ADRNR
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • C_RDPGOODSMOVEMENTDOCUMENTDEX.CUSTOMERCOUNTRY == T005.LAND1
  • C_RDPGOODSMOVEMENTDOCUMENTDEX.SUPPLIERCOUNTRY == T005.LAND1
  • C_RDPGOODSMOVEMENTDOCUMENTDEX.MANDT == T005.MANDT
Country key
  • Country/Region Key
  • Country/Region Key
  • Client
  • C_RDPGOODSMOVEMENTDOCUMENTDEX.ISSUINGORRECEIVINGPLANTCOUNTRY == T005.LAND1
  • C_RDPGOODSMOVEMENTDOCUMENTDEX.PLANTCOUNTRY == T005.LAND1
  • C_RDPGOODSMOVEMENTDOCUMENTDEX.MANDT == T005.MANDT
Product Type
  • Client
  • Product Type
  • C_RDPGOODSMOVEMENTDOCUMENTDEX.MANDT == T134.MANDT
  • C_RDPGOODSMOVEMENTDOCUMENTDEX.MATERIALTYPE == T134.MTART
Country key
  • Country/Region Key
  • Country/Region Key
  • Client
  • C_RDPGOODSMOVEMENTDOCUMENTDEX.ISSUINGORRECEIVINGPLANTCOUNTRY == T005.LAND1
  • C_RDPGOODSMOVEMENTDOCUMENTDEX.PLANTCOUNTRY == T005.LAND1
  • C_RDPGOODSMOVEMENTDOCUMENTDEX.MANDT == T005.MANDT
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • C_RDPGOODSMOVEMENTDOCUMENTDEX.CUSTOMERCOUNTRY == T005.LAND1
  • C_RDPGOODSMOVEMENTDOCUMENTDEX.SUPPLIERCOUNTRY == T005.LAND1
  • C_RDPGOODSMOVEMENTDOCUMENTDEX.MANDT == T005.MANDT