P_CndnTypeTaxClassification

DDL: P_CNDNTYPETAXCLASSIFICATION SQL: PCNDNTYPTXCLS Type: view BASIC
12 Fields 4 Data Sources

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.

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 Application
KEY ConditionType kschl Tax Item Type
KEY DepartureCountry aland Dep. Ctry/Reg.
KEY TaxCode mwskz Tax Code
KEY ConditionValidityEndDate Validity period
ConditionValidityStartDate Validity period
KEY ConditionType kschl Tax Item Type
KEY DepartureCountry aland Dep. Ctry/Reg.
KEY TaxCode mwskz Tax Code
KEY ConditionValidityEndDate datbi Validity period
ConditionValidityStartDate datab Validity period
ConditionRecord a4av knumh NoCondRec.Batch

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_CndnTypeTaxClassification.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PCNDNTYPTXCLS

CREATE VIEW P_CndnTypeTaxClassification AS
SELECT
  kappl AS Application,
  kschl AS ConditionType,
  aland AS DepartureCountry,
  mwskz AS TaxCode,
  '99991231' AS ConditionValidityEndDate,
  '00000000' AS ConditionValidityStartDate,
  a4av.knumh AS ConditionRecord
FROM a003
INNER JOIN I_TimeDependentTaxStatus ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): a4av
;

Learn More