C_MfgOrdDocdGoodsMvt

Documented Goods Movement of an Order | view: CMFGORDDOCDGMVT | TRAN | Extraction: Not supported | Component: Shop Floor Execution

Tables used: AUFM, AUFK, PRPS

🔑 Keys (3)
💰 Amounts (1)
∑ Quantities (2)
📅 Dates (2)
☰ Categorical (6)
Other (11)
🔗 Relations (20)

Column Name	Description
GoodsMovement	Number of Material Document
MaterialDocumentItem	Material Document Item
MaterialDocumentYear	Material Document Year

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
ManufacturingOrderCategory	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
MaterialDocument	Number of Material Document	BELNR
ReservationItem	Reservation Item	RSPOS
ReservationRecordType	Reservation Record Type	RSART
SalesOrder	Sales Order	VBELN
SalesOrderItem	Sales Order Item	POSNR
WBSElementExternalID	Work Breakdown Structure Element (WBS Element) Edited	PS_POSID_EDIT
WBSDescription	WBS Element Name	TEXT40
GoodsRecipientName	Goods Recipient	WEMPF
UnloadingPointName	Unloading Point	TEXT25
GoodsMovementYear	Material Document Year	GJAHR
GoodsMovementItem	Material Document Item	MBLPO

Master Data Relations	Join Conditions
Base Unit of Measure Client Base Unit of Measure	`C_MFGORDDOCDGOODSMVT.MANDT == T006.MANDT` `C_MFGORDDOCDGOODSMVT.BASEUNIT == T006.MSEHI`
Batch Number Batch Number Material Number for Order Client	`C_MFGORDDOCDGOODSMVT.BATCH == MCH1.CHARG` `C_MFGORDDOCDGOODSMVT.MATERIAL == MCH1.MATNR` `C_MFGORDDOCDGOODSMVT.MANDT == MCH1.MANDT`
Currency Key Currency Key Client	`C_MFGORDDOCDGOODSMVT.COMPANYCODECURRENCY == TCURC.WAERS` `C_MFGORDDOCDGOODSMVT.MANDT == TCURC.MANDT`
Controlling Area Controlling Area Client	`C_MFGORDDOCDGOODSMVT.CONTROLLINGAREA == TKA01.KOKRS` `C_MFGORDDOCDGOODSMVT.MANDT == TKA01.MANDT`
Unit of entry Unit of entry Client	`C_MFGORDDOCDGOODSMVT.ENTRYUNIT == T006.MSEHI` `C_MFGORDDOCDGOODSMVT.MANDT == T006.MANDT`
G/L Account Number G/L Account Number ? Client	`C_MFGORDDOCDGOODSMVT.GLACCOUNT == SKA1.SAKNR` `C_MFGORDDOCDGOODSMVT.[column in domain "KTOPL"] == SKA1.KTOPL` `C_MFGORDDOCDGOODSMVT.MANDT == SKA1.MANDT`
Plant Client Plant Production Plant	`C_MFGORDDOCDGOODSMVT.MANDT == T001W.MANDT` `C_MFGORDDOCDGOODSMVT.GOODSMOVEMENTPLANT == T001W.WERKS` `C_MFGORDDOCDGOODSMVT.PRODUCTIONPLANT == T001W.WERKS`
Goods Movement Type Goods Movement Type Client	`C_MFGORDDOCDGOODSMVT.GOODSMOVEMENTTYPE == T156.BWART` `C_MFGORDDOCDGOODSMVT.MANDT == T156.MANDT`
Inventory Special Stock Type Inventory Special Stock Type Client	`C_MFGORDDOCDGOODSMVT.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ` `C_MFGORDDOCDGOODSMVT.MANDT == T148.MANDT`
Inventory Valuation Type Inventory Valuation Type Client	`C_MFGORDDOCDGOODSMVT.INVENTORYVALUATIONTYPE == T149D.BWTAR` `C_MFGORDDOCDGOODSMVT.MANDT == T149D.MANDT`
Manufacturing Order ID Manufacturing Order ID Client	`C_MFGORDDOCDGOODSMVT.MANUFACTURINGORDER == AUFK.AUFNR` `C_MFGORDDOCDGOODSMVT.MANDT == AUFK.MANDT`
Order Type Order Type Client	`C_MFGORDDOCDGOODSMVT.MANUFACTURINGORDERTYPE == T003O.AUART` `C_MFGORDDOCDGOODSMVT.MANDT == T003O.CLIENT`
Material Number for Order Material Number for Order Client	`C_MFGORDDOCDGOODSMVT.MATERIAL == MARA.MATNR` `C_MFGORDDOCDGOODSMVT.MANDT == MARA.MANDT`
Production Plant Client Plant Production Plant	`C_MFGORDDOCDGOODSMVT.MANDT == T001W.MANDT` `C_MFGORDDOCDGOODSMVT.GOODSMOVEMENTPLANT == T001W.WERKS` `C_MFGORDDOCDGOODSMVT.PRODUCTIONPLANT == T001W.WERKS`
Storage Location Storage Location Client Plant Production Plant	`C_MFGORDDOCDGOODSMVT.STORAGELOCATION == T001L.LGORT` `C_MFGORDDOCDGOODSMVT.MANDT == T001L.MANDT` `C_MFGORDDOCDGOODSMVT.GOODSMOVEMENTPLANT == T001L.WERKS` `C_MFGORDDOCDGOODSMVT.PRODUCTIONPLANT == T001L.WERKS`
Vendor's account number Vendor's account number Client	`C_MFGORDDOCDGOODSMVT.SUPPLIER == LFA1.LIFNR` `C_MFGORDDOCDGOODSMVT.MANDT == LFA1.MANDT`