C_GLAcctInCoCodeTP
Consumption View: G/L Acct in CoCode
C_GLAcctInCoCodeTP is a Consumption CDS View that provides data about "Consumption View: G/L Acct in CoCode" in SAP S/4HANA. It reads from 1 data source (I_GLAcctInCoCodeTP) and exposes 91 fields with key fields ChartOfAccounts, GLAccount, CompanyCode. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_GLAcctInCoCodeTP | tpview | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_ChartOfAccountsText | _ChartOfAccountsText | $projection.CountryChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts |
| [1..1] | C_GLAcctInChtAcctsTP | _GLAcctInChtAcctsTP | $projection.ChartOfAccounts = _GLAcctInChtAcctsTP.ChartOfAccounts and $projection.GLAccount = _GLAcctInChtAcctsTP.GLAccount |
Annotations (17)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.sqlViewName | CGLACOCDTD | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| EndUserText.label | Consumption View: G/L Acct in CoCode | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| UI.headerInfo.typeName | G/L Account In Company Code | view | |
| UI.headerInfo.typeNamePlural | G/L Accounts In Company Code | view | |
| UI.headerInfo.title.type | #STANDARD | view | |
| UI.headerInfo.title.value | GLAccount | view | |
| UI.headerInfo.description.type | #STANDARD | view | |
| UI.headerInfo.description.value | CompanyCode | view | |
| VDM.viewType | #CONSUMPTION | view | |
| Search.searchable | true | view |
Fields (91)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ChartOfAccounts | I_GLAcctInCoCodeTP | ChartOfAccounts | Node Class |
| KEY | GLAccount | I_GLAcctInCoCodeTP | GLAccount | General Ledger |
| KEY | CompanyCode | I_GLAcctInCoCodeTP | CompanyCode | Receiver Company Code |
| CompanyCodeForEdit | I_GLAcctInCoCodeTP | CompanyCodeForEdit | Company Code | |
| CompanyCodeName | I_GLAcctInCoCodeTP | CompanyCodeName | Company Name | |
| AuthorizationGroup | I_GLAcctInCoCodeTP | AuthorizationGroup | AuthorizGroup | |
| AccountingClerk | I_GLAcctInCoCodeTP | AccountingClerk | Clerk Abbrev. | |
| LastInterestCalcRunDate | I_GLAcctInCoCodeTP | LastInterestCalcRunDate | Last Int. Calc. | |
| CreationDate | I_GLAcctInCoCodeTP | CreationDate | Time Stamp | |
| CreatedByUser | I_GLAcctInCoCodeTP | CreatedByUser | User Name | |
| CreatedByUserName | _User | UserDescription | Full Name | |
| PlanningLevel | I_GLAcctInCoCodeTP | PlanningLevel | Planning Level | |
| PlanningLevelName | ||||
| HouseBank | I_GLAcctInCoCodeTP | HouseBank | House Bank | |
| HouseBankAccount | I_GLAcctInCoCodeTP | HouseBankAccount | House Bank Account | |
| HouseBankAccountDescription | ||||
| ExchRateDifferencesAccountDetn | I_GLAcctInCoCodeTP | ExchRateDifferencesAccountDetn | E/R Diff. Key | |
| ReconciliationAccountType | I_GLAcctInCoCodeTP | ReconciliationAccountType | Reconcil. ID | |
| ReconciliationAccountTypeName | ||||
| TaxCategory | I_GLAcctInCoCodeTP | TaxCategory | Tax Code | |
| TaxCodeName | ||||
| InterestCalculationCode | I_GLAcctInCoCodeTP | InterestCalculationCode | Interest Indic. | |
| InterestCalculationCodeName | ||||
| GLAccountCurrency | I_GLAcctInCoCodeTP | GLAccountCurrency | Currency | |
| CurrencyShortName | ||||
| IsManagedExternally | I_GLAcctInCoCodeTP | IsManagedExternally | Is Managed Ext. | |
| IsAutomaticallyPosted | I_GLAcctInCoCodeTP | IsAutomaticallyPosted | Auto. Posting | |
| LineItemDisplayIsEnabled | I_GLAcctInCoCodeTP | LineItemDisplayIsEnabled | Line Items | |
| SupplementIsAllowed | I_GLAcctInCoCodeTP | SupplementIsAllowed | Supplement | |
| IsOpenItemManaged | I_GLAcctInCoCodeTP | IsOpenItemManaged | Open Item Management | |
| InterestCalculationDate | I_GLAcctInCoCodeTP | InterestCalculationDate | Last Key Date | |
| IntrstCalcFrequencyInMonths | I_GLAcctInCoCodeTP | IntrstCalcFrequencyInMonths | Int.Calc.Freq. | |
| AcctgDocItmDisplaySequenceRule | I_GLAcctInCoCodeTP | AcctgDocItmDisplaySequenceRule | Sort key | |
| AcctgDocItmDspSequenceRuleName | ||||
| AlternativeGLAccountExternal | I_GLAcctInCoCodeTP | AlternativeGLAccountExternal | ||
| AlternativeGLAccount | I_GLAcctInCoCodeTP | AlternativeGLAccount | Group Account | |
| AlternativeGLAccountName | ||||
| JointVentureRecoveryCode | I_GLAcctInCoCodeTP | JointVentureRecoveryCode | Recovery Ind. | |
| JointVentureRecoveryCodeName | ||||
| CommitmentItem | I_GLAcctInCoCodeTP | CommitmentItem | Commitment item | |
| TaxCodeIsRequired | I_GLAcctInCoCodeTP | TaxCodeIsRequired | Pstg w/o tax allowed | |
| BalanceHasLocalCurrency | I_GLAcctInCoCodeTP | BalanceHasLocalCurrency | Balances in LC | |
| ValuationGroup | I_GLAcctInCoCodeTP | ValuationGroup | Valuation Group | |
| APARToleranceGroup | I_GLAcctInCoCodeTP | APARToleranceGroup | Tolerance Group | |
| APARToleranceGroupName | ||||
| AccountIsBlockedForPosting | I_GLAcctInCoCodeTP | AccountIsBlockedForPosting | Posting Block | |
| AccountIsMarkedForDeletion | I_GLAcctInCoCodeTP | AccountIsMarkedForDeletion | Deletion Flag | |
| GLAcctCoCodeImplementStatus | I_GLAcctInCoCodeTP | GLAcctCoCodeImplementStatus | Implement. Status | |
| GLAccountCoCodIsDeliveredBySAP | I_GLAcctInCoCodeTP | GLAccountCoCodIsDeliveredBySAP | ||
| ClearingIsLedgerGroupSpecific | I_GLAcctInCoCodeTP | ClearingIsLedgerGroupSpecific | OI Mgmt by LedgerGrp | |
| IsCashFlowAccount | I_GLAcctInCoCodeTP | IsCashFlowAccount | Rel.Cash Flow | |
| GLAcctInflationKey | I_GLAcctInCoCodeTP | GLAcctInflationKey | Inflation key | |
| GLAcctInflationKeyName | ||||
| FieldStatusGroup | I_GLAcctInCoCodeTP | FieldStatusGroup | Field Status Grp | |
| FieldStatusGroupName | ||||
| MultiCurrencyAccountingCode | I_GLAcctInCoCodeTP | MultiCurrencyAccountingCode | MCA Key | |
| MultiCurrencyAcctgCodeName | ||||
| ReconciliationAcctIsChangeable | I_GLAcctInCoCodeTP | ReconciliationAcctIsChangeable | Rec.Act Ready | |
| IsExtendedOpenItemManaged | I_GLAcctInCoCodeTP | IsExtendedOpenItemManaged | Extended OI Mgmt | |
| MaintenanceLanguage | I_GLAcctInCoCodeTP | MaintenanceLanguage | Maint. Language | |
| GLAccountForEdit | I_GLAcctInCoCodeTP | GLAccountForEdit | G/L Account | |
| GLAccountName | I_GLAcctInCoCodeTP | GLAccountName | Short Text | |
| GLAccountLongName | I_GLAcctInCoCodeTP | GLAccountLongName | Long Text | |
| ChartOfAccountsForEdit | I_GLAcctInCoCodeTP | ChartOfAccountsForEdit | Chart of Accts | |
| CountryChartOfAccounts | I_GLAcctInCoCodeTP | CountryChartOfAccounts | Chart of Accts | |
| Country | I_GLAcctInCoCodeTP | Country | Venue: Ctry/Reg | |
| CountryName | ||||
| ControllingArea | I_GLAcctInCoCodeTP | ControllingArea | Controlling Area | |
| FieldStatusVariant | I_GLAcctInCoCodeTP | FieldStatusVariant | Fld stat.var. | |
| _AcctgDocItmDspSqncRule | I_GLAcctInCoCodeTP | _AcctgDocItmDspSqncRule | ||
| _AlternativeGLAccount | I_GLAcctInCoCodeTP | _AlternativeGLAccount | ||
| _CompanyCode | I_GLAcctInCoCodeTP | _CompanyCode | ||
| _FieldStatusGroup | I_GLAcctInCoCodeTP | _FieldStatusGroup | ||
| _GLAccountCurrency | I_GLAcctInCoCodeTP | _GLAccountCurrency | ||
| _GLAccountToleranceGroup | I_GLAcctInCoCodeTP | _GLAccountToleranceGroup | ||
| _GLAcctInChtAcctsTP | _GLAcctInChtAcctsTP | |||
| _GLAcctTxtInMaintLang | I_GLAcctInCoCodeTP | _GLAcctTxtInMaintLang | ||
| _HouseBank | I_GLAcctInCoCodeTP | _HouseBank | ||
| _HouseBankAccount | I_GLAcctInCoCodeTP | _HouseBankAccount | ||
| _InflationKey | I_GLAcctInCoCodeTP | _InflationKey | ||
| _InterestCalculationCode | I_GLAcctInCoCodeTP | _InterestCalculationCode | ||
| _JointVentureRecovery | I_GLAcctInCoCodeTP | _JointVentureRecovery | ||
| _MultiCurrencyAccounting | I_GLAcctInCoCodeTP | _MultiCurrencyAccounting | ||
| _PlanningLevel | I_GLAcctInCoCodeTP | _PlanningLevel | ||
| _Reconciliationaccttype | I_GLAcctInCoCodeTP | _Reconciliationaccttype | ||
| _TaxCategory | I_GLAcctInCoCodeTP | _TaxCategory | ||
| _User | I_GLAcctInCoCodeTP | _User | ||
| _FieldStatusVariant | I_GLAcctInCoCodeTP | _FieldStatusVariant | ||
| _ChartOfAccounts | I_GLAcctInCoCodeTP | _ChartOfAccounts | ||
| _GLAccount | I_GLAcctInCoCodeTP | _GLAccount | ||
| _ChartOfAccountsText | _ChartOfAccountsText |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view C_GLAcctInCoCodeTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CGLACOCDTD
CREATE VIEW C_GLAcctInCoCodeTP AS
SELECT
tpview.ChartOfAccounts AS ChartOfAccounts,
tpview.GLAccount AS GLAccount,
tpview.CompanyCode AS CompanyCode,
tpview.CompanyCodeForEdit AS CompanyCodeForEdit,
tpview.CompanyCodeName AS CompanyCodeName,
tpview.AuthorizationGroup AS AuthorizationGroup,
tpview.AccountingClerk AS AccountingClerk,
tpview.LastInterestCalcRunDate AS LastInterestCalcRunDate,
tpview.CreationDate AS CreationDate,
tpview.CreatedByUser AS CreatedByUser,
_User.UserDescription AS CreatedByUserName,
tpview.PlanningLevel AS PlanningLevel,
_PlanningLevel._Text[1:Language = $session.system_language].PlanningLevelName AS PlanningLevelName,
tpview.HouseBank AS HouseBank,
tpview.HouseBankAccount AS HouseBankAccount,
_HouseBankAccount._Text[1:Language = $session.system_language].HouseBankAccountDescription AS HouseBankAccountDescription,
tpview.ExchRateDifferencesAccountDetn AS ExchRateDifferencesAccountDetn,
tpview.ReconciliationAccountType AS ReconciliationAccountType,
_Reconciliationaccttype._Text[1:Language = $session.system_language].ReconciliationAccountTypeName AS ReconciliationAccountTypeName,
tpview.TaxCategory AS TaxCategory,
_TaxCategory._Text[1:Language = $session.system_language].TaxCategoryName AS TaxCodeName,
tpview.InterestCalculationCode AS InterestCalculationCode,
_InterestCalculationCode._Text[1:Language = $session.system_language].InterestCalculationCodeName AS InterestCalculationCodeName,
tpview.GLAccountCurrency AS GLAccountCurrency,
_GLAccountCurrency._Text[1:Language = $session.system_language].CurrencyShortName AS CurrencyShortName,
tpview.IsManagedExternally AS IsManagedExternally,
tpview.IsAutomaticallyPosted AS IsAutomaticallyPosted,
tpview.LineItemDisplayIsEnabled AS LineItemDisplayIsEnabled,
tpview.SupplementIsAllowed AS SupplementIsAllowed,
tpview.IsOpenItemManaged AS IsOpenItemManaged,
tpview.InterestCalculationDate AS InterestCalculationDate,
tpview.IntrstCalcFrequencyInMonths AS IntrstCalcFrequencyInMonths,
tpview.AcctgDocItmDisplaySequenceRule AS AcctgDocItmDisplaySequenceRule,
_AcctgDocItmDspSqncRule._Text[1:Language = $session.system_language].AcctgDocItmDspSequenceRuleName AS AcctgDocItmDspSequenceRuleName,
tpview.AlternativeGLAccountExternal AS AlternativeGLAccountExternal,
tpview.AlternativeGLAccount AS AlternativeGLAccount,
_AlternativeGLAccount._Text[1:Language = $session.system_language].GLAccountName AS AlternativeGLAccountName,
tpview.JointVentureRecoveryCode AS JointVentureRecoveryCode,
_JointVentureRecovery._Text[1:Language = $session.system_language].JointVentureRecoveryCodeName AS JointVentureRecoveryCodeName,
tpview.CommitmentItem AS CommitmentItem,
tpview.TaxCodeIsRequired AS TaxCodeIsRequired,
tpview.BalanceHasLocalCurrency AS BalanceHasLocalCurrency,
tpview.ValuationGroup AS ValuationGroup,
tpview.APARToleranceGroup AS APARToleranceGroup,
_GLAccountToleranceGroup._Text[1:Language = $session.system_language].APARToleranceGroupName AS APARToleranceGroupName,
tpview.AccountIsBlockedForPosting AS AccountIsBlockedForPosting,
tpview.AccountIsMarkedForDeletion AS AccountIsMarkedForDeletion,
tpview.GLAcctCoCodeImplementStatus AS GLAcctCoCodeImplementStatus,
tpview.GLAccountCoCodIsDeliveredBySAP AS GLAccountCoCodIsDeliveredBySAP,
tpview.ClearingIsLedgerGroupSpecific AS ClearingIsLedgerGroupSpecific,
tpview.IsCashFlowAccount AS IsCashFlowAccount,
tpview.GLAcctInflationKey AS GLAcctInflationKey,
_InflationKey._Text[1:Language = $session.system_language].GLAcctInflationKeyName AS GLAcctInflationKeyName,
tpview.FieldStatusGroup AS FieldStatusGroup,
_FieldStatusGroup._Text[1:Language = $session.system_language].FieldStatusGroupName AS FieldStatusGroupName,
tpview.MultiCurrencyAccountingCode AS MultiCurrencyAccountingCode,
_MultiCurrencyAccounting._Text[1:Language = $session.system_language].MultiCurrencyAcctgCodeName AS MultiCurrencyAcctgCodeName,
tpview.ReconciliationAcctIsChangeable AS ReconciliationAcctIsChangeable,
tpview.IsExtendedOpenItemManaged AS IsExtendedOpenItemManaged,
tpview.MaintenanceLanguage AS MaintenanceLanguage,
tpview.GLAccountForEdit AS GLAccountForEdit,
tpview.GLAccountName AS GLAccountName,
tpview.GLAccountLongName AS GLAccountLongName,
tpview.ChartOfAccountsForEdit AS ChartOfAccountsForEdit,
tpview.CountryChartOfAccounts AS CountryChartOfAccounts,
tpview.Country AS Country,
_CompanyCode._Country._Text[1:Language = $session.system_language].CountryName AS CountryName,
tpview.ControllingArea AS ControllingArea,
tpview.FieldStatusVariant AS FieldStatusVariant,
tpview._AcctgDocItmDspSqncRule AS _AcctgDocItmDspSqncRule,
tpview._AlternativeGLAccount AS _AlternativeGLAccount,
tpview._CompanyCode AS _CompanyCode,
tpview._FieldStatusGroup AS _FieldStatusGroup,
tpview._GLAccountCurrency AS _GLAccountCurrency,
tpview._GLAccountToleranceGroup AS _GLAccountToleranceGroup,
tpview._GLAcctTxtInMaintLang AS _GLAcctTxtInMaintLang,
tpview._HouseBank AS _HouseBank,
tpview._HouseBankAccount AS _HouseBankAccount,
tpview._InflationKey AS _InflationKey,
tpview._InterestCalculationCode AS _InterestCalculationCode,
tpview._JointVentureRecovery AS _JointVentureRecovery,
tpview._MultiCurrencyAccounting AS _MultiCurrencyAccounting,
tpview._PlanningLevel AS _PlanningLevel,
tpview._Reconciliationaccttype AS _Reconciliationaccttype,
tpview._TaxCategory AS _TaxCategory,
tpview._User AS _User,
tpview._FieldStatusVariant AS _FieldStatusVariant,
tpview._ChartOfAccounts AS _ChartOfAccounts,
tpview._GLAccount AS _GLAccount
FROM I_GLAcctInCoCodeTP AS tpview
LEFT OUTER JOIN I_ChartOfAccountsText AS _ChartOfAccountsText ON CountryChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts -- association [0..*]
LEFT OUTER JOIN C_GLAcctInChtAcctsTP AS _GLAcctInChtAcctsTP ON ChartOfAccounts = _GLAcctInChtAcctsTP.ChartOfAccounts AND GLAccount = _GLAcctInChtAcctsTP.GLAccount -- association [1..1]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA