P_COMPANYCODEGLACCOUNTINCOA
Operating Chart of Accounts
P_COMPANYCODEGLACCOUNTINCOA is a CDS View in S/4HANA. Operating Chart of Accounts. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_CoCodeGLAcctOpgCOATP | view_entity | from | TRANSACTIONAL | Trnsctnl View GL Acct in Oper. COA |
@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