P_TaxRecon08

DDL: P_TAXRECON08 SQL: PTAXRECON08 Type: view BASIC
12 Fields 1 Data Sources

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

Data Sources (1)

SourceAliasJoin Type
P_TaxRecon11 bset from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PTAXRECON08 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 (12)

KeyFieldSource TableSource FieldDescription
bukrs P_TaxRecon11 bukrs Value
belnr P_TaxRecon11 belnr SD Document
mwskz P_TaxRecon11 mwskz Tax Code
tax_country P_TaxRecon11 tax_country Tax Ctry/Rgn
txdat_from P_TaxRecon11 txdat_from Tax Rate Valid-From
gjahr P_TaxRecon11 gjahr Settlement Year
ktosl P_TaxRecon11 ktosl Transaction
stbkz bset2 stbkz Posting indic.
stazf bset2 stazf Not deductible
txgrp
hwste P_TaxRecon11 hwste LC Tax
hwbas P_TaxRecon11 hwbas LC Base Amt

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_TaxRecon08.
-- 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: PTAXRECON08

CREATE VIEW P_TaxRecon08 AS
SELECT
  bset.bukrs AS bukrs,
  bset.belnr AS belnr,
  bset.mwskz AS mwskz,
  bset.tax_country AS tax_country,
  bset.txdat_from AS txdat_from,
  bset.gjahr AS gjahr,
  bset.ktosl AS ktosl,
  bset2.stbkz AS stbkz,
  bset2.stazf AS stazf,
  '' AS txgrp,
  bset.hwste AS hwste,
  bset.hwbas AS hwbas
FROM P_TaxRecon11 AS bset
;

Learn More