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
Possible values
Working days according to the factory calendar
0
Non-working days (overrides factory calendar)
1
Working days (overrides factory calendar)
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