SOC

SOC is an SAP database table in S/4HANA. It contains 12 fields.

Fields (12)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY FinancialTransactionType FinancialTransactionType 1
KEY FiscalYear FiscalYear 1
KEY StatementOfChangesSortOrder StatementOfChangesSortOrder 1
AmountInDisplayCurrency AmountInDisplayCurrency 1
ChartOfAccounts ChartOfAccounts 1
ControllingArea ControllingArea 1
DisplayCurrency DisplayCurrency 1
GLAccount GLAccount 1
PartnerCompany PartnerCompany 1
ProfitCenter ProfitCenter 1
Segment Segment 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 SOC (
    COMPANYCODE,
    FINANCIALTRANSACTIONTYPE,
    FISCALYEAR,
    STATEMENTOFCHANGESSORTORDER,
    AMOUNTINDISPLAYCURRENCY,
    CHARTOFACCOUNTS,
    CONTROLLINGAREA,
    DISPLAYCURRENCY,
    GLACCOUNT,
    PARTNERCOMPANY,
    PROFITCENTER,
    SEGMENT,
    PRIMARY KEY (COMPANYCODE, FINANCIALTRANSACTIONTYPE, FISCALYEAR, STATEMENTOFCHANGESSORTORDER)
);