P_TaxRecon11

DDL: P_TAXRECON11 SQL: PTAXRECON11 Type: view BASIC
11 Fields 1 Data Sources

P_TaxRecon11 is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (P_TaxRecon12) and exposes 11 fields.

Data Sources (1)

SourceAliasJoin Type
P_TaxRecon12 P_TaxRecon12 from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PTAXRECON11 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 (11)

KeyFieldSource TableSource FieldDescription
bukrs bukrs Value
belnr belnr SD Document
gjahr gjahr Settlement Year
ktosl ktosl Transaction
taxps taxps Tax doc. item number
mwskz mwskz Tax Code
tax_country tax_country Tax Ctry/Rgn
txdat_from txdat_from Tax Rate Valid-From
kbetr kbetr Tax Rate
hwbas
hwste

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_TaxRecon11.
-- 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: PTAXRECON11

CREATE VIEW P_TaxRecon11 AS
SELECT
  bukrs,
  belnr,
  gjahr,
  ktosl,
  taxps,
  mwskz,
  tax_country,
  txdat_from,
  kbetr,
  sum(hwbas) AS hwbas,
  sum(hwste) AS hwste
FROM P_TaxRecon12
;

Learn More