C_AllocationSenderGLAcctVH

DDL: C_ALLOCATIONSENDERGLACCTVH SQL: CGLACCVH Type: view CONSUMPTION Package: ODATA_MANAGE_ALLOCATION

Account Number

C_AllocationSenderGLAcctVH is a Consumption CDS View that provides data about "Account Number" in SAP S/4HANA. It reads from 4 data sources (I_CompanyCode, I_CostElementOnControllingArea, I_GLAccountInCompanyCode, I_GLAcctWithGrpChartOfAccounts) and exposes 10 fields with key fields GLAccount, CompanyCode, ChartOfAccounts, ControllingArea. It has 3 associations to related views. It is exposed through 1 OData service (UI_FCO_MANAGE_ALLOCATION). Part of development package ODATA_MANAGE_ALLOCATION.

4 data source(s) Exposed by 1 service(s) 10 fields

Data Sources (4)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode inner
I_CostElementOnControllingArea I_CostElementOnControllingArea inner
I_GLAccountInCompanyCode I_GLAccountInCompanyCode from
I_GLAcctWithGrpChartOfAccounts I_GLAcctWithGrpChartOfAccounts inner

Associations (3)

CardinalityTargetAliasCondition
[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
[0..1] I_UnivAllocGLAccountTypeText _GLAccountTypeText $projection.GLAccountType = _GLAccountTypeText.GLAccountType and _GLAccountTypeText.Language = $session.system_language

Annotations (13)

NameValueLevelField
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 Account Number view

OData Services (1)

ServiceBindingVersionContractRelease
UI_FCO_MANAGE_ALLOCATION UI_FCOUA_MANAGE_ALLOCATION V2 C1 NOT_RELEASED

Fields (10)

KeyFieldSource TableSource FieldDescription
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
GLAccountType I_GLAcctWithGrpChartOfAccounts GLAccountType
GLAccountTypeText _GLAccountTypeText GLAccountTypeText
_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: 'Account Number'
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

    inner join   I_GLAcctWithGrpChartOfAccounts on I_CompanyCode.ChartOfAccounts = I_GLAcctWithGrpChartOfAccounts.ChartOfAccounts
                                                and I_GLAccountInCompanyCode.GLAccount = I_GLAcctWithGrpChartOfAccounts.GLAccount 
    
  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 
                                                                                     
  association [0..1] to I_UnivAllocGLAccountTypeText as _GLAccountTypeText on $projection.GLAccountType = _GLAccountTypeText.GLAccountType
                                                                          and _GLAccountTypeText.Language = $session.system_language                                                      
{
      @UI.lineItem.position: 10
      @Search.defaultSearchElement: true
      @UI.selectionField.position: 10
  key I_GLAccountInCompanyCode.GLAccount,
      //@UI.hidden: true

      @UI.lineItem.position: 49
      @UI.selectionField.position: 49
  key I_CompanyCode.CompanyCode,
      @UI.lineItem.position: 40
      @UI.selectionField.position: 40
  key I_CompanyCode.ChartOfAccounts,
      @UI.selectionField.position: 60
      @UI.lineItem.position: 60
  key I_CompanyCode.ControllingArea,
      
      @UI.selectionField.position: 50
      @UI.lineItem.position: 50
      I_CompanyCode.CompanyCodeName,
      
      @UI.selectionField.position: 20
      @UI.lineItem.position: 20
      _GLAcctTextTP.GLAccountName,
      @UI.selectionField.position: 30
      @UI.lineItem.position: 30
      _GLAcctTextTP.GLAccountLongName,
      
      @UI.selectionField.position: 70
      @UI.lineItem.position: 70
      @Consumption.valueHelpDefinition: [ { entity: { name: 'C_UnivAllocGLAccountTypeVH', element: 'GLAccountType'  } } ]
      I_GLAcctWithGrpChartOfAccounts.GLAccountType,
      
      @UI.selectionField.position: 80
      @UI.lineItem.position: 80
      _GLAccountTypeText.GLAccountTypeText,
      
      _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,
  I_GLAcctWithGrpChartOfAccounts.GLAccountType,
  _GLAccountTypeText.GLAccountTypeText

Learn More