P_RU_VatSalesPurchaseLedgers5

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_VatSalesPurchaseLedgers5.
-- 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: PRUVATSPLD5
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_StartDate : datum, P_EndDate : datum

CREATE VIEW P_RU_VatSalesPurchaseLedgers5 AS
SELECT *  -- field list not available in parsed metadata
LEFT OUTER JOIN P_RU_VatReversalDocument1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OperationalAcctgDocItem AS BusinessPartnerItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RU_ExtInvoiceTotalAmount AS _ExtOriginalDocumentAmount ON CompanyCode = _ExtOriginalDocumentAmount.CompanyCode AND ExternalOriginalDocument = _ExtOriginalDocumentAmount.ExternalAccountingDocument AND ExternalAcctgDocumentDate = _ExtOriginalDocumentAmount.ExternalAcctgDocumentDate  -- association [0..1]
LEFT OUTER JOIN P_RU_BSET AS _VatInTransitAmount ON CompanyCode = _VatInTransitAmount.CompanyCode AND OriginalDocument = _VatInTransitAmount.AccountingDocument AND OriginalDocumentYear = _VatInTransitAmount.FiscalYear AND TaxCode = _VatInTransitAmount.TaxCode  -- association [0..1]
LEFT OUTER JOIN I_RU_ReverseDocuments AS ReverseDocument ON ReverseDocument.CompanyCode = VatSalesPurchaseLedgers.CompanyCode AND ReverseDocument.AccountingDocument = VatSalesPurchaseLedgers.AccountingDocument AND ReverseDocument.FiscalYear = VatSalesPurchaseLedgers.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_SupplierInvoice AS _SupplierInvoice ON _SupplierInvoice.SupplierInvoice = VatSalesPurchaseLedgers.ReferenceDocumentNumber AND _SupplierInvoice.FiscalYear = VatSalesPurchaseLedgers.ReferenceDocumentYear  -- association [0..1]
LEFT OUTER JOIN I_RU_ImprtCstmsDecln AS _ImprtCstmsDecln ON _ImprtCstmsDecln.ImportCustomsDecln = VatSalesPurchaseLedgers.ReferenceDocumentNumber AND _ImprtCstmsDecln.ImportCustomsDeclnItem = '00001'  -- association [0..1]
LEFT OUTER JOIN I_RU_ImprtCstmsDecln AS _ImprtCstmsDeclnMM ON _ImprtCstmsDeclnMM.ImportCustomsDecln = VatSalesPurchaseLedgers.ImportCustomsDecln AND _ImprtCstmsDeclnMM.ImportCustomsDeclnItem = '00001'  -- association [0..1]
;