I_DFS_FRCELMNTPLNDOP

CDS View
20 Fields 5 CDS Views

Infotype for HRP6200

I_DFS_FRCELMNTPLNDOP is a CDS View in S/4HANA. Infotype for HRP6200. It contains 20 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_DFS_PosPlndOpTP view from CONSUMPTION Position Planned Operation - TP
I_DFS_FrcElmntPlndOpTP view from TRANSACTIONAL Transactional Processing for HRP6200 - TP
I_DFS_FrcElmntPlndOpTP view union_all TRANSACTIONAL Transactional Processing for HRP6200 - TP
I_DFS_PosPlndOpTP view from TRANSACTIONAL Planned Operations for Positions - TP
I_DFS_PosPlndOpTP view union_all TRANSACTIONAL Planned Operations for Positions - TP

Fields (20)

KeyField CDS FieldsUsed in Views
KEY DfsAssgmtValdtyEndDate DfsAssgmtValdtyEndDate 2
KEY DfsAssgmtValdtyStrtDate DfsAssgmtValdtyStrtDate 2
KEY FrcElmntOrgPlanVersion FrcElmntOrgPlanVersion 2
KEY FrcElmntOrgPlngStatus FrcElmntOrgPlngStatus 2
KEY FrcElmntOrgSubType FrcElmntOrgSubType 2
KEY FrcElmntOrgType FrcElmntOrgType 2
KEY NumberOfForceElementOrg NumberOfForceElementOrg 2
KEY PlannedRelOpVariationField PlannedRelOpVariationField 2
FrcElmntOrgConcatenatedID FrcElmntOrgConcatenatedID 2
FrcElmntOrgInfoType FrcElmntOrgInfoType 2
FrcElmntOrgPlanDelimitDate FrcElmntOrgPlanDelimitDate 2
FrcElmntOrgPlanOpCode FrcElmntOrgPlanOpCode 2
FrcElmntOrgPlngStatusName FrcElmntOrgPlngStatusName 2
FrcElmntOrgPlngStsCritlty FrcElmntOrgPlngStsCritlty 1
FrcElmntOrgRefInfoType FrcElmntOrgRefInfoType 2
FrcElmntOrgRefSequenceNumber FrcElmntOrgRefSequenceNumber 2
FrcElmntOrgRefSubtype FrcElmntOrgRefSubtype 2
FrcElmntOrgRefVariationID FrcElmntOrgRefVariationID 2
FrcElmntOrgValdtyRefEndDate FrcElmntOrgValdtyRefEndDate 2
FrcElmntOrgValdtyRefStartDate FrcElmntOrgValdtyRefStartDate 2

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.

-- Infotype for HRP6200
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DFS_FRCELMNTPLNDOP (
    DFSASSGMTVALDTYENDDATE,
    DFSASSGMTVALDTYSTRTDATE,
    FRCELMNTORGPLANVERSION,
    FRCELMNTORGPLNGSTATUS,
    FRCELMNTORGSUBTYPE,
    FRCELMNTORGTYPE,
    NUMBEROFFORCEELEMENTORG,
    PLANNEDRELOPVARIATIONFIELD,
    FRCELMNTORGCONCATENATEDID,
    FRCELMNTORGINFOTYPE,
    FRCELMNTORGPLANDELIMITDATE,
    FRCELMNTORGPLANOPCODE,
    FRCELMNTORGPLNGSTATUSNAME,
    FRCELMNTORGPLNGSTSCRITLTY,
    FRCELMNTORGREFINFOTYPE,
    FRCELMNTORGREFSEQUENCENUMBER,
    FRCELMNTORGREFSUBTYPE,
    FRCELMNTORGREFVARIATIONID,
    FRCELMNTORGVALDTYREFENDDATE,
    FRCELMNTORGVALDTYREFSTARTDATE,
    PRIMARY KEY (DFSASSGMTVALDTYENDDATE, DFSASSGMTVALDTYSTRTDATE, FRCELMNTORGPLANVERSION, FRCELMNTORGPLNGSTATUS, FRCELMNTORGSUBTYPE, FRCELMNTORGTYPE, NUMBEROFFORCEELEMENTORG, PLANNEDRELOPVARIATIONFIELD)
);

Learn More