I_FRCELMNTTOOPEXERRELSHPTP

CDS View
25 Fields 7 CDS Views

Transactional view of Operation/Exercise Relationship

I_FRCELMNTTOOPEXERRELSHPTP is a CDS View in S/4HANA. Transactional view of Operation/Exercise Relationship. It contains 25 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
C_FrcElmntToExercisePosTP view from CONSUMPTION Position Assignment for Organizational Structure
C_FrcElmntToExerciseRelshpTP view from CONSUMPTION Manage Force Element to Exercise Relationship Assignment
C_FrcElmntToExerStaffPrpslTP view from CONSUMPTION Exercise Staff Proposal
C_FrcElmntToOperationPosTP view from CONSUMPTION Operation Position Assignment
C_FrcElmntToOperationRelshpTP view from CONSUMPTION Manage Force Element to Operation Relationship Assignment
C_FrcElmntToOpExerCommandsTP view from CONSUMPTION Manage Force Element To Command Assignment
C_FrcElmntToOpStaffPrpslTP view from CONSUMPTION Consumption View for FE to Operation Staff Proposal

Fields (25)

KeyField CDS FieldsUsed in Views
KEY ForceElementOrgID ForceElementOrgID 7
KEY FrcElmntOrgPlngStatus FrcElmntOrgPlngStatus 7
KEY FrcElmntOrgRelatedOrgID FrcElmntOrgRelatedOrgID 7
KEY FrcElmntOrgSubType FrcElmntOrgSubType 7
KEY FrcElmntOrgValdtyEndDate FrcElmntOrgValdtyEndDate 7
KEY FrcElmntOrgValdtyStartDate FrcElmntOrgValdtyStartDate 7
ForceElementOrgIDFoEd ForceElementOrgIDFoEd 7
FrcElmntOrgCnctntdRelshpName FrcElmntOrgCnctntdRelshpName 7
FrcElmntOrgConcatenatedID FrcElmntOrgConcatenatedID 7
FrcElmntOrgForceProviderID FrcElmntOrgForceProviderID 7
FrcElmntOrgInfoType FrcElmntOrgInfoType 7
FrcElmntOrgInitialMatlSuplrID FrcElmntOrgInitialMatlSuplrID 7
FrcElmntOrgInitialPersSuplrID FrcElmntOrgInitialPersSuplrID 7
FrcElmntOrgOpExerciseID FrcElmntOrgOpExerciseID 7
FrcElmntOrgPlanVersion FrcElmntOrgPlanVersion 7
FrcElmntOrgPlngStsCritlty FrcElmntOrgPlngStsCritlty 7
FrcElmntOrgRelatedOrgIDFoEd FrcElmntOrgRelatedOrgIDFoEd 7
FrcElmntOrgRelatedOrgType FrcElmntOrgRelatedOrgType 7
FrcElmntOrgRelshpDesc FrcElmntOrgRelshpDesc 5
FrcElmntOrgRotationKey FrcElmntOrgRotationKey 7
FrcElmntOrgType FrcElmntOrgType 7
FrcElmntOrgValdtyEndDateFoEd FrcElmntOrgValdtyEndDateFoEd 7
FrcElmntOrgValdtyStartDateFoEd FrcElmntOrgValdtyStartDateFoEd 7
FrcElmntOrgVariationID FrcElmntOrgVariationID 7
NumberOfForceElementOrg NumberOfForceElementOrg 7

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 Operation/Exercise Relationship
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FRCELMNTTOOPEXERRELSHPTP (
    FORCEELEMENTORGID,
    FRCELMNTORGPLNGSTATUS,
    FRCELMNTORGRELATEDORGID,
    FRCELMNTORGSUBTYPE,
    FRCELMNTORGVALDTYENDDATE,
    FRCELMNTORGVALDTYSTARTDATE,
    FORCEELEMENTORGIDFOED,
    FRCELMNTORGCNCTNTDRELSHPNAME,
    FRCELMNTORGCONCATENATEDID,
    FRCELMNTORGFORCEPROVIDERID,
    FRCELMNTORGINFOTYPE,
    FRCELMNTORGINITIALMATLSUPLRID,
    FRCELMNTORGINITIALPERSSUPLRID,
    FRCELMNTORGOPEXERCISEID,
    FRCELMNTORGPLANVERSION,
    FRCELMNTORGPLNGSTSCRITLTY,
    FRCELMNTORGRELATEDORGIDFOED,
    FRCELMNTORGRELATEDORGTYPE,
    FRCELMNTORGRELSHPDESC,
    FRCELMNTORGROTATIONKEY,
    FRCELMNTORGTYPE,
    FRCELMNTORGVALDTYENDDATEFOED,
    FRCELMNTORGVALDTYSTARTDATEFOED,
    FRCELMNTORGVARIATIONID,
    NUMBEROFFORCEELEMENTORG,
    PRIMARY KEY (FORCEELEMENTORGID, FRCELMNTORGPLNGSTATUS, FRCELMNTORGRELATEDORGID, FRCELMNTORGSUBTYPE, FRCELMNTORGVALDTYENDDATE, FRCELMNTORGVALDTYSTARTDATE)
);

Learn More