I_GLACCTINCOCODE

CDS View
44 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 44 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 from COMPOSITE company code list item data
I_GLAcctInCoCodeTP view from TRANSACTIONAL G/L Account in Company Code (Draft 2.0)
P_GLAcctNotMarkForDeletion view from COMPOSITE

Fields (44)

KeyField CDS FieldsUsed in Views
KEY ChartOfAccounts ChartOfAccounts,ChartOfAccountsForEdit 2
KEY CompanyCode CompanyCode,CompanyCodeForEdit 2
KEY GLAccount GLAccount,GLAccountForEdit 2
AccountingClerk AccountingClerk 1
AccountIsBlockedForPosting AccountIsBlockedForPosting 1
AccountIsMarkedForDeletion AccountIsMarkedForDeletion 1
AcctgDocItmDisplaySequenceRule AcctgDocItmDisplaySequenceRule 1
AlternativeGLAccount AlternativeGLAccount 1
APARToleranceGroup APARToleranceGroup 1
AuthorizationGroup AuthorizationGroup 1
BalanceHasLocalCurrency BalanceHasLocalCurrency 1
ClearingIsLedgerGroupSpecific ClearingIsLedgerGroupSpecific 1
CommitmentItem CommitmentItem 1
ControllingArea ControllingArea 1
Country Country 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
ExchRateDifferencesAccountDetn ExchRateDifferencesAccountDetn 1
FieldStatusGroup FieldStatusGroup 1
FieldStatusVariant FieldStatusVariant 1
GLAccountCurrency GLAccountCurrency 1
GLAcctInflationKey GLAcctInflationKey 1
HouseBank HouseBank 1
HouseBankAccount HouseBankAccount 1
InterestCalculationCode InterestCalculationCode 1
InterestCalculationDate InterestCalculationDate 1
IntrstCalcFrequencyInMonths IntrstCalcFrequencyInMonths 1
IsAutomaticallyPosted IsAutomaticallyPosted 1
IsCashFlowAccount IsCashFlowAccount 1
IsExtendedOpenItemManaged IsExtendedOpenItemManaged 2
IsManagedExternally IsManagedExternally 1
IsOpenItemManaged IsOpenItemManaged 1
JointVentureRecoveryCode JointVentureRecoveryCode 1
LastChangeDateTime LastChangeDateTime 1
LastInterestCalcRunDate LastInterestCalcRunDate 1
LineItemDisplayIsEnabled LineItemDisplayIsEnabled 1
MultiCurrencyAccountingCode MultiCurrencyAccountingCode 1
PlanningLevel PlanningLevel 1
ReconciliationAccountType ReconciliationAccountType 1
ReconciliationAcctIsChangeable ReconciliationAcctIsChangeable 1
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.

-- 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,
    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