P_GLAccountTypeVH

DDL: P_GLACCOUNTTYPEVH SQL: PGLACCTPVH Type: view CONSUMPTION

P_GLAccountTypeVH is a Consumption CDS View in SAP S/4HANA. It reads from 3 data sources (I_CompanyCode, I_GLAccountInCompanyCode, I_GLAcctWithGrpChartOfAccounts) and exposes 8 fields with key fields CompanyCode, GLAccount, GLAccountExternal, ChartOfAccounts. It has 1 association to related views.

3 data source(s) 8 fields

Data Sources (3)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode inner
I_GLAccountInCompanyCode I_GLAccountInCompanyCode from
I_GLAcctWithGrpChartOfAccounts I_GLAcctWithGrpChartOfAccounts inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_GLAccountTextRawData _GLAcctTextTP $projection.ChartOfAccounts = _GLAcctTextTP.ChartOfAccounts and $projection.GLAccount = _GLAcctTextTP.GLAccount and _GLAcctTextTP.Language = $session.system_language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PGLACCTPVH 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 #B view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view
VDM.private true view
Search.searchable true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCode CompanyCode
KEY GLAccount I_GLAccountInCompanyCode GLAccount
KEY GLAccountExternal I_GLAcctWithGrpChartOfAccounts GLAccountExternal
KEY ChartOfAccounts I_GLAcctWithGrpChartOfAccounts ChartOfAccounts
AlternativeGLAccount I_GLAccountInCompanyCode AlternativeGLAccount
GLAccountType I_GLAcctWithGrpChartOfAccounts GLAccountType
GLAccountName _GLAcctTextTP GLAccountName
GLAccountLongName _GLAcctTextTP GLAccountLongName 
@AbapCatalog.sqlViewName: 'PGLACCTPVH'
@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: #B
@ObjectModel.usageType.sizeCategory: #M
@VDM.viewType: #CONSUMPTION
@VDM.private: true

//@EndUserText.label: 'gl account vh'


@Search.searchable: true
define view P_GLAccountTypeVH as
select from I_GLAccountInCompanyCode

  inner join I_CompanyCode on I_CompanyCode.CompanyCode = I_GLAccountInCompanyCode.CompanyCode
  
  inner join I_GLAcctWithGrpChartOfAccounts on I_GLAcctWithGrpChartOfAccounts.GLAccount = I_GLAccountInCompanyCode.GLAccount
                                           and I_GLAcctWithGrpChartOfAccounts.ChartOfAccounts = I_CompanyCode.ChartOfAccounts
                                           
  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                                           
{                                           
    @UI.lineItem.position: 40
    key I_CompanyCode.CompanyCode,
    @UI.lineItem.position: 10
    @Search.defaultSearchElement: true
    key I_GLAccountInCompanyCode.GLAccount,  
    @UI.lineItem.position: 20  
    key I_GLAcctWithGrpChartOfAccounts.GLAccountExternal,
    @UI.lineItem.position: 50    
    key I_GLAcctWithGrpChartOfAccounts.ChartOfAccounts,
    @UI.lineItem.position: 30
    I_GLAccountInCompanyCode.AlternativeGLAccount,
    @UI.lineItem.position: 60
    I_GLAcctWithGrpChartOfAccounts.GLAccountType,
    @UI.lineItem.position: 12
    _GLAcctTextTP.GLAccountName,
    @UI.lineItem.position: 14
    _GLAcctTextTP.GLAccountLongName       
}

Learn More