P_TaxRecon06

DDL: P_TAXRECON06 SQL: PTAXRECON06 Type: view BASIC
10 Fields 1 Data Sources

P_TaxRecon06 is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (P_TaxRecon07) and exposes 10 fields.

Data Sources (1)

SourceAliasJoin Type
P_TaxRecon07 bseg from

Annotations (6)

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

Fields (10)

KeyFieldSource TableSource FieldDescription
bukrs bukrs Value
belnr belnr SD Document
mwskz mwskz Tax Code
tax_country tax_country Tax Ctry/Rgn
txdat_from txdat_from Tax Rate Valid-From
dmbtr_sum
txbhw_sum
hwbas_sum
h_hwaer h_hwaer Local Currency
gjahr gjahr Settlement Year

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_TaxRecon06.
-- 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: PTAXRECON06

CREATE VIEW P_TaxRecon06 AS
SELECT
  bukrs,
  belnr,
  mwskz,
  tax_country,
  txdat_from,
  sum(dmbtr) AS dmbtr_sum,
  sum(txbhw) AS txbhw_sum,
  sum(hwbas) AS hwbas_sum,
  h_hwaer,
  gjahr
FROM P_TaxRecon07 AS bseg
;

Learn More