P_RU_GtdFromPOMM34

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_GtdFromPOMM34.
-- 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: PRUGTDPOMM34

CREATE VIEW P_RU_GtdFromPOMM34 AS
SELECT
  ImCD.CompanyCode AS CompanyCode,
  cast(' ' as werks_d preserving type) AS Plant,
  ImCD.PurchaseOrder AS PurchaseOrder,
  ImCD.PurchaseOrderItem AS PurchaseOrderItem,
  ImCD.MaterialDocument AS MaterialDocument,
  ImCD.MaterialDocumentYear AS MaterialDocumentYear,
  cast(' ' as belnr_d preserving type) AS SupplierInvoice,
  cast('0000' as gjahr preserving type) AS SupplierInvoiceFiscalYear,
  'IMCD' AS PurchaseOrderSouce,
  ImCD.Supplier AS Supplier,
  ImCD.EntryCustomsOffice AS EntryCustomsOffice,
  ImCD.CustomsDeclarationDate AS CustomsDeclarationDate,
  ImCD.CustomsDeclaration AS CustomsDeclaration,
  ImCD.ImportCustomsDeclnItem AS ImportCustomsDeclnItem,
  ImCD.ImportCustomsDeclnPrintItem AS ImportCustomsDeclnPrintItem,
  ImCD.ImportCustomsDecln AS ImportCustomsDecln
FROM I_RU_ImprtCstmsDecln AS ImCD
INNER JOIN I_PurchasingDocumentHistory AS PurchaseHistory_GR ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurchasingDocumentHistory AS PurchaseHistory_IR ON /* join condition not captured in parsed metadata */
INNER JOIN I_SupplierInvoiceItemPurOrdRef AS PurchOrderRef ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_RU_ImprtCstmsDecln
;