SAP MATDOC Material Documents Table

Overview

MATDOC is a standard SAP S/4HANA table that stores Material Documents data. There are total 313 fields in the MATDOC table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table MATDOC belongs to Basic Functions (MM-IM-GF) module and is located in the package MM: Inventory Management New Data Model Restricted Usage (MBND_RESTRICTED).

In addition, following links provide an overview of foreign key relationships, if any, that link MATDOC to other SAP tables and standard CDS views available based on MATDOC table in S/4HANA 2020.

Techincal Settings of MATDOC

Below are technical details of the table MATDOC

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of MATDOC Fields

The following table gives you an overview of the fields available in MATDOC

FieldDescriptionData ElementCheck TableData Type
MANDTClientMANDT*CLNT(3)
RECORD_TYPERecord TypeNSDM_RECORD_TYPECHAR(30)
HEADER_COUNTERMaterial Document CounterNSDM_HEADER_COUNTERINT4(10)
MATBFMaterial in Respect of Which Stock is ManagedMATBF*CHAR(40)
WERKSPlantWERKS_DCHAR(4)
LGORT_SIDStorage Location (Stock Identifier)NSDM_LGORT*CHAR(4)
CHARG_SIDBatch Number (Stock Identifier)NSDM_CHARG*CHAR(10)
LIFNR_SIDSupplier for Special StockNSDM_LIFNRCHAR(10)
MAT_KDAUFSales order number of valuated sales order stockMAT_KDAUFCHAR(10)
MAT_KDPOSSales Order Item of Valuated Sales Order StockMAT_KDPOSNUMC(6)
MAT_PSPNRValuated Sales Order Stock WBS ElementMAT_PSPNR*NUMC(8)
KUNNR_SIDCustomer for Special StockNSDM_KUNNRCHAR(10)
SOBKZSpecial Stock IndicatorSOBKZ*CHAR(1)
LBBSA_SIDStock Type of Goods Movement (Stock Identifier)NSDM_LBBSACHAR(2)
DISUB_OWNER_SIDAdditional Supplier for Special StockNSDM_DISUB_OWNERCHAR(10)
RESOURCENAME_SIDResource Name (Stock Identifier)NSDM_RESOURCENAME_SIDCHAR(40)
BUKRSCompany CodeBUKRSCHAR(4)
CHARG_WHS_SGBatch Number of Warehouse Stock (Stock Identifier)NSDM_CHARG_WHS*CHAR(10)
MENGUQuantity Updating in Material Master RecordMENGUCHAR(1)
WERTUValue Updating in Material Master RecordWERTUCHAR(1)
VBOBJ_SGSD Document ObjectNSDM_VBOBJCHAR(1)
KZBWSValuation of Special StockKZBWSCHAR(1)
BSTAUS_SGStock CharacteristicsNSDM_BSTAUSCHAR(1)
BSTTYP_SGStock CategoryNSDM_BSTTYPCHAR(1)
KALNRCost Estimate Number - Product CostingCK_KALNR1*NUMC(12)
BERIDMRP AreaBERID*CHAR(10)
WAERSCurrency KeyWAERS*CUKY(5)
DMBTRAmount in Local CurrencyDMBTR_CSCURR(13)
BNBTRDelivery costs in local currencyBNBTRCURR(13)
BUALTAmount Posted in Alternative Price ControlBUALTCURR(13)
DMBUMRevaluation amount on back-posting to a previous periodDMBUMCURR(13)
EXBWRExternally Entered Posting Amount in Local CurrencyEXBWRCURR(13)
VKWRTValue at Sales Prices Including Value-Added TaxVKWRTCURR(13)
EXVKWExternally Entered Sales Value in Local CurrencyEXVKWCURR(13)
SALK3Value of total valuated stock before the postingSALK3_MSEGCURR(13)
VKWRAValue at Sales Prices Excluding Value Added TaxVKWRACURR(13)
J_1BEXBASEAlternate base amount in document currencyJ_1BEXBASECURR(13)
STOCK_VKWRTValue at Sales Prices Including Value-Added TaxNSDM_STOCK_VKWRTCURR(13)
DMBTR_STOCKAmount in Local Currency with Sign of Stock QuantityNSDM_DMBTR_STOCKCURR(13)
DMBTR_CONSAmount in Local Currency with Sign of Consumption QuantityNSDM_DMBTR_CONSCURR(13)
MEINSBase Unit of MeasureMEINS*UNIT(3)
MENGEQuantityMENGE_DQUAN(13)
LBKUMTotal valuated stock before the postingLBKUM_MSEGQUAN(13)
STOCK_QTYStock QuantityNSDM_STOCK_QTYQUAN(31)
CONSUMPTION_QTYConsumption QuantityNSDM_CONSUMPTION_QTYQUAN(31)
ERFMEUnit of entryERFME*UNIT(3)
ERFMGQuantity in unit of entryERFMGQUAN(13)
BPRMEOrder Price Unit (Purchasing)BPRME*UNIT(3)
BPMNGQuantity in Purchase Order Price UnitBPMNGQUAN(13)
BSTMEPurchase Order Unit of MeasureBSTME*UNIT(3)
BSTMGGoods receipt quantity in order unitMB_BSTMGQUAN(13)
LSMEHUnit of Measure From Delivery NoteLSMEH*UNIT(3)
LSMNGQuantity in Unit of Measure from Delivery NoteLSMNGQUAN(13)
PBAMGQuantityMENGE_DQUAN(13)
CURRENCY_A1Analytical Currency of Warehouse Stock - not usedNSDM_ANALYTIC_CURRENCY*CUKY(5)
PRICE_A1Analytical Price of one Base Unit of Measure - not usedNSDM_ANALYTIC_PRICEDEC(31)
PRICE_SOURCE_A1Indicator for Analytical Value of Price Source - not usedNSDM_PRICE_SOURCECHAR(32)
STOCK_VALUE_A1Analytical Value of Warehouse Stock - not usedNSDM_STOCK_VALUEDEC(31)
CONS_VALUE_A1Analytical Value of Consumption Quantity - not usedNSDM_CONSUMPTION_VALUEDEC(31)
/CWM/MENGEQuantity in Parallel Unit of Measure/CWM/MENGEQUAN(13)
/CWM/MEINSParallel Unit of Measure/CWM/MEINS*UNIT(3)
/CWM/ERFMGQuantity in Parallel Unit of Entry/CWM/ERFMGQUAN(13)
/CWM/ERFMEPUoM Entry Unit of Measure/CWM/ERFME*UNIT(3)
/CWM/STOCK_QTYStock Quantity in PUoM/CWM/STOCK_QTYQUAN(31)
/CWM/CONSUMPTION_QTYConsumption Quantity in PUoM/CWM/CONSUMPTION_QTYQUAN(31)
/CWM/MEINS_SIDParallel Unit of Measure (Stock Identifier)/CWM/MEINS_SID*UNIT(3)
UMMAB_CIDReceiving/Issuing MaterialUMMAT*CHAR(40)
UMWRK_CIDPlantWERKS_DCHAR(4)
LGORT_CIDStorage Location (Stock Identifier)NSDM_LGORT*CHAR(4)
CHARG_CIDBatch Number (Stock Identifier)NSDM_CHARG*CHAR(10)
LIFNR_CIDSupplier for Special StockNSDM_LIFNRCHAR(10)
MAT_KDAUF_CIDSales and Distribution Document Number (Stock Identifier)NSDM_VBELNCHAR(10)
MAT_KDPOS_CIDItem Number of the SD Document (Stock Identifier)NSDM_POSNRNUMC(6)
MAT_PSPNR_CIDWork Breakdown Structure Element (Stock Identifier)NSDM_PS_PSP_PNR*NUMC(8)
KUNNR_CIDCustomer for Special StockNSDM_KUNNRCHAR(10)
UMSOK_CIDSpecial Stock IndicatorSOBKZ*CHAR(1)
LBBSA_CIDStock Type of Goods Movement (Stock Identifier)NSDM_LBBSACHAR(2)
DISUB_OWNER_CIDAccount Number of Vendor or CreditorLIFNRCHAR(10)
RESOURCENAME_CIDResource Name (Stock Identifier Complement)NSDM_RESOURCENAME_CIDCHAR(40)
UMBUK_CGCompany CodeBUKRSCHAR(4)
CHARG_WHS_CGBatch Number of Warehouse Stock (Stock Identifier)NSDM_CHARG_WHS*CHAR(10)
UMMEN_CGQuantity Updating in Material Master RecordMENGUCHAR(1)
UMWER_CGValue Updating in Material Master RecordWERTUCHAR(1)
VBOBJ_CGSD Document ObjectNSDM_VBOBJCHAR(1)
UMKZBWS_CGValuation of Special StockKZBWSCHAR(1)
BSTAUS_CGStock CharacteristicsNSDM_BSTAUSCHAR(1)
BSTTYP_CGStock CategoryNSDM_BSTTYPCHAR(1)
KALNR_CGComplement Cost Estimate Number - Product CostingNSDM_UMKALNR*NUMC(12)
BUDATPosting Date in the DocumentBUDATDATS(8)
CPUDTDay On Which Accounting Document Was EnteredCPUDTDATS(8)
CPUTMTime of EntryCPUTMTIMS(6)
YEARDAY_BUDATYear-Day-CombinationNSDM_YEARDAYNUMC(7)
YEARWEEK_BUDATYear-Week-CombinationNSDM_YEARWEEKNUMC(6)
YEARMONTH_BUDATYear-Month-CombinationNSDM_YEARMONTHNUMC(6)
YEARQUARTER_BUDATYear-Quarter-CombinationNSDM_YEARQUARTERNUMC(5)
WEEKDAY_BUDATWeek DayNSDM_WEEKDAYNUMC(1)
BLDATDocument Date in DocumentBLDATDATS(8)
AEDATDate of Last ChangeAEDATDATS(8)
SPE_BUDAT_UHRTime of Goods Issue (Local, Relating to a Plant)WAUHRTIMS(6)
SPE_BUDAT_ZONETime ZoneTZNZONE*CHAR(6)
PERIVFiscal Year VariantPERIV*CHAR(2)
GJAHRFiscal YearGJAHRNUMC(4)
GJPERPeriod/YearJAHRPERNUMC(7)
GJPER_CURR_PERPeriod/YearJAHRPERNUMC(7)
VFDATShelf Life Expiration or Best-Before DateVFDATDATS(8)
DABRBZReference date for settlementDABRBEZDATS(8)
DABRZReference date for settlementDABRBEZDATS(8)
HSDATDate of ManufactureHSDATDATS(8)
MBLNRNumber of Material DocumentMBLNRCHAR(10)
MJAHRMaterial Document YearMJAHRNUMC(4)
ZEILEItem in Material DocumentMBLPONUMC(4)
LINE_IDUnique identification of document lineMB_LINE_IDNUMC(6)
PARENT_IDIdentifier of immediately superior lineMB_PARENT_IDNUMC(6)
LINE_DEPTHHierarchy level of line in documentMB_LINE_DEPTHNUMC(2)
MAA_URZEIOriginal Line for Account Assignment Item in Material Doc.MAA_URZEINUMC(4)
KDAUFSales Order NumberKDAUFCHAR(10)
KDPOSItem number in Sales OrderKDPOSNUMC(6)
KDEINDelivery schedule for sales orderKDEINNUMC(4)
EBELNPurchase order numberBSTNR*CHAR(10)
EBELPItem Number of Purchasing DocumentEBELP*NUMC(5)
LFBJAFiscal Year of a Reference DocumentLFBJANUMC(4)
LFBNRDocument No. of a Reference DocumentLFBNRCHAR(10)
LFPOSItem of a Reference DocumentLFPOSNUMC(4)
SJAHRMaterial Document YearMJAHRNUMC(4)
SMBLNNumber of Material DocumentMBLNRCHAR(10)
SMBLPItem in Material DocumentMBLPONUMC(4)
AUFNROrder NumberAUFNR*CHAR(12)
ANLN1Main Asset NumberANLN1*CHAR(12)
ANLN2Asset SubnumberANLN2*CHAR(4)
BELNRAccounting Document NumberBELNR_DCHAR(10)
BUZEINumber of Line Item Within Accounting DocumentBUZEINUMC(3)
BELUMAccounting Document NumberBELNR_DCHAR(10)
BUZUMNumber of Line Item Within Accounting DocumentBUZEINUMC(3)
RSNUMNumber of reservation/dependent requirementsRSNUM*NUMC(10)
RSPOSItem Number of Reservation / Dependent RequirementsRSPOSNUMC(4)
TBNUMTransfer Requirement NumberTBNUM*NUMC(10)
TBPOSTransfer Requirement ItemTBPOSNUMC(4)
UBNUMPosting Change NumberUBNUMNUMC(10)
TANUMTransfer Order NumberTANUMNUMC(10)
URZEIOriginal line in material documentURZEINUMC(4)
XBLNRReference Document NumberXBLNR1CHAR(16)
VBELN_IMDeliveryVBELN_VLCHAR(10)
VBELP_IMDelivery ItemPOSNR_VLNUMC(6)
LE_VBELNDeliveryVBELN_VLCHAR(10)
SPE_LOGSYSLogical System of EWM Material Document/SPE/_LOGSYS_MD*CHAR(10)
SPE_MDNUM_EWMNumber of Material Document in EWM/SPE/MDNUM_EWMCHAR(16)
CANCELLEDItem has been CancelledNSDM_CANCELLED_INDCHAR(1)
CANCELLATION_TYPERelevance for AnalyticsNSDM_CANCELLATION_TYPECHAR(1)
REVERSAL_MOVEMENTReversal movement typeXSTBWCHAR(1)
SERVICE_DOC_TYPEService Document TypeFCO_SRVDOC_TYPECHAR(4)
SERVICE_DOC_IDService Document IDFCO_SRVDOC_IDCHAR(10)
SERVICE_DOC_ITEM_IDService Document Item IDFCO_SRVDOC_ITEM_IDNUMC(6)
EWM_LGNUMWarehouse Number/Warehouse Complex/SCWM/LGNUMCHAR(4)
EWM_GMDOCWarehouse Document for Goods Movement/SCWM/DE_GM_DOCNUMC(12)
BWARTMovement type (inventory management)BWART*CHAR(3)
XAUTOItem automatically createdMB_XAUTOCHAR(1)
MATNRMaterial NumberMATNRCHAR(40)
LGORTStorage locationLGORT_D*CHAR(4)
CHARGBatch NumberCHARG_D*CHAR(10)
BWTARValuation TypeBWTAR_D*CHAR(10)
INSMKStock TypeMB_INSMKCHAR(1)
ZUSCHBatch status keyDZUSCHCHAR(1)
ZUSTDBatch in Restricted-Use StockDZUSTDCHAR(1)
LIFNRVendor's account numberELIFNCHAR(10)
KUNNRAccount number of customerEKUNN*CHAR(10)
PLPLADistribution of DifferencesPLPLACHAR(10)
SHKZGDebit/Credit IndicatorSHKZGCHAR(1)
SHKUMDebit/credit indicator in revaluationSHKUMCHAR(1)
ELIKZDelivery Completed IndicatorELIKZCHAR(1)
SGTXTItem TextSGTXTCHAR(50)
EQUNREquipment NumberEQUNRCHAR(18)
WEMPFGoods RecipientWEMPFCHAR(12)
ABLADUnloading PointABLADCHAR(25)
GSBERBusiness AreaGSBER*CHAR(4)
KOKRSControlling AreaKOKRS*CHAR(4)
PARGBTrading partner's business areaPARGB*CHAR(4)
PARBUClearing company codePARBU*CHAR(4)
KOSTLCost CenterKOSTL*CHAR(10)
PROJNOld: Project number : No longer used --> PS_POSNRPROJNCHAR(16)
XSKSTIndicator: Statistical Posting to Cost CenterXSKSTCHAR(1)
XSAUFIndicator: Posting to Order Is StatisticalXSAUFCHAR(1)
XSPROIndicator: Posting to Project Is StatisticalXSPROCHAR(1)
XSERGIndicator: Posting to Profitability Analysis Is StatisticalXSERGCHAR(1)
XRUEMAllow Posting to Previous Period (Backposting)XRUEMCHAR(1)
XRUEJIndicator: post to previous yearXRUEJCHAR(1)
KZEARFinal issue for this reservationKZEARCHAR(1)
KZSTRTransaction/event is relevant to statisticsKZSTRCHAR(1)
UMMATReceiving/Issuing MaterialUMMAT*CHAR(40)
UMCHAReceiving/Issuing BatchUMCHA*CHAR(10)
UMLGOReceiving/issuing storage locationUMLGO*CHAR(4)
UMZSTStatus of Transfer BatchUMZSTCHAR(1)
UMZUSStatus key of transfer batchUMZUSCHAR(1)
KZBEWMovement IndicatorKZBEWCHAR(1)
KZVBRConsumption postingKZVBRCHAR(1)
KZZUGReceipt IndicatorKZZUGCHAR(1)
WEUNBGoods Receipt, Non-ValuatedWEUNBCHAR(1)
PALANWMS Number of palletsPALANDEC(11)
LGNUMWarehouse Number / Warehouse ComplexLGNUM*CHAR(3)
LGTYPStorage TypeLGTYPCHAR(3)
LGPLAStorage BinLGPLACHAR(10)
BESTQStock Category in the Warehouse Management SystemBESTQCHAR(1)
BWLVSMovement Type for Warehouse ManagementBWLVS*NUMC(3)
XBLVSIndicator: posting in warehouse management systemXBLVSCHAR(1)
VSCHNInd: interim storage posting for source stor.type and binT333_VSCHNCHAR(1)
NSCHNInd.: interim storage posting for dest.stor.type and binT333_NSCHNCHAR(1)
DYPLAIndicator: dynamic storage binDYPLACHAR(1)
TBPRITransfer PriorityTBPRICHAR(1)
WEANZNumber of GR/GI Slips to Be PrintedWEANZNUMC(3)
GRUNDReason for MovementMB_GRBEW*NUMC(4)
EVERSShipping InstructionsEVERS*CHAR(2)
EVERECompliance with Shipping InstructionsEVERE*CHAR(2)
IMKEYInternal Key for Real Estate ObjectIMKEYCHAR(8)
KSTRGCost ObjectKSTRG*CHAR(12)
PAOBJNRProfitability Segment Number (CO-PA)RKEOBJNRNUMC(10)
PRCTRProfit CenterPRCTRCHAR(10)
PS_PSP_PNRWork Breakdown Structure Element (WBS Element)PS_PSP_PNR*NUMC(8)
NPLNRNetwork Number for Account AssignmentNPLNR*CHAR(12)
AUFPLRouting number of operations in the orderCO_AUFPLNUMC(10)
APLZLInternal counterCIM_COUNTNUMC(8)
AUFPSOrder item numberCO_POSNRNUMC(4)
VPTNRPartner account numberJV_PART*CHAR(10)
FIPOSCommitment ItemFIPOS*CHAR(14)
SAKTOG/L Account NumberSAKNRCHAR(10)
XWSBRReversal of GR allowed for GR-based IV despite invoiceXWSBRCHAR(1)
EMLIFSupplier to be Supplied/Who is to Receive DeliveryEMLIF*CHAR(10)
AKTNRPromotionWAKTION*CHAR(10)
ZEKKNSequential Number of Account AssignmentDZEKKNNUMC(2)
CUOBJ_CHInternal object number of the batch classificationCUOBJ_CHNUMC(18)
PPRCTRPartner Profit CenterPPRCTR*CHAR(10)
RSARTRecord typeRSARTCHAR(1)
GEBERFundBP_GEBER*CHAR(10)
FISTLFunds CenterFISTL*CHAR(16)
BUSTMPosting string for quantitiesBUSTMCHAR(4)
BUSTWPosting String for ValuesBUSTWCHAR(4)
VPRSVPrice control indicatorVPRSVCHAR(1)
FKBERFunctional AreaFKBER*CHAR(16)
XBEAUPurchase order created at time of goods receiptXBEAUCHAR(1)
QINSPSTStatus of Goods Receipt InspectionQINSPSTCHAR(1)
MWSKZTax on sales/purchases codeMWSKZ*CHAR(2)
TXJCDTax JurisdictionTXJCD*CHAR(15)
EMATNMaterial number corresponding to manufacturer part numberEMATN*CHAR(40)
J_1AGIRUPDGoods issue revaluation performedJ_1AGIRUPDCHAR(1)
VKMWSTax on sales/purchases codeMWSKZ*CHAR(2)
BERKZMaterial Staging Indicator for Production SupplyBERKZCHAR(1)
XWOFFCalculation of val. openXWOFFCHAR(1)
BEMOTAccounting IndicatorBEMOT*CHAR(2)
PRZNRBusiness ProcessCO_PRZNR*CHAR(12)
LLIEFGoods SupplierLLIEF*CHAR(10)
LSTARActivity TypeLSTARCHAR(6)
XOBEWVendor Stock Valuation IndicatorXOBEWCHAR(1)
GRANT_NBRGrantGM_GRANT_NBRCHAR(20)
ZUSTD_T156MStock Type Modification (Read from Table T156M)BAMOK_MSEGCHAR(1)
SPE_GTS_STOCK_TYGTS Stock Type/SPE/GTS_STOCK_TYPECHAR(1)
KBLNRDocument number for earmarked fundsKBLNR_FI*CHAR(10)
KBLPOSEarmarked Funds: Document ItemKBLPOS*NUMC(3)
XMACCMultiple Account AssignmentXMACCCHAR(1)
UMMABReceiving/Issuing MaterialUMMAT*CHAR(40)
UMBARValuation Type of Transfer BatchUMBAR*CHAR(10)
UMWRKPlantWERKS_DCHAR(4)
UMSOKSpecial Stock IndicatorSOBKZ*CHAR(1)
SGT_SCATStock SegmentSGT_SCATCHAR(40)
SGT_UMSCATReceiving/Issuing Stock SegmentSGT_UMSCATCHAR(40)
SGT_RCATRequirement SegmentSGT_RCATCHAR(40)
DISUB_OWNERAccount Number of Vendor or CreditorLIFNRCHAR(10)
COMPL_MARKCompleted indicatorCOMPL_MARKCHAR(1)
FZGLS_MARKDo Not Adjust Cumulative Received QuantityFZGLSCHAR(1)
ETANP_MARKAdjust Open Quantity in Scheduling Agreement ItemETANPCHAR(1)
POPUP_MARKDisplay Dialog BoxPOPUPCHAR(1)
XSAUTCreate serial number automaticallyXSAUTCHAR(1)
SERVICEPERFORMERService PerformerSERVICEPERFORMER*CHAR(10)
PERNRPersonnel NumberPERNR_DNUMC(8)
KNTTP_GRAccount Assignment CategoryKNTTP*CHAR(1)
WORK_ITEM_IDWork Item ID/CPD/PFP_WORKITEM_IDCHAR(10)
FBUDADate on which services are renderedFBUDADATS(8)
ZTEST98765ABCDEFG - ChangeZTEST98765CHAR(80)
ZDIRECTTest 456ZTEST456CHAR(2)
FSH_SEASON_YEARSeason YearFSH_SAISJCHAR(4)
FSH_SEASONSeasonFSH_SAISOCHAR(10)
FSH_COLLECTIONFashion CollectionFSH_COLLECTION*CHAR(10)
FSH_THEMEFashion ThemeFSH_THEMECHAR(10)
WRF_CHARSTC1Characteristic Value 1WRF_CHARSTC1CHAR(18)
WRF_CHARSTC2Characteristic Value 2WRF_CHARSTC2CHAR(18)
WRF_CHARSTC3Characteristic Value 3WRF_CHARSTC3CHAR(18)
OINAVNWNon-deductible input taxNAVNWCURR(13)
OICONDCODJoint Venture Indicator (Condition Key)JV_CONDCOD*CHAR(2)
CONDIJoint Venture Indicator (Condition Key)JV_CONDCOD*CHAR(2)
ASS_PSPNRAssigned Operative WBS ElementPMMO_ASSIGNED_PS_POSNR_DNUMC(8)
BLARTDocument TypeBLART*CHAR(2)
BLAUMDocument type of revaluation documentBLAUM*CHAR(2)
TCODEUndefined range (can be used for patch levels)CHAR4CHAR(4)
BKTXTDocument Header TextBKTXTCHAR(25)
FRATHUnplanned delivery costsFRATHCURR(13)
FRBNRNumber of Bill of Lading at Time of Goods ReceiptFRBNR1CHAR(16)
WEVERVersion for Printing GR/GI SlipWEVERCHAR(1)
XABLNGoods Receipt/Issue Slip NumberXABLNCHAR(10)
AWSYSLogical SystemLOGSYSTEM*CHAR(10)
BLA2DDoc. type for additional doc. in purchase account managementBLA2D*CHAR(2)
BFWMSControl posting for external WMSBFWMSCHAR(1)
VGARTTransaction/Event TypeVGART*CHAR(2)
USNAMUser NameUSNAM*CHAR(12)
TCODE2Transaction CodeTCODE*CHAR(20)
EXNUMNumber of foreign trade data in MM and SD documentsEXNUMCHAR(10)
GTS_CUSREF_NOCustoms Reference Number for Scrapping/SAPSLL/SCREF_SPICHAR(35)
FLS_RSTOStore Return with Inbound and Outbound DeliveryFLS_RSTOCHAR(1)
MSR_ACTIVEAdvanced Returns Management ActiveMSR_ACTIVECHAR(1)
XCOMPLSingle-Character FlagCHAR1CHAR(1)
KNUMVNumber of the Document ConditionKNUMVCHAR(10)
_DATAAGINGData Filter Value for Data AgingDATA_TEMPERATUREDATS(8)
XPRINTPrint via Output ControlXNAPRCHAR(1)
LMBMVUnder/OverdeliveryLMBMVCHAR(1)
PABPMPercentage variance in order price unitPABPMDEC(4)
XFMATMaterial is a missing partXFMATCHAR(1)
KNBDRPrint kanban cardKNBDRCHAR(1)

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for MATDOC

