P_RU_TaxCode

DDL: P_RU_TAXCODE SQL: PRUTAXCODE Type: view COMPOSITE

P_RU_TaxCode is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_CompanyCode, I_Country, I_TaxCode) and exposes 5 fields with key fields CompanyCode, TaxCalculationProcedure, TaxCode.

3 data source(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode inner
I_Country I_Country inner
I_TaxCode I_TaxCode from

Annotations (7)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName PRUTAXCODE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCode CompanyCode
KEY TaxCalculationProcedure I_TaxCode TaxCalculationProcedure
KEY TaxCode I_TaxCode TaxCode
TaxType I_TaxCode TaxType
Country I_CompanyCode Country 
@VDM.private:true
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'PRUTAXCODE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_RU_TaxCode
  as select from I_TaxCode

    inner join   I_Country     on I_Country.TaxCalculationProcedure = I_TaxCode.TaxCalculationProcedure

    inner join   I_CompanyCode on I_CompanyCode.Country = I_Country.Country

{
  key    I_CompanyCode.CompanyCode,
  key    I_TaxCode.TaxCalculationProcedure,
  key    I_TaxCode.TaxCode,
         I_TaxCode.TaxType,
         I_CompanyCode.Country
}

Learn More