SAP WSTN_AL_ALLOC Prepack allocation planning lines Table
Overview
WSTN_AL_ALLOC is a standard SAP S/4HANA table that stores Prepack allocation planning lines data. There are total 11 fields in the WSTN_AL_ALLOC table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WSTN_AL_ALLOC 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_ALLOC to other SAP tables and standard CDS views available based on WSTN_AL_ALLOC table in S/4HANA 2020.
Techincal Settings of WSTN_AL_ALLOC
Below are technical details of the table WSTN_AL_ALLOC
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WSTN_AL_ALLOC Fields
The following table gives you an overview of the fields available in WSTN_AL_ALLOC
| 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 |
| MATNR | Material Number | MATNR | MARA | CHAR | 40 |
| ATTYP | Material Category | ATTYP | CHAR | 2 | |
| PONUM | Item number in the prepack allocation plan | WSTN_AL_PONUM | WSTN_AL_POSI | NUMC | 5 |
| QTY_AL_SITE | Material Quantity Allocated per Plant | WSTN_QTY_AL_SITE | QUAN | 10 | |
| QTY_AL_TOTAL | Material quantity allocated per store group | WSTN_QTY_AL_TOTAL | QUAN | 10 | |
| AUFME | Allocation Unit | AUFME | T006 | UNIT | 3 |
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_ALLOC
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WSTN_AL_ALLOC | ASORT | C: CN | WRS1 |
| WSTN_AL_ALLOC | AUFME | : | T006 |
| WSTN_AL_ALLOC | FILGRP | C: CN | TWISPC_FILGRP |
| WSTN_AL_ALLOC | MANDT | 1: CN | T000 |
| WSTN_AL_ALLOC | MATNR | 1: CN | MARA |
| WSTN_AL_ALLOC | PONUM | 1: CN | WSTN_AL_POSI |
| WSTN_AL_ALLOC | SBELN | C: CN | SVKO |