VBEP SAP (Sales Document: Schedule Line Data) Table details
Dictionary Type: Table
Description: Sales Document: Schedule Line Data
Description: Sales Document: Schedule Line Data
Table field list including key, data, relationships and ABAP select examples
VBEP is a standard SAP Table which is used to store Sales Document: Schedule Line Data data and is available within R/3 SAP systems depending on the version and release level.
The VBEP table consists of various fields, each holding specific information or linking keys about Sales Document: Schedule Line Data data available in SAP. These include VBELN (Sales Document), POSNR (Sales Document Item), ETENR (Delivery Schedule Line Number), ETTYP (Schedule line category).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VBEP table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VBELN | Sales Document | VBELN_VA | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
POSNR | Sales Document Item | POSNR_VA | NUMC | 6 | VBUP | POSNR | APO | ||
ETENR | Delivery Schedule Line Number | ETENR | NUMC | 4 | ETENR | ||||
ETTYP | Schedule line category | ETTYP | CHAR | 2 | TVEP | ETTYP | |||
LFREL | Item is relevant for delivery | LFREL | CHAR | 1 | XFELD | ||||
EDATU | Schedule line date | EDATU | DATS | 8 | DATUM | ||||
EZEIT | Arrival time | EZEIT_VBEP | TIMS | 6 | UZEIT | ||||
WMENG | Order quantity in sales units | WMENG | QUAN | 13(3) | MENG13 | ||||
BMENG | Confirmed Quantity | BMENG | QUAN | 13(3) | MENG13 | ||||
VRKME | Sales unit | VRKME | UNIT | 3 | T006 | CUNIT | MEINS | ||
LMENG | Required quantity for mat.management in stockkeeping units | LMENG | QUAN | 13(3) | MENG13 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
BDDAT | Requirement date (deadline for procurement) | BDDAT | DATS | 8 | DATUM | ||||
BDART | Requirement type | BDART | CHAR | 2 | BDART | BDA | |||
PLART | Planning type | PLART | CHAR | 1 | Assigned to domain | PLART | |||
VBELE | Business document number | VBELE | CHAR | 10 | VBUK | ALPHA | VBELN | ||
POSNE | Business item number | POSNE | NUMC | 6 | VBUP | POSNR | |||
ETENE | Schedule line | ETENE | NUMC | 4 | VBEP | ETENR | |||
RSDAT | Earliest possible reservation date | RSDAT | DATS | 8 | DATUM | ||||
IDNNR | Maintenance request | IDNNR | NUMC | 10 | ALPHA | IDNNR | |||
BANFN | Purchase Requisition Number | BANFN | CHAR | 10 | ALPHA | BANFN | BAN | MBAN_C | |
BSART | Order Type (Purchasing) | BSART | CHAR | 4 | T161 | BSART | BSA | ||
BSTYP | Purchasing Document Category | BSTYP | CHAR | 1 | BSTYP | ||||
WEPOS | Confirmation status of schedule line (incl.ALE) | WEPOS_A | CHAR | 1 | ECOST | ||||
REPOS | Invoice Receipt Indicator | REPOS | CHAR | 1 | XFELD | ||||
LRGDT | Return date for returnable packaging | LRGDT | DATS | 8 | DATUM | ||||
PRGRS | Date type (day, week, month, interval) | PRGRS | CHAR | 1 | PRGRS | ||||
TDDAT | Transportation Planning Date | TDDAT_D | DATS | 8 | DATUM | ||||
MBDAT | Material Staging/Availability Date | MBDAT | DATS | 8 | DATUM | ||||
LDDAT | Loading Date | LDDAT | DATS | 8 | DATUM | ||||
WADAT | Goods Issue Date | WADAT | DATS | 8 | DATUM | ||||
CMENG | Corrected quantity in sales unit | CMENG | QUAN | 13(3) | MENG13 | ||||
LIFSP | Schedule line blocked for delivery | LIFSP_EP | CHAR | 2 | TVLS | LIFSP | |||
GRSTR | Group definition of structure data | GRSTR | NUMC | 3 | GRSTR | ||||
ABART | Release type | ABART | CHAR | 1 | ABART | ||||
ABRUF | Forecast Delivery schedule number | ABRUF | NUMC | 10 | ABRUF | ||||
ROMS1 | Committed quantity | DCQNT | QUAN | 13(3) | MENG13 | ||||
ROMS2 | Size 2 | ROMS2 | QUAN | 13(3) | MENG13 | ||||
ROMS3 | Size 3 | ROMS3 | QUAN | 13(3) | MENG13 | ||||
ROMEI | Unit of measure for sizes 1 to 3 | ROMEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
RFORM | Formula key | RFORM | CHAR | 2 | Assigned to domain | RFORM | |||
UMVKZ | Numerator (factor) for conversion of sales quantity into SKU | UMVKZ | DEC | 5 | UMBSZ | ||||
UMVKN | Denominator (Divisor) for Conversion of Sales Qty into SKU | UMVKN | DEC | 5 | UMBSN | ||||
VERFP | Availability confirmed automatically | VERFP_MAS | CHAR | 1 | XFELD | ||||
BWART | Movement Type (Inventory Management) | BWART | CHAR | 3 | T156 | BWART | BWA | ||
BNFPO | Item Number of Purchase Requisition | BNFPO | NUMC | 5 | EBAN | BNFPO | BAP | ||
ETART | Schedule line type EDI | EDI_ETTYP | CHAR | 1 | TVET | ETART | |||
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
PLNUM | Planned order number | PLNUM | CHAR | 10 | PLAF | ALPHA | PLNUM | PAF | |
SERNR | BOM explosion number | SERNR | CHAR | 8 | SNUM | SERNR | |||
AESKD | Customer Engineering Change Status | AESKD | CHAR | 17 | AESKD | ||||
ABGES | Guaranteed (factor between 0 and 1) | ABGES_CM | FLTP | 16(16) | FLTP | ||||
MBUHR | Material Staging Time (Local, Relating to a Plant) | MBUHR | TIMS | 6 | TIME_PLANT | ||||
TDUHR | Transp. Planning Time (Local, Relating to a Shipping Point) | TDUHR | TIMS | 6 | TIME_SHIPP | ||||
LDUHR | Loading Time (Local Time Relating to a Shipping Point) | LDUHR | TIMS | 6 | TIME_SHIPP | ||||
WAUHR | Time of Goods Issue (Local, Relating to a Plant) | WAUHR | TIMS | 6 | TIME_PLANT | ||||
AULWE | Route Schedule | AULWE | CHAR | 10 | VALW | AULWE | |||
HANDOVERDATE | Handover Date at the Handover Location | HANDOVER_DATE | DATS | 8 | HANDOVER_DATE | ||||
HANDOVERTIME | Handover time at the handover location | HANDOVER_TIME | TIMS | 6 | HANDOVER_TIME | ||||
.INCLU--AP | 0 | ||||||||
SEL | Segment Level | ADSPCM_SEL | NUMC | 1 | NUM1 | ||||
CCI | Contractor/Customer Indicator | ADSPCM_CCI | CHAR | 1 | CHAR1 | ||||
SEN | Segment Sequence Number | ADSPCM_SEN | NUMC | 6 | NUM6 | ||||
PSEL | Segment Level | ADSPCM_SEL | NUMC | 1 | NUM1 | ||||
PCCI | Contractor/Customer Indicator | ADSPCM_CCI | CHAR | 1 | CHAR1 | ||||
PSEN | Segment Sequence Number | ADSPCM_SEN | NUMC | 6 | NUM6 | ||||
DNO | DIVERSION NUMBER | ADSPCM_DNO | CHAR | 12 | CHAR12 | ||||
SHM | SHIPPING METHOD | ADSPCM_SHM | CHAR | 3 | CHAR3 | ||||
SMB | SUPPLY MANAG. BRANCH INDICATOR | ADSPCM_SMB | CHAR | 6 | CHAR6 | ||||
ECC | EVIDENCE CONTROL CODE | ADSPCM_ECC | CHAR | 7 | CHAR7 | ||||
PLC | PACKAGING LEVEL CODE | ADSPCM_PLC | CHAR | 1 | CHAR1 | ||||
.INCLU--AP | 0 | ||||||||
MBDAT_DRS | Material Availability Date Third-Party Order Planning | MBDAT_DRS | DATS | 8 | DATUM |
Key field | Non-key field |
How do I retrieve data from SAP table VBEP using ABAP code
The following ABAP code Example will allow you to do a basic selection on VBEP to SELECT all data from the tableDATA: WA_VBEP TYPE VBEP.
SELECT SINGLE *
FROM VBEP
INTO CORRESPONDING FIELDS OF WA_VBEP
WHERE...
How to access SAP table VBEP
Within an ECC or HANA version of SAP you can also view further information about VBEP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects