SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

MSEG Table in SAP | Document Segment: Material Table & Fields List

MSEG is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of MSEG in SAP.

  • Table description : Document Segment: Material
  • Module : CRM
  • Parent Module : CRM
  • Package : MB
  • Software Component : BBPCRM
MSEG table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP MSEG Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
MBLNRNumber of Material DocumentMBLNRBELNR
MJAHRYear of material documentMJAHRGJAHR
ZEILEItem in material documentMBLPOMBLPO
.INCLUDEDocmt Structure    
LINE_IDUnique identification of document lineMB_LINE_IDMB_LINE_ID
PARENT_IDIdentifier of immediately superior lineMB_PARENT_IDMB_LINE_ID
LINE_DEPTHHierarchy level of line in documentMB_LINE_DEPTHMB_LINE_DEPTH
MAA_URZEIOriginal Line for Account Assignment Item in Material Doc.MAA_URZEIMBLPO
BWARTMovement type (inventory management)BWARTBWART
XAUTOItem automatically createdMB_XAUTOMB_XAUTO
MATNRMaterial NumberMATNRMATNR
WERKSPlantWERKS_DWERKS
LGORTStorage locationLGORT_DLGORT
CHARGBatch NumberCHARG_DCHARG
INSMKStock TypeMB_INSMKMB_INSMK
ZUSCHBatch status keyDZUSCHZUSCH
ZUSTDBatch in Restricted-Use StockDZUSTDXFELD
SOBKZSpecial Stock IndicatorSOBKZSOBKZ
LIFNRVendor's account numberELIFNLIFNR
KUNNRAccount number of customerEKUNNKUNNR
KDAUFSales Order NumberKDAUFVBELN
KDPOSItem number in Sales OrderKDPOSNUM06
KDEINDelivery schedule for sales orderKDEINNUM04
PLPLADistribution of DifferencesPLPLAPLPLA
SHKZGDebit/Credit IndicatorSHKZGSHKZG
WAERSCurrency KeyWAERSWAERS
DMBTRAmount in local currencyDMBTRWERT7
BNBTRDelivery costs in local currencyBNBTRWERT13N
BUALTAmount posted in alternative price controlBUALTWERTV7
SHKUMDebit/credit indicator in revaluationSHKUMSHKZG
DMBUMRevaluation amount on back-posting to a previous periodDMBUMWERT7
BWTARValuation typeBWTAR_DBWTAR
MENGEQuantityMENGE_DMENG13
MEINSBase Unit of MeasureMEINSMEINS
ERFMGQuantity in unit of entryERFMGMENG13
ERFMEUnit of entryERFMEMEINS
BPMNGQuantity in order price quantity unitBPMNGMENG13
BPRMEOrder Price Unit (purchasing)BBPRMMEINS
EBELNPurchase order numberBSTNREBELN
EBELPItem Number of Purchasing DocumentEBELPEBELP
LFBJAFiscal Year of a Reference DocumentLFBJAGJAHR
LFBNRDocument number of a reference documentLFBNRBELNR
LFPOSItem of a reference documentLFPOSMBLPO
SJAHRYear of material documentMJAHRGJAHR
SMBLNNumber of Material DocumentMBLNRBELNR
SMBLPItem in material documentMBLPOMBLPO
ELIKZ"Delivery Completed" IndicatorELIKZXFELD
SGTXTItem TextSGTXTTEXT50
EQUNREquipment NumberEQUNREQUNR
WEMPFGoods recipientWEMPFWEMPF
ABLADUnloading PointABLADTEXT25
GSBERBusiness AreaGSBERGSBER
KOKRSControlling AreaKOKRSCACCD
PARGBTrading partner's business areaPARGBGSBER
PARBUClearing company codePARBUBUKRS
KOSTLCost CenterKOSTLKOSTL
PROJNOld: Project number : No longer used --> PS_POSNRPROJNPROJN
AUFNROrder NumberAUFNRAUFNR
ANLN1Main Asset NumberANLN1ANLN1
ANLN2Asset SubnumberANLN2ANLN2
XSKSTIndicator: Statistical Posting to Cost CenterXSKSTXFELD
XSAUFIndicator: Posting to Order Is StatisticalXSAUFXFELD
XSPROIndicator: Posting to Project Is StatisticalXSPROXFELD
XSERGIndicator: Posting to Profitability Analysis Is StatisticalXSERGXFELD
GJAHRFiscal YearGJAHRGJAHR
XRUEMAllow Posting to Previous Period (Backposting)XRUEMXFELD
XRUEJIndicator: post to previous yearXRUEJXFELD
BUKRSCompany CodeBUKRSBUKRS
BELNRAccounting Document NumberBELNR_DBELNR
BUZEINumber of Line Item Within Accounting DocumentBUZEIBUZEI
BELUMAccounting Document NumberBELNR_DBELNR
BUZUMNumber of Line Item Within Accounting DocumentBUZEIBUZEI
RSNUMNumber of reservation/dependent requirementsRSNUMRSNUM
RSPOSItem Number of Reservation / Dependent RequirementsRSPOSRSPOS
KZEARFinal issue for this reservationKZEARXFELD
PBAMGQuantityMENGE_DMENG13
KZSTRTransaction/event is relevant to statisticsKZSTRKZSTR
UMMATReceiving/issuing materialUMMATMATNR
UMWRKReceiving plant/issuing plantUMWRKWERKS
UMLGOReceiving/issuing storage locationUMLGOLGORT
UMCHAReceiving/issuing batchUMCHACHARG
UMZSTStatus of receiving batchUMZSTZUSTD
UMZUSStatus key of transfer batchUMZUSZUSCH
UMBARValuation type of transfer batchUMBARBWTAR
UMSOKSpecial stock indicator for physical stock transferUMSOKSOBKZ
KZBEWMovement IndicatorKZBEWKZBEW
KZVBRConsumption postingKZVBRKZVBR
KZZUGReceipt indicatorKZZUGKZZUG
WEUNBGoods Receipt, Non-ValuatedWEUNBXFELD
PALANWMS Number of palletsPALANPALAN
LGNUMWarehouse Number / Warehouse ComplexLGNUMLGNUM
LGTYPStorage TypeLGTYPLGTYP
LGPLAStorage BinLGPLALGPLA
BESTQStock Category in the Warehouse Management SystemBESTQBESTQ
BWLVSMovement Type for Warehouse ManagementBWLVSBWLVS
TBNUMTransfer Requirement NumberTBNUMTBNUM
TBPOSTransfer Requirement ItemTBPOSTBPOS
XBLVSIndicator: posting in warehouse management systemXBLVSXFELD
VSCHNInd: interim storage posting for source stor.type and binT333_VSCHNXFELD
NSCHNInd.: interim storage posting for dest.stor.type and binT333_NSCHNXFELD
DYPLAIndicator: dynamic storage binDYPLAXFELD
UBNUMPosting Change NumberUBNUMUBNUM
TBPRITransfer PriorityTBPRITBPRI
TANUMTransfer Order NumberTANUMTANUM
WEANZNumber of GR/GI slips to be printedWEANZNUM3
GRUNDReason for movementMB_GRBEWMB_GRBEW
EVERSShipping InstructionsEVERSEVERS
EVERECompliance with Shipping InstructionsEVEREEVERE
IMKEYInternal Key for Real Estate ObjectIMKEYIMKEY
KSTRGCost ObjectKSTRGKSTRG
PAOBJNRProfitability Segment Number (CO-PA)RKEOBJNRRKEOBJNR
PRCTRProfit CenterPRCTRPRCTR
PS_PSP_PNRWork Breakdown Structure Element (WBS Element)PS_PSP_PNRPS_POSNR
NPLNRNetwork Number for Account AssignmentNPLNRAUFNR
AUFPLRouting number of operations in the orderCO_AUFPLAUFPL
APLZLInternal counterCIM_COUNTCIM_COUNT
AUFPSOrder item numberCO_POSNRCO_POSNR
VPTNRPartner account numberJV_PARTKUNNR
FIPOSCommitment ItemFIPOSFIPOS
SAKTOG/L Account NumberSAKNRSAKNR
BSTMGGoods receipt quantity in order unitMB_BSTMGMENG13
BSTMEOrder unitBSTMEMEINS
XWSBRReversal of GR allowed for GR-based IV despite invoiceXWSBRXFELD
EMLIFVendor to be supplied/who is to receive deliveryEMLIFLIFNR
.INCLUDE   
EXBWRExternally Entered Posting Amount in Local CurrencyEXBWRWERT7
VKWRTValue at sales prices including value-added taxVKWRTWERT7
AKTNRPromotionWAKTIONWAKTION
ZEKKNSequential Number of Account AssignmentDZEKKNNUM02
VFDATShelf Life Expiration or Best-Before DateVFDATDATUM
CUOBJ_CHInternal object number of the batch classificationCUOBJ_CHCUOBJ
EXVKWExternally Entered Sales Value in Local CurrencyEXVKWWERT7
PPRCTRPartner Profit CenterPPRCTRPRCTR
RSARTRecord typeRSARTRSART
GEBERFundBP_GEBERBP_GEBER
FISTLFunds CenterFISTLFISTL
MATBFMaterial in Respect of Which Stock is ManagedMATBFMATNR
UMMABReceiving/issuing materialUMMATMATNR
BUSTMPosting string for quantitiesBUSTMBUSTM
BUSTWPosting string for valuesBUSTWBUSTW
MENGUQuantity Updating in Material Master RecordMENGUXFELD
WERTUValue Updating in Material Master RecordWERTUXFELD
LBKUMTotal valuated stock before the postingLBKUM_MSEGMENGV13
SALK3Value of total valuated stock before the postingSALK3_MSEGWERT13N
VPRSVPrice control indicatorVPRSVVPRSV
FKBERFunctional AreaFKBERFKBER
DABRBZReference date for settlementDABRBEZDDAT
VKWRAValue at sales prices excluding value-added taxVKWRAWERT7
DABRZReference date for settlementDABRBEZDDAT
XBEAUPurchase order created at time of goods receiptXBEAUXFELD
LSMNGQuantity in Unit of Measure from Delivery NoteLSMNGMENG13
LSMEHUnit of Measure From Delivery NoteLSMEHMEINS
KZBWSValuation of Special StockKZBWSKZBWS
QINSPSTStatus of Goods Receipt InspectionQINSPSTQINSPST
URZEIOriginal line in material documentURZEIMBLPO
J_1BEXBASEAlternate base amount in document currencyJ_1BEXBASEWERT7
MWSKZTax on sales/purchases codeMWSKZMWSKZ
TXJCDTax JurisdictionTXJCDTXJCD
EMATNMaterial number corresponding to manufacturer part numberEMATNMATNR
J_1AGIRUPDGoods issue revaluation performedJ_1AGIRUPDJ_1AGIRUPD
VKMWSTax on sales/purchases codeMWSKZMWSKZ
HSDATDate of ManufactureHSDATDATUM
BERKZMaterial Staging Indicator for Production SupplyBERKZLVS_BERKZ
MAT_KDAUFSales order number of valuated sales order stockMAT_KDAUFVBELN
MAT_KDPOSSales Order Item of Valuated Sales Order StockMAT_KDPOSNUM06
MAT_PSPNRValuated customer stock WBS elementMAT_PSPNRPS_POSNR
XWOFFCalculation of val. openXWOFFXFELD
BEMOTAccounting IndicatorBEMOTBEMOT
PRZNRBusiness ProcessCO_PRZNRCO_PRZNR
LLIEFSupplying VendorLLIEFLIFNR
LSTARActivity TypeLSTARLSTAR
XOBEWVendor Stock Valuation IndicatorXOBEWXFELD
GRANT_NBRGrantGM_GRANT_NBRGM_GRANT_NBR
ZUSTD_T156MStock Type Modification (Read from Table T156M)BAMOK_MSEGBAMOK_MSEG
SPE_GTS_STOCK_TYGTS Stock Type/SPE/GTS_STOCK_TYPE/SPE/GTS_STOCK_TYPE
KBLNRDocument number for earmarked fundsKBLNR_FIKBLNR
KBLPOSEarmarked Funds: Document ItemKBLPOSKBLPOS
XMACCMultiple Account AssignmentXMACCCHAR1
VGART_MKPFTransaction/Event TypeVGARTVGART
BUDAT_MKPFPosting Date in the DocumentBUDATDATUM
CPUDT_MKPFAccounting document entry dateCPUDTDATUM
CPUTM_MKPFTime of data entryCPUTMUZEIT
USNAM_MKPFUser nameUSNAMXUBNAME
XBLNR_MKPFReference Document NumberXBLNRXBLNR
TCODE2_MKPFTransaction CodeTCODETCODE
VBELN_IMDeliveryVBELN_VLVBELN
VBELP_IMDelivery ItemPOSNR_VLPOSNR
.INCLU--APFields for Excise Duties in Material Document (MSEG)    
/BEV2/ED_KZ_VERProcessing Status of Material Document for Excise Duties/BEV2/EDKZ_VER/BEV2/EDKZ_VER
/BEV2/ED_USERUser nameUSNAMXUBNAME
/BEV2/ED_AEDATLast Changed OnAEDATDATUM
/BEV2/ED_AETIMSystem TimeSYUZEITSYTIME
.INCLU--APJoint Venture Fields    
OINAVNWNon-deductible input taxNAVNWWERT7
OICONDCODJoint Venture Indicator (Condition Key)JV_CONDCODJV_CONDCOD
CONDIJoint Venture Indicator (Condition Key)JV_CONDCODJV_CONDCOD

MSEG related tables

TableNote
MSEGDocument Segment: Material
MYSEG_EXTRACTDocument Segment: Material
SMOMSEGDocument Segment: Material
BDMS_MAPSGMapping between segment name and segment structure
CRMC_MKTTG_OT_1CRM Marketing: Segment Types for a Marketing Segment
SMOG_MAPSGMapping between segment name and segment structure
TNCS3IS-HCM: Segment-to-Group Segment Assignment
UDM_SGMT_CRAssignment of Credit Segment to Collection Segment
PSOSEGADocument Segment for Assets Document Parking
VBSECDocument Parking One-Time Data Document Segment
VBSEGADocument Segment for Document Parking - Asset Database
VBSEGDDocument Segment for Customer Document Parking
VBSEGKDocument Segment for Vendor Document Parking
VBSEGSDocument Segment for Document Parking - G/L Account Database
VBSETDocument Segment for Taxes Document Parking
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com