DFS_SCEN_TASKREL

Transparent Table Application Table
17 Fields 1 CDS Views

Relationship between a Task and Capability and a Task FE

DFS_SCEN_TASKREL is an SAP database table in S/4HANA. Relationship between a Task and Capability and a Task FE. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_DfsScenAltvTaskRelshpBasic view from BASIC View For Scenario Task Relationship

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY dfsscenarioaltvtaskrelshpuuid DFS_ALTV_TSK_RELSHPUUID Relationship UUID
dfsscenarioaltvtaskuuid DFS_SCENTASKUUID Task UUID
dfsscenarioaltvuuid DFS_ALTVUUID Alternative UUID
dfsscenariouuid DFS_SCENUUID Scenario UUID
dfsscenarioaltvtaskrelshptype DFS_SCEN_RELSHPTYPE Relationship Type
dfscapabilityobjectuuid DFS_COUUID Capability Obj UUID
dfscapabilityobjectid DFS_COID Capability ID
forceelementorguuid /ISDFPS/FORCE_ID GUID 32
forceelementorgid HROBJID Object ID
flxblmatlplngobjectid DFS_FMPOID FMPO ID
flxblmatlplngobjvariantid DFS_VARIANTID Variant ID
dfsassgmtnmbrofassgdmatl DFS_QUANT Quantity
dfsscenaltvtskrelshpcrtndtetme DFS_CREATEDON Created On
dfsscenaltvtskrelshpcrtedbyusr DFS_CREATEDBY Created By
dfsscentskrelshplastchgddtetme DFS_CHANGEDON Changed On
dfsscentaskrelshplastchgdbyusr DFS_CHANGEDBY Changed By

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.

-- Relationship between a Task and Capability and a Task FE
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFS_SCEN_TASKREL (
    MANDT,                           -- Client [MANDT]
    DFSSCENARIOALTVTASKRELSHPUUID,   -- Relationship UUID [DFS_ALTV_TSK_RELSHPUUID]
    DFSSCENARIOALTVTASKUUID,         -- Task UUID [DFS_SCENTASKUUID]
    DFSSCENARIOALTVUUID,             -- Alternative UUID [DFS_ALTVUUID]
    DFSSCENARIOUUID,                 -- Scenario UUID [DFS_SCENUUID]
    DFSSCENARIOALTVTASKRELSHPTYPE,   -- Relationship Type [DFS_SCEN_RELSHPTYPE]
    DFSCAPABILITYOBJECTUUID,         -- Capability Obj UUID [DFS_COUUID]
    DFSCAPABILITYOBJECTID,           -- Capability ID [DFS_COID]
    FORCEELEMENTORGUUID,             -- GUID 32 [/ISDFPS/FORCE_ID]
    FORCEELEMENTORGID,               -- Object ID [HROBJID]
    FLXBLMATLPLNGOBJECTID,           -- FMPO ID [DFS_FMPOID]
    FLXBLMATLPLNGOBJVARIANTID,       -- Variant ID [DFS_VARIANTID]
    DFSASSGMTNMBROFASSGDMATL,        -- Quantity [DFS_QUANT]
    DFSSCENALTVTSKRELSHPCRTNDTETME,  -- Created On [DFS_CREATEDON]
    DFSSCENALTVTSKRELSHPCRTEDBYUSR,  -- Created By [DFS_CREATEDBY]
    DFSSCENTSKRELSHPLASTCHGDDTETME,  -- Changed On [DFS_CHANGEDON]
    DFSSCENTASKRELSHPLASTCHGDBYUSR,  -- Changed By [DFS_CHANGEDBY]
    PRIMARY KEY (MANDT, DFSSCENARIOALTVTASKRELSHPUUID)
);

Learn More