I_GLACCOUNT

CDS View
24 Fields 15 CDS Views

General Ledger Account

I_GLACCOUNT is a CDS View in S/4HANA. General Ledger Account. It contains 24 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
C_BalanceAuditTrailAccount view from CONSUMPTION Accounts for Balance Audit Trail
C_CN_GLAcctVH view from CONSUMPTION GL Account Value Help
C_GeneralLedgerAccount view from CONSUMPTION General Ledger Account
C_GLAccountInCompanyCode view from CONSUMPTION Gl accounts in company code
C_MM_GLAccountVH view from CONSUMPTION GL Account Value Help in Material Management
C_MnlPostgAllwdGLAccount view from CONSUMPTION GL account open for manual postings
C_RevnVarcGLAcctVH view from CONSUMPTION Value help for GL Account
C_Ssp_Glaccountvh view from CONSUMPTION Consumption view for GL Account
FAC_POST_CRCY_ADJMT_GLACCT_VH view_entity from Post Currency Adjustments GL Acct VH
FAC_POST_JOUR_ENTRY_GLACCT_VH view from Post Journal Entry GL Acct VH
FAC_POST_TAX_PAYABLE_GLACCT_VH view from Value Help of Post Tax Payable
I_GLAccountStdVH view from COMPOSITE General Ledger Account
Summerizationterm1 view from summerization term with first priority
Summerizationterm2 view from summerization term with second priority
Summerizationterm3 view from summerization term with third priority

Fields (24)

KeyField CDS FieldsUsed in Views
KEY ChartOfAccounts ChartOfAccount,ChartOfAccounts 4
KEY CompanyCode CompanyCode 5
KEY GLAccount GLAccount 6
KEY PartnerCompany PartnerCompany 2
AccountIsBlockedForCreation AccountIsBlockedForCreation 1
AccountIsBlockedForPlanning AccountIsBlockedForPlanning 1
AccountIsBlockedForPosting AccountIsBlockedForPosting 1
AccountIsMarkedForDeletion AccountIsMarkedForDeletion 1
AcctgDocItmDisplaySequenceRule AcctgDocItmDisplaySequenceRule 1
AlternativeGLAccount AlternativeGLAccount 1
AuthorizationGroup AuthorizationGroup 1
CorporateGroupAccount CorporateGroupAccount 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
FunctionalArea FunctionalArea 1
GLAccountExternal GLAccountExternal 1
GLAccountGroup GLAccountGroup 1
IsBalanceSheetAccount IsBalanceSheetAccount 1
IsOpenItemManaged IsOpenItemManaged 1
IsProfitLossAccount IsProfitLossAccount 1
LineItemDisplayIsEnabled LineItemDisplayIsEnabled 1
ProfitLossAccountType ProfitLossAccountType 1
ReconciliationAccountType ReconciliationAccountType 1
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.

-- General Ledger Account
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_GLACCOUNT (
    CHARTOFACCOUNTS,
    COMPANYCODE,
    GLACCOUNT,
    PARTNERCOMPANY,
    ACCOUNTISBLOCKEDFORCREATION,
    ACCOUNTISBLOCKEDFORPLANNING,
    ACCOUNTISBLOCKEDFORPOSTING,
    ACCOUNTISMARKEDFORDELETION,
    ACCTGDOCITMDISPLAYSEQUENCERULE,
    ALTERNATIVEGLACCOUNT,
    AUTHORIZATIONGROUP,
    CORPORATEGROUPACCOUNT,
    CREATEDBYUSER,
    CREATIONDATE,
    FUNCTIONALAREA,
    GLACCOUNTEXTERNAL,
    GLACCOUNTGROUP,
    ISBALANCESHEETACCOUNT,
    ISOPENITEMMANAGED,
    ISPROFITLOSSACCOUNT,
    LINEITEMDISPLAYISENABLED,
    PROFITLOSSACCOUNTTYPE,
    RECONCILIATIONACCOUNTTYPE,
    SAMPLEGLACCOUNT,
    PRIMARY KEY (CHARTOFACCOUNTS, COMPANYCODE, GLACCOUNT, PARTNERCOMPANY)
);

Learn More