P_MX_DefTaxItem

DDL: P_MX_DEFTAXITEM SQL: PMXDEFTAXITEM Type: view BASIC
24 Fields 1 Data Sources

P_MX_DefTaxItem is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (deftax_item) and exposes 24 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, TransactionTypeDetermination.

Data Sources (1)

SourceAliasJoin Type
deftax_item deftax_item from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PMXDEFTAXITEM 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
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #BASIC view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bukrs Value
KEY AccountingDocument belnr SD Document
KEY FiscalYear Settlement Year
KEY AccountingDocumentItem buzei Posting View Item
KEY TransactionTypeDetermination ktosl Transaction
KEY PaymentCompanyCode zbukr Paying CoCd
KEY PaymentAccountingDocument zbeln Document Number
KEY PaymentFiscalYear Fiscal Year
KEY PaymentDocumentItem zbuze Item
TaxCode mwskz Tax Code
CAReversalDocumentNumber rbeln Tax transfer revers
LineType line_type Valuation line type
ClearingAccountingDocument cbeln Clearing document
ClearingDocumentFiscalYear cgjah Clearing doc year
TaxTransferDocument tbeln Tax transfer doc
TaxTransferDocumentYear Transfer doc year
Supplier lifnr Vendor no.
Customer kunnr Stock customer
GrossAmtInLocalCrcy hwbtr LC Gross
GrossAmtInNationalCrcy fwbtr Gross Amount
PartialGrossAmtInLocalCrcy hteil LC Part. Amt
PartialGrossAmtInNationalCrcy lteil NC Part. Amt
PartialTaxAmtInLocalCrcy hteis LC PartTax
PartialTaxAmtInNationalCrcy lteis NC Part. Tax

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_MX_DefTaxItem.
-- 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: PMXDEFTAXITEM

CREATE VIEW P_MX_DefTaxItem AS
SELECT
  bukrs AS CompanyCode,
  belnr AS AccountingDocument,
  cast( gjahr as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  buzei AS AccountingDocumentItem,
  ktosl AS TransactionTypeDetermination,
  zbukr AS PaymentCompanyCode,
  zbeln AS PaymentAccountingDocument,
  cast( zgjah as fis_gjahr_no_conv preserving type ) AS PaymentFiscalYear,
  zbuze AS PaymentDocumentItem,
  mwskz AS TaxCode,
  rbeln AS CAReversalDocumentNumber,
  line_type AS LineType,
  cbeln AS ClearingAccountingDocument,
  cgjah AS ClearingDocumentFiscalYear,
  tbeln AS TaxTransferDocument,
  cast( tgjah as fis_gjahr_no_conv preserving type ) AS TaxTransferDocumentYear,
  lifnr AS Supplier,
  kunnr AS Customer,
  hwbtr AS GrossAmtInLocalCrcy,
  fwbtr AS GrossAmtInNationalCrcy,
  hteil AS PartialGrossAmtInLocalCrcy,
  lteil AS PartialGrossAmtInNationalCrcy,
  hteis AS PartialTaxAmtInLocalCrcy,
  lteis AS PartialTaxAmtInNationalCrcy
FROM deftax_item
;

Learn More