How many fields does C_AllocationSenderGLAcctVH have?

C_AllocationSenderGLAcctVH has 8 fields. Key fields: GLAccount, CompanyCode, ChartOfAccounts, ControllingArea.

C_AllocationSenderGLAcctVH

Q: Which tables does C_AllocationSenderGLAcctVH use?

C_AllocationSenderGLAcctVH reads from 3 data source(s): I_CompanyCode, I_CostElementOnControllingArea, I_GLAccountInCompanyCode.

DDL: C_ALLOCATIONSENDERGLACCTVH SQL: CGLACCVH Type: view CONSUMPTION

Allocation Sender GL Account

C_AllocationSenderGLAcctVH is a Consumption CDS View that provides data about "Allocation Sender GL Account" in SAP S/4HANA. It reads from 3 data sources (I_CompanyCode, I_CostElementOnControllingArea, I_GLAccountInCompanyCode) and exposes 8 fields with key fields GLAccount, CompanyCode, ChartOfAccounts, ControllingArea. It has 2 associations to related views.

Data Sources (3)

Source	Alias	Join Type
I_CompanyCode	I_CompanyCode	inner
I_CostElementOnControllingArea	I_CostElementOnControllingArea	inner
I_GLAccountInCompanyCode	I_GLAccountInCompanyCode	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_GLAccountTextRawData	_GLAcctTextTP	`$projection.ChartOfAccounts = _GLAcctTextTP.ChartOfAccounts and $projection.GLAccount = _GLAcctTextTP.GLAccount and _GLAcctTextTP.Language = $session.system_language`
[1..1]	I_ControllingArea	_ControllingArea	`$projection.ControllingArea = _ControllingArea.ControllingArea`

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	CGLACCVH	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#CUSTOMIZING	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.dataCategory	#VALUE_HELP	view
VDM.viewType	#CONSUMPTION	view
Search.searchable	true	view
EndUserText.label	Allocation Sender GL Account	view

Fields (8)

Key	Field	Source Table	Source Field
KEY	GLAccount	I_GLAccountInCompanyCode	GLAccount
KEY	CompanyCode	I_CompanyCode	CompanyCode
KEY	ChartOfAccounts	I_CompanyCode	ChartOfAccounts
KEY	ControllingArea	I_CompanyCode	ControllingArea
	CompanyCodeName	I_CompanyCode	CompanyCodeName
	GLAccountName	_GLAcctTextTP	GLAccountName
	GLAccountLongName	_GLAcctTextTP	GLAccountLongName
	_ControllingArea		_ControllingArea

@AbapCatalog.sqlViewName: 'CGLACCVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking:#NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.dataCategory: #VALUE_HELP

@VDM.viewType: #CONSUMPTION

@Search.searchable: true

@EndUserText.label: 'Allocation Sender GL Account'
define view C_AllocationSenderGLAcctVH
  as select from I_GLAccountInCompanyCode //I_GLAccountInCompanyCode skb1

    inner join   I_CostElementOnControllingArea on I_CostElementOnControllingArea.CostElement = I_GLAccountInCompanyCode.GLAccount //I_CostElementOnControllingArea //cskb

    inner join   I_CompanyCode                  on I_GLAccountInCompanyCode.CompanyCode = I_CompanyCode.CompanyCode //I_CompanyCode //t001

  association [0..1] to I_GLAccountTextRawData as _GLAcctTextTP on  $projection.ChartOfAccounts = _GLAcctTextTP.ChartOfAccounts //I_GLAcctTextTP //skat

                                                        and $projection.GLAccount       = _GLAcctTextTP.GLAccount
                                                        and _GLAcctTextTP.Language      = $session.system_language
                                                        
  association [1..1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea                                                        
{
      @UI.lineItem.position: 10
      @Search.defaultSearchElement: true
  key I_GLAccountInCompanyCode.GLAccount,
      //@UI.hidden: true

      @UI.lineItem.position: 49
  key I_CompanyCode.CompanyCode,
      @UI.lineItem.position: 40
  key I_CompanyCode.ChartOfAccounts,
      @UI.lineItem.position: 60
  key I_CompanyCode.ControllingArea,
      
      @UI.lineItem.position: 50
      I_CompanyCode.CompanyCodeName,

      @UI.lineItem.position: 20
      _GLAcctTextTP.GLAccountName,
      @UI.lineItem.position: 30
      _GLAcctTextTP.GLAccountLongName,
      
      _ControllingArea            
}
where
  (
       CostElementCategory = '01'
    or CostElementCategory = '03'
    or CostElementCategory = '04'
    or CostElementCategory = '22'
    //    or CostElementCategory = '42'//overhead

  )
  and  ValidityEndDate               >= $session.system_date
group by
  I_GLAccountInCompanyCode.GLAccount,  
  I_CompanyCode.CompanyCode,
  I_CompanyCode.ChartOfAccounts,
  I_CompanyCode.CompanyCodeName,
  I_CompanyCode.ControllingArea,
  _GLAcctTextTP.GLAccountName,
  _GLAcctTextTP.GLAccountLongName
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_COSTELEMENTONCONTROLLINGAREA",
"I_GLACCOUNTINCOMPANYCODE",
"I_GLACCOUNTTEXTRAWDATA"
],
"ASSOCIATED":
[
"I_CONTROLLINGAREA",
"I_GLACCOUNTTEXTRAWDATA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

C_AllocationSenderGLAcctVH view