AFFL

Transparent Table Application Table
23 Fields 2 CDS Views

Work order sequence

AFFL is an SAP database table in S/4HANA. Work order sequence. It contains 23 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_OrderSequence view from BASIC Order Sequence
I_OrderSequenceBasic view_entity from BASIC Order Sequence

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY aufpl CO_AUFPL Plan No.f.Oper.
KEY aplzl CIM_COUNT Counter
plnty PLNTY Task List Type
plnnr PLNNR Group
plnal PLNAL Group Counter
plnfl PLNFOLGE Sequence
zaehl CIM_COUNT Counter
aennr AENNR Change Number
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
objnr J_OBJNR Object number
objtype OCM_OBJ_TYPE ChangeInd
ch_proc OCM_CH_PROC ChangeProcType

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.

-- Work order sequence
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AFFL (
    MANDT,    -- Client [MANDT]
    AUFPL,    -- Plan No.f.Oper. [CO_AUFPL]
    APLZL,    -- Counter [CIM_COUNT]
    PLNTY,    -- Task List Type [PLNTY]
    PLNNR,    -- Group [PLNNR]
    PLNAL,    -- Group Counter [PLNAL]
    PLNFL,    -- Sequence [PLNFOLGE]
    ZAEHL,    -- Counter [CIM_COUNT]
    AENNR,    -- Change Number [AENNR]
    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]
    OBJNR,    -- Object number [J_OBJNR]
    OBJTYPE,  -- ChangeInd [OCM_OBJ_TYPE]
    CH_PROC,  -- ChangeProcType [OCM_CH_PROC]
    PRIMARY KEY (MANDT, AUFPL, APLZL)
);

Learn More