VVBEP 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
VVBEP 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 VVBEP 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: Not classified
SAP VVBEP 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 | Assigned to domain | 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 |
Key field | Non-key field |
How do I retrieve data from SAP table VVBEP using ABAP code
The following ABAP code Example will allow you to do a basic selection on VVBEP to SELECT all data from the tableDATA: WA_VVBEP TYPE VVBEP.
SELECT SINGLE *
FROM VVBEP
INTO CORRESPONDING FIELDS OF WA_VVBEP
WHERE...
How to access SAP table VVBEP
Within an ECC or HANA version of SAP you can also view further information about VVBEP 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