KAPA

Transparent Table Application Table
18 Fields 1 CDS Views

Shift Parameters for Available Capacity

KAPA is an SAP database table in S/4HANA. Shift Parameters for Available Capacity. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AvailableCapacityShift view from BASIC Available Capacity Shift

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY kapid kapid Capacity ID
KEY versn kapversion Version
KEY datub endda End Date
KEY tagnr cr_tagnr Weekday number
KEY schnr schichtnr Capacity Shift
anzhl kapanzahl Number
begzt kapbegzt Start Time
einzt kapeinzt Operating Durn
endzt kapendzt End Time
fabtg kapfabtag Workdays
kapaz kapazitaet Capacity
pause kappause Break Duration
ngrad nutzgrad Utilization
tprog kaptprog Shift Definition
wotag syfdayw Factory calendar day
ang_min kapazit_vm_min Min. capacity
ang_max kapazit_vm_max Max. capacity

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Shift Parameters for Available Capacity
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KAPA (
    MANDT,    -- Client [mandt]
    KAPID,    -- Capacity ID [kapid]
    VERSN,    -- Version [kapversion]
    DATUB,    -- End Date [endda]
    TAGNR,    -- Weekday number [cr_tagnr]
    SCHNR,    -- Capacity Shift [schichtnr]
    ANZHL,    -- Number [kapanzahl]
    BEGZT,    -- Start Time [kapbegzt]
    EINZT,    -- Operating Durn [kapeinzt]
    ENDZT,    -- End Time [kapendzt]
    FABTG,    -- Workdays [kapfabtag]
    KAPAZ,    -- Capacity [kapazitaet]
    PAUSE,    -- Break Duration [kappause]
    NGRAD,    -- Utilization [nutzgrad]
    TPROG,    -- Shift Definition [kaptprog]
    WOTAG,    -- Factory calendar day [syfdayw]
    ANG_MIN,  -- Min. capacity [kapazit_vm_min]
    ANG_MAX,  -- Max. capacity [kapazit_vm_max]
    PRIMARY KEY (MANDT, KAPID, VERSN, DATUB, TAGNR, SCHNR)
);

Learn More