SAP WSTN_AL_LINK Relation between alloc table created and generic article Table
Overview
WSTN_AL_LINK is a standard SAP S/4HANA table that stores Relation between alloc table created and generic article data. There are total 12 fields in the WSTN_AL_LINK table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WSTN_AL_LINK 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_LINK to other SAP tables and standard CDS views available based on WSTN_AL_LINK table in S/4HANA 2020.
Techincal Settings of WSTN_AL_LINK
Below are technical details of the table WSTN_AL_LINK
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WSTN_AL_LINK Fields
The following table gives you an overview of the fields available in WSTN_AL_LINK
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| STYLNR | Material Number of the Generic Material | WSTR_SATNR | MARA | CHAR | 40 |
| SAISJ | Season Year | SAISJ | CHAR | 4 | |
| SAISO | Season Category | SAISO | T6WSP | CHAR | 4 |
| SAITY | Rollout in a Season | SAITY | T6WSA | CHAR | 2 |
| ABELN | Allocation Table | ABELN | AUKO | CHAR | 10 |
| AUFAR | Allocation Table Type | AUFAR | T620 | CHAR | 4 |
| EKORG | Purchasing organization | EKORG | T024E | CHAR | 4 |
| EKGRP | Purchasing Group | EKGRP | T024 | CHAR | 3 |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR | 10 |
| ADD_DC_PO | Extend Supplier Purchase Orders for DC | ADD_DC_PO | CHAR | 1 | |
| PLANNR | Prepack allocation plan number | WSTN_AL_PLANNR | NUMC | 10 |
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_LINK
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WSTN_AL_LINK | ABELN | C: CN | AUKO |
| WSTN_AL_LINK | AUFAR | 1: CN | T620 |
| WSTN_AL_LINK | EKGRP | 1: CN | T024 |
| WSTN_AL_LINK | EKORG | 1: CN | T024E |
| WSTN_AL_LINK | LIFNR | C: CN | LFA1 |
| WSTN_AL_LINK | MANDT | 1: CN | T000 |
| WSTN_AL_LINK | SAISO | 1: CN | T6WSP |
| WSTN_AL_LINK | SAITY | C: CN | T6WSA |
| WSTN_AL_LINK | STYLNR | 1: CN | MARA |