R_ES_CompanyCode

DDL: R_ES_COMPANYCODE Type: view_entity COMPOSITE

Spain Company Codes

R_ES_CompanyCode is a Composite CDS View that provides data about "Spain Company Codes" in SAP S/4HANA. It reads from 4 data sources (I_CompanyCode, I_CompanyCode, fot_txa_registn, R_TaxAbroadActivationStatus) and exposes 3 fields with key field CompanyCode.

4 data source(s) 3 fields

Data Sources (4)

SourceAliasJoin Type
I_CompanyCode CompanyCode from
I_CompanyCode CompanyCode union
fot_txa_registn ForeignTaxRegis inner
R_TaxAbroadActivationStatus ForeignTaxStatus inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Spain Company Codes view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCode CompanyCode
CompanyCodeasCompanyCode
CountryendascountryasTaxCountry 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Spain Company Codes'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #M,
  dataClass: #MASTER
}
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
define view entity R_ES_CompanyCode as select from I_CompanyCode as CompanyCode
{
  key CompanyCode.CompanyCode as CompanyCode,
      CompanyCode.Country as TaxCountry
} where CompanyCode.Country = 'ES'

union select from I_CompanyCode as CompanyCode
inner join R_TaxAbroadActivationStatus as ForeignTaxStatus on CompanyCode.CompanyCode = ForeignTaxStatus.CompanyCode
inner join fot_txa_registn as ForeignTaxRegis on CompanyCode.CompanyCode = ForeignTaxRegis.comp_code
{
  key CompanyCode.CompanyCode as CompanyCode,
      cast(case
        when (ForeignTaxStatus.TaxAbroadActivationStatus = cast('4' as int1) or ForeignTaxStatus.TaxAbroadActivationStatus = cast('5' as int1))
             and ForeignTaxRegis.deactivation_flag <> 'X' then 'ES'
                                                          else CompanyCode.Country
       end as country) as TaxCountry
} where CompanyCode.Country <> 'ES' and ForeignTaxRegis.tax_country = 'ES'

Learn More