_GLACCOUNT

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

Fields (37)

KeyField CDS FieldsUsed in Views
_ChartOfAccounts _ChartOfAccounts 1
AccountingClerk AccountingClerk 1
AccountIsBlockedForCreation AccountIsBlockedForCreation 1
AccountIsBlockedForPlanning AccountIsBlockedForPlanning 1
AccountIsBlockedForPosting AccountIsBlockedForPosting 2
AccountIsMarkedForDeletion AccountIsMarkedForDeletion 2
AcctgDocItmDisplaySequenceRule AcctgDocItmDisplaySequenceRule 1
APARToleranceGroup APARToleranceGroup 1
AuthorizationGroup AuthorizationGroup 1
BalanceHasLocalCurrency BalanceHasLocalCurrency 1
CashPlanningGroup CashPlanningGroup 1
ChartOfAccounts ChartOfAccounts 8
ClearingIsLedgerGroupSpecific ClearingIsLedgerGroupSpecific 1
CommitmentItem CommitmentItem 1
CompanyCodeName CompanyCodeName 1
CreatedByUser CreatedByUser 1
ExchRateDifferencesAccountDetn ExchRateDifferencesAccountDetn 1
GLAccount GLAccount 1
GLAccountCurrency GLAccountCurrency 1
GLAccountGroup GLAccountGroup 1
HouseBank HouseBank 1
HouseBankAccount HouseBankAccount 1
InterestCalculationCode InterestCalculationCode 1
IntrstCalcFrequencyInMonths IntrstCalcFrequencyInMonths 1
IsAutomaticallyPosted IsAutomaticallyPosted 1
IsBalanceSheetAccount IsBalanceSheetAccount 1
IsCashFlowAccount IsCashFlowAccount 1
IsManagedExternally IsManagedExternally 1
IsOpenItemManaged IsOpenItemManaged 2
JointVentureRecoveryCode JointVentureRecoveryCode 1
LineItemDisplayIsEnabled LineItemDisplayIsEnabled 1
PlanningLevel PlanningLevel 1
ReconciliationAccountType ReconciliationAccountType 2
SupplementIsAllowed SupplementIsAllowed 1
TaxCategory TaxCategory 1
TaxCodeIsRequired TaxCodeIsRequired 1
ValuationGroup ValuationGroup 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,
    ACCOUNTINGCLERK,
    ACCOUNTISBLOCKEDFORCREATION,
    ACCOUNTISBLOCKEDFORPLANNING,
    ACCOUNTISBLOCKEDFORPOSTING,
    ACCOUNTISMARKEDFORDELETION,
    ACCTGDOCITMDISPLAYSEQUENCERULE,
    APARTOLERANCEGROUP,
    AUTHORIZATIONGROUP,
    BALANCEHASLOCALCURRENCY,
    CASHPLANNINGGROUP,
    CHARTOFACCOUNTS,
    CLEARINGISLEDGERGROUPSPECIFIC,
    COMMITMENTITEM,
    COMPANYCODENAME,
    CREATEDBYUSER,
    EXCHRATEDIFFERENCESACCOUNTDETN,
    GLACCOUNT,
    GLACCOUNTCURRENCY,
    GLACCOUNTGROUP,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    INTERESTCALCULATIONCODE,
    INTRSTCALCFREQUENCYINMONTHS,
    ISAUTOMATICALLYPOSTED,
    ISBALANCESHEETACCOUNT,
    ISCASHFLOWACCOUNT,
    ISMANAGEDEXTERNALLY,
    ISOPENITEMMANAGED,
    JOINTVENTURERECOVERYCODE,
    LINEITEMDISPLAYISENABLED,
    PLANNINGLEVEL,
    RECONCILIATIONACCOUNTTYPE,
    SUPPLEMENTISALLOWED,
    TAXCATEGORY,
    TAXCODEISREQUIRED,
    VALUATIONGROUP
);