SAP VALW Delivery Plan: Definition of Route Schedule Table
Overview
VALW is a standard SAP S/4HANA table that stores Delivery Plan: Definition of Route Schedule data. There are total 14 fields in the VALW table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VALW belongs to Shipping (LE-SHP) module and is located in the package WS-SHP: General Processing for Shipping (VL).
In addition, following links provide an overview of foreign key relationships, if any, that link VALW to other SAP tables and standard CDS views available based on VALW table in S/4HANA 2020.
Techincal Settings of VALW
Below are technical details of the table VALW
- Buffering switched on
- Full buffering as specified by generic key
- Storage type is Column Store
List of VALW Fields
The following table gives you an overview of the fields available in VALW
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| AULWE | Route Schedule | AULWE | CHAR | 10 | |
| ROUTE | Route | ROUTE | TVRO | CHAR | 6 |
| PRIOA | Period type: day | PRIOA | TVPO | CHAR | 3 |
| PERI_AUSPR | Goods issue day | PERI_AUSPR | CHAR | 3 | |
| W_ZEIT | Goods issue time | W_ZEIT | TIMS | 6 | |
| V_TAGE | Processing lead time - in days | V_TAGE | NUMC | 5 | |
| V_STUNDE | Processing lead time - in hours | V_STUNDE | NUMC | 2 | |
| V_MINUTEN | Processing lead time - in minutes | V_MINUTEN | NUMC | 2 | |
| AV_TAGE | Call lead time - no. of days | AV_TAGE | NUMC | 5 | |
| AV_STUNDEN | Call lead time - no. of hours | AV_STUNDEN | NUMC | 2 | |
| AV_MINUTEN | Call lead time - no. of minutes | AV_MINUTEN | NUMC | 2 | |
| ID_INT | Internal Route Schedule ID | BORRTTS_GUID | * | CHAR | 22 |
| SUBID | Schedule Item Number | BORRT_SUBID | CHAR | 4 |
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 VALW
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VALW | MANDT | 1: CN | T000 |
| VALW | PRIOA | 1: CN | TVPO |
| VALW | ROUTE | 1: CN | TVRO |