I_RO_SAFTTaxReturnCountry

DDL: I_RO_SAFTTAXRETURNCOUNTRY Type: view_entity BASIC

Tax Country

I_RO_SAFTTaxReturnCountry is a Basic CDS View that provides data about "Tax Country" in SAP S/4HANA. It reads from 2 data sources (t005, /ceecv/roctaxmap) and exposes 7 fields with key fields CompanyCodeCountry, CostingSheetProcedure, TargetTaxCode, AccountKeyForGLAccount, TaxRateValidityEndDate.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
t005 country from
/ceecv/roctaxmap taxmap inner

Annotations (8)

NameValueLevelField
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Analytics.internalName #LOCAL view
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Tax Country view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCodeCountry t005 land1
KEY CostingSheetProcedure /ceecv/roctaxmap kalsm
KEY TargetTaxCode /ceecv/roctaxmap mwskz
KEY AccountKeyForGLAccount /ceecv/roctaxmap ktosl
KEY TaxRateValidityEndDate /ceecv/roctaxmap endda
TaxRateValidityStartDate /ceecv/roctaxmap begda
Country /ceecv/roctaxmap land1 
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@Analytics.internalName:#LOCAL
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Tax Country'
define view entity I_RO_SAFTTaxReturnCountry
  as select from t005             as country
    inner join   /ceecv/roctaxmap as taxmap on country.kalsm = taxmap.kalsm
{
  key country.land1 as CompanyCodeCountry,
  key taxmap.kalsm  as CostingSheetProcedure,
  key taxmap.mwskz  as TargetTaxCode,
  key taxmap.ktosl  as AccountKeyForGLAccount,
  key taxmap.endda  as TaxRateValidityEndDate,
      taxmap.begda  as TaxRateValidityStartDate,
      taxmap.land1  as Country

}

Learn More