PLFH

Transparent Table Application Table
48 Fields 7 CDS Views

Task list - production resources/tools

PLFH is an SAP database table in S/4HANA. Task list - production resources/tools. It contains 48 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_BOOOperationPRTChangeState view from BASIC BOO Operation Production Resource/Tool Change State
I_RoutingPRTSearchModel view_entity from BASIC BOO Operation Production Resource/Tool
P_ProdnRoutingDocPRTAssgmtDEX view_entity from BASIC
P_ProdnRoutingMatlPRTAssgmtDEX view_entity from BASIC
P_ProdnRtgEquipPRTAssgmtDEX view_entity from BASIC
P_ProdnRtgMiscPRTAssgmtDEX view_entity from BASIC
sdm_task_list view inner SDM: All Task List Tables

Fields (48)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY plnty PLNTY Task List Type
KEY plnnr PLNNR Group
KEY pzlfh PZLFH PRT Item Count.
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
datui ANDAT Created On
useri ANNAM Created by
datuc AEDAT Changed On
userc AENAM Changed By
objty CR_OBJTY Object Type
objid CR_OBJID Object ID
objct OBJCT_D Object
plnal PLNAL Group Counter
plnfl PLNFOLGE Sequence
plnkn PLNKN Node
psnfh PSNFH Item Number
steuf STEUF PRT Control Profile
kzkbl KZKBL Load records
bzoffb BZOFFB Reference Date
offstb OFFSTB Offset
ehoffb EHOFFB Unit
bzoffe BZOFFE Reference
offste OFFSTE Offset to finsh
ehoffe EHOFFE Unit
mgeinh MGEINH Unit
mgvgw MGVGW Quantity
mgform CF_MGFORM Formula
eweinh EWEINH Usage Val. Unit
ewvgw EWVGW Usage Value
ewform CF_EWFORM Formula
txtsp SPRAS Language
ktsch CF_KTSCH Std Text Key
txtz1 TXTZ1 Text for PRT
knobj KNOBJ Assgmt no.
gp_krit1 PLOBJ Planning object
valid_to DATUB to
loekz_inherited LKENZ Deletion Ind.
versn PLNVERSN Routing Version
versn_source PLNVERSN_SOURCE_VERSN Source Version
versn_source_pzlfh PLNVERSN_SOURCE_PZLFH Src. PRT item count.
versn_origin_routing MPE_TEMPLATE_OBJECT_ORIGIN Origin
claimable MPE_PRT_CLAIMABLE Claimable
registrable MPE_PRT_REGISTRABLE Registrable

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 - production resources/tools
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PLFH (
    MANDT,                 -- Client [MANDT]
    PLNTY,                 -- Task List Type [PLNTY]
    PLNNR,                 -- Group [PLNNR]
    PZLFH,                 -- PRT Item Count. [PZLFH]
    ZAEHL,                 -- Counter [CIM_COUNT]
    DATUV,                 -- Valid From [DATUV]
    TECHV,                 -- Tech st from [TECHV]
    LOEKZ,                 -- Deletion Ind. [LKENZ]
    PARKZ,                 -- Inactive [PARKZ]
    AENNR,                 -- Change Number [AENNR]
    DATUI,                 -- Created On [ANDAT]
    USERI,                 -- Created by [ANNAM]
    DATUC,                 -- Changed On [AEDAT]
    USERC,                 -- Changed By [AENAM]
    OBJTY,                 -- Object Type [CR_OBJTY]
    OBJID,                 -- Object ID [CR_OBJID]
    OBJCT,                 -- Object [OBJCT_D]
    PLNAL,                 -- Group Counter [PLNAL]
    PLNFL,                 -- Sequence [PLNFOLGE]
    PLNKN,                 -- Node [PLNKN]
    PSNFH,                 -- Item Number [PSNFH]
    STEUF,                 -- PRT Control Profile [STEUF]
    KZKBL,                 -- Load records [KZKBL]
    BZOFFB,                -- Reference Date [BZOFFB]
    OFFSTB,                -- Offset [OFFSTB]
    EHOFFB,                -- Unit [EHOFFB]
    BZOFFE,                -- Reference [BZOFFE]
    OFFSTE,                -- Offset to finsh [OFFSTE]
    EHOFFE,                -- Unit [EHOFFE]
    MGEINH,                -- Unit [MGEINH]
    MGVGW,                 -- Quantity [MGVGW]
    MGFORM,                -- Formula [CF_MGFORM]
    EWEINH,                -- Usage Val. Unit [EWEINH]
    EWVGW,                 -- Usage Value [EWVGW]
    EWFORM,                -- Formula [CF_EWFORM]
    TXTSP,                 -- Language [SPRAS]
    KTSCH,                 -- Std Text Key [CF_KTSCH]
    TXTZ1,                 -- Text for PRT [TXTZ1]
    KNOBJ,                 -- Assgmt no. [KNOBJ]
    GP_KRIT1,              -- Planning object [PLOBJ]
    VALID_TO,              -- to [DATUB]
    LOEKZ_INHERITED,       -- Deletion Ind. [LKENZ]
    VERSN,                 -- Routing Version [PLNVERSN]
    VERSN_SOURCE,          -- Source Version [PLNVERSN_SOURCE_VERSN]
    VERSN_SOURCE_PZLFH,    -- Src. PRT item count. [PLNVERSN_SOURCE_PZLFH]
    VERSN_ORIGIN_ROUTING,  -- Origin [MPE_TEMPLATE_OBJECT_ORIGIN]
    CLAIMABLE,             -- Claimable [MPE_PRT_CLAIMABLE]
    REGISTRABLE,           -- Registrable [MPE_PRT_REGISTRABLE]
    PRIMARY KEY (MANDT, PLNTY, PLNNR, PZLFH, ZAEHL)
);

Learn More