A_MaterialDocumentItem

Document Items | view: AMATDOCITEM | TRAN | Extraction: Not supported | Component: VDM Stock and Goods Movements
Tables used: MATDOCPRTEPROJPRPS
Column Name Description
MaterialDocumentYear Material Document Year
MaterialDocument Number of Material Document
MaterialDocumentItem Material Document Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
GdsMvtExtAmtInCoCodeCrcy Externally Entered Posting Amount in Local Currency
SlsPrcAmtInclVATInCoCodeCrcy Value at Sales Prices Including Value-Added Tax
Column Name Description
📏 Base Unit of Measure (MaterialBaseUnit):
QuantityInBaseUnit Quantity
📏 Unit of entry (EntryUnit):
QuantityInEntryUnit Quantity in unit of entry
Column Name Description
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
GoodsMovementRefDocType Goods movement ref doc type Show values
IssuingOrReceivingStockType Transfer Stock Type Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
SerialNumbersAreCreatedAutomly Create serial number automatically Show values
ReservationIsFinallyIssued Final Issue for Reservation Show values
IsAutomaticallyCreated Item Automatically Created Indicator Show values
GoodsMovementIsCancelled Item has been Cancelled Show values
MaterialDocumentPostingType Reversal, return delivery, or transfer posting Show values
InventoryUsabilityCode Posting Control Stock Type Show values
Column Name Description Domain name
Material Material Number MATNR
Plant Plant WERKS
StorageLocation Storage location LGORT
Batch Batch Number CHARG
GoodsMovementType Movement type (inventory management) BWART
InventoryValuationType Valuation Type BWTAR
InventorySpecialStockType Special Stock Type SOBKZ
Supplier Vendor's account number LIFNR
Customer Account number of customer KUNNR
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
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
ManufacturingOrder Manufacturing Order AUFNR
ManufacturingOrderItem Manufacturing Order Item CO_POSNR
GoodsMovementReasonCode Reason for Movement MB_GRBEW
Delivery Delivery VBELN
DeliveryItem Delivery Item POSNR
AccountAssignmentCategory Account Assignment Category KNTTP
CostCenter Cost Center KOSTL
ControllingArea Controlling Area CACCD
CostObject Cost Object KSTRG
ProfitabilitySegment Profitability Segment RKEOBJNR
ProfitCenter Profit Center PRCTR
GLAccount G/L Account Number SAKNR
FunctionalArea Functional Area FKBER
FiscalYear Fiscal Year GJAHR
FiscalYearPeriod Period Year FINS_FYEARPERIOD
FiscalYearVariant Fiscal Year Variant PERIV
IssgOrRcvgMaterial Transfer Material MATNR
IssgOrRcvgBatch Transfer Batch CHARG
IssuingOrReceivingPlant Receiving/Issuing Plant WERKS
IssuingOrReceivingStorageLoc Receiving/issuing storage location LGORT
IssgOrRcvgSpclStockInd Transfer Special Stock Type SOBKZ
IssuingOrReceivingValType Valuation Type of Transfer Batch BWTAR
MaterialDocumentItemText Item Text TEXT50
UnloadingPointName Unloading Point TEXT25
Reservation Number of reservation/dependent requirements RSNUM
ReservationItem Item Number of Reservation / Dependent Requirements RSPOS
SpecialStockIdfgSalesOrder Sales order number of valuated sales order stock VBELN
SpecialStockIdfgSalesOrderItem Sales Order Item of Valuated Sales Order Stock NUM06
SpecialStockIdfgWBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
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
ReversedMaterialDocumentYear Reversed Material Document Year GJAHR
ReversedMaterialDocument Reversed Material Document BELNR
ReversedMaterialDocumentItem Reversed Material Document Item MBLPO
ReferenceDocumentFiscalYear Fiscal Year of a Reference Document GJAHR
InvtryMgmtRefDocumentItem Item of a Reference Document MBLPO
InvtryMgmtReferenceDocument Document No. of a Reference Document BELNR
EWMWarehouse Warehouse Number/Warehouse Complex /SCWM/LGNUM
EWMStorageBin Storage Bin /SCWM/LGPLA
StockSegment Stock Segment SGT_SRCA
IssgOrRcvgStockSegment Receiving/Issuing Stock Segment SGT_SRCA