Fields (37)
| Key | Field | CDS Fields | Used 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
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA