DFS_ASSGMT

Transparent Table Application Table
83 Fields 3 CDS Views

Assigment

DFS_ASSGMT is an SAP database table in S/4HANA. Assigment. It contains 83 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_DFS_UniversalAssignmentBasic view from EXTENSION Ext. View for Assigment
I_DFS_UnivAssgmtFlxMtPlObjDEX view_entity from BASIC Data Extractor for FE to FMPO List
I_DFS_UniversalAssignmentBasic view from BASIC Basic Intf. View for Assignment

Fields (83)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY dfsassgmtuuid DFS_ASSIGNMENT_UUID Assigment GUID
forceelementorgsrceuuid /ISDFPS/FORCE_ID GUID 32
forceelementorgsrceid HROBJID Object ID
dfscapabilityobjectuuid DFS_COUUID Capability Obj UUID
dfscapabilityobjectid DFS_COID Capability ID
dfspositionsourceuuid /ISDFPS/FORCE_ID GUID 32
dfspositionsourceid HROBJID Object ID
dfsmaintplatformuuid DFS_PLTFRMUUID Pltfrm UUID
dfsmaintplatformid DFS_PLTFRMID Platform ID
forceelementorgtargetuuid /ISDFPS/FORCE_ID GUID 32
forceelementorgtargetid HROBJID Object ID
flxblmatlplngobjectuuid DFS_FMPOUUID FMPO UUID
flxblmatlplngobjvariantuuid DFS_VARIANTUUID Variant UUID
flxblmatlplngobjectid DFS_FMPOID FMPO ID
flxblmatlplngobjvariantid DFS_VARIANTID Variant ID
product PRODUCTNUMBER Product
dfscapabilitystatementuuid DFS_CSUUID Cap Stmnt UUID
dfscapabilitystatementid DFS_CSID Statement ID
missionessentialtaskuuid DFS_METUUID MET UUID
missionessentialtaskid DFS_METASKID MET ID
dfscapabilityobjecttargetuuid DFS_COUUID Capability Obj UUID
dfscapabilityobjecttargetid DFS_COID Capability ID
frcelmntorgmaintcapblt DFS_MAINTCAP Maintenance Cap
dfsjobid HROBJID Object ID
equipment EQUNR Equipment
costcenter KOSTL Cost Center
wbselementinternalid /ISDFPS/PS_POSNR WBS Element
frcelmntorgrotationkey /ISDFPS/CON_ID Contingent Key
frcelmntorgopexerciseid /ISDFPS/OPERATION_ID Op./Exercise ID
frcelmntorgforceproviderid HROBJID Object ID
frcelmntorginitialmatlsuplrid HROBJID Object ID
frcelmntorginitialperssuplrid HROBJID Object ID
dfsassgmtsourceobjectuuid DFS_SOURCEUUID Source UUID
dfsassgmtsourceobjecttype DFS_SOURCE_TYPE Source Type
dfsassgmtstatusprofile J_STSMA Status Profile
dfsassgmtusagetype /ISDFPS/CASE_TYPE Usage Type
dfsassgmtsourcetype DFS_ASSIGNMENT_TYPE_SOURCE Source Object Type
dfsassgmttype DFS_ASSIGNMENT_TYPE Assignment Type
dfsassgmtvaldtystrtdate DFS_VALID_START_DATE Valid From (Date)
dfsassgmtvaldtystrttime DFS_VALID_START_TIME Valid From (Time)
dfsassgmtvaldtyenddate DFS_VALID_END_DATE Valid To (Date)
dfsassgmtvaldtyendtime DFS_VALID_END_TIME Valid To (Time)
dfsassgmtvaldtytimezone DFS_VALID_TIMEZONE Valid Time Zone
dfsassgmtstatusobject DFS_OBJNR Object Number
dfsassgmtstatuscode J_STATUS Status
dfsassgmtplanstatusobject DFS_OBJNR_PLAN Object No. Pl. Op.
dfsassgmtplanoperationcode DFS_PLAN_OP Planned Op. Code
dfsassgmtplandelimitdate DFS_PLAN_DELIM_DATE Planned Del. Date
dfsassgmtplandelimittime DFS_PLAN_DELIM_TIME Planned Del. Time
dfsassgmtlogicalsystem DFS_LOGSYS Logical System
dfsassgmtcomment DFS_COMMENT Comment
dfsassgmtpriority PRIOX Priority
dfsassgmtcreationdatetime DFS_CREATEDON Created On
dfsassgmtcreatedbyuser DFS_CREATEDBY Created By
dfsassgmtchangedatetime DFS_CHANGEDON Changed On
dfsassgmtlastchgdbyuser DFS_CHANGEDBY Changed By
dfsassgmtisdefaultassignment DFS_ASSIGNMENT_ISDEFAULT Default Assgnmnt Ind
dfsassgmtdamagetype DFS_DAMAGE_TYPE Maint Cap
dfsassgmtexternalproductgroup EXTWG Ext. Matl Group
dfsassgmtnmbrofassgdmatl DFS_QUANT Quantity
dfsassgmtminnmbrofassgdmatl DFS_QUANT_MIN Minimum Quantity
dfsassgmtmaxnmbrofassgdmatl DFS_QUANT_MAX Maximum Quantity
dfsassgmtmaterialindicatorcode DFS_MATIND Material Indicator
dfsassgmtcorrectionvalue DFS_CORRECTION_VALUE Adjustment Value
dfsassgmtcorrectionreason DFS_CORRECTION_REASON Adjustment Reason
dfsassgmtmaterialweightingrate DFS_WEIGHTING_FACTOR Weighting Factor
dfsassgmtismandforrdnsscalc DFS_READINESS_REQUIRED Rdnss Mndtry Ind
dfsassgmtisusedformassmatlplng DFS_MASS_CREATION Mass Creation Ind
dfsassgmtmaterialcategory DFS_MAT_TYPE Matl Category
dfsassgmtinitialsupplystatus DFS_MAT_INIT_STAT Intial Sup Stat: Mat
dfsassgmtisownprovision DFS_STOCK My Provis.
dfscapbltstmntsqncnmbr DFS_SQNCNMBR Sequence Number
dfscapbltstmnttype DFS_CSTYPE Statement Type
dfsassgmtfrcelmnttrngassmtdte DFS_TRNG_ASSMT_DATE Assessed On
dfsassgmtfrcelmnttrngassmtby DFS_TRNG_ASSMT_BY Assessed By
dfsisaccreditingmsnesnltsk DFS_ACCREDITING_METL Assessing METL
dfsplatformdetailstext DFS_PLTFRMTEXT Text
dfsplatformextension DFS_PLTFRMEXTN Platform Extension
dfsmaintpltfrmisleadpltfrm BOOLEAN_FLG Boolean Variables (X=true, space=false)
controllingarea FIS_KOKRS Controlling Area
dfsprodassgdtoleadingpltfrmid PRODUCTNUMBER Product
dummy_assgmt_incl_eew_ps CFD_DUMMY Dummy

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.

-- Assigment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFS_ASSGMT (
    CLIENT,                          -- Client [MANDT]
    DFSASSGMTUUID,                   -- Assigment GUID [DFS_ASSIGNMENT_UUID]
    FORCEELEMENTORGSRCEUUID,         -- GUID 32 [/ISDFPS/FORCE_ID]
    FORCEELEMENTORGSRCEID,           -- Object ID [HROBJID]
    DFSCAPABILITYOBJECTUUID,         -- Capability Obj UUID [DFS_COUUID]
    DFSCAPABILITYOBJECTID,           -- Capability ID [DFS_COID]
    DFSPOSITIONSOURCEUUID,           -- GUID 32 [/ISDFPS/FORCE_ID]
    DFSPOSITIONSOURCEID,             -- Object ID [HROBJID]
    DFSMAINTPLATFORMUUID,            -- Pltfrm UUID [DFS_PLTFRMUUID]
    DFSMAINTPLATFORMID,              -- Platform ID [DFS_PLTFRMID]
    FORCEELEMENTORGTARGETUUID,       -- GUID 32 [/ISDFPS/FORCE_ID]
    FORCEELEMENTORGTARGETID,         -- Object ID [HROBJID]
    FLXBLMATLPLNGOBJECTUUID,         -- FMPO UUID [DFS_FMPOUUID]
    FLXBLMATLPLNGOBJVARIANTUUID,     -- Variant UUID [DFS_VARIANTUUID]
    FLXBLMATLPLNGOBJECTID,           -- FMPO ID [DFS_FMPOID]
    FLXBLMATLPLNGOBJVARIANTID,       -- Variant ID [DFS_VARIANTID]
    PRODUCT,                         -- Product [PRODUCTNUMBER]
    DFSCAPABILITYSTATEMENTUUID,      -- Cap Stmnt UUID [DFS_CSUUID]
    DFSCAPABILITYSTATEMENTID,        -- Statement ID [DFS_CSID]
    MISSIONESSENTIALTASKUUID,        -- MET UUID [DFS_METUUID]
    MISSIONESSENTIALTASKID,          -- MET ID [DFS_METASKID]
    DFSCAPABILITYOBJECTTARGETUUID,   -- Capability Obj UUID [DFS_COUUID]
    DFSCAPABILITYOBJECTTARGETID,     -- Capability ID [DFS_COID]
    FRCELMNTORGMAINTCAPBLT,          -- Maintenance Cap [DFS_MAINTCAP]
    DFSJOBID,                        -- Object ID [HROBJID]
    EQUIPMENT,                       -- Equipment [EQUNR]
    COSTCENTER,                      -- Cost Center [KOSTL]
    WBSELEMENTINTERNALID,            -- WBS Element [/ISDFPS/PS_POSNR]
    FRCELMNTORGROTATIONKEY,          -- Contingent Key [/ISDFPS/CON_ID]
    FRCELMNTORGOPEXERCISEID,         -- Op./Exercise ID [/ISDFPS/OPERATION_ID]
    FRCELMNTORGFORCEPROVIDERID,      -- Object ID [HROBJID]
    FRCELMNTORGINITIALMATLSUPLRID,   -- Object ID [HROBJID]
    FRCELMNTORGINITIALPERSSUPLRID,   -- Object ID [HROBJID]
    DFSASSGMTSOURCEOBJECTUUID,       -- Source UUID [DFS_SOURCEUUID]
    DFSASSGMTSOURCEOBJECTTYPE,       -- Source Type [DFS_SOURCE_TYPE]
    DFSASSGMTSTATUSPROFILE,          -- Status Profile [J_STSMA]
    DFSASSGMTUSAGETYPE,              -- Usage Type [/ISDFPS/CASE_TYPE]
    DFSASSGMTSOURCETYPE,             -- Source Object Type [DFS_ASSIGNMENT_TYPE_SOURCE]
    DFSASSGMTTYPE,                   -- Assignment Type [DFS_ASSIGNMENT_TYPE]
    DFSASSGMTVALDTYSTRTDATE,         -- Valid From (Date) [DFS_VALID_START_DATE]
    DFSASSGMTVALDTYSTRTTIME,         -- Valid From (Time) [DFS_VALID_START_TIME]
    DFSASSGMTVALDTYENDDATE,          -- Valid To (Date) [DFS_VALID_END_DATE]
    DFSASSGMTVALDTYENDTIME,          -- Valid To (Time) [DFS_VALID_END_TIME]
    DFSASSGMTVALDTYTIMEZONE,         -- Valid Time Zone [DFS_VALID_TIMEZONE]
    DFSASSGMTSTATUSOBJECT,           -- Object Number [DFS_OBJNR]
    DFSASSGMTSTATUSCODE,             -- Status [J_STATUS]
    DFSASSGMTPLANSTATUSOBJECT,       -- Object No. Pl. Op. [DFS_OBJNR_PLAN]
    DFSASSGMTPLANOPERATIONCODE,      -- Planned Op. Code [DFS_PLAN_OP]
    DFSASSGMTPLANDELIMITDATE,        -- Planned Del. Date [DFS_PLAN_DELIM_DATE]
    DFSASSGMTPLANDELIMITTIME,        -- Planned Del. Time [DFS_PLAN_DELIM_TIME]
    DFSASSGMTLOGICALSYSTEM,          -- Logical System [DFS_LOGSYS]
    DFSASSGMTCOMMENT,                -- Comment [DFS_COMMENT]
    DFSASSGMTPRIORITY,               -- Priority [PRIOX]
    DFSASSGMTCREATIONDATETIME,       -- Created On [DFS_CREATEDON]
    DFSASSGMTCREATEDBYUSER,          -- Created By [DFS_CREATEDBY]
    DFSASSGMTCHANGEDATETIME,         -- Changed On [DFS_CHANGEDON]
    DFSASSGMTLASTCHGDBYUSER,         -- Changed By [DFS_CHANGEDBY]
    DFSASSGMTISDEFAULTASSIGNMENT,    -- Default Assgnmnt Ind [DFS_ASSIGNMENT_ISDEFAULT]
    DFSASSGMTDAMAGETYPE,             -- Maint Cap [DFS_DAMAGE_TYPE]
    DFSASSGMTEXTERNALPRODUCTGROUP,   -- Ext. Matl Group [EXTWG]
    DFSASSGMTNMBROFASSGDMATL,        -- Quantity [DFS_QUANT]
    DFSASSGMTMINNMBROFASSGDMATL,     -- Minimum Quantity [DFS_QUANT_MIN]
    DFSASSGMTMAXNMBROFASSGDMATL,     -- Maximum Quantity [DFS_QUANT_MAX]
    DFSASSGMTMATERIALINDICATORCODE,  -- Material Indicator [DFS_MATIND]
    DFSASSGMTCORRECTIONVALUE,        -- Adjustment Value [DFS_CORRECTION_VALUE]
    DFSASSGMTCORRECTIONREASON,       -- Adjustment Reason [DFS_CORRECTION_REASON]
    DFSASSGMTMATERIALWEIGHTINGRATE,  -- Weighting Factor [DFS_WEIGHTING_FACTOR]
    DFSASSGMTISMANDFORRDNSSCALC,     -- Rdnss Mndtry Ind [DFS_READINESS_REQUIRED]
    DFSASSGMTISUSEDFORMASSMATLPLNG,  -- Mass Creation Ind [DFS_MASS_CREATION]
    DFSASSGMTMATERIALCATEGORY,       -- Matl Category [DFS_MAT_TYPE]
    DFSASSGMTINITIALSUPPLYSTATUS,    -- Intial Sup Stat: Mat [DFS_MAT_INIT_STAT]
    DFSASSGMTISOWNPROVISION,         -- My Provis. [DFS_STOCK]
    DFSCAPBLTSTMNTSQNCNMBR,          -- Sequence Number [DFS_SQNCNMBR]
    DFSCAPBLTSTMNTTYPE,              -- Statement Type [DFS_CSTYPE]
    DFSASSGMTFRCELMNTTRNGASSMTDTE,   -- Assessed On [DFS_TRNG_ASSMT_DATE]
    DFSASSGMTFRCELMNTTRNGASSMTBY,    -- Assessed By [DFS_TRNG_ASSMT_BY]
    DFSISACCREDITINGMSNESNLTSK,      -- Assessing METL [DFS_ACCREDITING_METL]
    DFSPLATFORMDETAILSTEXT,          -- Text [DFS_PLTFRMTEXT]
    DFSPLATFORMEXTENSION,            -- Platform Extension [DFS_PLTFRMEXTN]
    DFSMAINTPLTFRMISLEADPLTFRM,      -- Boolean Variables (X=true, space=false) [BOOLEAN_FLG]
    CONTROLLINGAREA,                 -- Controlling Area [FIS_KOKRS]
    DFSPRODASSGDTOLEADINGPLTFRMID,   -- Product [PRODUCTNUMBER]
    DUMMY_ASSGMT_INCL_EEW_PS,        -- Dummy [CFD_DUMMY]
    PRIMARY KEY (CLIENT, DFSASSGMTUUID)
);

Learn More