I_MaterialDocumentRecord

Basis view for MATDOC table | view: IMATDOCREC | TRAN | Extraction: Not supported | Component: Basic Functions
Tables used: MATDOC
Column Name Description
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):
QuantityInBaseUnit Quantity
MatlStkChangeQtyInBaseUnit Stock Quantity
MatlCnsmpnQtyInMatlBaseUnit Consumption Quantity
📏 Unit of entry (EntryUnit):
QuantityInEntryUnit Quantity in unit of entry
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
GoodsReceiptQtyInOrderUnit Goods receipt quantity in order unit
📏 Order Price Unit (Purchasing) (OrderPriceUnit):
QtyInPurchaseOrderPriceUnit Quantity in Purchase Order Price Unit
Column Name Description
DocumentDate Document Date in Document
CreationDate Day On Which Accounting Document Was Entered
CreationTime Time of Entry
ShelfLifeExpirationDate Shelf Life Expiration or Best-Before Date
ManufactureDate Date of Manufacture
ServicesRenderedDate Date on which services are rendered
PostingDate Posting Date in the Document
Column Name Description
InventoryStockType Stock Type of Goods Movement (Stock Identifier) Show values
IssuingOrReceivingStockType Transfer Stock Type Show values
GoodsReceiptType Receipt Indicator Show values
GoodsMovementRefDocType Goods movement ref doc type Show values
ConsumptionPosting Consumption posting Show values
DebitCreditCode Debit/Credit Indicator Show values
InventoryUsabilityCode Posting Control Stock Type Show values
InventorySpecialStockValnType Separate Valuation Type Show values
ReservationIsFinallyIssued Final Issue for Reservation Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
RvslOfGoodsReceiptIsAllowed Reversal of GR allowed for GR-based IV despite invoice Show values
IsReversalMovementType Has Reversal Movement Type Show values
GoodsMovementIsCancelled Item has been Cancelled Show values
GoodsMovementCancellationType Relevance for Analytics Show values
GoodsReceiptIsNonValuated Goods Receipt, Non-Valuated Show values
MultipleAccountAssignmentCode Multiple Account Assignment Show values
CtrlPostgForExtWhseMgmtSyst Control posting for external WMS Show values
ActivityInWarehouseIsPending Indicator: posting in warehouse management system Show values
VersionForPrintingSlip Version for Printing GR/GI Slip Show values
ManualPrintIsTriggered Print via Output Control Show values
WeekDay Day of Week Show values
IsAutomaticallyCreated Item Automatically Created Indicator Show values
MaterialDocumentRecordType Record Type Show values
SerialNumbersAreCreatedAutomly Create serial number automatically Show values
MaterialDocumentPostingType Reversal, return delivery, or transfer posting Show values
Column Name Description Domain name
MaterialDocumentKey1 Key field 1
MaterialDocumentKey2 Key field 2
MaterialDocumentKey3 Key field 3
MaterialDocumentKey4 Key field 4
MaterialDocumentKey5 Key field 5
MaterialDocumentKey6 Key field 6
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 PS_POSNR
SpecialStockIdfgCustomer Customer for Special Stock KUNNR
InventorySpecialStockType Special Stock Type SOBKZ
SpecialStockIdfgStockOwner Add. Supplier for Special Stock LIFNR
ResourceID Resource Name (Stock Identifier) NSDM_RESOURCENAME
IssgOrRcvgStkIdfgMaterial Receiving/Issuing Material MATNR
IssgOrRcvgStkIdfgPlant Complementary Plant (Stock Identifier) WERKS
IssgOrRcvgStkIdfgStorLoc Complementary Storage Location (Stock Identifier) LGORT
IssgOrRcvgStkIdfgBatch Complementary Batch Number (Stock Identifier) CHARG
IssgOrRcvgSpclStkIdfgSupplier Complentary Supplier for Special Stock LIFNR
IssgOrRcvgSalesOrder Sales and Distribution Document Number (Stock Identifier) VBELN
IssgOrRcvgSalesOrderItem Item Number of the SD Document (Stock Identifier) POSNR
IssgOrRcvgWBSElement Work Breakdown Structure Element (Stock Identifier) PS_POSNR
IssgOrRcvgSpclStkIdfgCustomer Complementary Customer for Special Stock KUNNR
IssgOrRcvgStkIdfgSpclStkType Complementary Special Stock Indicator SOBKZ
IssgOrRcvgSpclStkIdfgStkOwner Complementary Additional Supplier for Special Stock LIFNR
IssgOrRcvgResourceID Resource Name (Stock Identifier Complement) NSDM_RESOURCENAME
Material Material Number MATNR
StorageLocation Storage location LGORT
Batch Batch Number CHARG
Supplier Vendor's account number LIFNR
SalesOrder Sales Order Number VBELN
SalesOrderItem Sales Order Item POSNR
SalesOrderScheduleLine Sales Order Schedule NUM04
Customer Account number of customer KUNNR
StockOwner Additional Supplier for Special Stock LIFNR
WBSElementInternalID WBS Element Internal ID PS_POSNR
IssgOrRcvgMaterial Transfer Material MATNR
IssuingOrReceivingPlant Transfer Plant WERKS
IssuingOrReceivingStorageLoc Receiving/issuing storage location LGORT
IssgOrRcvgBatch Transfer Batch CHARG
IssgOrRcvgSpclStockInd Special Stock Indicator SOBKZ
IssuingOrReceivingValType Valuation Type of Transfer Batch BWTAR
GoodsMovementReasonCode Reason for Movement MB_GRBEW
GoodsMovementType Movement type (inventory management) BWART
AccountingDocumentType Document Type BLART
InventoryTransactionType Transaction/Event Type VGART
CreatedByUser User Name XUBNAME
MaterialDocumentHeaderText Document Header Text TEXT25
MaterialDocumentItemText Item Text TEXT50
DeliveryInMatlDocumentHeader Delivery Document on Header VBELN
BillOfLading Number of Bill of Lading at Time of Goods Receipt XBLNR1
InventoryValuationType Valuation Type BWTAR
PurchaseOrder Purchase order number EBELN
PurchaseOrderItem Item Number of Purchasing Document EBELP
ProjectNetwork Network Number for Account Assignment AUFNR
ManufacturingOrder Manufacturing Order AUFNR
ManufacturingOrderItem Manufacturing Order Item CO_POSNR
OrderID Order Number AUFNR
OrderItem Order Item CO_POSNR
Reservation Number of reservation/dependent requirements RSNUM
ReservationItem Item Number of Reservation / Dependent Requirements RSPOS
DeliveryDocument Delivery VBELN
DeliveryDocumentItem Delivery Document Item POSNR
ReversedMaterialDocumentYear Reversed Material Document Year GJAHR
ReversedMaterialDocument Reversed Material Document BELNR
ReversedMaterialDocumentItem Reversed Material Document Item MBLPO
GoodsRecipientName Goods Recipient WEMPF
UnloadingPointName Unloading Point TEXT25
CostCenter Cost Center KOSTL
GLAccount G/L Account Number SAKNR
CostObject Cost Object KSTRG
ProfitabilitySegment Profitability Segment RKEOBJNR
ProfitabilitySegment_2 Profitability Segment RKEOBJNR_CHAR
ProfitCenter Profit Center PRCTR
CostEstimate Cost Estimate Number - Product Costing CK_KALNR
ReferenceDocument Reference Document Number XBLNR1
ServicePerformer Service Performer BU_PARTNER
EmploymentInternalID Employment ID (Deprecated) PERNR
PersonWorkAgreement Personnel Number PERNR
AccountAssignmentCategory Account Assignment Category KNTTP
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
CompanyCode Company Code BUKRS
BusinessArea Business Area GSBER
ControllingArea Controlling Area CACCD
FunctionalArea Functional Area FKBER
OriginalMaterialDocumentItem Original line in material document MBLPO
MultiAcctAssgmtOriglMatlDocItm Original Line for Account Assignment Item in Material Doc. MBLPO
HasMultipleAccountAssignment Multiple Account Assignment CHAR1
MasterFixedAsset Main Asset Number ANLN1
FixedAsset Asset Subnumber ANLN2
FiscalYearPeriod Period Year FINS_FYEARPERIOD
FiscalYearVariant Fiscal Year Variant PERIV
FundsCenter Funds Center FISTL
Fund Fund BP_GEBER
CommitmentItem Commitment Item FIPOS
CommitmentItemShortID Commitment Item Short ID FMIS_CI_INTERNALNAME
GrantID Grant GM_GRANT_NBR
StorageType Storage Type LGTYP
StorageBin Storage Bin LGPLA
ReferenceDocumentFiscalYear Fiscal Year of a Reference Document GJAHR
InvtryMgmtReferenceDocument Document No. of a Reference Document BELNR
InvtryMgmtRefDocumentItem Item of a Reference Document MBLPO
EWMWarehouse Warehouse Number/Warehouse Complex /SCWM/LGNUM
EWMStorageBin Storage Bin /SCWM/LGPLA
MaintOrderRoutingNumber Routing number of operations in the order AUFPL
MaintOrderOperationCounter Internal counter CIM_COUNT
ManufacturerMaterial Material number corresponding to manufacturer part number MATNR
WarehouseNumber Warehouse Number / Warehouse Complex LGNUM
TransferRequirementNumber Transfer Requirement Number TBNUM
TransferPriority Transfer Priority TBPRI
ShippingInstruction Shipping Instructions EVERS
ShipgInstrnSupplierCompliance Compliance with Shipping Instructions EVERE
YearDay Year-Day-Combination NSDM_YEARDAY
YearWeek Year-Week-Combination NUM6
YearMonth Year-Month-Combination NUM6
YearQuarter Year-Quarter-Combination NUM5
DocumentYear Year
CalendarQuarter Quarter (1 - 4)
CalendarMonth Month (1 - 12)
CalendarWeek Calendar Week (1 - 53)
CalendarDay Day of Year (1 - 366)
FiscalYear Fiscal Year GJAHR
YearPeriod Fiscal Year + Fiscal Period FINS_FYEARPERIOD
GoodsIssueOrReceiptSlipNumber Goods Receipt/Issue Slip Number BELNR
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
IsMaterialDocumentHeader Material Document Counter NSDM_HEADER_COUNTER
ReservationRecordType Reservation Record Type RSART
StockSegment Stock Segment SGT_SRCA
IssgOrRcvgStockSegment Receiving/Issuing Stock Segment SGT_SRCA