P_MX_DefTaxOpenPayment

DDL: P_MX_DEFTAXOPENPAYMENT SQL: PMXDEFTAXOPPAY Type: view COMPOSITE
11 Fields 2 Data Sources

P_MX_DefTaxOpenPayment is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_MX_DefTaxItem, P_MX_DefTaxItem) and exposes 11 fields with key fields CompanyCode, AccountingDocument, FiscalYear, PaymentCompanyCode, PaymentAccountingDocument.

Data Sources (2)

SourceAliasJoin Type
P_MX_DefTaxItem OpenPayment inner
P_MX_DefTaxItem P_MX_DefTaxItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PMXDEFTAXOPPAY 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 #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_MX_DefTaxItem CompanyCode Receiver Company Code
KEY AccountingDocument P_MX_DefTaxItem AccountingDocument Journal Entry
KEY FiscalYear P_MX_DefTaxItem FiscalYear G/L Fiscal Year
KEY PaymentCompanyCode P_MX_DefTaxItem PaymentCompanyCode Paying CoCd
KEY PaymentAccountingDocument P_MX_DefTaxItem PaymentAccountingDocument Document Number
KEY PaymentFiscalYear P_MX_DefTaxItem PaymentFiscalYear
LineType P_MX_DefTaxItem LineType Type of line
ClearingAccountingDocument P_MX_DefTaxItem ClearingAccountingDocument Clearing Journal Entry
ClearingDocumentFiscalYear P_MX_DefTaxItem ClearingDocumentFiscalYear Clearing doc year
TaxTransferDocument P_MX_DefTaxItem TaxTransferDocument Document Number
TaxTransferDocumentYear P_MX_DefTaxItem TaxTransferDocumentYear

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_DefTaxOpenPayment.
-- 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: PMXDEFTAXOPPAY

CREATE VIEW P_MX_DefTaxOpenPayment AS
SELECT
  P_MX_DefTaxItem.CompanyCode AS CompanyCode,
  P_MX_DefTaxItem.AccountingDocument AS AccountingDocument,
  P_MX_DefTaxItem.FiscalYear AS FiscalYear,
  P_MX_DefTaxItem.PaymentCompanyCode AS PaymentCompanyCode,
  OpenPayment.PaymentAccountingDocument AS PaymentAccountingDocument,
  OpenPayment.PaymentFiscalYear AS PaymentFiscalYear,
  P_MX_DefTaxItem.LineType AS LineType,
  P_MX_DefTaxItem.ClearingAccountingDocument AS ClearingAccountingDocument,
  P_MX_DefTaxItem.ClearingDocumentFiscalYear AS ClearingDocumentFiscalYear,
  P_MX_DefTaxItem.TaxTransferDocument AS TaxTransferDocument,
  P_MX_DefTaxItem.TaxTransferDocumentYear AS TaxTransferDocumentYear
FROM P_MX_DefTaxItem
INNER JOIN P_MX_DefTaxItem AS OpenPayment ON /* join condition not captured in parsed metadata */
;

Learn More