P_GB_TaxCodeCustomizing

DDL: P_GB_TAXCODECUSTOMIZING Type: view_entity BASIC

Great Britain Tax customizing

P_GB_TaxCodeCustomizing is a Basic CDS View that provides data about "Great Britain Tax customizing" in SAP S/4HANA. It reads from 4 data sources (a4av, t005, t007b, t683s) and exposes 10 fields.

4 data source(s) 10 fields

Data Sources (4)

SourceAliasJoin Type
a4av a4av from
t005 t005 inner
t007b t007b inner
t683s t683s inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Great Britain Tax customizing view

Fields (10)

KeyFieldSource TableSource FieldDescription
Application a4av kappl
ConditionType a4av kschl
DepartureCountry a4av aland
TaxCode a4av mwskz
ConditionValidityEndDate a4av datbi
ConditionValidityStartDate a4av datab
ConditionRecord a4av knumh
TransactionTypeDetermination t683s kvsl1
TaxIsNotDeductible t007b stazf
TaxRate 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@VDM.private:true
@VDM.viewType: #BASIC
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #L,
  dataClass: #MIXED
}
@EndUserText.label: 'Great Britain Tax customizing'
define view entity P_GB_TaxCodeCustomizing
  as select from           a4av //P_CndnTypeTaxClassification

    left outer to one join konp  on  konp.kappl = a4av.kappl
                                 and konp.kschl = a4av.kschl
                                 and konp.knumh = a4av.knumh
                                 and konp.kbetr > 0
    inner join             t005  on t005.land1 = a4av.aland
    inner join             t683s on  t683s.kvewe = 'A'
                                 and t683s.kappl = konp.kappl
                                 and t683s.kalsm = t005.kalsm
                                 and t683s.kschl = konp.kschl
    inner join             t007b on t007b.ktosl = t683s.kvsl1


{
  a4av.kappl                                               as Application,
  a4av.kschl                                               as ConditionType,
  a4av.aland                                               as DepartureCountry,
  a4av.mwskz                                               as TaxCode,
  a4av.datbi                                               as ConditionValidityEndDate,
  a4av.datab                                               as ConditionValidityStartDate,
  a4av.knumh                                               as ConditionRecord,
  t683s.kvsl1                                              as TransactionTypeDetermination,
  t007b.stazf                                              as TaxIsNotDeductible,
  //division(konp.kbetr, 10, 2)                            as TaxRate2,

  division( cast ( konp.kbetr as abap.dec(10,2)), 1000, 4) as TaxRate
}

where
      a4av.kappl  = 'TX'
  and a4av.kschl  = 'GB'
  and t007b.stazf is initial

Learn More