C_GoodsMovementQuery

Goods Movement Analysis | view: CGDSMVTQUERY | TRAN | Extraction: Not supported | Component: VDM Stock and Goods Movements

Tables used: MATDOC, EKKO, VBKD, VEDA, VBAK, MARA, T001L

🔑 Keys
💰 Amounts (4)
∑ Quantities (11)
📅 Dates (4)
☰ Categorical (14)
Other (54)
🔗 Relations (8)

Column Name	Description

Column Name	Description
💲 Company Code Currency (CompanyCodeCurrency):
GoodsReceiptAmountInCoCodeCrcy	Receipt Amount
GoodsIssueAmountInCoCodeCrcy	Issue Amount
GoodsMvtCnsmpnAmtInCCCrcy	Consumption Amount
GoodsMovementStkAmtInCCCrcy	Stock Change Amount

Column Name	Description
📏 Base Unit of Measure (MaterialBaseUnit):
GoodsReceiptQtyInBaseUnit	Receipt Quantity
GoodsIssueQtyInBaseUnit	Issue Quantity
TotalGdsMvtQtyInBaseUnit	Movement Quantity
MatlCnsmpnQtyInMatlBaseUnit	Consumption Quantity
MatlStkChangeQtyInBaseUnit	Stock Change Quantity
MinGoodsRcptQtyInBaseUnit	Minimum Receipt Quantity
MaxGoodsRcptQtyInBaseUnit	Max Receipt Quantity
MinGoodsIssueQtyInBaseUnit	Minimum Issue Quantity
MaxGoodsIssueQtyInBaseUnit	Max Issue Quantity
MinCnsmpnQtyInBaseUnit	Minimum Consumption Quantity
MaxCnsmpnQtyInBaseUnit	Maximum Consumption Quantity

Column Name	Description
DocumentDate	Document Date in Document
PostingDate	Posting Date in the Document
FirstGoodsMovementPostingDate	First Goods Movement Posting Date
LastGoodsMovementPostingDate	Last Goods Movement Posting Date

Column Name	Description
InventoryStockType	Stock Type of Goods Movement (Stock Identifier)	Show values
InventorySpecialStockValnType	Separate Valuation Type	Show values
IsReversalMovementType	Has Reversal Movement Type	Show values
IssuingOrReceivingStockType	Transfer Stock Type	Show values
GoodsMovementIsCancelled	Item has been Cancelled	Show values
WeekDay	Day of Week	Show values
StockChangeCategory	Stock Change Category	Show values
IsConsumptionMovement	Is Consumption Movement	Show values
IsCrossPlantTransfer	Is Cross Plant Transfer	Show values
IsStorageLocChangeByTransf	Is Storage Location Change	Show values
IsMaterialChangeByTransf	Is Material Change	Show values
IsBatchChangeByTransf	Batch Change by Transfer	Show values
IsSpclStkTypeChangeByTransf	Is Special Stock Type Change	Show values
IsStockTypeChangeByTransf	Is Stock Type Change	Show values

