SAP VBEP Sales Document: Schedule Line Data Table
Overview
VBEP is a standard SAP S/4HANA table that stores Sales Document: Schedule Line Data data. There are total 82 fields in the VBEP table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VBEP belongs to Sales (SD-SLS) module and is located in the package Application development R/3 Sales (VA).
In addition, following links provide an overview of foreign key relationships, if any, that link VBEP to other SAP tables and standard CDS views available based on VBEP table in S/4HANA 2020.
Techincal Settings of VBEP
Below are technical details of the table VBEP
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VBEP Fields
The following table gives you an overview of the fields available in VBEP
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| VBELN | Sales Document | VBELN_VA | CHAR | 10 | |
| POSNR | Sales Document Item | POSNR_VA | NUMC | 6 | |
| ETENR | Schedule Line Number | ETENR | NUMC | 4 | |
| ETTYP | Schedule line category | ETTYP | TVEP | CHAR | 2 |
| LFREL | Item is relevant for delivery | LFREL | CHAR | 1 | |
| EDATU | Schedule line date | EDATU | DATS | 8 | |
| EZEIT | Arrival time | EZEIT_VBEP | TIMS | 6 | |
| WMENG | Order Quantity in Sales Units | WMENG | QUAN | 13 | |
| BMENG | Confirmed Quantity | BMENG | QUAN | 13 | |
| VRKME | Sales unit | VRKME | T006 | UNIT | 3 |
| LMENG | Required quantity for mat.management in stockkeeping units | LMENG | QUAN | 13 | |
| MEINS | Base Unit of Measure | MEINS | T006 | UNIT | 3 |
| BDDAT | Requirement date (deadline for procurement) | BDDAT | DATS | 8 | |
| BDART | Requirement type | BDART | CHAR | 2 | |
| PLART | Planning type | PLART | CHAR | 1 | |
| VBELE | Business document number | VBELE | CHAR | 10 | |
| POSNE | Business item number | POSNE | NUMC | 6 | |
| ETENE | Schedule line | ETENE | VBEP | NUMC | 4 |
| RSDAT | Earliest possible reservation date | RSDAT | DATS | 8 | |
| IDNNR | Maintenance request | IDNNR | NUMC | 10 | |
| BANFN | Purchase Requisition Number | BANFN | CHAR | 10 | |
| BSART | Order Type (Purchasing) | BSART | T161 | CHAR | 4 |
| BSTYP | Purchasing Document Category | BSTYP | CHAR | 1 | |
| WEPOS | Confirmation status of schedule line (incl.ALE) | WEPOS_A | CHAR | 1 | |
| REPOS | Invoice receipt indicator | REPOS | CHAR | 1 | |
| LRGDT | Return date for returnable packaging | LRGDT | DATS | 8 | |
| PRGRS | Date type (day week month interval) | PRGRS | CHAR | 1 | |
| TDDAT | Transportation Planning Date | TDDAT_D | DATS | 8 | |
| MBDAT | Material Staging/Availability Date | MBDAT | DATS | 8 | |
| LDDAT | Loading Date | LDDAT | DATS | 8 | |
| WADAT | Goods Issue Date | WADAT | DATS | 8 | |
| CMENG | Corrected quantity in sales unit | CMENG | QUAN | 13 | |
| LIFSP | Schedule Line Blocked for Delivery | LIFSP_EP | TVLS | CHAR | 2 |
| GRSTR | Group definition of structure data | GRSTR | NUMC | 3 | |
| ABART | Release type | ABART | CHAR | 1 | |
| ABRUF | Forecast Delivery schedule number | ABRUF | NUMC | 10 | |
| ROMS1 | Committed quantity | DCQNT | QUAN | 13 | |
| ROMS2 | Size 2 | ROMS2 | QUAN | 13 | |
| ROMS3 | Size 3 | ROMS3 | QUAN | 13 | |
| ROMEI | Unit of measure for sizes 1 to 3 | ROMEI | T006 | UNIT | 3 |
| RFORM | Formula Key for Variable-Size Items | RFORM | CHAR | 2 | |
| UMVKZ | Numerator (factor) for conversion of sales quantity into SKU | UMVKZ | DEC | 5 | |
| UMVKN | Denominator (Divisor) for Conversion of Sales Qty into SKU | UMVKN | DEC | 5 | |
| VERFP | Availability confirmed automatically | VERFP_MAS | CHAR | 1 | |
| BWART | Movement type (inventory management) | BWART | T156 | CHAR | 3 |
| BNFPO | Item number of purchase requisition | BNFPO | EBAN | NUMC | 5 |
| ETART | Schedule line type EDI | EDI_ETTYP | TVET | CHAR | 1 |
| AUFNR | Order Number | AUFNR | AUFK | CHAR | 12 |
| PLNUM | Planned Order | PLNUM | PLAF | CHAR | 10 |
| SERNR | BOM explosion number | SERNR | SNUM | CHAR | 8 |
| AESKD | Customer Engineering Change Status | AESKD | CHAR | 17 | |
| ABGES | Guaranteed (factor between 0 and 1) | ABGES_CM | FLTP | 16 | |
| MBUHR | Material Staging Time (Local Relating to a Plant) | MBUHR | TIMS | 6 | |
| TDUHR | Transp. Planning Time (Local Relating to a Shipping Point) | TDUHR | TIMS | 6 | |
| LDUHR | Loading Time (Local Time Relating to a Shipping Point) | LDUHR | TIMS | 6 | |
| WAUHR | Time of Goods Issue (Local Relating to a Plant) | WAUHR | TIMS | 6 | |
| AULWE | Route Schedule | AULWE | VALW | CHAR | 10 |
| HANDOVERDATE | Handover Date at the Handover Location | HANDOVER_DATE | DATS | 8 | |
| HANDOVERTIME | Handover time at the handover location | HANDOVER_TIME | TIMS | 6 | |
| DELIVERY_DATE_TYPE_RULE | Delivery Date Rule | SD_DELIVERY_DATE_TYPE_RULE | CHAR | 1 | |
| DLVQTY_BU | Delivered Quantity | DLVQTY | QUAN | 13 | |
| DLVQTY_SU | Delivered Quantity | DLVQTY | QUAN | 13 | |
| OCDQTY_BU | Open Confirmed Delivery Quantity | OCDQTY | QUAN | 13 | |
| OCDQTY_SU | Open Confirmed Delivery Quantity | OCDQTY | QUAN | 13 | |
| ORDQTY_BU | Open requested Delivery Quantity | ORDQTY | QUAN | 13 | |
| ORDQTY_SU | Open requested Delivery Quantity | ORDQTY | QUAN | 13 | |
| CREA_DLVDATE | Delivery Creation Date | LEDAT | DATS | 8 | |
| REQ_DLVDATE | Schedule line date | EDATU | DATS | 8 | |
| BEDAR | Requirements class | BEDAR | CHAR | 3 | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 | |
| WAERK | SD document currency | WAERK | CUKY | 5 | |
| ODN_AMOUNT | Open Delivery Net Amount (in Sales Document Currency) | TDD_ODN_AMOUNT | CURR | 15 | |
| HANDLE | GUID in 'RAW' format | GUID_16 | RAW | 16 | |
| LCCST | Legal Control Check Status | TDD_LCCST | CHAR | 1 | |
| RRQQTY_BU | Requested Requirement Quantity in Base Unit | TDD_RRQQTY_BU | QUAN | 15 | |
| CRQQTY_BU | Confirmed Requirement Quantity in Base Unit | TDD_CRQQTY_BU | QUAN | 15 | |
| DUMMY_SLSDOCSCHEDL_INCL_EEW_PS | Dummy function in length 1 | DUMMY | CHAR | 1 | |
| FSH_RALLOC_QTY | ARun Requirement Allocated Quantity | FSH_RALLOC_QTY | QUAN | 13 | |
| FSH_OS_ID | Order Scheduling Group ID | FSH_OS_ID | NUMC | 4 | |
| FSH_PQR_RC | Rejection Code for Partial Quantity Rejection | FSH_PQR_RC | CHAR | 2 | |
| MBDAT_DRS | Material Availability Date Third-Party Order Planning | MBDAT_DRS | DATS | 8 |
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 VBEP
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VBEP | AUFNR | : | AUFK |
| VBEP | AULWE | : | VALW |
| VBEP | BNFPO | C: CN | EBAN |
| VBEP | BSART | C: CN | T161 |
| VBEP | BWART | C: CN | T156 |
| VBEP | ETART | C: CN | TVET |
| VBEP | ETENE | C: CN | VBEP |
| VBEP | ETTYP | 1: CN | TVEP |
| VBEP | LIFSP | C: CN | TVLS |
| VBEP | MANDT | 1: CN | T000 |
| VBEP | MEINS | C: CN | T006 |
| VBEP | PLNUM | : | PLAF |
| VBEP | ROMEI | C: CN | T006 |
| VBEP | SERNR | C: CN | SNUM |
| VBEP | VRKME | C: CN | T006 |