_GLACCOUNTINCHARTOFACCOUNTS

17 Fields

_GLACCOUNTINCHARTOFACCOUNTS is an SAP database table in S/4HANA. It contains 17 fields.

Fields (17)

KeyField CDS FieldsUsed in Views
KEY GLAccount GLAccount 2
KEY GLAccountExternal AlternativeGLAccountExternal,GLAccountExternal 6
AccountIsBlockedForCreation AccountIsBlockedForCreation 2
AccountIsBlockedForPlanning AccountIsBlockedForPlanning 2
AccountIsBlockedForPosting AccountIsBlockedForPosting 1
AccountIsMarkedForDeletion AccountIsMarkedForDeletion 1
ChartOfAccounts ChartOfAccounts 1
CorporateGroupAccount CorporateGroupAccount 9
CreatedByUser CreatedByUser 1
FunctionalArea FunctionalArea 1
GLAccountGroup GLAccountGroup 6
GLAccountType GLAccountType 14
IsBalanceSheetAccount IsBalanceSheetAccount 12
IsProfitLossAccount IsProfitLossAccount 2
PartnerCompany PartnerCompany 2
ProfitLossAccountType ProfitLossAccountType 2
SampleGLAccount SampleGLAccount 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 _GLACCOUNTINCHARTOFACCOUNTS (
    GLACCOUNT,
    GLACCOUNTEXTERNAL,
    ACCOUNTISBLOCKEDFORCREATION,
    ACCOUNTISBLOCKEDFORPLANNING,
    ACCOUNTISBLOCKEDFORPOSTING,
    ACCOUNTISMARKEDFORDELETION,
    CHARTOFACCOUNTS,
    CORPORATEGROUPACCOUNT,
    CREATEDBYUSER,
    FUNCTIONALAREA,
    GLACCOUNTGROUP,
    GLACCOUNTTYPE,
    ISBALANCESHEETACCOUNT,
    ISPROFITLOSSACCOUNT,
    PARTNERCOMPANY,
    PROFITLOSSACCOUNTTYPE,
    SAMPLEGLACCOUNT,
    PRIMARY KEY (GLACCOUNT, GLACCOUNTEXTERNAL)
);

Learn More