I_ACTIVEGLACCTINCOCODELISTITEM

CDS View
65 Fields 1 CDS Views

company code list item data

I_ACTIVEGLACCTINCOCODELISTITEM is a CDS View in S/4HANA. company code list item data. It contains 65 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_GLAcctInCoCdListItem view_entity from CONSUMPTION company code list item

Fields (65)

KeyField CDS FieldsUsed in Views
KEY ChartOfAccounts ChartOfAccounts 1
KEY CompanyCode CompanyCode 1
KEY GLAccount GLAccount 1
AccountingClerk AccountingClerk 1
AccountIsBlockedForPosting AccountIsBlockedForPosting 1
AccountIsMarkedForDeletion AccountIsMarkedForDeletion 1
AcctgDocItmDisplaySequenceRule AcctgDocItmDisplaySequenceRule 1
AcctgDocItmDspSequenceRuleName AcctgDocItmDspSequenceRuleName 1
APARToleranceGroup APARToleranceGroup 1
APARToleranceGroupName APARToleranceGroupName 1
AuthorizationGroup AuthorizationGroup 1
BalanceHasLocalCurrency BalanceHasLocalCurrency 1
ClearingIsLedgerGroupSpecific ClearingIsLedgerGroupSpecific 1
CommitmentItem CommitmentItem 1
CompanyCodeName CompanyCodeName 1
ControllingArea ControllingArea 1
Country Country 1
CountryName CountryName 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
CurrencyShortName CurrencyShortName 1
DraftIsProcessedByMe DraftIsProcessedByMe 1
ExchRateDifferencesAccountDetn ExchRateDifferencesAccountDetn 1
FieldStatusGroup FieldStatusGroup 1
FieldStatusGroupName FieldStatusGroupName 1
FieldStatusVariant FieldStatusVariant 1
GLAccountCoCodIsDeliveredBySAP GLAccountCoCodIsDeliveredBySAP 1
GLAccountCurrency GLAccountCurrency 1
GLAccountIsNotProdnRelevant GLAccountIsNotProdnRelevant 1
GLAcctCoCodeImplementStatus GLAcctCoCodeImplementStatus 1
GLAcctInChartOfAcctsDraftUUID GLAcctInChartOfAcctsDraftUUID 1
GLAcctInflationKey GLAcctInflationKey 1
GLAcctInflationKeyName GLAcctInflationKeyName 1
HasDraftEntity HasDraftEntity 1
HouseBank HouseBank 1
HouseBankAccount HouseBankAccount 1
HouseBankAccountDescription HouseBankAccountDescription 1
InProcessByUser InProcessByUser 1
InProcessByUserDescription InProcessByUserDescription 1
InterestCalculationCode InterestCalculationCode 1
InterestCalculationCodeName InterestCalculationCodeName 1
InterestCalculationDate InterestCalculationDate 1
IntrstCalcFrequencyInMonths IntrstCalcFrequencyInMonths 1
IsAutomaticallyPosted IsAutomaticallyPosted 1
IsCashFlowAccount IsCashFlowAccount 1
IsExtendedOpenItemManaged IsExtendedOpenItemManaged 1
IsManagedExternally IsManagedExternally 1
IsOpenItemManaged IsOpenItemManaged 1
JointVentureRecoveryCode JointVentureRecoveryCode 1
JointVentureRecoveryCodeName JointVentureRecoveryCodeName 1
LastChangeDateTime LastChangeDateTime 1
LastInterestCalcRunDate LastInterestCalcRunDate 1
LineItemDisplayIsEnabled LineItemDisplayIsEnabled 1
MultiCurrencyAccountingCode MultiCurrencyAccountingCode 1
MultiCurrencyAcctgCodeName MultiCurrencyAcctgCodeName 1
PlanningLevel PlanningLevel 1
PlanningLevelName PlanningLevelName 1
ReconciliationAccountType ReconciliationAccountType 1
ReconciliationAccountTypeName ReconciliationAccountTypeName 1
ReconciliationAcctIsChangeable ReconciliationAcctIsChangeable 1
SupplementIsAllowed SupplementIsAllowed 1
TaxCategory TaxCategory 1
TaxCodeIsRequired TaxCodeIsRequired 1
TaxCodeName TaxCodeName 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.

-- company code list item data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ACTIVEGLACCTINCOCODELISTITEM (
    CHARTOFACCOUNTS,
    COMPANYCODE,
    GLACCOUNT,
    ACCOUNTINGCLERK,
    ACCOUNTISBLOCKEDFORPOSTING,
    ACCOUNTISMARKEDFORDELETION,
    ACCTGDOCITMDISPLAYSEQUENCERULE,
    ACCTGDOCITMDSPSEQUENCERULENAME,
    APARTOLERANCEGROUP,
    APARTOLERANCEGROUPNAME,
    AUTHORIZATIONGROUP,
    BALANCEHASLOCALCURRENCY,
    CLEARINGISLEDGERGROUPSPECIFIC,
    COMMITMENTITEM,
    COMPANYCODENAME,
    CONTROLLINGAREA,
    COUNTRY,
    COUNTRYNAME,
    CREATEDBYUSER,
    CREATIONDATE,
    CURRENCYSHORTNAME,
    DRAFTISPROCESSEDBYME,
    EXCHRATEDIFFERENCESACCOUNTDETN,
    FIELDSTATUSGROUP,
    FIELDSTATUSGROUPNAME,
    FIELDSTATUSVARIANT,
    GLACCOUNTCOCODISDELIVEREDBYSAP,
    GLACCOUNTCURRENCY,
    GLACCOUNTISNOTPRODNRELEVANT,
    GLACCTCOCODEIMPLEMENTSTATUS,
    GLACCTINCHARTOFACCTSDRAFTUUID,
    GLACCTINFLATIONKEY,
    GLACCTINFLATIONKEYNAME,
    HASDRAFTENTITY,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    HOUSEBANKACCOUNTDESCRIPTION,
    INPROCESSBYUSER,
    INPROCESSBYUSERDESCRIPTION,
    INTERESTCALCULATIONCODE,
    INTERESTCALCULATIONCODENAME,
    INTERESTCALCULATIONDATE,
    INTRSTCALCFREQUENCYINMONTHS,
    ISAUTOMATICALLYPOSTED,
    ISCASHFLOWACCOUNT,
    ISEXTENDEDOPENITEMMANAGED,
    ISMANAGEDEXTERNALLY,
    ISOPENITEMMANAGED,
    JOINTVENTURERECOVERYCODE,
    JOINTVENTURERECOVERYCODENAME,
    LASTCHANGEDATETIME,
    LASTINTERESTCALCRUNDATE,
    LINEITEMDISPLAYISENABLED,
    MULTICURRENCYACCOUNTINGCODE,
    MULTICURRENCYACCTGCODENAME,
    PLANNINGLEVEL,
    PLANNINGLEVELNAME,
    RECONCILIATIONACCOUNTTYPE,
    RECONCILIATIONACCOUNTTYPENAME,
    RECONCILIATIONACCTISCHANGEABLE,
    SUPPLEMENTISALLOWED,
    TAXCATEGORY,
    TAXCODEISREQUIRED,
    TAXCODENAME,
    VALUATIONGROUP,
    PRIMARY KEY (CHARTOFACCOUNTS, COMPANYCODE, GLACCOUNT)
);

Learn More