SAP table WSTN_AL_LINK (Relation between alloc table created and generic article)

SAP table WSTN_AL_LINK has 5 primary key fields being MANDT,STYLNR,SAISJ,SAISO,SAITY.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
STYLNR Material Number of the Generic Material CHAR 40 0 MARA WSTR_SATNR
SAISJ Season Year CHAR 4 0 SAISJ
SAISO Season Category CHAR 4 0 T6WSP SAISO
SAITY Rollout in a Season CHAR 2 0 T6WSA SAITY
ABELN Allocation Table CHAR 10 0 AUKO ABELN
AUFAR Allocation Table Type CHAR 4 0 T620 AUFAR
EKORG Purchasing organization CHAR 4 0 T024E EKORG
EKGRP Purchasing Group CHAR 3 0 T024 EKGRP
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
ADD_DC_PO Extend Supplier Purchase Orders for DC CHAR 1 0 ADD_DC_PO
PLANNR Prepack allocation plan number NUMC 10 0 WSTN_AL_PLANNR

WSTN_AL_LINK foreign key relationships

Table Field Check Table Check Field
0 WSTN_AL_LINK ABELN AUKO Allocation Table Document Header ABELN
1 WSTN_AL_LINK AUFAR T620 Allocation Table Document Types MANDT
0 WSTN_AL_LINK EKGRP T024 Purchasing Groups EKGRP
1 WSTN_AL_LINK EKORG T024E Purchasing Organizations EKORG
0 WSTN_AL_LINK LIFNR LFA1 Supplier Master (General Section) MANDT
0 WSTN_AL_LINK LIFNR LFA1 Supplier Master (General Section) LIFNR
1 WSTN_AL_LINK MANDT T000 Clients MANDT
0 WSTN_AL_LINK SAISO T6WSP Check Table for Season Indicator MANDT
0 WSTN_AL_LINK SAISO T6WSP Check Table for Season Indicator SAISO
1 WSTN_AL_LINK SAITY T6WSA Categories of seasonal materials MANDT
1 WSTN_AL_LINK SAITY T6WSA Categories of seasonal materials SAITY
0 WSTN_AL_LINK STYLNR MARA General Material Data MATNR