I_FRCELMNTORGDESCRIPTIONTP

CDS View
21 Fields 2 CDS Views

Transactional View of Description of FE Organisation

I_FRCELMNTORGDESCRIPTIONTP is a CDS View in S/4HANA. Transactional View of Description of FE Organisation. It contains 21 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_FrcElmntOrgDescriptionTP view from CONSUMPTION View of Description of FE Organisation
C_FrcElmntOrgRefOrgDescTP view from CONSUMPTION Consumption View of Description of Reference FE Organization

Fields (21)

KeyField CDS FieldsUsed in Views
KEY ForceElementOrgID ForceElementOrgID 2
KEY FrcElmntOrgDescription FrcElmntOrgDescription 2
KEY FrcElmntOrgLanguage FrcElmntOrgLanguage 2
KEY FrcElmntOrgPlanVersion FrcElmntOrgPlanVersion 2
KEY FrcElmntOrgPlngStatus FrcElmntOrgPlngStatus 2
KEY FrcElmntOrgSubType FrcElmntOrgSubType 2
KEY FrcElmntOrgType FrcElmntOrgType 2
KEY FrcElmntOrgValdtyEndDate FrcElmntOrgValdtyEndDate 2
KEY FrcElmntOrgValdtyStartDate FrcElmntOrgValdtyStartDate 2
KEY NumberOfForceElementOrg NumberOfForceElementOrg 2
KEY NumberOfFrcElmntOrgDescRef NumberOfFrcElmntOrgDescRef 2
FrcElmntOrgConcatenatedID FrcElmntOrgConcatenatedID 2
FrcElmntOrgDescRefNumber FrcElmntOrgDescRefNumber 2
FrcElmntOrgDescriptionForEdit FrcElmntOrgDescriptionForEdit 2
FrcElmntOrgInfoType FrcElmntOrgInfoType 2
FrcElmntOrgLanguageFoEd FrcElmntOrgLanguageFoEd 2
FrcElmntOrgPlngStatusForEdit FrcElmntOrgPlngStatusForEdit 2
FrcElmntOrgPlngStsCritlty FrcElmntOrgPlngStsCritlty 2
FrcElmntOrgSubTypeForEdit FrcElmntOrgSubTypeForEdit 2
FrcElmntOrgValdtyEndDateFoEd FrcElmntOrgValdtyEndDateFoEd 2
FrcElmntOrgValdtyStartDateFoEd FrcElmntOrgValdtyStartDateFoEd 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 Description of FE Organisation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FRCELMNTORGDESCRIPTIONTP (
    FORCEELEMENTORGID,
    FRCELMNTORGDESCRIPTION,
    FRCELMNTORGLANGUAGE,
    FRCELMNTORGPLANVERSION,
    FRCELMNTORGPLNGSTATUS,
    FRCELMNTORGSUBTYPE,
    FRCELMNTORGTYPE,
    FRCELMNTORGVALDTYENDDATE,
    FRCELMNTORGVALDTYSTARTDATE,
    NUMBEROFFORCEELEMENTORG,
    NUMBEROFFRCELMNTORGDESCREF,
    FRCELMNTORGCONCATENATEDID,
    FRCELMNTORGDESCREFNUMBER,
    FRCELMNTORGDESCRIPTIONFOREDIT,
    FRCELMNTORGINFOTYPE,
    FRCELMNTORGLANGUAGEFOED,
    FRCELMNTORGPLNGSTATUSFOREDIT,
    FRCELMNTORGPLNGSTSCRITLTY,
    FRCELMNTORGSUBTYPEFOREDIT,
    FRCELMNTORGVALDTYENDDATEFOED,
    FRCELMNTORGVALDTYSTARTDATEFOED,
    PRIMARY KEY (FORCEELEMENTORGID, FRCELMNTORGDESCRIPTION, FRCELMNTORGLANGUAGE, FRCELMNTORGPLANVERSION, FRCELMNTORGPLNGSTATUS, FRCELMNTORGSUBTYPE, FRCELMNTORGTYPE, FRCELMNTORGVALDTYENDDATE, FRCELMNTORGVALDTYSTARTDATE, NUMBEROFFORCEELEMENTORG, NUMBEROFFRCELMNTORGDESCREF)
);

Learn More