DFS_FETOWBSE_D

Transparent Table Application Table
40 Fields 1 CDS Views

I_FRCELMNTTOWBSELMNTTP I_FRCELMNTTOWBSELMNTTP

DFS_FETOWBSE_D is an SAP database table in S/4HANA. I_FRCELMNTTOWBSELMNTTP I_FRCELMNTTOWBSELMNTTP. It contains 40 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FrcElmntToWBSElmntDraft view from BASIC Interface View for FE to additional WBS Element Draft

Fields (40)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY draftuuid /BOBF/UUID Key
forceelementorgid HROBJID Object ID
frcelmntorgrelatedorgid SOBID ID rel.object
frcelmntorgplngstatus ISTAT_D Planning status
frcelmntorgvaldtystartdate BEGDATUM Start date
frcelmntorgvaldtyenddate ENDDATUM End Date
frcelmntorgtype OTYPE Object type
frcelmntorgplanversion PLVAR Plan version
frcelmntorgrelshpspec RSIGN Relationship
frcelmntorgrelshpbtwnobj RELAT Relnship
frcelmntorgrelshppriority PRIOX Priority
numberofforceelementorg SEQNR IT record no.
frcelmntorginfotype INFOTYP Infotype
frcelmntorgconcatenatedid OTJID Obj.type/obj.ID
frcelmntorgsubtype SUBTYP Subtype
frcelmntorgplngstscritlty abap.int1
frcelmntorgrelatedorgtype SCLAS Rel.obj.type
frcelmntorglastchgdbyuser USRNAME User Name
wbselementinternalid PS_S4_PSPNR WBS Internal ID
wbselementexternalid PS_POSID_EDIT WBS Element
wbselement PS_POSID WBS Element
wbsdescription PS_S4_POST1 WBS Element Name
projectprofilecode PROFIDPROJ Project Profile
projectinternalid PS_S4_PROJ_PSPNR Project Def.
projectexternalid PS_PSPID_EDIT Project def.
project PS_PSPID Project def.
projectdescription PS_S4_PROJ_POST1_V1 Project Name
projectprofilecodetext PROFI_TXT Description
frcelmntorgvaldtystartdatefoed BEGDATUM Start date
frcelmntorgvaldtyenddatefoed ENDDATUM End Date
frcelmntorgmeasureuuid SCMG_CASE_GUID Case Key
frcelmntorgmeasuretype /ISDFPS/ORGM_TYPE Measure Type
frcelmntorgmeasuredesc /ISDFPS/ORGM_TYPE_TEXT Ty.
hasactiveentity SDRAFT_HAS_ACTIVE Has active
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code

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_FRCELMNTTOWBSELMNTTP I_FRCELMNTTOWBSELMNTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFS_FETOWBSE_D (
    MANDT,                           -- Client [MANDT]
    DRAFTUUID,                       -- Key [/BOBF/UUID]
    FORCEELEMENTORGID,               -- Object ID [HROBJID]
    FRCELMNTORGRELATEDORGID,         -- ID rel.object [SOBID]
    FRCELMNTORGPLNGSTATUS,           -- Planning status [ISTAT_D]
    FRCELMNTORGVALDTYSTARTDATE,      -- Start date [BEGDATUM]
    FRCELMNTORGVALDTYENDDATE,        -- End Date [ENDDATUM]
    FRCELMNTORGTYPE,                 -- Object type [OTYPE]
    FRCELMNTORGPLANVERSION,          -- Plan version [PLVAR]
    FRCELMNTORGRELSHPSPEC,           -- Relationship [RSIGN]
    FRCELMNTORGRELSHPBTWNOBJ,        -- Relnship [RELAT]
    FRCELMNTORGRELSHPPRIORITY,       -- Priority [PRIOX]
    NUMBEROFFORCEELEMENTORG,         -- IT record no. [SEQNR]
    FRCELMNTORGINFOTYPE,             -- Infotype [INFOTYP]
    FRCELMNTORGCONCATENATEDID,       -- Obj.type/obj.ID [OTJID]
    FRCELMNTORGSUBTYPE,              -- Subtype [SUBTYP]
    FRCELMNTORGPLNGSTSCRITLTY,       -- abap.int1
    FRCELMNTORGRELATEDORGTYPE,       -- Rel.obj.type [SCLAS]
    FRCELMNTORGLASTCHGDBYUSER,       -- User Name [USRNAME]
    WBSELEMENTINTERNALID,            -- WBS Internal ID [PS_S4_PSPNR]
    WBSELEMENTEXTERNALID,            -- WBS Element [PS_POSID_EDIT]
    WBSELEMENT,                      -- WBS Element [PS_POSID]
    WBSDESCRIPTION,                  -- WBS Element Name [PS_S4_POST1]
    PROJECTPROFILECODE,              -- Project Profile [PROFIDPROJ]
    PROJECTINTERNALID,               -- Project Def. [PS_S4_PROJ_PSPNR]
    PROJECTEXTERNALID,               -- Project def. [PS_PSPID_EDIT]
    PROJECT,                         -- Project def. [PS_PSPID]
    PROJECTDESCRIPTION,              -- Project Name [PS_S4_PROJ_POST1_V1]
    PROJECTPROFILECODETEXT,          -- Description [PROFI_TXT]
    FRCELMNTORGVALDTYSTARTDATEFOED,  -- Start date [BEGDATUM]
    FRCELMNTORGVALDTYENDDATEFOED,    -- End Date [ENDDATUM]
    FRCELMNTORGMEASUREUUID,          -- Case Key [SCMG_CASE_GUID]
    FRCELMNTORGMEASURETYPE,          -- Measure Type [/ISDFPS/ORGM_TYPE]
    FRCELMNTORGMEASUREDESC,          -- Ty. [/ISDFPS/ORGM_TYPE_TEXT]
    HASACTIVEENTITY,                 -- Has active [SDRAFT_HAS_ACTIVE]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,    -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More