_CONTROLLINGAREA

_CONTROLLINGAREA is an SAP database table in S/4HANA. It contains 9 fields.

Fields (9)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
ChartOfAccounts ChartOfAccounts 16
ControllingArea ControllingArea 3
ControllingAreaCurrency ControllingAreaCurrency,GlobalCurrency 18
ControllingAreaName ControllingArea_T,ControllingAreaDesc,ControllingAreaName 197
CostCenterStandardHierarchy ProfitCenterStandardHierarchy 1
FINANCIALMANAGEMENTAREA FINANCIALMANAGEMENTAREA 1
FiscalYearVariant FiscalYearVariant 2
ktopl ChartOfAccounts 1

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 _CONTROLLINGAREA (
    COMPANYCODE,
    CHARTOFACCOUNTS,
    CONTROLLINGAREA,
    CONTROLLINGAREACURRENCY,
    CONTROLLINGAREANAME,
    COSTCENTERSTANDARDHIERARCHY,
    FINANCIALMANAGEMENTAREA,
    FISCALYEARVARIANT,
    KTOPL,
    PRIMARY KEY (COMPANYCODE)
);