I_LstMiSDInvoice

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 I_LstMiSDInvoice.
-- 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: ILSTMISDINV

CREATE VIEW I_LstMiSDInvoice AS
SELECT
  toVisit.BillingDocument AS Invoice,
  toVisit.LastMileRouteVisitUUID AS LastMileRouteVisitUUID,
  toVisit.LastMileRouteUUID AS LastMileRouteUUID,
  cast( ( TotalNetAmount + TotalTaxAmount ) as lmd_sd_invoice_total_gross_amt ) AS TotalGrossAmount,
  TransactionCurrency,
  CustomerPaymentTerms,
  AccountingDocument,
  FiscalYear,
  CompanyCode,
  OverallSDProcessStatus,
  OverallBillingStatus,
  billingDocument.SDDocumentCategory AS SDDocumentCategory,
  _AccountingDocument.AccountingDocumentCategory AS AccountingDocumentCategory
FROM I_BillingDocument AS billingDocument
INNER JOIN P_LstMiRteVstToBillingDocument AS toVisit ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_LstMiRoute AS _Route ON LastMileRouteUUID = _Route.LastMileRouteUUID  -- association [1..1]
LEFT OUTER JOIN I_LstMiSDOutbDelivToSDInvoice AS _OutboundDelivery ON Invoice = _OutboundDelivery.Invoice  -- association [1..*]
;