PLFL

Transparent Table Application Table
32 Fields 3 CDS Views

Task list - sequences

PLFL is an SAP database table in S/4HANA. Task list - sequences. It contains 32 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BOOSequenceChangeState view from BASIC Bill of Operations Sequence Change State
I_RoutingSequenceSearchModel view_entity from BASIC Bill of Operations Sequence
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 plnnr Group
KEY plnal plnal Group Counter
KEY plnfl plnfolge Sequence
KEY zaehl cim_count Counter
datuv datuv Valid From
techv techv Tech st from
aennr aennr Change Number
loekz lkenz Deletion Ind.
parkz parkz Inactive
andat andat Created On
annam annam Created by
aedat aedat Changed On
aenam aenam Changed By
flgat folgenart Sequence Category
bezfl bezfl Ref. Sequence
bknt1 bezkntanf RefOpSet from
bknt2 bezkntend Ref.oper. to
ltxa1 flgtext Sequence Desc.
txtsp spras Language
losvn cp_flglosv Lot Size From
losbs cp_flglosb Lot Size To
bschl1 cp_bschl1 Rel. Branch op.
bschl2 cp_bschl2 Rel. Return op.
auschl cp_auschl Alignment Key
knobj knobj Assgmt no.
valid_to datub to
loekz_inherited lkenz Deletion Ind.
versn plnversn Routing Version
versn_source plnversn_source_versn Source Version
versn_source_plnfl plnversn_source_plnfl Source Sequence

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 - sequences
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PLFL (
    MANDT,               -- Client [mandt]
    PLNTY,               -- Task List Type [plnty]
    PLNNR,               -- Group [plnnr]
    PLNAL,               -- Group Counter [plnal]
    PLNFL,               -- Sequence [plnfolge]
    ZAEHL,               -- Counter [cim_count]
    DATUV,               -- Valid From [datuv]
    TECHV,               -- Tech st from [techv]
    AENNR,               -- Change Number [aennr]
    LOEKZ,               -- Deletion Ind. [lkenz]
    PARKZ,               -- Inactive [parkz]
    ANDAT,               -- Created On [andat]
    ANNAM,               -- Created by [annam]
    AEDAT,               -- Changed On [aedat]
    AENAM,               -- Changed By [aenam]
    FLGAT,               -- Sequence Category [folgenart]
    BEZFL,               -- Ref. Sequence [bezfl]
    BKNT1,               -- RefOpSet from [bezkntanf]
    BKNT2,               -- Ref.oper. to [bezkntend]
    LTXA1,               -- Sequence Desc. [flgtext]
    TXTSP,               -- Language [spras]
    LOSVN,               -- Lot Size From [cp_flglosv]
    LOSBS,               -- Lot Size To [cp_flglosb]
    BSCHL1,              -- Rel. Branch op. [cp_bschl1]
    BSCHL2,              -- Rel. Return op. [cp_bschl2]
    AUSCHL,              -- Alignment Key [cp_auschl]
    KNOBJ,               -- Assgmt no. [knobj]
    VALID_TO,            -- to [datub]
    LOEKZ_INHERITED,     -- Deletion Ind. [lkenz]
    VERSN,               -- Routing Version [plnversn]
    VERSN_SOURCE,        -- Source Version [plnversn_source_versn]
    VERSN_SOURCE_PLNFL,  -- Source Sequence [plnversn_source_plnfl]
    PRIMARY KEY (MANDT, PLNTY, PLNNR, PLNAL, PLNFL, ZAEHL)
);

Learn More