P_RU_VatSalesPurchaseLedgers1

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

CREATE VIEW P_RU_VatSalesPurchaseLedgers1 AS
SELECT
  AccountingDocument.CompanyCode AS CompanyCode,
  AccountingDocument.AccountingDocument AS AccountingDocument,
  AccountingDocument.FiscalYear AS FiscalYear,
  AccountingDocument.PostingDate AS PostingDate,
  AccountingDocument.ReverseDocument AS ReverseDocument,
  AccountingDocument.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  AccountingDocument.OriginalReferenceDocument AS OriginalReferenceDocument,
  AccountingDocument.ReferenceDocumentType AS ReferenceDocumentType,
  AccountingDocument.DocumentReferenceID AS DocumentReferenceID,
  AccountingDocument.CompanyCodeCurrency AS CompanyCodeCurrency,
  AccountingDocument.Currency AS Currency,
  AccountingDocument.TaxReportingDate AS TaxReportingDate,
  AccountingDocument.BusinessTransactionType AS BusinessTransactionType,
  AccountingDocument.IsReversal AS IsReversal,
  AccountingDocument.IsReversed AS IsReversed,
  TaxItem.TaxCode AS TaxCode,
  TaxItem.TaxRate AS TaxRate,
  case when TaxItem.TaxRate = 0.00 or TaxItem.TaxRate is null then _TaxBasisBalancesGrp.TaxCode else '' end as WithoutTax AS TaxCodeelseendasWithoutTax,
  AccountingDocument.DocumentDate AS DocumentDate,
  VatSPLedgerCust.RU_VATSubScenario AS RU_VATSubScenario,
  VatSPLedgerCust.RU_VATScenario AS RU_VATScenario,
  VatSPLedgerCust.RU_VATReturnSection AS RU_VATReturnSection,
  VatSPLedgerCust.RU_VATReturnSectionType AS RU_VATReturnSectionType,
  VatSPLedgerCust.RU_VATSubScenarioVersion AS RU_VATSubScenarioVersion,
  VatSPLedgerCust.RU_VATReturnVersion AS RU_VATReturnVersion,
  VatSPLedgerCust.BusinessPartnerType AS BusinessPartnerType,
  VatSPLedgerCust.PaymentOrderOutputType AS PaymentOrderOutputType,
  VatSPLedgerCust.ImprtCstmsDeclnIsRead AS ImprtCstmsDeclnIsRead,
  VatSPLedgerCust.RU_TaxBaseAmountCalcType AS RU_TaxBaseAmountCalcType,
  VatSPLedgerCust.AgentType AS AgentType,
  VatSPLedgerCust.RU_OrgOperationType AS RU_OrgOperationType,
  VatSPLedgerCust.RU_PersonOperationType AS RU_PersonOperationType,
  VatSPLedgerCust.MatlRcptDateIsRead AS MatlRcptDateIsRead,
  TaxItem.AccountingDocument AS SelectedDocument,
  TaxItem.TaxAmountInCoCodeCrcy AS TaxSumHW,
  TaxItem.TaxAmount AS TaxSumFW,
  VatSPLedgerCust.IsCorrectionInvoice AS IsCorrectionInvoice,
  Main.SourceDocument AS OriginalDocument,
  Main.SourceDocumentFiscalYear AS OriginalDocumentYear,
  Main.RevisionNumber AS RevisionNumber,
  '0' AS ActionRuleIsGenerated
FROM I_RU_StRpJournalEntryLog AS Main
LEFT OUTER JOIN I_TaxBasisBalancesGrp AS _TaxBasisBalancesGrp ON _TaxBasisBalancesGrp.Country = 'RU' AND _TaxBasisBalancesGrp.TaxItemGroupingVersion = 'PAY' AND _TaxBasisBalancesGrp.TaxCode = VatSPLedgerCust.TaxCode  -- association [0..1]
;