EAPL

Transparent Table Application Table

Allocation of task lists to pieces of equipment

EAPL is an SAP database table in S/4HANA. Allocation of task lists to pieces of equipment. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TaskListToEquipAlloc view_entity from BASIC Allocation of Task Lists to Equipments

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY equnr equnr Equipment
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
datuv datuv Valid From
techv techv Tech st from
loekz lkenz Deletion Ind.
parkz parkz Inactive
aennr aennr Change Number
swerk swerk MaintPlant
iwerk iwerk Planning Plant
plnvw pln_verwe Usage
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 pieces of equipment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EAPL (
    MANDT,  -- Client [mandt]
    EQUNR,  -- Equipment [equnr]
    PLNTY,  -- Task List Type [plnty]
    PLNNR,  -- Group [plnnr]
    PLNAL,  -- Group Counter [plnal]
    ZKRIZ,  -- Add. Crit. Cntr [dzkriz]
    ZAEHL,  -- Counter [cim_count]
    DATUV,  -- Valid From [datuv]
    TECHV,  -- Tech st from [techv]
    LOEKZ,  -- Deletion Ind. [lkenz]
    PARKZ,  -- Inactive [parkz]
    AENNR,  -- Change Number [aennr]
    SWERK,  -- MaintPlant [swerk]
    IWERK,  -- Planning Plant [iwerk]
    PLNVW,  -- Usage [pln_verwe]
    ANDAT,  -- Created On [andat]
    ANNAM,  -- Created by [annam]
    AEDAT,  -- Changed On [aedat]
    AENAM,  -- Changed By [aenam]
    PRIMARY KEY (MANDT, EQUNR, PLNTY, PLNNR, PLNAL, ZKRIZ, ZAEHL)
);