P_MY_TxItmWithSlsDeductionProd

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_MY_TxItmWithSlsDeductionProd.
-- 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.
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW P_MY_TxItmWithSlsDeductionProd AS
SELECT
  P_MY_TxItmWithSlsDeductionAmt.CompanyCode AS CompanyCode,
  P_MY_TxItmWithSlsDeductionAmt.AccountingDocument AS AccountingDocument,
  P_MY_TxItmWithSlsDeductionAmt.FiscalYear AS FiscalYear,
  TaxItem,
  P_MY_TxItmWithSlsDeductionAmt.TaxCode AS TaxCode,
  P_MY_TxItmWithSlsDeductionAmt.TransactionTypeDetermination AS TransactionTypeDetermination,
  ValidFrom,
  TaxBoxStructureType,
  TaxGroup,
  TaxBox,
  TaxDeclnAmountType,
  TaxBoxAggregationOperation,
  I_OperationalAcctgDocItem.Product AS Product,
  P_MY_TxItmWithSlsDeductionAmt.StatryRptRun AS StatryRptRun,
  P_MY_TxItmWithSlsDeductionAmt.CAReconciliationKey AS CAReconciliationKey,
  TaxRate,
  P_MY_TxItmWithSlsDeductionAmt.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  P_MY_TxItmWithSlsDeductionAmt.TaxType AS TaxType,
  P_MY_TxItmWithSlsDeductionAmt.GLAccount AS GLAccount,
  P_MY_TxItmWithSlsDeductionAmt.BusinessPlace AS BusinessPlace,
  P_MY_TxItmWithSlsDeductionAmt.TaxJurisdiction AS TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  P_MY_TxItmWithSlsDeductionAmt.AccountingDocumentType AS AccountingDocumentType,
  P_MY_TxItmWithSlsDeductionAmt.ReferenceDocumentType AS ReferenceDocumentType,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  DocumentReferenceID,
  Ledger,
  LedgerGroup,
  ReportingDate,
  P_MY_TxItmWithSlsDeductionAmt.PostingDate AS PostingDate,
  P_MY_TxItmWithSlsDeductionAmt.DocumentDate AS DocumentDate,
  TaxReportingDate,
  P_MY_TxItmWithSlsDeductionAmt.FiscalPeriod AS FiscalPeriod,
  ExchangeRate,
  IsReversal,
  IsReversed,
  AccountingDocumentHeaderText,
  ReportingCountry,
  BusinessPartner,
  BusinessPartnerCountry,
  BusinessPartnerName,
  CustomerSupplierAddress,
  MY_CompanyRegistrationNumber,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  ReportingCurrency,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  CountryCurrency,
  TaxBaseAmountInCountryCrcy,
  TaxAmountInCountryCrcy,
  P_MY_TxItmWithSlsDeductionAmt.DocumentCurrency AS DocumentCurrency,
  case P_MY_TxItmWithSlsDeductionAmt.TaxBaseAmountInCoCodeCrcy when 0 then 0 else division( abs(P_MY_TxItmWithSlsDeductionAmt.TaxAmount * cast(I_OperationalAcctgDocItem.AmountInCompanyCodeCurrency as abap.dec(10,4)) ), P_MY_TxItmWithSlsDeductionAmt.TaxBaseAmountInCoCodeCrcy,2) end as TaxAmount AS TaxBaseAmountInCoCodeCrcy2endasTaxAmount,
  P_MY_TxItmWithSlsDeductionAmt.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_OperationalAcctgDocItem.AmountInCompanyCodeCurrency AS TaxBaseAmountInCoCodeCrcy,
  P_MY_TxItmWithSlsDeductionAmt.AdditionalCurrency1 AS AdditionalCurrency1,
  P_MY_TxItmWithSlsDeductionAmt.AdditionalCurrency2 AS AdditionalCurrency2
FROM P_MY_TxItmWithSlsDeductionAmt
INNER JOIN I_OperationalAcctgDocItem ON /* join condition not captured in parsed metadata */
;