P_CndnTypeTaxClassification

DDL: P_CNDNTYPETAXCLASSIFICATION SQL: PCNDNTYPTXCLS Type: view BASIC

P_CndnTypeTaxClassification is a Basic CDS View in SAP S/4HANA. It reads from 4 data sources (a003, a4av, I_TimeDependentTaxStatus, I_TimeDependentTaxStatus) and exposes 12 fields with key fields Application, ConditionType, DepartureCountry, TaxCode, ConditionValidityEndDate.

4 data source(s) 12 fields

Data Sources (4)

SourceAliasJoin Type
a003 a003 from
a4av a4av union_all
I_TimeDependentTaxStatus I_TimeDependentTaxStatus inner
I_TimeDependentTaxStatus I_TimeDependentTaxStatus inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCNDNTYPTXCLS view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Application kappl
KEY ConditionType kschl
KEY DepartureCountry aland
KEY TaxCode mwskz
KEY ConditionValidityEndDate
ConditionValidityStartDate
KEY ConditionType kschl
KEY DepartureCountry aland
KEY TaxCode mwskz
KEY ConditionValidityEndDate datbi
ConditionValidityStartDate datab
ConditionRecord a4av knumh 
@AbapCatalog.sqlViewName: 'PCNDNTYPTXCLS'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Condition Type Classification'

define view P_CndnTypeTaxClassification as select from a003 

inner join I_TimeDependentTaxStatus on  Country = aland

{

key kappl as Application,
key kschl as ConditionType,
key aland as DepartureCountry,
key mwskz as TaxCode,
key '99991231'  as ConditionValidityEndDate,
'00000000'      as ConditionValidityStartDate,
a003.knumh      as ConditionRecord
  
}

where CountryIsTimeDependentTxActive = ''

union all 

select from a4av 

inner join I_TimeDependentTaxStatus on  Country = aland

{

key kappl as Application,
key kschl as ConditionType,
key aland as DepartureCountry,
key mwskz as TaxCode,
key datbi as ConditionValidityEndDate,
    datab as ConditionValidityStartDate,
a4av.knumh as ConditionRecord
}

where CountryIsTimeDependentTxActive = 'X'

Learn More