P_PCLblProdCmbndByBusProc

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_PCLblProdCmbndByBusProc.
-- 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: PPRODCMBND

CREATE VIEW P_PCLblProdCmbndByBusProc AS
SELECT
  cast( '01' as ehlbl_bus_proc_code preserving type ) AS PCLblBusProc,
  cast( Product as abap.char( 40 ) ) AS PCLblBusProcSearchElementText,
  cast( Product as ehlbl_product_number_nc preserving type ) AS Product,
  cast( ' ' as vbeln_vl preserving type ) AS DeliveryDocument,
  cast( Product as abap.char( 72 ) ) AS UniqueItemIdentifier,
  cast( ' ' as ehfnd_maint_order_id_nc preserving type ) AS ManufacturingOrder,
  cast( ' ' as vdm_sales_order preserving type ) AS SalesOrder,
  cast( ' ' as werks_d preserving type ) AS Plant,
  cast( ' ' as kunnr preserving type ) AS Customer,
  cast( ' ' as vkorg preserving type ) AS SalesOrganization,
  cast( _Text[1: Language = $session.system_language ].ProductName as ehfnd_cci_internal_name ) AS ProductName,
  cast( cast( '1' as abap.quan( 13, 3 ) ) as mfgorderplannedtotalqty preserving type ) AS ActualDeliveryQuantity,
  BaseUnit,
  ' ' AS Country,
  cast( ' ' as abap.char(15) ) AS Batch,
  AuthorizationGroup,
  ProductType,
  ProductGroup,
  cast(' ' as vstel preserving type ) AS ShippingPoint,
  cast('00' as pph_autyp preserving type ) AS ManufacturingOrderCategory,
  cast(' ' as aufart preserving type ) AS ManufacturingOrderType,
  cast(' ' as pwwrk preserving type ) AS ProductionPlant,
  cast(' ' as ehfnd_cci_is_transported preserving type ) AS MaterialIsTransported,
  cast(' ' as ehfnd_cci_is_produced preserving type ) AS MaterialIsProduced,
  cast(' ' as ehfnd_cci_is_sold preserving type ) AS MaterialIsSold,
  cast(' ' as ehfnd_cci_is_sourced preserving type ) AS MaterialIsSourced,
  cast(' ' as ehfnd_cci_responsible_unit_pss preserving type ) AS ProdStewardshipRespUnit,
  cast(' ' as ehfnd_cci_is_disposed preserving type ) AS MaterialIsDisposed,
  _Product._ProductType AS _ProductType,
  _Product._ProductGroup_2 AS _ProductGroup_2,
  MaterialIsEmissionRelevant
FROM I_Product
INNER JOIN I_Product AS _Product ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_DeliveryPickViewItem, I_ManufacturingOrder, I_ChmlCmplncInfo
;