_ROOTPROFITCENTERTOPROJECT

_ROOTPROFITCENTERTOPROJECT is an SAP database table in S/4HANA. It contains 11 fields.

Fields (11)

KeyField CDS FieldsUsed in Views
CompanyCode RootCompanyCode 5
ControllingArea RootControllingArea 5
OrganizationalChange RootOrganizationalChange 5
OrglChangeEffectiveDate OrglChangeEffectiveDate 1
OrglChangeReassignmentStatus RootOrglChangeReassignmentSts 5
OrglChgLastDateBeforeEffDate OrglChgLastDateBeforeEffDate 1
ProfitCenter RootProfitCenter 5
ProfitCenterBeforeOrglChange RootProfitCenterBeforeOrglChng 5
ProjectInternalID RootProjectInternalID 5
ValidityEndDate RootValidityEndDate 5
ValidityStartDate RootValidityStartDate 5

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _ROOTPROFITCENTERTOPROJECT (
    COMPANYCODE,
    CONTROLLINGAREA,
    ORGANIZATIONALCHANGE,
    ORGLCHANGEEFFECTIVEDATE,
    ORGLCHANGEREASSIGNMENTSTATUS,
    ORGLCHGLASTDATEBEFOREEFFDATE,
    PROFITCENTER,
    PROFITCENTERBEFOREORGLCHANGE,
    PROJECTINTERNALID,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE
);