C_GLAcctInChtAcctsTP
Consumption View: G/L Acct in ChtAccts
C_GLAcctInChtAcctsTP is a Consumption CDS View that provides data about "Consumption View: G/L Acct in ChtAccts" in SAP S/4HANA. It reads from 1 data source (I_GLAcctInChtAcctsTP) and exposes 58 fields with key fields ChartOfAccounts, GLAccount. It has 4 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_GLAcctInChtAcctsTP | tpview | from |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | C_GLAcctTextTP | _Text | $projection.ChartOfAccounts = _Text.ChartOfAccounts and $projection.GLAccount = _Text.GLAccount |
| [0..*] | C_GLAcctInCoCodeTP | _GLAcctInCoCodeTP | $projection.ChartOfAccounts = _GLAcctInCoCodeTP.ChartOfAccounts and $projection.GLAccount = _GLAcctInCoCodeTP.GLAccount |
| [0..*] | C_CostElementTP | _CostElementTP | $projection.ChartOfAccounts = _CostElementTP.ChartOfAccounts and $projection.GLAccount = _CostElementTP.GLAccount |
| [0..1] | C_GLAccountForPublicSectorTP | _PublicSectorTP | $projection.ChartOfAccounts = _PublicSectorTP.ChartOfAccounts and $projection.GLAccount = _PublicSectorTP.GLAccount |
Annotations (17)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.sqlViewName | CGLACOATP | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| EndUserText.label | Consumption View: G/L Acct in ChtAccts | 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 | view | |
| UI.headerInfo.typeNamePlural | G/L Accounts | view | |
| UI.headerInfo.title.type | #STANDARD | view | |
| UI.headerInfo.title.value | GLAccount | view | |
| UI.headerInfo.description.type | #STANDARD | view | |
| UI.headerInfo.description.value | Language | view | |
| VDM.viewType | #CONSUMPTION | view | |
| Search.searchable | true | view |
Fields (58)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ChartOfAccounts | I_GLAcctInChtAcctsTP | ChartOfAccounts | Node Class |
| KEY | GLAccount | I_GLAcctInChtAcctsTP | GLAccount | General Ledger |
| ChartOfAccountsForEdit | I_GLAcctInChtAcctsTP | ChartOfAccountsForEdit | Chart of Accts | |
| ChartOfAccountsName | ||||
| GLAccountForEdit | I_GLAcctInChtAcctsTP | GLAccountForEdit | G/L Account | |
| IsBalanceSheetAccount | I_GLAcctInChtAcctsTP | IsBalanceSheetAccount | Is Balance Sheet Account | |
| GLAccountGroup | I_GLAcctInChtAcctsTP | GLAccountGroup | Account Group | |
| AccountGroupName | ||||
| CorporateGroupAccountExternal | CorporateGroupAccountExternal | G/L Account | ||
| CorporateGroupAccount | I_GLAcctInChtAcctsTP | CorporateGroupAccount | Group Account Number | |
| CorporateGroupAccountName | ||||
| ProfitLossAccountType | I_GLAcctInChtAcctsTP | ProfitLossAccountType | Profit Loss Account Type | |
| RetainedEarningsGLAccountName | ||||
| SampleGLAccount | I_GLAcctInChtAcctsTP | SampleGLAccount | Sample Account | |
| AccountIsMarkedForDeletion | I_GLAcctInChtAcctsTP | AccountIsMarkedForDeletion | Deletion Flag | |
| AccountIsBlockedForCreation | I_GLAcctInChtAcctsTP | AccountIsBlockedForCreation | Creation Block | |
| AccountIsBlockedForPosting | I_GLAcctInChtAcctsTP | AccountIsBlockedForPosting | Posting Block | |
| AccountIsBlockedForPlanning | I_GLAcctInChtAcctsTP | AccountIsBlockedForPlanning | Planning Block | |
| PartnerCompany | I_GLAcctInChtAcctsTP | PartnerCompany | Trading Partner | |
| PartnerCompanyName | _Globalcompany | CompanyName | Text | |
| FunctionalArea | I_GLAcctInChtAcctsTP | FunctionalArea | Sendr Fctl Area | |
| FunctionalAreaName | ||||
| CreationDate | I_GLAcctInChtAcctsTP | CreationDate | Time Stamp | |
| CreatedByUser | I_GLAcctInChtAcctsTP | CreatedByUser | User Name | |
| CreatedByUserName | _User | UserDescription | Full Name | |
| GLAccountType | I_GLAcctInChtAcctsTP | GLAccountType | G/L Account Type | |
| GLAccountTypeName | ||||
| GLAccountSubtype | I_GLAcctInChtAcctsTP | GLAccountSubtype | G/L Account Subtype | |
| GLAccountSubtypeName | ||||
| BankReconciliationAccount | I_GLAcctInChtAcctsTP | BankReconciliationAccount | Reconciliation Acct | |
| BankReconciliationAccountName | ||||
| CorporateGroupChartOfAccounts | I_GLAcctInChtAcctsTP | CorporateGroupChartOfAccounts | Group ChtAccts | |
| CorpGroupChartOfAccountsName | ||||
| GLAccountExternal | I_GLAcctInChtAcctsTP | GLAccountExternal | G/L Acct External ID | |
| GLAccountIsNotProdnRelevant | I_GLAcctInChtAcctsTP | GLAccountIsNotProdnRelevant | G/L Account Not Used | |
| GLAcctCOAImplementStatus | I_GLAcctInChtAcctsTP | GLAcctCOAImplementStatus | Implement. Status | |
| GLAccountCOAIsDeliveredBySAP | I_GLAcctInChtAcctsTP | GLAccountCOAIsDeliveredBySAP | Source is Ref. Cont. | |
| MaintenanceLanguage | I_GLAcctInChtAcctsTP | MaintenanceLanguage | Maint. Language | |
| DraftReferenceChartOfAccounts | I_GLAcctInChtAcctsTP | DraftReferenceChartOfAccounts | Chart of Accts | |
| DraftReferenceGLAccount | I_GLAcctInChtAcctsTP | DraftReferenceGLAccount | G/L Account | |
| GLAccountName | I_GLAcctInChtAcctsTP | GLAccountName | Short Text | |
| GLAccountLongName | I_GLAcctInChtAcctsTP | GLAccountLongName | Long Text | |
| _ChartOfAccounts | I_GLAcctInChtAcctsTP | _ChartOfAccounts | ||
| _CorporateGroupAccount | I_GLAcctInChtAcctsTP | _CorporateGroupAccount | ||
| _CostElementTP | _CostElementTP | |||
| _PublicSectorTP | _PublicSectorTP | |||
| _FunctionalArea | I_GLAcctInChtAcctsTP | _FunctionalArea | ||
| _Glaccountgroup | I_GLAcctInChtAcctsTP | _Glaccountgroup | ||
| _Glaccounttype | I_GLAcctInChtAcctsTP | _Glaccounttype | ||
| _GLAccountSubtype | I_GLAcctInChtAcctsTP | _GLAccountSubtype | ||
| _BankRecnclnAcct | I_GLAcctInChtAcctsTP | _BankRecnclnAcct | ||
| _GLAcctInCoCodeTP | _GLAcctInCoCodeTP | |||
| _GLAcctTxtInMaintLang | I_GLAcctInChtAcctsTP | _GLAcctTxtInMaintLang | ||
| _Globalcompany | I_GLAcctInChtAcctsTP | _Globalcompany | ||
| _ProfitLossAccountType_Vh | I_GLAcctInChtAcctsTP | _ProfitLossAccountType_Vh | ||
| _CorpGroupChartOfAccounts | I_GLAcctInChtAcctsTP | _CorpGroupChartOfAccounts | ||
| _Text | _Text | |||
| _User | I_GLAcctInChtAcctsTP | _User |
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_GLAcctInChtAcctsTP.
-- 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: CGLACOATP
CREATE VIEW C_GLAcctInChtAcctsTP AS
SELECT
tpview.ChartOfAccounts AS ChartOfAccounts,
tpview.GLAccount AS GLAccount,
tpview.ChartOfAccountsForEdit AS ChartOfAccountsForEdit,
_ChartOfAccounts._Text[1:Language = $session.system_language].ChartOfAccountsName AS ChartOfAccountsName,
tpview.GLAccountForEdit AS GLAccountForEdit,
tpview.IsBalanceSheetAccount AS IsBalanceSheetAccount,
tpview.GLAccountGroup AS GLAccountGroup,
_Glaccountgroup._GLAccountGroupText[1:Language = $session.system_language].AccountGroupName AS AccountGroupName,
CorporateGroupAccountExternal,
tpview.CorporateGroupAccount AS CorporateGroupAccount,
_CorporateGroupAccount._Text[1:Language = $session.system_language].GLAccountName AS CorporateGroupAccountName,
tpview.ProfitLossAccountType AS ProfitLossAccountType,
_RetainedEarningsGLAccount._GLAccountInChartOfAccounts._Text[1:Language = $session.system_language].GLAccountName AS RetainedEarningsGLAccountName,
tpview.SampleGLAccount AS SampleGLAccount,
tpview.AccountIsMarkedForDeletion AS AccountIsMarkedForDeletion,
tpview.AccountIsBlockedForCreation AS AccountIsBlockedForCreation,
tpview.AccountIsBlockedForPosting AS AccountIsBlockedForPosting,
tpview.AccountIsBlockedForPlanning AS AccountIsBlockedForPlanning,
tpview.PartnerCompany AS PartnerCompany,
_Globalcompany.CompanyName AS PartnerCompanyName,
tpview.FunctionalArea AS FunctionalArea,
_FunctionalArea._Text[1:Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
tpview.CreationDate AS CreationDate,
tpview.CreatedByUser AS CreatedByUser,
_User.UserDescription AS CreatedByUserName,
tpview.GLAccountType AS GLAccountType,
_Glaccounttype._GLAccountTypeText[1:Language = $session.system_language].GLAccountTypeName AS GLAccountTypeName,
tpview.GLAccountSubtype AS GLAccountSubtype,
_GLAccountSubtype._GLAccountSubtypeText[1:Language = $session.system_language].GLAccountSubtypeName AS GLAccountSubtypeName,
tpview.BankReconciliationAccount AS BankReconciliationAccount,
_BankRecnclnAcct._Text[1:Language = $session.system_language].GLAccountName AS BankReconciliationAccountName,
tpview.CorporateGroupChartOfAccounts AS CorporateGroupChartOfAccounts,
_ChartOfAccounts._CorpGroupChartOfAccounts._Text[1:Language = $session.system_language].ChartOfAccountsName AS CorpGroupChartOfAccountsName,
tpview.GLAccountExternal AS GLAccountExternal,
tpview.GLAccountIsNotProdnRelevant AS GLAccountIsNotProdnRelevant,
tpview.GLAcctCOAImplementStatus AS GLAcctCOAImplementStatus,
tpview.GLAccountCOAIsDeliveredBySAP AS GLAccountCOAIsDeliveredBySAP,
tpview.MaintenanceLanguage AS MaintenanceLanguage,
tpview.DraftReferenceChartOfAccounts AS DraftReferenceChartOfAccounts,
tpview.DraftReferenceGLAccount AS DraftReferenceGLAccount,
tpview.GLAccountName AS GLAccountName,
tpview.GLAccountLongName AS GLAccountLongName,
tpview._ChartOfAccounts AS _ChartOfAccounts,
tpview._CorporateGroupAccount AS _CorporateGroupAccount,
tpview._FunctionalArea AS _FunctionalArea,
tpview._Glaccountgroup AS _Glaccountgroup,
tpview._Glaccounttype AS _Glaccounttype,
tpview._GLAccountSubtype AS _GLAccountSubtype,
tpview._BankRecnclnAcct AS _BankRecnclnAcct,
tpview._GLAcctTxtInMaintLang AS _GLAcctTxtInMaintLang,
tpview._Globalcompany AS _Globalcompany,
tpview._ProfitLossAccountType_Vh AS _ProfitLossAccountType_Vh,
tpview._CorpGroupChartOfAccounts AS _CorpGroupChartOfAccounts,
tpview._User AS _User
FROM I_GLAcctInChtAcctsTP AS tpview
LEFT OUTER JOIN C_GLAcctTextTP AS _Text ON ChartOfAccounts = _Text.ChartOfAccounts AND GLAccount = _Text.GLAccount -- association [0..*]
LEFT OUTER JOIN C_GLAcctInCoCodeTP AS _GLAcctInCoCodeTP ON ChartOfAccounts = _GLAcctInCoCodeTP.ChartOfAccounts AND GLAccount = _GLAcctInCoCodeTP.GLAccount -- association [0..*]
LEFT OUTER JOIN C_CostElementTP AS _CostElementTP ON ChartOfAccounts = _CostElementTP.ChartOfAccounts AND GLAccount = _CostElementTP.GLAccount -- association [0..*]
LEFT OUTER JOIN C_GLAccountForPublicSectorTP AS _PublicSectorTP ON ChartOfAccounts = _PublicSectorTP.ChartOfAccounts AND GLAccount = _PublicSectorTP.GLAccount -- association [0..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