PLAB

Transparent Table Application Table
32 Fields 4 CDS Views

Relationships

PLAB is an SAP database table in S/4HANA. Relationships. It contains 32 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_BillOfOperationsRelationship view_entity from BASIC Bill of Operation Relationship
P_SchedProdnOperReln view union BASIC
P_SchedProdnPlndOrdReln view from BASIC
sdm_task_list view inner SDM: All Task List Tables

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY plnty PLNTY Task List Type
KEY plnnr AOB_PLNNR Std Network
KEY plnal PLNAL Group Counter
KEY plnkn PLNKN Node
KEY plnrn AOB_PLNNR Std Network
KEY alnrn PLNAL Group Counter
KEY knnrn PLNKN Node
KEY aobar AOBAR Relations. type
KEY mimax DAUMIMAX Max. interval
KEY zaehl CIM_COUNT Counter
datuv CIM_DATE Valid-from date
techv TECHV Tech st from
aennr AENNR Change Number
zeinh AOBDAUEH Rel. unit
dauer AOBDAUER Time Interval
daukz AOBDAUKZ Rel. duration
vornc VORG_NACH Maint.frm.succ.
ncvor NACH_VORG Sucsr maint.
loekz LOEKZ Deletion Indic.
kalid WFCID Factory Cal. ID
prznt AOB_PRZNT Time interval %
provg AOB_PROVG Time intvl key
arbid OBJEKTID Object ID
werks WERKS_D Plant
andat ANDAT Created On
annam ANNAM Created by
aedat AEDAT Changed On
aenam AENAM Changed By
dauermax AOBDAUERM max. time inter.
valid_to DATUB to
loekz_inherited LKENZ Deletion Ind.

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.

-- Relationships
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PLAB (
    MANDT,            -- Client [MANDT]
    PLNTY,            -- Task List Type [PLNTY]
    PLNNR,            -- Std Network [AOB_PLNNR]
    PLNAL,            -- Group Counter [PLNAL]
    PLNKN,            -- Node [PLNKN]
    PLNRN,            -- Std Network [AOB_PLNNR]
    ALNRN,            -- Group Counter [PLNAL]
    KNNRN,            -- Node [PLNKN]
    AOBAR,            -- Relations. type [AOBAR]
    MIMAX,            -- Max. interval [DAUMIMAX]
    ZAEHL,            -- Counter [CIM_COUNT]
    DATUV,            -- Valid-from date [CIM_DATE]
    TECHV,            -- Tech st from [TECHV]
    AENNR,            -- Change Number [AENNR]
    ZEINH,            -- Rel. unit [AOBDAUEH]
    DAUER,            -- Time Interval [AOBDAUER]
    DAUKZ,            -- Rel. duration [AOBDAUKZ]
    VORNC,            -- Maint.frm.succ. [VORG_NACH]
    NCVOR,            -- Sucsr maint. [NACH_VORG]
    LOEKZ,            -- Deletion Indic. [LOEKZ]
    KALID,            -- Factory Cal. ID [WFCID]
    PRZNT,            -- Time interval % [AOB_PRZNT]
    PROVG,            -- Time intvl key [AOB_PROVG]
    ARBID,            -- Object ID [OBJEKTID]
    WERKS,            -- Plant [WERKS_D]
    ANDAT,            -- Created On [ANDAT]
    ANNAM,            -- Created by [ANNAM]
    AEDAT,            -- Changed On [AEDAT]
    AENAM,            -- Changed By [AENAM]
    DAUERMAX,         -- max. time inter. [AOBDAUERM]
    VALID_TO,         -- to [DATUB]
    LOEKZ_INHERITED,  -- Deletion Ind. [LKENZ]
    PRIMARY KEY (MANDT, PLNTY, PLNNR, PLNAL, PLNKN, PLNRN, ALNRN, KNNRN, AOBAR, MIMAX, ZAEHL)
);

Learn More