I_FRCELMNTORGDFSEXTERNALRELSHP

CDS View
18 Fields 4 CDS Views

Interface View of Force Element External Relshp

I_FRCELMNTORGDFSEXTERNALRELSHP is a CDS View in S/4HANA. Interface View of Force Element External Relshp. It contains 18 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_FrcElmntOrgAddrParentAddress view union CONSUMPTION Consumption view for Address Parent list
I_AuthzdRelshpPeaceTmeFrcElmnt view from COMPOSITE Basic View For FE Relations Peace Time
I_AuthzdRelshpWarTmeFrcElmnt view from COMPOSITE Basic View For FE Relations War Time
I_FrcElmntOrgExtRelshpWithDrft view from COMPOSITE Interface view for the External Relationship with Draft

Fields (18)

KeyField CDS FieldsUsed in Views
KEY ForceElementOrgID ForceElementOrgID 2
KEY FrcElmntOrgPlanVersion FrcElmntOrgPlanVersion 2
KEY FrcElmntOrgSubType FrcElmntOrgSubType,FrcElmntOrgUsageType 2
KEY FrcElmntOrgType FrcElmntOrgType 2
FrcElmntOrgCnctntdRelshpName FrcElmntOrgCnctntdRelshpName 1
FrcElmntOrgConcatenatedID FrcElmntOrgConcatenatedID 1
FrcElmntOrgInfoType FrcElmntOrgInfoType 1
FrcElmntOrgLastChgdByUserName FrcElmntOrgLastChgdByUserName 1
FrcElmntOrgPlanDelimitDate FrcElmntOrgPlanDelimitDate 1
FrcElmntOrgPlngStatus FrcElmntOrgPlngStatus 1
FrcElmntOrgPlngStatusName FrcElmntOrgPlngStatusName 1
FrcElmntOrgPlngStsCritlty FrcElmntOrgPlngStsCritlty 1
FrcElmntOrgRelatedOrgID FrcElmntOrgRelatedOrgID 1
FrcElmntOrgRelatedOrgType FrcElmntOrgRelatedOrgType 2
FrcElmntOrgRelshpPriority FrcElmntOrgRelshpPriority 1
FrcElmntOrgValdtyEndDate FrcElmntOrgValdtyEndDate 1
FrcElmntOrgValdtyStartDate FrcElmntOrgValdtyStartDate 1
NumberOfForceElementOrg NumberOfForceElementOrg 1

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.

-- Interface View of Force Element External Relshp
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FRCELMNTORGDFSEXTERNALRELSHP (
    FORCEELEMENTORGID,
    FRCELMNTORGPLANVERSION,
    FRCELMNTORGSUBTYPE,
    FRCELMNTORGTYPE,
    FRCELMNTORGCNCTNTDRELSHPNAME,
    FRCELMNTORGCONCATENATEDID,
    FRCELMNTORGINFOTYPE,
    FRCELMNTORGLASTCHGDBYUSERNAME,
    FRCELMNTORGPLANDELIMITDATE,
    FRCELMNTORGPLNGSTATUS,
    FRCELMNTORGPLNGSTATUSNAME,
    FRCELMNTORGPLNGSTSCRITLTY,
    FRCELMNTORGRELATEDORGID,
    FRCELMNTORGRELATEDORGTYPE,
    FRCELMNTORGRELSHPPRIORITY,
    FRCELMNTORGVALDTYENDDATE,
    FRCELMNTORGVALDTYSTARTDATE,
    NUMBEROFFORCEELEMENTORG,
    PRIMARY KEY (FORCEELEMENTORGID, FRCELMNTORGPLANVERSION, FRCELMNTORGSUBTYPE, FRCELMNTORGTYPE)
);

Learn More