I_OrderDocumentedGoodsMovement

Documented Goods Movement of an Order | view: IORDDOCDGMVT | TRAN | Extraction: Not supported | Component: Virtual Data Model in PP
Tables used: AUFM, AUFK
Column Name Description
GoodsMovement Number of Material Document
GoodsMovementYear Material Document Year
GoodsMovementItem Material Document Item
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
TotalGoodsMvtAmtInCCCrcy Amount in Local Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
QuantityInBaseUnit Quantity in Base Unit of Measure
📏 Unit of entry (EntryUnit):
QuantityInEntryUnit Quantity in Unit of Entry
Column Name Description
PostingDate Posting Date in the Document
DocumentDate Document Date in Document
Column Name Description
OrderCategory Order Category Show values
ReservationIsFinallyIssued Final Issue for Reservation Show values
DebitCreditCode Debit/Credit Code Show values
GoodsMovementRefDocType Goods Movement Reference Document Type Show values
GoodsReceiptIsNonValuated Goods Receipt is Non-Valuated Show values
GoodsReceiptIsCmpltlyDelivered "Delivery Completed" Indicator Show values
Column Name Description Domain name
ReservationItem Reservation Item RSPOS
ReservationRecordType Reservation Record Type RSART
SalesOrder Sales Order VBELN
SalesOrderItem Sales Order Item POSNR
GoodsRecipientName Goods Recipient WEMPF
UnloadingPointName Unloading Point TEXT25
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.MANDT == T006.MANDT
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.BASEUNIT == T006.MSEHI
Batch Number
  • Client
  • Batch Number
  • Material Number for Order
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.MANDT == MCH1.MANDT
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.BATCH == MCH1.CHARG
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.MATERIAL == MCH1.MATNR
Currency Key
  • Client
  • Currency Key
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.MANDT == TCURC.MANDT
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.MANDT == TKA01.MANDT
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.CONTROLLINGAREA == TKA01.KOKRS
Unit of entry
  • Unit of entry
  • Client
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.ENTRYUNIT == T006.MSEHI
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.MANDT == T006.MANDT
G/L Account Number
  • Client
  • ?
  • G/L Account Number
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.MANDT == SKA1.MANDT
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.[column in domain "KTOPL"] == SKA1.KTOPL
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.GLACCOUNT == SKA1.SAKNR
Plant
  • Client
  • Plant
  • Plant
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.MANDT == T001W.MANDT
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.PLANT == T001W.WERKS
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.GOODSMOVEMENTPLANT == T001W.WERKS
Goods Movement Type
  • Client
  • Goods Movement Type
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.MANDT == T156.MANDT
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.GOODSMOVEMENTTYPE == T156.BWART
Inventory Special Stock Type
  • Client
  • Inventory Special Stock Type
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.MANDT == T148.MANDT
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Inventory Valuation Type
  • Client
  • Inventory Valuation Type
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.MANDT == T149D.MANDT
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.INVENTORYVALUATIONTYPE == T149D.BWTAR
Material Number for Order
  • Client
  • Material Number for Order
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.MANDT == MARA.MANDT
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.MATERIAL == MARA.MATNR
Order Number
  • Order Number
  • Client
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.ORDERID == AUFK.AUFNR
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.MANDT == AUFK.MANDT
Order Type
  • Order Type
  • Client
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.ORDERTYPE == T003O.AUART
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.MANDT == T003O.CLIENT
Plant
  • Client
  • Plant
  • Plant
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.MANDT == T001W.MANDT
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.PLANT == T001W.WERKS
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.GOODSMOVEMENTPLANT == T001W.WERKS
Network Number for Account Assignment
  • Client
  • Network Number for Account Assignment
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.MANDT == AUFK.MANDT
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.PROJECTNETWORK == AUFK.AUFNR
Storage Location
  • Client
  • Plant
  • Plant
  • Storage Location
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.MANDT == T001L.MANDT
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.PLANT == T001L.WERKS
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.GOODSMOVEMENTPLANT == T001L.WERKS
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.STORAGELOCATION == T001L.LGORT
Vendor's account number
  • Client
  • Vendor's account number
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.MANDT == LFA1.MANDT
  • I_ORDERDOCUMENTEDGOODSMOVEMENT.SUPPLIER == LFA1.LIFNR