DFS_FETOPOSSTR_D

Transparent Table Application Table
29 Fields 1 CDS Views

I_FRCELMNTTOPOSSTRUCRELSHPTP I_FRCELMNTTOPOSSTRUCRELSHPTP

DFS_FETOPOSSTR_D is an SAP database table in S/4HANA. I_FRCELMNTTOPOSSTRUCRELSHPTP I_FRCELMNTTOPOSSTRUCRELSHPTP. It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FrcElmntToPosStrucRelshpDrft view from BASIC Interface View of FE To Pos Struc Relshp With Draft

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY draftuuid /bobf/uuid Key
dfsobjectid hrobjid Object ID
dfspositionrelatedobjectid sobid ID rel.object
dfsobjectplngstatus istat_d Planning status
dfspositionvaldtystartdate begdatum Start date
dfspositionvaldtyenddate enddatum End Date
dfsobjectsubtype subtyp Subtype
dfsobjectidforedit hrobjid Object ID
dfspositionrelatedobjectidfoed sobid ID rel.object
dfsobjecttype otype Object type
frcelmntorgplngstscritlty abap.int1
dfsobjectplanversion plvar Plan version
dfsobjectrelshpspec rsign Relationship
dfsobjectrelshpbtwnobj relat Relnship
dfsobjectrelshppriority priox Priority
dfspositiondescrefsqncnmbr seqnr IT record no.
dfsobjectinfotype infotyp Infotype
dfsobjectconcatenatedid otjid Obj.type/obj.ID
dfspositionrelatedobjecttype sclas Rel.obj.type
dfsobjrelshplastchgdbyusername prozt Percentage
dfsobjrelshplastchgdbyuser usrname User Name
dfsobjrelshplastchgddate aedtm Changed on
frcelmntorgplngstatus istat_d Planning status
frcelmntorgplandelimitdate gdate Delimit date
frcelmntorgplngstatusname pstext Planning Status
dfspositionvaldtystartdatefoed begdatum Start date
dfspositionvaldtyenddatefoed enddatum End Date
hasactiveentity sdraft_has_active Has active

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.

-- I_FRCELMNTTOPOSSTRUCRELSHPTP I_FRCELMNTTOPOSSTRUCRELSHPTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFS_FETOPOSSTR_D (
    MANDT,                           -- Client [mandt]
    DRAFTUUID,                       -- Key [/bobf/uuid]
    DFSOBJECTID,                     -- Object ID [hrobjid]
    DFSPOSITIONRELATEDOBJECTID,      -- ID rel.object [sobid]
    DFSOBJECTPLNGSTATUS,             -- Planning status [istat_d]
    DFSPOSITIONVALDTYSTARTDATE,      -- Start date [begdatum]
    DFSPOSITIONVALDTYENDDATE,        -- End Date [enddatum]
    DFSOBJECTSUBTYPE,                -- Subtype [subtyp]
    DFSOBJECTIDFOREDIT,              -- Object ID [hrobjid]
    DFSPOSITIONRELATEDOBJECTIDFOED,  -- ID rel.object [sobid]
    DFSOBJECTTYPE,                   -- Object type [otype]
    FRCELMNTORGPLNGSTSCRITLTY,       -- abap.int1
    DFSOBJECTPLANVERSION,            -- Plan version [plvar]
    DFSOBJECTRELSHPSPEC,             -- Relationship [rsign]
    DFSOBJECTRELSHPBTWNOBJ,          -- Relnship [relat]
    DFSOBJECTRELSHPPRIORITY,         -- Priority [priox]
    DFSPOSITIONDESCREFSQNCNMBR,      -- IT record no. [seqnr]
    DFSOBJECTINFOTYPE,               -- Infotype [infotyp]
    DFSOBJECTCONCATENATEDID,         -- Obj.type/obj.ID [otjid]
    DFSPOSITIONRELATEDOBJECTTYPE,    -- Rel.obj.type [sclas]
    DFSOBJRELSHPLASTCHGDBYUSERNAME,  -- Percentage [prozt]
    DFSOBJRELSHPLASTCHGDBYUSER,      -- User Name [usrname]
    DFSOBJRELSHPLASTCHGDDATE,        -- Changed on [aedtm]
    FRCELMNTORGPLNGSTATUS,           -- Planning status [istat_d]
    FRCELMNTORGPLANDELIMITDATE,      -- Delimit date [gdate]
    FRCELMNTORGPLNGSTATUSNAME,       -- Planning Status [pstext]
    DFSPOSITIONVALDTYSTARTDATEFOED,  -- Start date [begdatum]
    DFSPOSITIONVALDTYENDDATEFOED,    -- End Date [enddatum]
    HASACTIVEENTITY,                 -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More