I_FRCELMNTORGNAME

CDS View

Interface View of Force Element Organization Names

I_FRCELMNTORGNAME is a CDS View in S/4HANA. Interface View of Force Element Organization Names. It contains 13 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
C_FrcElmntOrgSuplmntyName view from CONSUMPTION View of Force Element Supplementary Names
C_FrcElmntOrgSuplmntyVrtlElmnt view from CONSUMPTION Consumption View for FE Org Supplementary Virtual Element
I_FrcElmntOrgNameTP view from TRANSACTIONAL Transactional View of Force Element Organization Names
I_FrcElmntOrgSuplmntyActvDte view from COMPOSITE Force Element supplementary active date
I_FrcElmntOrgSuplmntyMinDate view from BASIC Force Element supplementary Date
I_FrcElmntOrgSuplmntyStatus view from BASIC Force Element supplementary Status
I_FrcElmntOrgSuplmntyVrtlElmnt view from TRANSACTIONAL Transactional Processing for Supplementary Attribute VE

Fields (13)

KeyField CDS FieldsUsed in Views
KEY ForceElementOrgID ForceElementOrgID 4
KEY FrcElmntOrgLanguage FrcElmntOrgLanguage 2
KEY FrcElmntOrgPlanVersion FrcElmntOrgPlanVersion 2
KEY FrcElmntOrgPlngStatus FrcElmntOrgPlngStatus 2
KEY FrcElmntOrgType FrcElmntOrgType 2
KEY FrcElmntOrgValdtyEndDate FrcElmntOrgValdtyEndDate,FrcElmntOrgValdtyEndDateFoEd 2
KEY FrcElmntOrgValdtyStartDate FrcElmntOrgValdtyStartDate,FrcElmntOrgValdtyStartDateFoEd 2
KEY NumberOfForceElementOrg NumberOfForceElementOrg 2
FrcElmntOrgDelimitDate FrcElmntOrgDelimitDate 1
FrcElmntOrgInfoType FrcElmntOrgInfoType 1
FrcElmntOrgName FrcElmntOrgName 2
FrcElmntOrgPlngStsCritlty FrcElmntOrgPlngStsCritlty 1
FrcElmntOrgShortName FrcElmntOrgShortName 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.

-- Interface View of Force Element Organization Names
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FRCELMNTORGNAME (
    FORCEELEMENTORGID,
    FRCELMNTORGLANGUAGE,
    FRCELMNTORGPLANVERSION,
    FRCELMNTORGPLNGSTATUS,
    FRCELMNTORGTYPE,
    FRCELMNTORGVALDTYENDDATE,
    FRCELMNTORGVALDTYSTARTDATE,
    NUMBEROFFORCEELEMENTORG,
    FRCELMNTORGDELIMITDATE,
    FRCELMNTORGINFOTYPE,
    FRCELMNTORGNAME,
    FRCELMNTORGPLNGSTSCRITLTY,
    FRCELMNTORGSHORTNAME,
    PRIMARY KEY (FORCEELEMENTORGID, FRCELMNTORGLANGUAGE, FRCELMNTORGPLANVERSION, FRCELMNTORGPLNGSTATUS, FRCELMNTORGTYPE, FRCELMNTORGVALDTYENDDATE, FRCELMNTORGVALDTYSTARTDATE, NUMBEROFFORCEELEMENTORG)
);