SAP Table VBEP stores Sales Document: Schedule Line Datadata

  

In this post, I will try and describe everything you need to know about the SAP vbep table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for VBEP what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from VBEP....Right lets get started!


SAP VBEP dictionary attributes

Object Name: VBEP
Dictionary Type: Transparent table
Description: Sales Document: Schedule Line Data


VBEP field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) T000ClientMANDTTEST
VBELNVBELN_VACHAR10(0) VBUKSales DocumentVBELNAUNVA
POSNRPOSNR_VANUMC6(0) VBUPSales Document ItemPOSNRAPOVA
ETENRETENRNUMC4(0) Delivery Schedule Line NumberETENRVA
ETTYPETTYPCHAR2(0) TVEPSchedule line categoryETTYPVA
LFRELLFRELCHAR1(0) Item is relevant for deliveryXFELDVL
EDATUEDATUDATS8(0) Schedule line dateDATUMVA
EZEITEZEIT_VBEPTIMS6(0) Arrival timeUZEITVA
WMENGWMENGQUAN13(3) Order quantity in sales unitsMENG13VA
BMENGBMENGQUAN13(3) Confirmed QuantityMENG13VA
VRKMEVRKMEUNIT3(0) T006Sales unitMEINSV
LMENGLMENGQUAN13(3) Required quantity for mat.management in stockkeeping unitsMENG13VL
MEINSMEINSUNIT3(0) T006Base Unit of MeasureMEINSMG
BDDATBDDATDATS8(0) Requirement date (deadline for procurement)DATUMVA
BDARTBDARTCHAR2(0) Requirement typeBDARTBDAVA
PLARTPLARTCHAR1(0) *Planning typePLARTMD
VBELEVBELECHAR10(0) VBUKBusiness document numberVBELNV
POSNEPOSNENUMC6(0) VBUPBusiness item numberPOSNRV
ETENEETENENUMC4(0) VBEPSchedule lineETENRV
RSDATRSDATDATS8(0) Earliest possible reservation dateDATUMVA
IDNNRIDNNRNUMC10(0) Maintenance requestIDNNRVA
BANFNBANFNCHAR10(0) Purchase Requisition NumberBANFNBANMEMBAN_CBANFN
BSARTBSARTCHAR4(0) T161Order Type (Purchasing)BSARTBSAME
BSTYPBSTYPCHAR1(0) Purchasing Document CategoryBSTYPME
WEPOSWEPOS_ACHAR1(0) Confirmation status of schedule line (incl.ALE)ECOST
REPOSREPOSCHAR1(0) Invoice Receipt IndicatorXFELDME
LRGDTLRGDTDATS8(0) Return date for returnable packagingDATUMVA
PRGRSPRGRSCHAR1(0) Date type (day, week, month, interval)PRGRSVA
TDDATTDDAT_DDATS8(0) Transportation Planning DateDATUMVV
MBDATMBDATDATS8(0) Material Staging/Availability DateDATUMV
LDDATLDDATDATS8(0) Loading DateDATUMVA
WADATWADATDATS8(0) Goods Issue DateDATUMV
CMENGCMENGQUAN13(3) Corrected quantity in sales unitMENG13V
LIFSPLIFSP_EPCHAR2(0) TVLSSchedule line blocked for deliveryLIFSPVL
GRSTRGRSTRNUMC3(0) Group definition of structure dataGRSTRVSET
ABARTABARTCHAR1(0) Release typeABARTVA
ABRUFABRUFNUMC10(0) Forecast Delivery schedule numberABRUFVA
ROMS1DCQNTQUAN13(3) Committed quantityMENG13
ROMS2ROMS2QUAN13(3) Size 2MENG13CS
ROMS3ROMS3QUAN13(3) Size 3MENG13CS
ROMEIROMEIUNIT3(0) T006Unit of measure for sizes 1 to 3MEINSCS
RFORMRFORMCHAR2(0) *Formula keyRFORMCS
UMVKZUMVKZDEC5(0) Numerator (factor) for conversion of sales quantity into SKUUMBSZVS
UMVKNUMVKNDEC5(0) Denominator (Divisor) for Conversion of Sales Qty into SKUUMBSNVS
VERFPVERFP_MASCHAR1(0) Availability confirmed automaticallyXFELDVA
BWARTBWARTCHAR3(0) T156Movement Type (Inventory Management)BWARTBWAMB
BNFPOBNFPONUMC5(0) EBANItem Number of Purchase RequisitionBNFPOBAPME
ETARTEDI_ETTYPCHAR1(0) TVETSchedule line type EDIETART
AUFNRAUFNRCHAR12(0) AUFKOrder NumberAUFNRANRSAP
PLNUMPLNUMCHAR10(0) PLAFPlanned order numberPLNUMPAFMD
SERNRSERNRCHAR8(0) SNUMBOM explosion numberSERNRME
AESKDAESKDCHAR17(0) Customer Engineering Change StatusAESKD
ABGESABGES_CMFLTP16(16) Guaranteed (factor between 0 and 1)FLTP
MBUHRMBUHRTIMS6(0) Material Staging Time (Local, Relating to a Plant)TIME_PLANTV
TDUHRTDUHRTIMS6(0) Transp. Planning Time (Local, Relating to a Shipping Point)TIME_SHIPPV
LDUHRLDUHRTIMS6(0) Loading Time (Local Time Relating to a Shipping Point)TIME_SHIPP
WAUHRWAUHRTIMS6(0) Time of Goods Issue (Local, Relating to a Plant)TIME_PLANT
AULWEAULWECHAR10(0) VALWRoute ScheduleAULWE
HANDOVERDATEHANDOVER_DATEDATS8(0) Handover Date at the Handover LocationHANDOVER_DATE
HANDOVERTIMEHANDOVER_TIMETIMS6(0) Handover time at the handover locationHANDOVER_TIME
.INCLU--AP0(0)
SELADSPCM_SELNUMC1(0) Segment LevelNUM1
CCIADSPCM_CCICHAR1(0) Contractor/Customer IndicatorCHAR1
SENADSPCM_SENNUMC6(0) Segment Sequence NumberNUM6
PSELADSPCM_SELNUMC1(0) Segment LevelNUM1
PCCIADSPCM_CCICHAR1(0) Contractor/Customer IndicatorCHAR1
PSENADSPCM_SENNUMC6(0) Segment Sequence NumberNUM6
DNOADSPCM_DNOCHAR12(0) DIVERSION NUMBERCHAR12
SHMADSPCM_SHMCHAR3(0) SHIPPING METHODCHAR3
SMBADSPCM_SMBCHAR6(0) SUPPLY MANAG. BRANCH INDICATORCHAR6
ECCADSPCM_ECCCHAR7(0) EVIDENCE CONTROL CODECHAR7
PLCADSPCM_PLCCHAR1(0) PACKAGING LEVEL CODECHAR1
.INCLU--AP0(0)
MBDAT_DRSMBDAT_DRSDATS8(0) Material Availability Date Third-Party Order PlanningDATUMV