I_GLACCOUNTFORPUBLICSECTOR

CDS View
19 Fields 6 CDS Views

FM Settings for GL Accounts

I_GLACCOUNTFORPUBLICSECTOR is a CDS View in S/4HANA. FM Settings for GL Accounts. It contains 19 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_BudgetAccountInChtAccts view from BASIC Budget Account in Chart of Accounts
I_BudgetAccountText view inner BASIC Budget Account - Text
I_GLAccountForPublicSectorTP view from TRANSACTIONAL FM Settings for GL Accounts
I_PubSecInterestAccountVH view from COMPOSITE Interest Accounts
I_PubSecParticipantAccountVH view from COMPOSITE Participating Accounts
I_SpnsrdClassGLAccount view from BASIC GL Account Sponsored Class

Fields (19)

KeyField CDS FieldsUsed in Views
KEY ChartOfAccounts ChartOfAccounts 2
KEY GLAccount GLAccount 1
_CarryForwardBudgetAccount _CarryForwardBudgetAccount 2
_CashLedgerAccount _CashLedgerAccount 2
_ChartOfAccounts _ChartOfAccounts 2
_GLAccountHierarchyNode _GLAccountHierarchyNode 1
_PubSecBdgtAcctCarryFwdTo _PubSecBdgtAcctCarryFwdTo 2
_PubSecBdgtAcctRevnExpnCode _PubSecBdgtAcctRevnExpnCode 2
_PubSecBdgtCnsmpnType _PubSecBdgtCnsmpnType 2
_Text _Text 2
CashLedgerAccount CashLedgerAccount 2
PubSecBdgtAcctCarryFwdTo PubSecBdgtAcctCarryFwdTo 2
PubSecBdgtAcctIsBdgtAllowed PubSecBdgtAcctIsBdgtAllowed 2
PubSecBdgtAcctIsCarryFwd PubSecBdgtAcctIsCarryFwd 2
PubSecBdgtAcctIsPostgAllowed PubSecBdgtAcctIsPostgAllowed 2
PubSecBdgtAcctRevnExpnCode PubSecBdgtAcctRevnExpnCode 2
PubSecBudgetCnsmpnType PubSecBudgetCnsmpnType 2
PubSecBudgetIsRelevant PubSecBudgetIsRelevant 2
SponsoredClass SponsoredClass 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.

-- FM Settings for GL Accounts
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_GLACCOUNTFORPUBLICSECTOR (
    CHARTOFACCOUNTS,
    GLACCOUNT,
    _CARRYFORWARDBUDGETACCOUNT,
    _CASHLEDGERACCOUNT,
    _CHARTOFACCOUNTS,
    _GLACCOUNTHIERARCHYNODE,
    _PUBSECBDGTACCTCARRYFWDTO,
    _PUBSECBDGTACCTREVNEXPNCODE,
    _PUBSECBDGTCNSMPNTYPE,
    _TEXT,
    CASHLEDGERACCOUNT,
    PUBSECBDGTACCTCARRYFWDTO,
    PUBSECBDGTACCTISBDGTALLOWED,
    PUBSECBDGTACCTISCARRYFWD,
    PUBSECBDGTACCTISPOSTGALLOWED,
    PUBSECBDGTACCTREVNEXPNCODE,
    PUBSECBUDGETCNSMPNTYPE,
    PUBSECBUDGETISRELEVANT,
    SPONSOREDCLASS,
    PRIMARY KEY (CHARTOFACCOUNTS, GLACCOUNT)
);

Learn More