_COMPCODE

_COMPCODE is an SAP database table in S/4HANA. It contains 7 fields.

Fields (7)

KeyField CDS FieldsUsed in Views
KEY ChartOfAccounts ChartOfAccounts 8
KEY CountryChartOfAccounts CountryChartOfAccounts 4
KEY Currency CompanyCodeCurrency,Currency 10
CashDiscountBaseAmtIsNetAmt CashDiscountBaseAmtIsNetAmt 1
CompanyCodeName comp_code_desc,CompanyCodeName 32
ControllingArea ControllingArea 8
Country Country 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _COMPCODE (
    CHARTOFACCOUNTS,
    COUNTRYCHARTOFACCOUNTS,
    CURRENCY,
    CASHDISCOUNTBASEAMTISNETAMT,
    COMPANYCODENAME,
    CONTROLLINGAREA,
    COUNTRY,
    PRIMARY KEY (CHARTOFACCOUNTS, COUNTRYCHARTOFACCOUNTS, CURRENCY)
);