I_GLACCTINCOCODE

CDS View
45 Fields 5 CDS Views

General Ledger Account in Company Code

I_GLACCTINCOCODE is a CDS View in S/4HANA. General Ledger Account in Company Code. It contains 45 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_CrcyAdjmtItemToBeVerified view left_outer CONSUMPTION Inbox View of Crcy Adjmt to be verified
C_GLJrnlEntryItemToBeVerified view left_outer CONSUMPTION LI in Inbox View of GL JE to be verified
I_ActiveGLAcctInCoCodeListItem view_entity from COMPOSITE company code list item data
I_GLAcctInCoCodeTP view_entity from TRANSACTIONAL G/L Account in Company Code (Draft 2.0)
P_GLAcctNotMarkForDeletion view_entity from COMPOSITE gl account is not marked for deletion

Fields (45)

KeyField CDS FieldsUsed in Views
KEY ChartOfAccounts ChartOfAccounts,ChartOfAccountsForEdit 2
KEY CompanyCode CompanyCode,CompanyCodeForEdit 2
KEY GLAccount GLAccount,GLAccountForEdit 2
AccountingClerk AccountingClerk 2
AccountIsBlockedForPosting AccountIsBlockedForPosting 2
AccountIsMarkedForDeletion AccountIsMarkedForDeletion 2
AcctgDocItmDisplaySequenceRule AcctgDocItmDisplaySequenceRule 2
AlternativeGLAccount AlternativeGLAccount 2
APARToleranceGroup APARToleranceGroup 2
AuthorizationGroup AuthorizationGroup 2
BalanceHasLocalCurrency BalanceHasLocalCurrency 2
ClearingIsLedgerGroupSpecific ClearingIsLedgerGroupSpecific 2
CommitmentItem CommitmentItem 2
ControllingArea ControllingArea 1
Country Country 1
CountryChartOfAccounts CountryChartOfAccounts 2
CreatedByUser CreatedByUser 2
CreationDate CreationDate 2
ExchRateDifferencesAccountDetn ExchRateDifferencesAccountDetn 2
FieldStatusGroup FieldStatusGroup 2
FieldStatusVariant FieldStatusVariant 1
GLAccountCurrency GLAccountCurrency 2
GLAcctInflationKey GLAcctInflationKey 2
HouseBank HouseBank 2
HouseBankAccount HouseBankAccount 2
InterestCalculationCode InterestCalculationCode 2
InterestCalculationDate InterestCalculationDate 2
IntrstCalcFrequencyInMonths IntrstCalcFrequencyInMonths 2
IsAutomaticallyPosted IsAutomaticallyPosted 2
IsCashFlowAccount IsCashFlowAccount 2
IsExtendedOpenItemManaged IsExtendedOpenItemManaged 2
IsManagedExternally IsManagedExternally 2
IsOpenItemManaged IsOpenItemManaged 2
JointVentureRecoveryCode JointVentureRecoveryCode 2
LastChangeDateTime LastChangeDateTime 1
LastInterestCalcRunDate LastInterestCalcRunDate 2
LineItemDisplayIsEnabled LineItemDisplayIsEnabled 2
MultiCurrencyAccountingCode MultiCurrencyAccountingCode 2
PlanningLevel PlanningLevel 2
ReconciliationAccountType ReconciliationAccountType 2
ReconciliationAcctIsChangeable ReconciliationAcctIsChangeable 2
SupplementIsAllowed SupplementIsAllowed 2
TaxCategory TaxCategory 2
TaxCodeIsRequired TaxCodeIsRequired 2
ValuationGroup ValuationGroup 2

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 in Company Code
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_GLACCTINCOCODE (
    CHARTOFACCOUNTS,
    COMPANYCODE,
    GLACCOUNT,
    ACCOUNTINGCLERK,
    ACCOUNTISBLOCKEDFORPOSTING,
    ACCOUNTISMARKEDFORDELETION,
    ACCTGDOCITMDISPLAYSEQUENCERULE,
    ALTERNATIVEGLACCOUNT,
    APARTOLERANCEGROUP,
    AUTHORIZATIONGROUP,
    BALANCEHASLOCALCURRENCY,
    CLEARINGISLEDGERGROUPSPECIFIC,
    COMMITMENTITEM,
    CONTROLLINGAREA,
    COUNTRY,
    COUNTRYCHARTOFACCOUNTS,
    CREATEDBYUSER,
    CREATIONDATE,
    EXCHRATEDIFFERENCESACCOUNTDETN,
    FIELDSTATUSGROUP,
    FIELDSTATUSVARIANT,
    GLACCOUNTCURRENCY,
    GLACCTINFLATIONKEY,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    INTERESTCALCULATIONCODE,
    INTERESTCALCULATIONDATE,
    INTRSTCALCFREQUENCYINMONTHS,
    ISAUTOMATICALLYPOSTED,
    ISCASHFLOWACCOUNT,
    ISEXTENDEDOPENITEMMANAGED,
    ISMANAGEDEXTERNALLY,
    ISOPENITEMMANAGED,
    JOINTVENTURERECOVERYCODE,
    LASTCHANGEDATETIME,
    LASTINTERESTCALCRUNDATE,
    LINEITEMDISPLAYISENABLED,
    MULTICURRENCYACCOUNTINGCODE,
    PLANNINGLEVEL,
    RECONCILIATIONACCOUNTTYPE,
    RECONCILIATIONACCTISCHANGEABLE,
    SUPPLEMENTISALLOWED,
    TAXCATEGORY,
    TAXCODEISREQUIRED,
    VALUATIONGROUP,
    PRIMARY KEY (CHARTOFACCOUNTS, COMPANYCODE, GLACCOUNT)
);

Learn More