SAP Table WSTN_AL_LINK
Relation between alloc table created and generic article
WSTN_AL_LINK (Relation between alloc table created and generic article) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link WSTN_AL_LINK to other SAP tables.
WSTN_AL_LINK table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| STYLNR | Material Number of the Generic Material | WSTR_SATNR | MARA | CHAR | 18 | 0 | ||||||
| SAISJ | Season Year | SAISJ | CHAR | 4 | 0 | |||||||
| SAISO | Season Category | SAISO | T6WSP | CHAR | 4 | 0 | ||||||
| SAITY | Rollout in a Season | SAITY | T6WSA | CHAR | 2 | 0 | ||||||
| ABELN | Allocation Table Number | ABELN | AUKO | CHAR | 10 | 0 | ||||||
| AUFAR | Allocation Table Type | AUFAR | T620 | CHAR | 4 | 0 | ||||||
| EKORG | Purchasing Organization | EKORG | T024E | CHAR | 4 | 0 | ||||||
| EKGRP | Purchasing Group | EKGRP | T024 | CHAR | 3 | 0 | ||||||
| LIFNR | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR | 10 | 0 | ||||||
| ADD_DC_PO | Extend Vendor Purchase Orders for DC | ADD_DC_PO | CHAR | 1 | 0 |
Possible values
|
||||||
| PLANNR | Prepack allocation plan number | WSTN_AL_PLANNR | NUMC | 10 | 0 | |||||||
WSTN_AL_LINK foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| WSTN_AL_LINK | ABELN | WSTN_AL_LINK | MANDT | AUKO | Allocation Table Document Header | MANDT |
| WSTN_AL_LINK | ABELN | WSTN_AL_LINK | ABELN | AUKO | Allocation Table Document Header | ABELN |
| WSTN_AL_LINK | AUFAR | WSTN_AL_LINK | MANDT | T620 | Allocation Table Document Types | MANDT |
| WSTN_AL_LINK | AUFAR | WSTN_AL_LINK | AUFAR | T620 | Allocation Table Document Types | AUFAR |
| WSTN_AL_LINK | EKGRP | WSTN_AL_LINK | MANDT | T024 | Purchasing Groups | MANDT |
| WSTN_AL_LINK | EKGRP | WSTN_AL_LINK | EKGRP | T024 | Purchasing Groups | EKGRP |
| WSTN_AL_LINK | EKORG | WSTN_AL_LINK | EKORG | T024E | Purchasing Organizations | EKORG |
| WSTN_AL_LINK | EKORG | WSTN_AL_LINK | MANDT | T024E | Purchasing Organizations | MANDT |
| WSTN_AL_LINK | LIFNR | WSTN_AL_LINK | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| WSTN_AL_LINK | LIFNR | WSTN_AL_LINK | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| WSTN_AL_LINK | MANDT | WSTN_AL_LINK | MANDT | T000 | Clients | MANDT |
| WSTN_AL_LINK | SAISO | WSTN_AL_LINK | SAISO | T6WSP | Check Table for Season Indicator | SAISO |
| WSTN_AL_LINK | SAISO | WSTN_AL_LINK | MANDT | T6WSP | Check Table for Season Indicator | MANDT |
| WSTN_AL_LINK | SAITY | WSTN_AL_LINK | MANDT | T6WSA | Categories of seasonal materials | MANDT |
| WSTN_AL_LINK | SAITY | WSTN_AL_LINK | SAITY | T6WSA | Categories of seasonal materials | SAITY |
| WSTN_AL_LINK | STYLNR | WSTN_AL_LINK | STYLNR | MARA | General Material Data | MATNR |
| WSTN_AL_LINK | STYLNR | WSTN_AL_LINK | MANDT | MARA | General Material Data | MANDT |
