I_GLACCOUNT

CDS View
30 Fields 20 CDS Views

General Ledger Account

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

CDS Views using this table (20)

ViewTypeJoinVDMDescription
C_BalanceAuditTrailAccount view from CONSUMPTION
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_GLAcctWthHouseBankAcctVH view from CONSUMPTION GL/Account with HouseBank & HouseBankAcc
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_JOUR_ENTRY_GLACCT_VH view from
FAC_POST_TAX_PAYABLE_GLACCT_VH view from
FCLM_GLAccount view from G/L Accounts for Cash Management
I_GeneralLedgerAccountVH view from COMPOSITE General Ledger Value Help
I_GLAccountStdVH view from COMPOSITE General Ledger Account
I_GLAcctLiquidityItemInfo view_entity inner COMPOSITE Default Liquidity Item Entries
P_GlAccountByFinMgmtArea view from CONSUMPTION GL Account by Financial Management Area
P_RecrrgSuplrInvcGLAccountVH view from BASIC
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 (30)

KeyField CDS FieldsUsed in Views
KEY ChartOfAccounts ChartOfAccount,ChartOfAccounts 7
KEY CompanyCode CompanyCode 8
KEY GLAccount GLAccount 9
KEY PartnerCompany PartnerCompany 2
_ChartOfAccounts _ChartOfAccounts 1
_CompanyCode _CompanyCode 1
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 1
_GLAccountInCompanyCode _GLAccountInCompanyCode 1
_Text _Text 1
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 2
IsBalanceSheetAccount IsBalanceSheetAccount 2
IsOpenItemManaged IsOpenItemManaged 2
IsProfitLossAccount IsProfitLossAccount 1
LineItemDisplayIsEnabled LineItemDisplayIsEnabled 1
ProfitLossAccountType ProfitLossAccountType 1
ReconciliationAccountType ReconciliationAccountType 2
SampleGLAccount SampleGLAccount 1
TaxCategory TaxCategory 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,
    _CHARTOFACCOUNTS,
    _COMPANYCODE,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _GLACCOUNTINCOMPANYCODE,
    _TEXT,
    ACCOUNTISBLOCKEDFORCREATION,
    ACCOUNTISBLOCKEDFORPLANNING,
    ACCOUNTISBLOCKEDFORPOSTING,
    ACCOUNTISMARKEDFORDELETION,
    ACCTGDOCITMDISPLAYSEQUENCERULE,
    ALTERNATIVEGLACCOUNT,
    AUTHORIZATIONGROUP,
    CORPORATEGROUPACCOUNT,
    CREATEDBYUSER,
    CREATIONDATE,
    FUNCTIONALAREA,
    GLACCOUNTEXTERNAL,
    GLACCOUNTGROUP,
    ISBALANCESHEETACCOUNT,
    ISOPENITEMMANAGED,
    ISPROFITLOSSACCOUNT,
    LINEITEMDISPLAYISENABLED,
    PROFITLOSSACCOUNTTYPE,
    RECONCILIATIONACCOUNTTYPE,
    SAMPLEGLACCOUNT,
    TAXCATEGORY,
    PRIMARY KEY (CHARTOFACCOUNTS, COMPANYCODE, GLACCOUNT, PARTNERCOMPANY)
);

Learn More