I_ES_SIITAXRATEDETAIL

CDS View

Spain SII Tax Rate Details

I_ES_SIITAXRATEDETAIL is a CDS View in S/4HANA. Spain SII Tax Rate Details. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ES_EDCSuplrInvcSIITaxLine view_entity inner COMPOSITE Spain Supplier Invoice Tax lines 
@AbapCatalog.sqlViewName: 'IESSIITAXRATDET'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Spain SII Tax Rate Details'
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #M,
  dataClass: #CUSTOMIZING
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
define view I_ES_SIITaxRateDetail as select from t685a as SalesConditionTypes
left outer to one join I_ES_SIITaxRateDetailTaxType as TaxConditionTypes on SalesConditionTypes.kschl = TaxConditionTypes.ConditionType 
{
   SalesConditionTypes.kschl as ConditionType,
   SalesConditionTypes.kappl as ConditionApplication,
   SalesConditionTypes.krech as ConditionCalculationTypeShort
}where SalesConditionTypes.kappl = 'V' and TaxConditionTypes.ConditionApplication is null
union select from t685a as TaxConditionTypes
{
   TaxConditionTypes.kschl as ConditionType,
   TaxConditionTypes.kappl as ConditionApplication,
   TaxConditionTypes.krech as ConditionCalculationTypeShort
}where kappl = 'TX'

Learn More