P_COUNTCOUNTRY

CDS View

Private view to count no of countries

P_COUNTCOUNTRY is a CDS View in S/4HANA. Private view to count no of countries. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_StRpAdvncRetForSlsAndPurTxC view left_outer COMPOSITE Cube View which returns Sales and Purchases tax items
P_StRpCalTaxReturn view left_outer COMPOSITE Calculated Tax Return Information
P_StRpTaxReturnBox view left_outer COMPOSITE Private view to return Tax Details with TaxBox config 
@AbapCatalog.sqlViewName: 'PCOUNTCNTRY'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
//@EndUserText.label: 'Private view to count no of countries'

@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true

define view P_CountCountry as select from P_StRpTaxReturn {
    
     
 key CompanyCode, 
 key AccountingDocument,
 key FiscalYear,
     Country,
     ReportingDate,
     count(*) as NmbrOfChmlCmplncMktCountries   //NoOfCountries

    
}
group by CompanyCode, AccountingDocument, FiscalYear, Country, ReportingDate

Learn More