Table NameFieldCardinalityCheck Table
MATDOCZZBRAND1:ZTBRAND
MATDOCZZCHECK1:YTESTV1

Other References

The following table gives you an overview of SAP S/4HANA tcodes where the table MATDOC is used.

Transaction CodeDescription
PKMCControl Cycle Maintenance
MI01Create Physical Inventory Document
MIGO_GSSubseq. Adjust. of Material Provided
MB01Post Goods Receipt for PO
MI11Recount Physical Inventory Document
MIGO_TRTransfer Posting
QA03Display Inspection Lot
MBRLReturn Delivery for Matl Document
QA02Change Inspection Lot
PJ02Change JIT Call
MI07Process List of Differences
MB22Change Reservation
PK52Kanban Calculation Error Log
PK01Create Control Cycle
PK12Kanban Board: Supply Source View
LPK3Display Control Cycle for WM
QA01Create Inspection Lot
QA02AChange Inspection Lot
MI05Change Inventory Count
MI09Enter Inventory Count w/o Document
LPK2Change Control Cycle for WM
MI06Display Inventory Count
MB31Goods Receipt for Production Order
QA01ACreate Inspection Lot
QAC2Transfer Stock to Inspection Lot
VL09Cancel Goods Issue for Delivery Note
MB1COther Goods Receipts
LPK1Create Control Cycle for WM
PJ03Display JIT Call
MBSLCopy Material Document
PK24Enter Customer KANBAN Call
MDOC_AGING_ANALYSISAnalyze Data Aging for Mat. Doc.
MIGO_GOGoods Movement
PK12NKanban Board: Supply Source View
MIGOGoods Movement
PK02NRChange Control Cycle
MI02Change Physical Inventory Document
QAC3Cancel Sample Determination
LPK4Create Contr.Cycles for Rel.Ord.Part
MBSFRelease Blocked Stock via Mat. Doc.
PK31Container Correction
MB23Display Reservation
PK23Manual Kanban Creation
MB02Change Material Document
MB5BStocks for Posting Date
MB05Subseq. Adjustmt: Act.Ingredient Mat
PK02Change Control Cycle
MBSTCancel Material Document
MI04Enter Inventory Count with Document
MB0APost Goods Receipt for PO
MI08Create List of Differences with Doc.
PK22Kanban Quantity Signal
PK11Plant Overview: Kanban
MB03Display Material Document
MBSUPlace in Stor.for Mat.Doc: Init.Scrn
PK08Check Kanban Calculation Result
QAC1Change Insp. Lot Actual Quantity
MIGO_GIGoods Movement
PK21Change Kanban Container Status
PK13NKanban Board: Demand Source View
MI10Create List of Differences w/o Doc.
PK03Display Control Cycle
MB11Goods Movement
PK08NCheck Kanban Calculation Result
MIGO_GRGoods Movement
MI03Display Physical Inventory Document
PK41Backflush KANBAN Orders
PJWEGoods Receipt for JIT Call
MB1AGoods Withdrawal
MBNLSubsequent Delivery f. Material Doc.
PK13Kanban Board: Demand Source View
MB21Create Reservation
MB1BTransfer Posting
PK03NRDisplay Control Cycle
PKBCChnge Container Status With Bar Code
J2GLPVL09Cancelation of GI
MB04Subsequ.Adj.of "Mat.Provided"Consmp.