I_FRCELMNTORGEXTERNALRELSHPTP

CDS View

Transactional View of Force Element External Relshp

I_FRCELMNTORGEXTERNALRELSHPTP is a CDS View in S/4HANA. Transactional View of Force Element External Relshp. It contains 24 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_FrcElmntOrgPeaceTmeRelshpTP view from CONSUMPTION View of Force Element Peace Time Relationships
C_FrcElmntOrgWarTmeRelshpTP view from CONSUMPTION View of Force Element War Time Relationships

Fields (24)

KeyField CDS FieldsUsed in Views
KEY FrcElmntOrgConcatenatedID FrcElmntOrgConcatenatedID 2
KEY FrcElmntOrgDraftUUID FrcElmntOrgDraftUUID 2
KEY FrcElmntOrgPlngStatus FrcElmntOrgPlngStatus 2
KEY FrcElmntOrgRelatedOrgID FrcElmntOrgRelatedOrgID 2
KEY FrcElmntOrgSubType FrcElmntOrgSubType 2
KEY FrcElmntOrgValdtyEndDate FrcElmntOrgValdtyEndDate 2
KEY FrcElmntOrgValdtyStartDate FrcElmntOrgValdtyStartDate 2
Criticality Criticality 2
ForceElementOrgID ForceElementOrgID 2
ForceElementOrgIDForEdit ForceElementOrgIDForEdit 2
FrcElmntOrgCnctntdRelshpName FrcElmntOrgCnctntdRelshpName 2
FrcElmntOrgInfoType FrcElmntOrgInfoType 2
FrcElmntOrgName FrcElmntOrgName 2
FrcElmntOrgPlanVersion FrcElmntOrgPlanVersion 2
FrcElmntOrgPlngStatusFoEd FrcElmntOrgPlngStatusFoEd 2
FrcElmntOrgPlngStatusForEdit FrcElmntOrgPlngStatusForEdit 2
FrcElmntOrgRelatedOrgIDForEdit FrcElmntOrgRelatedOrgIDForEdit 2
FrcElmntOrgRelatedOrgType FrcElmntOrgRelatedOrgType 2
FrcElmntOrgRelshpPriority FrcElmntOrgRelshpPriority 2
FrcElmntOrgTechnicalStatusName FrcElmntOrgTechnicalStatusName 2
FrcElmntOrgType FrcElmntOrgType 2
FrcElmntOrgValdtyEndDateFoEd FrcElmntOrgValdtyEndDateFoEd 2
FrcElmntOrgValdtyStartDateFoEd FrcElmntOrgValdtyStartDateFoEd 2
NumberOfForceElementOrg NumberOfForceElementOrg 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.

-- Transactional View of Force Element External Relshp
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FRCELMNTORGEXTERNALRELSHPTP (
    FRCELMNTORGCONCATENATEDID,
    FRCELMNTORGDRAFTUUID,
    FRCELMNTORGPLNGSTATUS,
    FRCELMNTORGRELATEDORGID,
    FRCELMNTORGSUBTYPE,
    FRCELMNTORGVALDTYENDDATE,
    FRCELMNTORGVALDTYSTARTDATE,
    CRITICALITY,
    FORCEELEMENTORGID,
    FORCEELEMENTORGIDFOREDIT,
    FRCELMNTORGCNCTNTDRELSHPNAME,
    FRCELMNTORGINFOTYPE,
    FRCELMNTORGNAME,
    FRCELMNTORGPLANVERSION,
    FRCELMNTORGPLNGSTATUSFOED,
    FRCELMNTORGPLNGSTATUSFOREDIT,
    FRCELMNTORGRELATEDORGIDFOREDIT,
    FRCELMNTORGRELATEDORGTYPE,
    FRCELMNTORGRELSHPPRIORITY,
    FRCELMNTORGTECHNICALSTATUSNAME,
    FRCELMNTORGTYPE,
    FRCELMNTORGVALDTYENDDATEFOED,
    FRCELMNTORGVALDTYSTARTDATEFOED,
    NUMBEROFFORCEELEMENTORG,
    PRIMARY KEY (FRCELMNTORGCONCATENATEDID, FRCELMNTORGDRAFTUUID, FRCELMNTORGPLNGSTATUS, FRCELMNTORGRELATEDORGID, FRCELMNTORGSUBTYPE, FRCELMNTORGVALDTYENDDATE, FRCELMNTORGVALDTYSTARTDATE)
);