SAP table WRF_APC_PLH (Purchasing List Header Data)

SAP table WRF_APC_PLH has 2 primary key fields being MANDT,PLID.

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
PLID Purchasing List Number CHAR 10 0 WRF_PLID
HIER_ID Hierarchy CHAR 2 0 WRF_MATGRP_HIER WRF_HIER_CNT
NODE Hierarchy Node CHAR 18 0 WRF_MATGRP_STRUC WRF_STRUC_NODE2
SAISO Season Category CHAR 4 0 T6WSP SAISO
SAISJ Season Year CHAR 4 0 TWSAI SAISJ
ROLLOUT Rollout in a Season CHAR 2 0 TWSAI SAITY
ASRT_TYPE Assortment Type CHAR 4 0 WRFST_TYP WRFDE_ASSORTYP
SEQ_NO Sequence Number For Purchasing Lists NUMC 2 0 WRF_APC_SEQNO
EKORG Purchasing organization CHAR 4 0 T024E EKORG
EKGRP Purchasing Group CHAR 3 0 T024 EKGRP
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
TIMESTAMP Time Stamp NUMC 14 0 WRF_TIMESTAMP
FL_SYNC OAPC: Synchronisation Necessary for Purchasing List Item NUMC 2 0 WRF_APC_SYNC
00 Purchasing List (Item) is synchronous
01 Store or DC Assignments Changed
02 Some DC Assignment(s) Are No Longer Valid
04 Some Assortment Assignment(s) Are No Longer Valid
08 Purchasing List Item Needs Detailed Check
APPLLOG Application Log: Log Handle CHAR 22 0 BALLOGHNDL
FSH_SEASON_YEAR Season Year CHAR 4 0 FSH_SEASONS FSH_SAISJ
FSH_SEASON Season CHAR 10 0 FSH_SEASONS FSH_SAISO
FSH_COLLECTION Fashion Collection CHAR 10 0 FSH_COLLECTIONS FSH_COLLECTION
FSH_THEME Fashion Theme CHAR 10 0 FSH_THEMES FSH_THEME

WRF_APC_PLH foreign key relationships

Table Field Check Table Check Field
0 WRF_APC_PLH ASRT_TYPE WRFST_TYP Assortment Types MANDT
1 WRF_APC_PLH EKGRP T024 Purchasing Groups EKGRP
0 WRF_APC_PLH EKORG T024E Purchasing Organizations EKORG
1 WRF_APC_PLH FSH_COLLECTION FSH_COLLECTIONS Database table for FSH Collections FSH_SEASON_YEAR
1 WRF_APC_PLH FSH_COLLECTION FSH_COLLECTIONS Database table for FSH Collections FSH_SEASON
1 WRF_APC_PLH FSH_COLLECTION FSH_COLLECTIONS Database table for FSH Collections FSH_COLLECTION
0 WRF_APC_PLH FSH_SEASON FSH_SEASONS Database table for FSH Seasons FSH_SEASON_YEAR
0 WRF_APC_PLH FSH_SEASON FSH_SEASONS Database table for FSH Seasons FSH_SEASON
1 WRF_APC_PLH FSH_SEASON_YEAR FSH_SEASONS Database table for FSH Seasons FSH_SEASON_YEAR
1 WRF_APC_PLH FSH_SEASON_YEAR FSH_SEASONS Database table for FSH Seasons FSH_SEASON
0 WRF_APC_PLH FSH_THEME FSH_THEMES Database table for FSH Themes FSH_SEASON_YEAR
0 WRF_APC_PLH FSH_THEME FSH_THEMES Database table for FSH Themes FSH_SEASON
0 WRF_APC_PLH FSH_THEME FSH_THEMES Database table for FSH Themes FSH_COLLECTION
0 WRF_APC_PLH FSH_THEME FSH_THEMES Database table for FSH Themes FSH_THEME
1 WRF_APC_PLH HIER_ID WRF_MATGRP_HIER Article Hierarchy Properties MANDT
1 WRF_APC_PLH HIER_ID WRF_MATGRP_HIER Article Hierarchy Properties HIER_ID
0 WRF_APC_PLH MANDT T000 Clients MANDT
1 WRF_APC_PLH NODE WRF_MATGRP_STRUC Category Structure MANDT
1 WRF_APC_PLH NODE WRF_MATGRP_STRUC Category Structure HIER_ID
1 WRF_APC_PLH NODE WRF_MATGRP_STRUC Category Structure DATE_FROM
0 WRF_APC_PLH ROLLOUT TWSAI (Annual) Seasons MANDT
0 WRF_APC_PLH ROLLOUT TWSAI (Annual) Seasons SAISO
0 WRF_APC_PLH ROLLOUT TWSAI (Annual) Seasons KJAHR
1 WRF_APC_PLH SAISJ TWSAI (Annual) Seasons MANDT
1 WRF_APC_PLH SAISJ TWSAI (Annual) Seasons SAISO
1 WRF_APC_PLH SAISJ TWSAI (Annual) Seasons KJAHR
0 WRF_APC_PLH SAISO T6WSP Check Table for Season Indicator MANDT
0 WRF_APC_PLH SAISO T6WSP Check Table for Season Indicator SAISO
1 WRF_APC_PLH VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 WRF_APC_PLH VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 WRF_APC_PLH VTWEG TVTW Organizational Unit: Distribution Channels MANDT
0 WRF_APC_PLH VTWEG TVTW Organizational Unit: Distribution Channels VTWEG