_GLACCOUNT

_GLACCOUNT is an SAP database table in S/4HANA. It contains 13 fields.

Fields (13)

KeyField CDS FieldsUsed in Views
_ChartOfAccounts _ChartOfAccounts 1
AccountIsBlockedForCreation AccountIsBlockedForCreation 1
AccountIsBlockedForPlanning AccountIsBlockedForPlanning 1
AccountIsBlockedForPosting AccountIsBlockedForPosting 1
AccountIsMarkedForDeletion AccountIsMarkedForDeletion 1
ChartOfAccounts ChartOfAccounts 5
CompanyCodeName CompanyCodeName 1
GLAccount GLAccount 1
GLAccountGroup GLAccountGroup 1
GLAccountLongName GLAccountLongName 1
IsBalanceSheetAccount IsBalanceSheetAccount 1
IsOpenItemManaged IsOpenItemManaged 1
ReconciliationAccountType ReconciliationAccountType 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 _GLACCOUNT (
    _CHARTOFACCOUNTS,
    ACCOUNTISBLOCKEDFORCREATION,
    ACCOUNTISBLOCKEDFORPLANNING,
    ACCOUNTISBLOCKEDFORPOSTING,
    ACCOUNTISMARKEDFORDELETION,
    CHARTOFACCOUNTS,
    COMPANYCODENAME,
    GLACCOUNT,
    GLACCOUNTGROUP,
    GLACCOUNTLONGNAME,
    ISBALANCESHEETACCOUNT,
    ISOPENITEMMANAGED,
    RECONCILIATIONACCOUNTTYPE
);