I_GoodsMovementDocumentDEX

Material document data extraction | view: IGOODSMVMTDOCDEX | TRAN | Extraction: Full or Incremental | Component: VDM Stock and Goods Movements
Tables used: MATDOC
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
GdsMvtExtAmtInCoCodeCrcy Externally Entered Posting Amount in Local Currency
SlsPrcAmtInclVATInCoCodeCrcy Value at Sales Prices Including Value-Added Tax
EnteredSlsAmtInCoCodeCrcy Externally Entered Sales Value in Local Currency
Column Name Description
📏 Base Unit of Measure (MaterialBaseUnit):
MatlStkChangeQtyInBaseUnit Stock Quantity
MatlCnsmpnQtyInMatlBaseUnit Consumption Quantity
QuantityInBaseUnit Quantity
📏 Unit of entry (EntryUnit):
QuantityInEntryUnit Quantity in unit of entry
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
GoodsReceiptQtyInOrderUnit Goods receipt quantity in order unit
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
ShelfLifeExpirationDate Shelf Life Expiration or Best-Before Date
ManufactureDate Date of Manufacture
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
ConsumptionPosting Consumption posting Show values
GoodsReceiptType Receipt Indicator Show values
IssuingOrReceivingStockType Transfer Stock Type Show values
GoodsMovementIsCancelled Item has been Cancelled Show values
WeekDay Day of Week Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
GoodsMovementRefDocType Goods movement ref doc type Show values
SerialNumbersAreCreatedAutomly Create serial number automatically Show values
VersionForPrintingSlip Version for Printing GR/GI Slip Show values
ManualPrintIsTriggered Print via Output Control Show values
ReservationIsFinallyIssued Final Issue for Reservation Show values
DebitCreditCode Debit/Credit Indicator Show values
IsAutomaticallyCreated Item Automatically Created Indicator Show values
Column Name Description Domain name
MaterialDocumentYear Material Document Year GJAHR
MaterialDocument Number of Material Document BELNR
MaterialDocumentItem Material Document Item MBLPO
StockIdentifyingMaterial Material in Respect of Which Stock is Managed MATNR
Plant Plant WERKS
StockIdfgStorageLocation Storage Location (Stock Identifier) LGORT
StockIdentifyingBatch Batch Number (Stock Identifier) CHARG
SpecialStockIdfgSupplier Supplier for Special Stock LIFNR
SpecialStockIdfgSalesOrder Sales order number of valuated sales order stock VBELN
SpecialStockIdfgSalesOrderItem Sales Order Item of Valuated Sales Order Stock NUM06
SpecialStockIdfgWBSElement Valuated Sales Order Stock WBS Element
SpecialStockIdfgCustomer Customer for Special Stock KUNNR
InventorySpecialStockType Special Stock Type SOBKZ
SpecialStockIdfgStockOwner Add. Supplier for Special Stock LIFNR
ResourceID Resource NSDM_RESOURCENAME
CostEstimate Cost Estimate Number - Product Costing CK_KALNR
StorageLocation Storage location LGORT
Material Material Number MATNR
Batch Batch Number CHARG
StockOwner Additional Supplier for Special Stock LIFNR
CompanyCode Company Code BUKRS
InventoryTransactionType Transaction/Event Type VGART
IssuingOrReceivingPlant Transfer Plant WERKS
IssuingOrReceivingStorageLoc Receiving/issuing storage location LGORT
IssgOrRcvgMaterial Transfer Material MATNR
IssgOrRcvgBatch Transfer Batch CHARG
IssgOrRcvgSpclStockInd Special Stock Indicator SOBKZ
IssuingOrReceivingValType Valuation Type of Transfer Batch BWTAR
IssgOrRcvgResourceID Transfer Resource NSDM_RESOURCENAME
ReversedMaterialDocument Reversed Material Document BELNR
ReversedMaterialDocumentItem Reversed Material Document Item MBLPO
ReversedMaterialDocumentYear Reversed Material Document Year GJAHR
AccountingDocumentType Document Type BLART
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
ProjectNetwork Network Number for Account Assignment AUFNR
DeliveryDocument Delivery VBELN
DeliveryDocumentItem Delivery Item POSNR
WBSElementInternalID WBS Element
ManufacturingOrder Manufacturing Order AUFNR
ManufacturingOrderItem Manufacturing Order Item CO_POSNR
ReferenceDocument Reference Document Number XBLNR1
GoodsIssueOrReceiptSlipNumber Goods Receipt/Issue Slip Number BELNR
ReferenceDocumentFiscalYear Fiscal Year of a Reference Document GJAHR
InvtryMgmtRefDocumentItem Item of a Reference Document MBLPO
InvtryMgmtReferenceDocument Document No. of a Reference Document BELNR
GoodsMovementType Movement type (inventory management) BWART
InventoryValuationType Valuation Type BWTAR
CreatedByUser User Name XUBNAME
Supplier Vendor's account number LIFNR
Customer Account number of customer KUNNR
IsMaterialDocumentHeader Material Document Counter NSDM_HEADER_COUNTER
MaterialDocumentHeaderText Document Header Text TEXT25
MaterialDocumentItemText Item Text TEXT50
GoodsRecipientName Goods Recipient WEMPF
UnloadingPointName Unloading Point TEXT25
GoodsMovementReasonCode Reason for Movement MB_GRBEW
AccountAssignmentCategory Account Assignment Category KNTTP
CostCenter Cost Center KOSTL
ControllingArea Controlling Area CACCD
CostObject Cost Object KSTRG
GLAccount G/L Account Number SAKNR
FunctionalArea Functional Area FKBER
ProfitabilitySegment Profitability Segment RKEOBJNR
ProfitabilitySegment_2 Profitability Segment RKEOBJNR_CHAR
ProfitCenter Profit Center PRCTR
MasterFixedAsset Main Asset Number ANLN1
FixedAsset Asset Subnumber ANLN2
FundsCenter Funds Center FISTL
Fund Fund BP_GEBER
CommitmentItemShortID Commitment Item Short ID FMIS_CI_INTERNALNAME
GrantID Grant GM_GRANT_NBR
Reservation Number of reservation/dependent requirements RSNUM
ReservationItem Item Number of Reservation / Dependent Requirements RSPOS
TransactionCode Transaction Code TCODE
MaterialDocumentLine Unique Identification of Document Line MB_LINE_ID
MaterialDocumentParentLine Identifier of immediately superior line MB_LINE_ID
HierarchyNodeLevel Hierarchy level of line in document MB_LINE_DEPTH