SAP table ADPMWHGRPHD (Definiton of Inventory Groups ( Master Data ))

SAP table ADPMWHGRPHD has 3 primary key fields being MANDT,WERKS,WHGBE.

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
WERKS Plant CHAR 4 0 T001W WERKS_D
WHGBE CMC: Key for Rotable Inventory Group CHAR 16 0 ADPM_IVGRPKEY
LGGRP Inventory Group ID (Rotable Control) CHAR 2 0 ADPM_LGGRP
AC Installed in Technical Object
NW New
SC Scrapped
SV Serviceable
UD Undefined / Inspection
US Unserviceable
PRHIT Hits in Days (Goods Movements in the Past) NUMC 3 0 ADPM_HITRATE
PRIND Period Indicator CHAR 1 0 PERKZ
Initial value
M Monthly
P Period according to fiscal year variant
T Daily
W Weekly
PRBCK CMC: Periods Used for ROC Calculation NUMC 3 0 ADPM_PRROC
PRFWD CMC: Periods Used for ROC Calculation NUMC 3 0 ADPM_PRROC
MNWHG Main Inventory Group Indicator (Default) CHAR 1 0 ADPM_MAINWHG
MXTAT Maximum Shopfloor Turnaround Time QUAN 9 3 ADPM_MXTAT
TATUN Normal duration/unit UNIT 3 0 T006 DAUNORE
MXUSV Maximum Stock Level of Unserviceable Parts (Used by CMC) QUAN 13 3 ADPM_MXUSVQTY
TGROC CMC: Target Stock for ROC Calculation QUAN 13 3 ADPM_ROCEND
ITROC CMC: Initial Range of Coverage [Days] NUMC 3 0 ADPM_INITROC

ADPMWHGRPHD foreign key relationships

Table Field Check Table Check Field
0 ADPMWHGRPHD MANDT T000 Clients MANDT
1 ADPMWHGRPHD WERKS T001W Plants/Branches MANDT
1 ADPMWHGRPHD WERKS T001W Plants/Branches WERKS