P_AUDIT_AT_TAX_CODES

DDL: P_AUDIT_AT_TAX_CODES SQL: PAUDITATTAXCODES Type: view BASIC
29 Fields 1 Data Sources

P_AUDIT_AT_TAX_CODES is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (t007s) and exposes 29 fields with key fields bukrs, gjahr, kalsm, mwskz.

Data Sources (1)

SourceAliasJoin Type
t007s t007s left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PAUDITATTAXCODES view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MASTER view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY bukrs bset bukrs Value
KEY gjahr bset gjahr Settlement Year
KEY kalsm t005 kalsm Search Proced.
KEY mwskz t007a mwskz Tax Code
ltext t007s text1 Vertikalization Text
pruef t007a pruef Deviation Error
mwart t007a mwart Tax Type
xmstu t007a xmstu Single-Character Flag
zmwsk t007a zmwsk Target Tax Code
egrkz t007a egrkz EU Code/Code
xslta t007a xslta No Exch. Rate Diff. When Clearing in LC
procd t007a procd Product Code
txind t007a txind Tax Category
txrel t007a txrel Tax-Relevant
lstml t007a lstml Reporting C/R
j_1busage t007a j_1busage Usage
j_1biss t007a j_1biss Serv. w/o ICMS/IPI
j_1btaxlw1 t007a j_1btaxlw1 ICMS Law
j_1btaxlw2 t007a j_1btaxlw2 IPI Law
j_1btxicex t007a j_1btxicex ICMS-exempt
j_1btxipex t007a j_1btxipex IPI-exempt
tolerance t007a tolerance Weight Tolerance
zmwsk_esa t007a zmwsk_esa TgtTxCd OutpTax
zmwsk_ese t007a zmwsk_ese TgtTxCd Inp.Tax
newdeftax t007a newdeftax New Def. TaxCde
j_1btaxlw4 t007a j_1btaxlw4 COFINS Law
j_1btaxlw5 t007a j_1btaxlw5 PIS Law
xinact t007a xinact Inactive
mossc t007a mossc OSS C/R

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_AUDIT_AT_TAX_CODES.
-- 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: PAUDITATTAXCODES

CREATE VIEW P_AUDIT_AT_TAX_CODES AS
SELECT
  bset.bukrs AS bukrs,
  bset.gjahr AS gjahr,
  t005.kalsm AS kalsm,
  t007a.mwskz AS mwskz,
  t007s.text1 AS ltext,
  t007a.pruef AS pruef,
  t007a.mwart AS mwart,
  t007a.xmstu AS xmstu,
  t007a.zmwsk AS zmwsk,
  t007a.egrkz AS egrkz,
  t007a.xslta AS xslta,
  t007a.procd AS procd,
  t007a.txind AS txind,
  t007a.txrel AS txrel,
  t007a.lstml AS lstml,
  t007a.j_1busage AS j_1busage,
  t007a.j_1biss AS j_1biss,
  t007a.j_1btaxlw1 AS j_1btaxlw1,
  t007a.j_1btaxlw2 AS j_1btaxlw2,
  t007a.j_1btxicex AS j_1btxicex,
  t007a.j_1btxipex AS j_1btxipex,
  t007a.tolerance AS tolerance,
  t007a.zmwsk_esa AS zmwsk_esa,
  t007a.zmwsk_ese AS zmwsk_ese,
  t007a.newdeftax AS newdeftax,
  t007a.j_1btaxlw4 AS j_1btaxlw4,
  t007a.j_1btaxlw5 AS j_1btaxlw5,
  t007a.xinact AS xinact,
  t007a.mossc AS mossc
LEFT OUTER JOIN t007s ON /* join condition not captured in parsed metadata */
;

Learn More