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