I_ProductSpecification

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_ProductSpecification.
-- 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: IPRODSPEC

CREATE VIEW I_ProductSpecification AS
SELECT
  cast( SpecificationInternalID as /plmb/spc_prod_int_id preserving type ) AS ProductSpecificationInternalID,
  cast( SpecificationChangeState as /plmb/spc_prod_change_state preserving type ) AS ProductSpecificationChgState,
  cast( Specification as /plmb/spc_prod_spec_ext_id_api preserving type ) AS ProductSpecification,
  SpecificationValidityStartDate AS ProdSpecValidityStartDate,
  SpecificationValidityEndDate AS ProdSpecValidityEndDate,
  SpecificationChangeNumber AS ChangeNumber,
  SpecificationCreatedByUser AS ProdSpecCreatedByUser,
  SpecificationCreationDate AS ProdSpecCreationDate,
  SpecificationLastChangedByUser AS ProdSpecLastChangedByUser,
  SpecificationLastChangeDate AS ProdSpecLastChangeDate,
  SpecificationNote AS ProdSpecNote,
  SpecificationIsDeleted AS ProdSpecIsDeleted,
  _ProdSpecType.SpecificationType AS ProdSpecType,
  SpecificationAuthznGroup AS ProdSpecAuthznGroup
FROM I_Specification AS _Specification
INNER JOIN I_ProdSpecType AS _ProdSpecType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ChangeMaster AS _ChangeMaster ON _ChangeMaster.ChangeNumber = ChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_ProdSpecNonHistoric AS _ProdSpecNonHistoric ON _ProdSpecNonHistoric.ProductSpecificationInternalID = ProductSpecificationInternalID  -- association [1..1]
LEFT OUTER JOIN I_ProdSpecDescription AS _ProdSpecDescription ON _ProdSpecDescription.ProductSpecificationInternalID = ProductSpecificationInternalID AND _ProdSpecDescription.ProdSpecDescValidityStartDate <= ProdSpecValidityStartDate AND _ProdSpecDescription.ProdSpecDescValidityEndDate >= ProdSpecValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_ProdSpecStdCmpstnHeader AS _ProdSpecStdCmpstnHeader ON _ProdSpecStdCmpstnHeader.ProductSpecificationInternalID = ProductSpecificationInternalID AND _ProdSpecStdCmpstnHeader.ProdSpecCmpstnHdrValdtyStrtDte <= ProdSpecValidityStartDate AND _ProdSpecStdCmpstnHeader.ProdSpecCmpstnHdrValdtyEndDte >= ProdSpecValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_ProdSpecAllergenCmpstnHeader AS _ProdSpecAllergenCmpstnHeader ON _ProdSpecAllergenCmpstnHeader.ProductSpecificationInternalID = ProductSpecificationInternalID AND _ProdSpecAllergenCmpstnHeader.ProdSpecCmpstnHdrValdtyStrtDte <= ProdSpecValidityStartDate AND _ProdSpecAllergenCmpstnHeader.ProdSpecCmpstnHdrValdtyEndDte >= ProdSpecValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_ProdSpecNutrientCmpstnHdr AS _ProdSpecNutrientCmpstnHdr ON _ProdSpecNutrientCmpstnHdr.ProductSpecificationInternalID = ProductSpecificationInternalID AND _ProdSpecNutrientCmpstnHdr.ProdSpecCmpstnHdrValdtyStrtDte <= ProdSpecValidityStartDate AND _ProdSpecNutrientCmpstnHdr.ProdSpecCmpstnHdrValdtyEndDte >= ProdSpecValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_ProdSpecCmpstnHeader AS _ProdSpecCmpstnHeader ON _ProdSpecCmpstnHeader.ProductSpecificationInternalID = ProductSpecificationInternalID AND _ProdSpecCmpstnHeader.ProdSpecCmpstnHdrValdtyStrtDte <= ProdSpecValidityStartDate AND _ProdSpecCmpstnHeader.ProdSpecCmpstnHdrValdtyEndDte >= ProdSpecValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_ProdSpecQtytvCmpstnHeader AS _ProdSpecQtytvCmpstnHeader ON _ProdSpecQtytvCmpstnHeader.ProductSpecificationInternalID = ProductSpecificationInternalID AND _ProdSpecQtytvCmpstnHeader.ProdSpecCmpstnHdrValdtyStrtDte <= ProdSpecValidityStartDate AND _ProdSpecQtytvCmpstnHeader.ProdSpecCmpstnHdrValdtyEndDte >= ProdSpecValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_ProdSpecQltatvCmpstnHeader AS _ProdSpecQltatvCmpstnHeader ON _ProdSpecQltatvCmpstnHeader.ProductSpecificationInternalID = ProductSpecificationInternalID AND _ProdSpecQltatvCmpstnHeader.ProdSpecCmpstnHdrValdtyStrtDte <= ProdSpecValidityStartDate AND _ProdSpecQltatvCmpstnHeader.ProdSpecCmpstnHdrValdtyEndDte >= ProdSpecValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_ProdSpecListingCmpstnHeader AS _ProdSpecListingCmpstnHeader ON _ProdSpecListingCmpstnHeader.ProductSpecificationInternalID = ProductSpecificationInternalID AND _ProdSpecListingCmpstnHeader.ProdSpecCmpstnHdrValdtyStrtDte <= ProdSpecValidityStartDate AND _ProdSpecListingCmpstnHeader.ProdSpecCmpstnHdrValdtyEndDte >= ProdSpecValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_ProdSpecPropertyHeader AS _ProdSpecPropertyHeader ON _ProdSpecPropertyHeader.ProductSpecificationInternalID = ProductSpecificationInternalID AND _ProdSpecPropertyHeader.ProdSpecPrptyHdrValdtyStrtDte <= ProdSpecValidityStartDate AND _ProdSpecPropertyHeader.ProdSpecPrptyHdrValdtyEndDte >= ProdSpecValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_SpecificationLastChange AS _SpecificationLastChange ON ProductSpecificationInternalID = _SpecificationLastChange.SpecificationInternalID  -- association [0..1]
;