AFFH

Transparent Table Application Table
69 Fields 2 CDS Views

PRT assignment data for the work order

AFFH is an SAP database table in S/4HANA. PRT assignment data for the work order. It contains 69 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MaintOrderOpProdnRsceTool view inner BASIC Maintenance Order Operation PRT
I_OrderProdnResourceTool view from BASIC Order Production Resource Tool

Fields (69)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY aufpl CO_AUFPL Plan No.f.Oper.
KEY pzlfh PZLFH PRT Item Count.
loekz LKENZ Deletion Ind.
parkz PARKZ Inactive
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
plnty_key PLNTY Task List Type
plnnr_key PLNNR Group
pzlfh_key PZLFH PRT Item Count.
zaehl_key CIM_COUNT Counter
objct OBJCT_D Object
aplzl CIM_COUNT Counter
psnfh PSNFH Item Number
objnr J_OBJNR Object 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
fsfhd CF_FSFHD Earliest Start Date
fsfhz CF_FSFHZ Earliest Start Time
fefhd CF_FEFHD Earliest End Date
fefhz CF_FEFHZ Earliest End Time
ssfhd CF_SSFHD Latest Start Date
ssfhz CF_SSFHZ Latest Start Time
sefhd CF_SEFHD Latest End Date
sefhz CF_SEFHZ Latest End Time
isfhd CF_ISFHD Actual Start Date
isfhz CF_ISFHZ Actual Start Time
iefhd CF_IEFHD Actual End Date
iefhz CF_IEFHZ Actual End Time
daufl CF_DAUFL Usage Duration
daueh CF_DAUEH Usage Duration Unit
mgeinh MGEINH Unit
mgvgw MGVGW Quantity
mgsoleh MGEINH Unit
mgsol MGSOL Quantity
mgisteh MGEINH Unit
mgist MGIST Actual Quantity
mgrsteh MGEINH Unit
mgrst MGRST Remaining
mgauseh MGEINH Unit
mgaus MGAUS Checked-out qty
mgform CF_MGFORM Formula
eweinh EWEINH Usage Val. Unit
ewvgw EWVGW Usage Value
ewsoleh EWEINH Usage Val. Unit
ewsol EWSOL Usage Value
ewisteh EWEINH Usage Val. Unit
ewist EWIST Actual
ewrsteh EWEINH Usage Val. Unit
ewrst EWRST Remaining
ewform CF_EWFORM Formula
txtsp SPRAS Language
ktsch CF_KTSCH Std Text Key
txtz1 TXTZ1 Text for PRT
objtype OCM_OBJ_TYPE ChangeInd
ch_proc OCM_CH_PROC ChangeProcType
aennr AENNR Change Number
prt_versn PLNVERSN Routing Version
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.

-- PRT assignment data for the work order
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AFFH (
    MANDT,        -- Client [MANDT]
    AUFPL,        -- Plan No.f.Oper. [CO_AUFPL]
    PZLFH,        -- PRT Item Count. [PZLFH]
    LOEKZ,        -- Deletion Ind. [LKENZ]
    PARKZ,        -- Inactive [PARKZ]
    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]
    PLNTY_KEY,    -- Task List Type [PLNTY]
    PLNNR_KEY,    -- Group [PLNNR]
    PZLFH_KEY,    -- PRT Item Count. [PZLFH]
    ZAEHL_KEY,    -- Counter [CIM_COUNT]
    OBJCT,        -- Object [OBJCT_D]
    APLZL,        -- Counter [CIM_COUNT]
    PSNFH,        -- Item Number [PSNFH]
    OBJNR,        -- Object number [J_OBJNR]
    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]
    FSFHD,        -- Earliest Start Date [CF_FSFHD]
    FSFHZ,        -- Earliest Start Time [CF_FSFHZ]
    FEFHD,        -- Earliest End Date [CF_FEFHD]
    FEFHZ,        -- Earliest End Time [CF_FEFHZ]
    SSFHD,        -- Latest Start Date [CF_SSFHD]
    SSFHZ,        -- Latest Start Time [CF_SSFHZ]
    SEFHD,        -- Latest End Date [CF_SEFHD]
    SEFHZ,        -- Latest End Time [CF_SEFHZ]
    ISFHD,        -- Actual Start Date [CF_ISFHD]
    ISFHZ,        -- Actual Start Time [CF_ISFHZ]
    IEFHD,        -- Actual End Date [CF_IEFHD]
    IEFHZ,        -- Actual End Time [CF_IEFHZ]
    DAUFL,        -- Usage Duration [CF_DAUFL]
    DAUEH,        -- Usage Duration Unit [CF_DAUEH]
    MGEINH,       -- Unit [MGEINH]
    MGVGW,        -- Quantity [MGVGW]
    MGSOLEH,      -- Unit [MGEINH]
    MGSOL,        -- Quantity [MGSOL]
    MGISTEH,      -- Unit [MGEINH]
    MGIST,        -- Actual Quantity [MGIST]
    MGRSTEH,      -- Unit [MGEINH]
    MGRST,        -- Remaining [MGRST]
    MGAUSEH,      -- Unit [MGEINH]
    MGAUS,        -- Checked-out qty [MGAUS]
    MGFORM,       -- Formula [CF_MGFORM]
    EWEINH,       -- Usage Val. Unit [EWEINH]
    EWVGW,        -- Usage Value [EWVGW]
    EWSOLEH,      -- Usage Val. Unit [EWEINH]
    EWSOL,        -- Usage Value [EWSOL]
    EWISTEH,      -- Usage Val. Unit [EWEINH]
    EWIST,        -- Actual [EWIST]
    EWRSTEH,      -- Usage Val. Unit [EWEINH]
    EWRST,        -- Remaining [EWRST]
    EWFORM,       -- Formula [CF_EWFORM]
    TXTSP,        -- Language [SPRAS]
    KTSCH,        -- Std Text Key [CF_KTSCH]
    TXTZ1,        -- Text for PRT [TXTZ1]
    OBJTYPE,      -- ChangeInd [OCM_OBJ_TYPE]
    CH_PROC,      -- ChangeProcType [OCM_CH_PROC]
    AENNR,        -- Change Number [AENNR]
    PRT_VERSN,    -- Routing Version [PLNVERSN]
    REGISTRABLE,  -- Registrable [MPE_PRT_REGISTRABLE]
    PRIMARY KEY (MANDT, AUFPL, PZLFH)
);

Learn More