P_TH_TaxCodeRate

DDL: P_TH_TAXCODERATE SQL: PTHTAXCODERATE Type: view COMPOSITE

P_TH_TaxCodeRate is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (a003, I_TaxCode, konp) and exposes 6 fields with key fields TaxCode, ConditionType, TaxCalculationProcedure.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
a003 a003 from
I_TaxCode I_TaxCode left_outer
konp konp left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PTHTAXCODERATE view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY TaxCode a003 mwskz
KEY ConditionType a003 kschl
KEY TaxCalculationProcedure I_TaxCode TaxCalculationProcedure
ConditionNumber a003 knumh
TaxType I_TaxCode TaxType
TaxRate 
@AbapCatalog.sqlViewName: 'PTHTAXCODERATE'
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #CUSTOMIZING

define view P_TH_TaxCodeRate
  as select from    a003
    left outer join konp      on  konp.kappl = a003.kappl
                              and konp.knumh = a003.knumh
                              and konp.kschl = a003.kschl

 
    left outer join I_TaxCode on  a003.mwskz                        = I_TaxCode.TaxCode
                            //  and I_TaxCode.TaxCalculationProcedure = 'TAXTH' //get tax code for Thailand

{

  key a003.mwskz as TaxCode,
  key a003.kschl as ConditionType,
  key I_TaxCode.TaxCalculationProcedure,
      a003.knumh as ConditionNumber,
      I_TaxCode.TaxType,
      division ( konp.kbetr , 10, 2 ) as TaxRate // rate need to be division by 10 

}
where
      a003.kappl        = 'TX'
  and a003.aland        = 'TH' //get tax code for Thailand

  and I_TaxCode.TaxType = 'V' // input tax

Learn More