SAP WSTN_AL_AULW Prepack allocation planning delivery phases Table
Overview
WSTN_AL_AULW is a standard SAP S/4HANA table that stores Prepack allocation planning delivery phases data. There are total 12 fields in the WSTN_AL_AULW table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WSTN_AL_AULW belongs to Obsolete Functionality (LO-RFM-OBS) module and is located in the package Prepack Allocation Planning Dialog (WSTRN).
In addition, following links provide an overview of foreign key relationships, if any, that link WSTN_AL_AULW to other SAP tables and standard CDS views available based on WSTN_AL_AULW table in S/4HANA 2020.
Techincal Settings of WSTN_AL_AULW
Below are technical details of the table WSTN_AL_AULW
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WSTN_AL_AULW Fields
The following table gives you an overview of the fields available in WSTN_AL_AULW
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| PLANNR | Prepack allocation plan number | WSTN_AL_PLANNR | NUMC | 10 | |
| ASORT | Assortment | ASORT | WRS1 | CHAR | 10 |
| FILGRP | Store Group | WISP_FILGRP | TWISPC_FILGRP | NUMC | 2 |
| SBELN | No. of allocation rule | SBELN | SVKO | CHAR | 10 |
| PPNR | Material Number of the Prepack Material | WSTR_LOTNR | MARA | CHAR | 40 |
| LWNUM | Serial number | LFNR3 | NUMC | 3 | |
| WEDAT | Delivery date | LFDAT | DATS | 8 | |
| WETYP | Date type (day week month interval) | PRGRS | CHAR | 1 | |
| WEUZT | Delivery Date Time-Spot | LZEIT | TIMS | 6 | |
| WEPRZ | Delivery phase in percent of total qty | LWPRZ | NUMC | 3 | |
| DELV_TYPE | Default delivery phase type | WSTN_DELV_TYPE | CHAR | 1 |
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 WSTN_AL_AULW
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WSTN_AL_AULW | ASORT | C: CN | WRS1 |
| WSTN_AL_AULW | FILGRP | C: CN | TWISPC_FILGRP |
| WSTN_AL_AULW | MANDT | 1: CN | T000 |
| WSTN_AL_AULW | PPNR | 1: CN | MARA |
| WSTN_AL_AULW | SBELN | C: CN | SVKO |