Column Name	Description	Domain name
MaterialDocumentYear	Material Document Year	GJAHR
MaterialDocument	Number of Material Document	BELNR
MaterialDocumentItem	Material Document Item	MBLPO
Plant	Plant	WERKS
StorageLocation	Storage location	LGORT
Material	Material Number	MATNR
Batch	Batch Number	CHARG
InventorySpecialStockType	Special Stock Type	SOBKZ
StockOwner	Additional Supplier for Special Stock	LIFNR
CompanyCode	Company Code	BUKRS
ResourceID	Resource	NSDM_RESOURCENAME
IssgOrRcvgMaterial	Transfer Material	MATNR
IssgOrRcvgBatch	Transfer Batch	CHARG
IssgOrRcvgSpclStockInd	Transfer Special Stock Type	SOBKZ
IssgOrRcvgResourceID	Transfer Resource	NSDM_RESOURCENAME
FiscalYearVariant	Fiscal Year Variant	PERIV
FiscalYear	Fiscal Year	GJAHR
FiscalYearPeriod	Period Year	FINS_FYEARPERIOD
YearDay	Year-Day-Combination	NSDM_YEARDAY
YearWeek	Year-Week-Combination	NUM6
YearMonth	Year-Month-Combination	NUM6
YearQuarter	Year-Quarter-Combination	NUM5
CalendarQuarter	Quarter (1 - 4)
CalendarMonth	Month (1 - 12)
CalendarWeek	Calendar Week (1 - 53)
CalendarDay	Day of Year (1 - 366)
SalesOrder	Sales Order Number	VBELN
SalesOrderItem	Sales Order Item	POSNR
SalesOrderScheduleLine	Sales Order Schedule	NUM04
PurchaseOrder	Purchase order number	EBELN
PurchaseOrderItem	Item Number of Purchasing Document	EBELP
DeliveryDocument	Delivery	VBELN
DeliveryDocumentItem	Delivery Item	POSNR
WBSElementInternalID	WBS Element Internal ID	PS_POSNR
ManufacturingOrder	Manufacturing Order	AUFNR
ManufacturingOrderItem	Manufacturing Order Item	CO_POSNR
GoodsMovementType	Movement type (inventory management)	BWART
GoodsMovementReasonCode	Reason for Movement	MB_GRBEW
InventoryValuationType	Valuation Type	BWTAR
Supplier	Vendor's account number	LIFNR
Customer	Account number of customer	KUNNR
AccountAssignmentCategory	Account Assignment Category	KNTTP
CostObject	Cost Object	KSTRG
CostCenter	Cost Center	KOSTL
ControllingArea	Controlling Area	CACCD
ProfitabilitySegment	Profitability Segment	RKEOBJNR
ProfitabilitySegment_2	Profitability Segment	RKEOBJNR_CHAR
ProfitCenter	Profit Center	PRCTR
GLAccount	G/L Account Number	SAKNR
FunctionalArea	Functional Area	FKBER
NumberOfGoodsReceipts	Number of Goods Receipt Movements
NumberOfGoodsIssues	Number of Goods Issue Movements
NumberOfGoodsMovements	Number of Goods Movements
StockSegment	Stock Segment	SGT_SRCA

Master Data Relations	Join Conditions
Distribution channel in order header Distribution Channel Client Sales Organization	`C_GOODSMOVEMENTQUERY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG` `C_GOODSMOVEMENTQUERY.MANDT == TVKOV.MANDT` `C_GOODSMOVEMENTQUERY.SALESORGANIZATION == TVKOV.VKORG`
Material Group Material Group Client	`C_GOODSMOVEMENTQUERY.MATERIALGROUP == T023.MATKL` `C_GOODSMOVEMENTQUERY.MANDT == T023.MANDT`
Material type Material type Client	`C_GOODSMOVEMENTQUERY.MATERIALTYPE == T134.MTART` `C_GOODSMOVEMENTQUERY.MANDT == T134.MANDT`
Division in order header Sales Division Distribution Channel Client Sales Organization	`C_GOODSMOVEMENTQUERY.ORGANIZATIONDIVISION == TVTA.SPART` `C_GOODSMOVEMENTQUERY.DISTRIBUTIONCHANNEL == TVTA.VTWEG` `C_GOODSMOVEMENTQUERY.MANDT == TVTA.MANDT` `C_GOODSMOVEMENTQUERY.SALESORGANIZATION == TVTA.VKORG`
Purchasing Group Purchasing Group Client	`C_GOODSMOVEMENTQUERY.PURCHASINGGROUP == T024.EKGRP` `C_GOODSMOVEMENTQUERY.MANDT == T024.MANDT`
Purchasing Organization Purchasing Organization Client	`C_GOODSMOVEMENTQUERY.PURCHASINGORGANIZATION == T024E.EKORG` `C_GOODSMOVEMENTQUERY.MANDT == T024E.MANDT`
Sales group Sales group Client ?	`C_GOODSMOVEMENTQUERY.SALESGROUP == TVBVK.VKGRP` `C_GOODSMOVEMENTQUERY.MANDT == TVBVK.MANDT` `C_GOODSMOVEMENTQUERY.[column in domain "VKBUR"] == TVBVK.VKBUR`
Sales organization in order header Client Sales Organization	`C_GOODSMOVEMENTQUERY.MANDT == TVKO.MANDT` `C_GOODSMOVEMENTQUERY.SALESORGANIZATION == TVKO.VKORG`