P_TaxRecon12

DDL: P_TAXRECON12 SQL: PTAXRECON12 Type: view BASIC Package: ODATA_TAX_RECONCILIATION
11 Fields 1 Data Sources

prepare data from bset

P_TaxRecon12 is a Basic CDS View that provides data about "prepare data from bset" in SAP S/4HANA. It reads from 1 data source (bset) and exposes 11 fields. Part of development package ODATA_TAX_RECONCILIATION.

Data Sources (1)

SourceAliasJoin Type
bset bset from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PTAXRECON12 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
txgrp txgrp Tax off grpg
kbetr_calc

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_TaxRecon12.
-- 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: PTAXRECON12

CREATE VIEW P_TaxRecon12 AS
SELECT
  bukrs,
  belnr,
  gjahr,
  ktosl,
  taxps,
  mwskz,
  tax_country,
  txdat_from,
  kbetr,
  txgrp,
  cast (DIVISION (bset.kbetr , 1000, 6) as abap.curr(10,6)) AS kbetr_calc
FROM bset
;

Learn More