P_OFFSETTINGACCOUNT

CDS View

Private union view for OffsettingAccount

P_OFFSETTINGACCOUNT is a CDS View in S/4HANA. Private union view for OffsettingAccount. It contains 5 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OffsettingAccount view_entity from COMPOSITE Offsetting Account

Fields (5)

KeyField CDS FieldsUsed in Views
KEY ChartOfAccounts ChartOfAccounts 1
KEY OffsettingAccount OffsettingAccount 1
KEY OffsettingAccountType OffsettingAccountType 1
OffsettingAccountName OffsettingAccountName 1
OffsettingAccountShortName OffsettingAccountShortName 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.

-- Private union view for OffsettingAccount
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_OFFSETTINGACCOUNT (
    CHARTOFACCOUNTS,
    OFFSETTINGACCOUNT,
    OFFSETTINGACCOUNTTYPE,
    OFFSETTINGACCOUNTNAME,
    OFFSETTINGACCOUNTSHORTNAME,
    PRIMARY KEY (CHARTOFACCOUNTS, OFFSETTINGACCOUNT, OFFSETTINGACCOUNTTYPE)
);