P_CompanyCodeGLAccountInCOA

DDL: P_COMPANYCODEGLACCOUNTINCOA Type: view_entity COMPOSITE Package: RAP_FI_GL_COA

Operating Chart of Accounts

P_CompanyCodeGLAccountInCOA is a Composite CDS View that provides data about "Operating Chart of Accounts" in SAP S/4HANA. It reads from 2 data sources (I_GLAccountInCompanyCode, I_CompanyCode) and exposes 4 fields with key fields ChartOfAccounts, GLAccount, CompanyCode. Part of development package RAP_FI_GL_COA.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_GLAccountInCompanyCode acct from
I_CompanyCode cocd right_outer

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.resultSet.sizeCategory #XS view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey ChartOfAccounts view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts I_CompanyCode ChartOfAccounts
KEY GLAccount I_GLAccountInCompanyCode GLAccount
KEY CompanyCode I_CompanyCode CompanyCode
CompanyCodeName I_CompanyCode CompanyCodeName 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.resultSet.sizeCategory: #XS
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.representativeKey: 'ChartOfAccounts'
@ObjectModel.supportedCapabilities:[#SEARCHABLE_ENTITY,#VALUE_HELP_PROVIDER]

define view entity P_CompanyCodeGLAccountInCOA   
         as select from I_GLAccountInCompanyCode as acct 
          right outer join I_CompanyCode as cocd
                               on acct.CompanyCode = cocd.CompanyCode
{
  key cocd.ChartOfAccounts as ChartOfAccounts,
  key acct.GLAccount as GLAccount,
  key cocd.CompanyCode,
  cocd.CompanyCodeName
}
where acct.GLAccount is not initial

Learn More