V_Mmim_DDL_Om_Param_PI

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 V_Mmim_DDL_Om_Param_PI.
-- 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: V_MMIM_OM_PAR_PI

CREATE VIEW V_Mmim_DDL_Om_Param_PI AS
SELECT
  document.mandt AS SAPClient,
  concat( document.PhysicalInventoryDocument, concat (document.FiscalYear, document.PhysicalInventoryDocumentItem ) ) AS pidockey,
  document.PhysicalInventoryDocument AS PhysicalInventoryDocument,
  document.FiscalYear AS PhysicalInventoryYear,
  document.PhysicalInventoryDocumentItem AS PhysicalInventoryItem,
  document.Plant AS Plant,
  document.StorageLocation AS StorageLocation,
  val.bukrs AS CompanyCode,
  plant.spras AS Language,
  plant.land1 AS Country,
  val.xvkbw AS SalesPriceValuation
FROM I_PhysInvtryDocItem AS document
INNER JOIN t001w AS plant ON /* join condition not captured in parsed metadata */
INNER JOIN t001k AS val ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_PhysInvtryDocumentItem AS _PrintExtension ON PhysicalInventoryYear = _PrintExtension.FiscalYear AND PhysicalInventoryDocument = _PrintExtension.PhysicalInventoryDocument AND PhysicalInventoryItem = _PrintExtension.PhysicalInventoryDocumentItem  -- association [0..1]
;