P_COUNTCOUNTRY
P_COUNTCOUNTRY is a CDS View in S/4HANA. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_StRpAdvncRetForSlsAndPurTxC | view | left_outer | COMPOSITE | Cube View which returns Sales and Purchases tax items |
| P_StRpCalTaxReturn | view | left_outer | COMPOSITE | |
| P_StRpTaxReturnBox | view | left_outer | COMPOSITE |
@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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_STRPTAXRETURN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/