TPKBP

Transparent Table Customizing Table
25 Fields 1 CDS Views

Kanban calculation profile

TPKBP is an SAP database table in S/4HANA. Kanban calculation profile. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_KanbanCalculationProfile view from BASIC Kanban Calculation Profile

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY werks WERKS_D Plant
KEY kcprf KCPRF Profile
kcart KCART Calc. Type
kcsaf KCSAF Safety
kccon KCCON Constant
kcgla KCGLA Smoothing Type
verti SA_VERTL Distribution
tstrid TSTRID Time stream ID
schgrup SCHGRUP Shift Grouping
sprog SCHPROG Shift Sequence
fabkl FABKL Factory Calend.
kwbzd KWBZD RLT [Days]
kwbzm KWBZM RLT [h:min]
schgrupv SCHGRUPV Grouping (Cons.)
sprogv SCHPROGV Shift Seq. (Cons.)
fabklv FABKLV Fact. Cal. (Cons.)
pintvd PINTVD Pull Int. [Days]
pintvm PINTVM Pull Int. [h:min]
kdmbuf KDMBUF Reqmnt Buffer %
kspbuf KSPBUF Suppl. Buffer %
kdmvol KDMVOL Reqt Flucts
tstridv TSTRID Time stream ID
mrppp MRPPP Plan. Calendar
abftb ABFTB Consid. Nonwork.Days

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.

-- Kanban calculation profile
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TPKBP (
    MANDT,     -- Client [MANDT]
    WERKS,     -- Plant [WERKS_D]
    KCPRF,     -- Profile [KCPRF]
    KCART,     -- Calc. Type [KCART]
    KCSAF,     -- Safety [KCSAF]
    KCCON,     -- Constant [KCCON]
    KCGLA,     -- Smoothing Type [KCGLA]
    VERTI,     -- Distribution [SA_VERTL]
    TSTRID,    -- Time stream ID [TSTRID]
    SCHGRUP,   -- Shift Grouping [SCHGRUP]
    SPROG,     -- Shift Sequence [SCHPROG]
    FABKL,     -- Factory Calend. [FABKL]
    KWBZD,     -- RLT [Days] [KWBZD]
    KWBZM,     -- RLT [h:min] [KWBZM]
    SCHGRUPV,  -- Grouping (Cons.) [SCHGRUPV]
    SPROGV,    -- Shift Seq. (Cons.) [SCHPROGV]
    FABKLV,    -- Fact. Cal. (Cons.) [FABKLV]
    PINTVD,    -- Pull Int. [Days] [PINTVD]
    PINTVM,    -- Pull Int. [h:min] [PINTVM]
    KDMBUF,    -- Reqmnt Buffer % [KDMBUF]
    KSPBUF,    -- Suppl. Buffer % [KSPBUF]
    KDMVOL,    -- Reqt Flucts [KDMVOL]
    TSTRIDV,   -- Time stream ID [TSTRID]
    MRPPP,     -- Plan. Calendar [MRPPP]
    ABFTB,     -- Consid. Nonwork.Days [ABFTB]
    PRIMARY KEY (MANDT, WERKS, KCPRF)
);

Learn More