P_StRpAdvncRetForSlsAndPurTx

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_StRpAdvncRetForSlsAndPurTx.
-- 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: PSRADVRTSLSPURTX

CREATE VIEW P_StRpAdvncRetForSlsAndPurTx AS
SELECT
  I_StRpTaxItemBoxCube.CompanyCode AS CompanyCode,
  I_StRpTaxItemBoxCube.AccountingDocument AS AccountingDocument,
  I_StRpTaxItemBoxCube.FiscalYear AS FiscalYear,
  TaxItem,
  I_StRpTaxItemBoxCube.TaxCode AS TaxCode,
  TransactionTypeDetermination,
  TaxBox,
  TaxDeclnAmountType,
  TaxItemGroupingVersion,
  ValidFrom,
  TaxBoxStructureType,
  DebitCreditCode,
  I_StRpTaxItemBoxCube.TaxCalculationProcedure AS TaxCalculationProcedure,
  TaxRate,
  GLAccount,
  TaxItemGroup,
  BusinessPlace,
  TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  AccountingDocumentType,
  ReferenceDocumentType,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  P_CndnTypeTaxClassification.ConditionRecord AS ConditionRecord,
  TaxAmountInCoCodeCrcy AS CalculatedTxAmtInCoCodeCrcy,
  TaxAmount AS CalculatedTaxAmountInTransCrcy,
  case when I_StRpTaxItemBoxCube.TaxReturnCountry is null or I_StRpTaxItemBoxCube.TaxReturnCountry = ' ' then CompanyCodeCountry else I_StRpTaxItemBoxCube.TaxReturnCountry end as Country AS TaxReturnCountryendasCountry,
  I_StRpTaxItemBoxCube.EUTaxClassification AS EUTaxClassification,
  DocumentReferenceID,
  Ledger,
  LedgerGroup,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  ReportingDate,
  FiscalPeriod,
  ExchangeRate,
  IsReversal,
  IsReversed,
  AccountingDocumentHeaderText,
  CompanyCodeCountry,
  ReportingCountry,
  I_StRpTaxItemBoxCube.TaxReturnCountry AS TaxReturnCountry,
  CompanyCodeCurrency,
  CountryCurrency,
  DocumentCurrency,
  ReportingCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmount,
  TaxBaseAmountInCountryCrcy,
  TaxAmountInCountryCrcy,
  TaxBaseAmountInTransCrcy,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  _AccountingDocument.OriginalReferenceDocument AS OriginalReferenceDocument,
  _DebtorCreditorRblsPyblsItem.FinancialAccountType AS FinancialAccountType,
  _DebtorCreditorRblsPyblsItem._Customer.Customer AS Customer,
  I_StRpTaxItemBoxCube.TaxType AS TaxType,
  I_StRpTaxItemBoxCube.TargetTaxCode AS TargetTaxCode,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  BusinessPartner,
  BusinessPartnerName,
  CustomerSupplierAddress,
  TaxBoxStructure,
  TaxBoxStructureName,
  TaxBoxName,
  TaxBoxCondition,
  TaxGroup,
  SupplierAccountGroup,
  TaxBoxAggregationOperation,
  TaxGroupOperation,
  I_StRpTaxItemBoxCube.TaxCountry AS TaxCountry,
  TaxIsNotDeductible,
  _ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  _ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  _ReportedItemsLog.StatryRptRunID AS StatryRptRunID
FROM I_StRpTaxItemBoxCube
INNER JOIN P_T007B_GLO ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RndRulesForCoCodeAndCrcy AS _CCCurrency ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RndRulesForCoCodeAndCrcy AS _DocCurrency ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RefundRelatedTaxCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_CndnTypeTaxClassification ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_BaseAmtForNegativeCharge AS _NegCharge ON CompanyCode = _NegCharge.CompanyCode AND AccountingDocument = _NegCharge.AccountingDocument AND FiscalYear = _NegCharge.FiscalYear  -- association [1..*]
;