I_US_EPCRAInvtryTierOneDimn

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_US_EPCRAInvtryTierOneDimn.
-- 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.

CREATE VIEW I_US_EPCRAInvtryTierOneDimn AS
SELECT
  I_US_EPCRAInvtryVw.Product AS Product,
  I_US_EPCRAInvtryVw.Plant AS Plant,
  I_US_EPCRAInvtryVw.StorageLocation AS StorageLocation,
  I_US_EPCRAInvtryVw.StockReportingDate AS StockReportingDate,
  I_US_EPCRAInvtryVw.StockUnit AS StockUnit,
  concat_with_space( I_US_EPCRAInvtryVw.Plant, I_US_EPCRAInvtryVw.StorageLocation, 1 ) AS PlantAndStorageLocation,
  I_US_EPCRAInvtryVw.ChemicalUUID AS ChemicalUUID,
  _ChemicalRevision._ChemicalBasicInfo._ChemicalName[1: Language = $session.system_language].NameOfChemical AS NameOfChemical,
  _Product._Text[1: Language = $session.system_language ].ProductName AS ProductName,
  _ChemicalRevision._ChemicalRoot.ChemicalID AS ChemicalID,
  _ChemicalRevision.ChemicalRevisionUUID AS ChemicalRevisionUUID,
  I_US_EPCRAInvtryVw.CompanyCode AS CompanyCode,
  I_US_EPCRAInvtryVw.AvailableStockQuantity AS AvailableStockQuantity,
  cast( 'TAG' as unit ) AS DaysProductOnSiteUnit,
  I_US_EPCRAInvtryVw.US_EPCRAHasMultipleChmlAssgd AS US_EPCRAHasMultipleChmlAssgd,
  I_US_EPCRAInvtryVw.US_EPCRAStorageCondition AS US_EPCRAStorageCondition,
  I_US_EPCRAInvtryVw.US_EPCRAContainerType AS US_EPCRAContainerType,
  _ChemicalRevision._ChemicalBasicInfo.StateOfMatter AS StateOfMatter,
  _ChemicalRevision._ChemicalBasicInfo.CASNumber AS CASNumber,
  _ChemicalRevision._ChemicalBasicInfo.US_EPCRAIsExtremelyHzdsSubst AS US_EPCRAIsExtremelyHzdsSubst,
  _Plant.PlantName AS PlantName,
  cast( _ChemicalRevision._ChemicalRoot.ChemicalType as abap.char(1)) AS ChemicalType,
  _US_EPCRAHazardClCnctntdName[1: Language = $session.system_language].US_EPCRAHazardClCnctntdName AS US_EPCRAHazardClCnctntdName
FROM I_US_EPCRAInvtryVw
LEFT OUTER JOIN I_ChemicalRevision AS _ChemicalRevision ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_US_ChemicalEPCRAHazardClass AS _US_ChemicalEPCRAHazardClass ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Material AS _Material ON Product = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [1..1]
LEFT OUTER JOIN I_ChemicalDimension AS _ChemicalDimension ON ChemicalUUID = _ChemicalDimension.ChemicalUUID  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _Calendar ON StockReportingDate = _Calendar.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_US_EPCRAHazardClass AS _US_EPCRAHazardClass ON US_EPCRAHazardClass = _US_EPCRAHazardClass.US_EPCRAHazardClass  -- association [0..1]
LEFT OUTER JOIN I_StateOfMatter AS _StateOfMatter ON StateOfMatter = _StateOfMatter.StateOfMatter  -- association [1..1]
LEFT OUTER JOIN I_ChemicalType AS _ChemicalType ON ChemicalType = _ChemicalType.ChemicalType  -- association [1..1]
LEFT OUTER JOIN I_US_EPCRAHazardClCnctntdName AS _US_EPCRAHazardClCnctntdName ON ChemicalUUID = _US_EPCRAHazardClCnctntdName.ChemicalUUID AND _ChemicalRevision.ChemicalRevisionUUID = _US_EPCRAHazardClCnctntdName.ChemicalRevisionUUID  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasureStockUnit ON StockUnit = _UnitOfMeasureStockUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_ChemicalTypeNameText AS _ChemicalTypeNameText ON ChemicalType = _ChemicalTypeNameText.ChemicalType  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;