PLKZ

Transparent Table Application Table
23 Fields 7 CDS Views

Task list: main header

PLKZ is an SAP database table in S/4HANA. Task list: main header. It contains 23 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_BillOfOperations view from BASIC Bill of Operations
I_MaintTaskListGroupCounter view from BASIC Maintenance Task List Group Counter
I_MasterRecipe view from BASIC Master Recipe Main Header Details
I_MfgEngShopFloorRtgMatlBasic view_entity inner BASIC Shop Floor Rtg with Material Assignment
I_ProductionRouting view_entity from BASIC Production Routing main header details
P_ProductionRoutingDEX view_entity from BASIC
P_RtgMainHeaderSrchMod view_entity from BASIC

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY plnty PLNTY Task List Type
KEY plnnr PLNNR Group
KEY plnal PLNAL Group Counter
abdat ABRUFDAT Last Call
abanz ABRUFANZ No. of Calls
aedat AEDATUM Changed on
aeuzeit AEUZEIT Changed at
aenam AENAM Changed By
delkz CP_DELKZ Deletion Flag
staufg STAUFG WrkCntr Op set
flg_ecm RTG_ECM Change no. ind.
flg_ecm_par RTG_ECM_PARAMETER Param.Eff.Ind.
subtype PLNSUBTYPE Version Profile
altext PLANALTEXT Description
rework MPE_REWORK_ROUTING Rework Routing
relaxed MPE_FLEXIBLE_PROCESSING Flexible
execution_in_me MPE_EXECUTION_IN_ME SAP ME
reference_template_type MPE_RTG_REF_TEMPLATE_TYPE Template Type
reference_template_subtype MPE_RTG_REF_TEMPLATE_SUBTYPE Validity
reference_template_category MPE_RTG_REF_TEMPLATE_CATEGORY Templ. Category
reference_template_owner MPE_OWNER Owner
erp_integration MPE_ERP_INTEGRATION ERP Integration

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.

-- Task list: main header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PLKZ (
    MANDT,                        -- Client [MANDT]
    PLNTY,                        -- Task List Type [PLNTY]
    PLNNR,                        -- Group [PLNNR]
    PLNAL,                        -- Group Counter [PLNAL]
    ABDAT,                        -- Last Call [ABRUFDAT]
    ABANZ,                        -- No. of Calls [ABRUFANZ]
    AEDAT,                        -- Changed on [AEDATUM]
    AEUZEIT,                      -- Changed at [AEUZEIT]
    AENAM,                        -- Changed By [AENAM]
    DELKZ,                        -- Deletion Flag [CP_DELKZ]
    STAUFG,                       -- WrkCntr Op set [STAUFG]
    FLG_ECM,                      -- Change no. ind. [RTG_ECM]
    FLG_ECM_PAR,                  -- Param.Eff.Ind. [RTG_ECM_PARAMETER]
    SUBTYPE,                      -- Version Profile [PLNSUBTYPE]
    ALTEXT,                       -- Description [PLANALTEXT]
    REWORK,                       -- Rework Routing [MPE_REWORK_ROUTING]
    RELAXED,                      -- Flexible [MPE_FLEXIBLE_PROCESSING]
    EXECUTION_IN_ME,              -- SAP ME [MPE_EXECUTION_IN_ME]
    REFERENCE_TEMPLATE_TYPE,      -- Template Type [MPE_RTG_REF_TEMPLATE_TYPE]
    REFERENCE_TEMPLATE_SUBTYPE,   -- Validity [MPE_RTG_REF_TEMPLATE_SUBTYPE]
    REFERENCE_TEMPLATE_CATEGORY,  -- Templ. Category [MPE_RTG_REF_TEMPLATE_CATEGORY]
    REFERENCE_TEMPLATE_OWNER,     -- Owner [MPE_OWNER]
    ERP_INTEGRATION,              -- ERP Integration [MPE_ERP_INTEGRATION]
    PRIMARY KEY (MANDT, PLNTY, PLNNR, PLNAL)
);

Learn More