P_TaxRecon07

DDL: P_TAXRECON07 SQL: PTAXRECON07 Type: view BASIC
25 Fields 1 Data Sources

P_TaxRecon07 is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (bseg) and exposes 25 fields with key fields bukrs, belnr, mwskz, tax_country, txdat_from.

Data Sources (1)

SourceAliasJoin Type
bseg bseg from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PTAXRECON07 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 (25)

KeyFieldSource TableSource FieldDescription
KEY bukrs bseg bukrs Value
KEY belnr bseg belnr SD Document
KEY mwskz mwskz Tax Code
KEY tax_country tax_country Tax Ctry/Rgn
KEY txdat_from txdat_from Tax Rate Valid-From
KEY gjahr bseg gjahr Settlement Year
h_hwaer h_hwaer Local Currency
txgrp
hkont hkont Transfer acct
buzei buzei Posting View Item
h_budat h_budat Posting Date
h_bldat h_bldat Document Date
h_monat h_monat Period
h_blart h_blart Document Type
altkt altkt Group Account Number
lokkt lokkt Local Acct No.
mwart
bupla bupla Business place
umskz umskz Special G/L Ind
prctr prctr Profit Centers
xauto xauto Auto. Item Keys
xmwsn t001 xmwsn Net Tax Base
xskfn t001 xskfn Net Discount Base
zbd1p t001 zbd1p Max. Cash Dis. (%)
land1 exclude land1 Trip Ctry/Reg

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_TaxRecon07.
-- 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: PTAXRECON07

CREATE VIEW P_TaxRecon07 AS
SELECT
  bseg.bukrs AS bukrs,
  bseg.belnr AS belnr,
  mwskz,
  tax_country,
  txdat_from,
  bseg.gjahr AS gjahr,
  h_hwaer,
  coalesce(txgrp, '') AS txgrp,
  hkont,
  buzei,
  h_budat,
  h_bldat,
  h_monat,
  h_blart,
  altkt,
  lokkt,
  coalesce (mwart, '') AS mwart,
  bupla,
  umskz,
  prctr,
  xauto,
  t001.xmwsn AS xmwsn,
  t001.xskfn AS xskfn,
  t001.zbd1p AS zbd1p,
  exclude.land1 AS land1
FROM bseg
;

Learn More