P_GLAccountInCompany

DDL: P_GLACCOUNTINCOMPANY SQL: PFIGLACCTRCOMP Type: view BASIC

P_GLAccountInCompany is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (I_CompanyCode) and exposes 3 fields with key fields PartnerCompany, GLAccount.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_CompanyCode _CompanyCode inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PFIGLACCTRCOMP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY PartnerCompany I_GLAccount PartnerCompany
KEY GLAccount I_GLAccount GLAccount
AuthorizationGroup I_GLAccount AuthorizationGroup 
@AbapCatalog.sqlViewName: 'PFIGLACCTRCOMP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@VDM.viewType: #BASIC
//@EndUserText.label: 'private view'

define view P_GLAccountInCompany as select distinct from I_GLAccount
inner join I_CompanyCode as _CompanyCode on I_GLAccount.PartnerCompany = _CompanyCode.Company
  

 {
 
  key I_GLAccount.PartnerCompany, 
  key I_GLAccount.GLAccount,
  
  I_GLAccount.AuthorizationGroup 
  
  /* Associations */ 

}
where I_GLAccount.PartnerCompany <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_GLACCOUNT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More