SAP table KAZY (Interval of Available Capacity)
SAP table KAZY has 4 primary key fields being MANDT,KAPID,VERSN,DATUB.
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 | |||||||
| KAPID | Capacity ID | NUMC | 8 | 0 | KAKO | KAPID | |||||||
| VERSN | Available capacity version | NUMC | 2 | 0 | TC36 | KAPVERSION | |||||||
| DATUB | Valid-to date | DATS | 8 | 0 | DATUB | ||||||||
| ANZHL | Number of Individual Capacities | INT2 | 5 | 0 | KAPANZAHL | ||||||||
| ANZSH | Number of Shifts in a Day | NUMC | 1 | 0 | ANZSCHICHT | ||||||||
| ANZTG | Length of the interval cycle | NUMC | 2 | 0 | DZYKDAU | ||||||||
| FABTG | Indicator: Workdays | CHAR | 1 | 0 | KAPFABTAG |
|
|||||||
| NGRAD | Capacity Utilization Ratio in Percent | NUMC | 3 | 0 | NUTZGRAD | ||||||||
| SPROG | Key for the Shift Sequence | CHAR | 4 | 0 | TC38A | SCHPROG | |||||||
| WOTAG | Weekday | CHAR | 3 | 0 | KAP_WOTAG | ||||||||
| KKOPF | Ind.: Standard Available Capacity is Valid for this Interval | CHAR | 1 | 0 | KAP_KOPF | ||||||||
| FIRST | First day | NUMC | 2 | 0 | TAG1 |
KAZY foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 KAZY | KAPID | KAKO | Capacity Header Segment | MANDT |
| 1 KAZY | MANDT | T000 | Clients | MANDT |
| 0 KAZY | SPROG | TC38A | Shift sequence | MANDT |
| 0 KAZY | SPROG | TC38A | Shift sequence | SPROG |
| 0 KAZY | SPROG | TC38A | Shift sequence | SCHNR |
| 1 KAZY | VERSN | TC36 | Available capacity version | MANDT |
| 1 KAZY | VERSN | TC36 | Available capacity version | VERSN |