TAPL

Transparent Table Application Table
17 Fields 1 CDS Views

Allocation of task lists to functional locations

TAPL is an SAP database table in S/4HANA. Allocation of task lists to functional locations. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TaskListToFuncnlLocAlloc view_entity from BASIC Allocation of Task Lists to Functional Location

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY tplnr tplnr Functional loc.
KEY plnty plnty Task List Type
KEY plnnr plnnr Group
KEY plnal plnal Group Counter
KEY zkriz dzkriz Add. Crit. Cntr
KEY zaehl cim_count Counter
iwerk iwerk Planning Plant
datuv datuv Valid From
techv techv Tech st from
loekz lkenz Deletion Ind.
parkz parkz Inactive
aennr aennr Change Number
andat andat Created On
annam annam Created by
aedat aedat Changed On
aenam aenam Changed By

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.

-- Allocation of task lists to functional locations
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TAPL (
    MANDT,  -- Client [mandt]
    TPLNR,  -- Functional loc. [tplnr]
    PLNTY,  -- Task List Type [plnty]
    PLNNR,  -- Group [plnnr]
    PLNAL,  -- Group Counter [plnal]
    ZKRIZ,  -- Add. Crit. Cntr [dzkriz]
    ZAEHL,  -- Counter [cim_count]
    IWERK,  -- Planning Plant [iwerk]
    DATUV,  -- Valid From [datuv]
    TECHV,  -- Tech st from [techv]
    LOEKZ,  -- Deletion Ind. [lkenz]
    PARKZ,  -- Inactive [parkz]
    AENNR,  -- Change Number [aennr]
    ANDAT,  -- Created On [andat]
    ANNAM,  -- Created by [annam]
    AEDAT,  -- Changed On [aedat]
    AENAM,  -- Changed By [aenam]
    PRIMARY KEY (MANDT, TPLNR, PLNTY, PLNNR, PLNAL, ZKRIZ, ZAEHL)
);

Learn More