P_GLACCOUNTTYPEVH

CDS View

P_GLACCOUNTTYPEVH is a CDS View in S/4HANA. 4 CDS views read from this table.

Used by 4 CDS view(s)

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_AllocationGLAccPrimSecdryVH view from CONSUMPTION Allocation Account
C_AllocationReceiverGLAcctVH view from CONSUMPTION Allocation Receiver GL Account
C_AllocGLAccPrimSecdryBalShtVH view from CONSUMPTION Allocation Account
C_AllocGLAcctBalShtNonOpgVH view from CONSUMPTION Allocation Account 
@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