I_PrmtHbRpldSupplierInvoice

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_PrmtHbRpldSupplierInvoice.
-- 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: IPRCHUBSINV

CREATE VIEW I_PrmtHbRpldSupplierInvoice AS
SELECT
  header.prmthbrpldsupplierinvoiceuuid AS PrmtHbRpldSupplierInvoiceUUID,
  header.procurementhubsourcesystem AS ProcurementHubSourceSystem,
  header.procmthubsupplierinvoicestatus AS ProcmtHubSupplierInvoiceStatus,
  header.procmthubsupplierinvoicesource AS ProcmtHubSupplierInvoiceSource,
  header.procmthubsupplierinvoiceorigin AS ProcmtHubSupplierInvoiceOrigin,
  header.prmthbrpldsupplierinvoice AS PrmtHbRpldSupplierInvoice,
  header.prmthbrpldsuplrinvcfiscalyear AS PrmtHbRpldSuplrInvcFiscalYear,
  header.procmthubcompanycode AS ProcmtHubCompanyCode,
  header.procmthubdocumentcurrency AS ProcmtHubDocumentCurrency,
  header.invoicegrossamount AS InvoiceGrossAmount,
  header.postingdate AS PostingDate,
  header.documentdate AS DocumentDate,
  header.taxreportingdate AS TaxReportingDate,
  header.suplrinvcautomreducedamount AS SuplrInvcAutomReducedAmount,
  header.suplrinvcmanuallyreducedamount AS SuplrInvcManuallyReducedAmount,
  header.supplierpostinglineitemtext AS SupplierPostingLineItemText,
  header.documentheadertext AS DocumentHeaderText,
  header.duecalculationbasedate AS DueCalculationBaseDate,
  header.cashdiscount1duedate AS CashDiscount1DueDate,
  header.cashdiscount2duedate AS CashDiscount2DueDate,
  header.netduedate AS NetDueDate,
  header.procmthubpaymentterms AS ProcmtHubPaymentTerms,
  header.manualcashdiscount AS ManualCashDiscount,
  header.fixedcashdiscount AS FixedCashDiscount,
  header.cashdiscount1percent AS CashDiscount1Percent,
  header.cashdiscount1days AS CashDiscount1Days,
  header.cashdiscount2percent AS CashDiscount2Percent,
  header.cashdiscount2days AS CashDiscount2Days,
  header.netpaymentdays AS NetPaymentDays,
  header.unplanneddeliverycost AS UnplannedDeliveryCost,
  header.invoicingparty AS PrmtHbInvoicingParty,
  header.supplierinvoiceidbyinvcgparty AS SupplierInvoiceIDByInvcgParty,
  header.prmthbaccountingdocumenttype AS PrmtHbAccountingDocumentType,
  header.assignmentreference AS AssignmentReference,
  header.exchangerate AS ExchangeRate,
  header.isinvoice AS IsInvoice,
  header.isendofpurposeblocked AS IsEndOfPurposeBlocked
FROM cim_d_header AS header
LEFT OUTER JOIN I_PrmtHbRpldSuplrInvcItmPORef AS _SupplierInvoiceItemPORef ON PrmtHbRpldSupplierInvoiceUUID = _SupplierInvoiceItemPORef.PrmtHbRpldSupplierInvoiceUUID  -- association [0..*]
LEFT OUTER JOIN I_PrmtHbRpldSuplrInvcItmGLAcct AS _SupplierInvoiceItemGLAcct ON PrmtHbRpldSupplierInvoiceUUID = _SupplierInvoiceItemGLAcct.PrmtHbRpldSupplierInvoiceUUID  -- association [0..*]
LEFT OUTER JOIN I_PrmtHbRpldSupplierInvoiceTax AS _SupplierInvoiceTax ON PrmtHbRpldSupplierInvoiceUUID = _SupplierInvoiceTax.PrmtHbRpldSupplierInvoiceUUID  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _Currency ON ProcmtHubDocumentCurrency = _Currency.Currency  -- association [0..1]
;