I_MDQAnlytsScrProdDescCube

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_MDQAnlytsScrProdDescCube.
-- 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_MDQAnlytsScrProdDescCube AS
SELECT
  MasterDataChangeProcess,
  Product,
  MDQualityBusinessRuleUUID,
  MDQltyBusRuleEvalResultCode,
  Language,
  _ProductDescription.ProductDescription AS ProductDescription,
  _MasterDataChangeProcess.MDChgProcessFinishDate AS MDChgProcessFinishDate,
  _MDQltyScoreEvalDetails.MDChgProcessIsLatest AS MDChgProcessIsLatest,
  MDQltyBusinessRuleBaseTable,
  _MDQBusinessRuleBaseTableText[1:Language=$session.system_language].MDQltyBusinessRuleBaseTabName AS MDQltyBusinessRuleBaseTabName,
  MDQltyBusinessRuleOwner,
  _MDQltyBusRule.MDQltyBusRuleCheckedField AS MDQltyBusRuleCheckedField,
  _MDQltyBusRule.MDQltyBusRuleCheckedFieldTable AS MDQltyBusRuleCheckedFieldTable,
  _MDQltyBusRule.MDQltyBusRuleChkdFieldAndTable AS MDQltyBusRuleChkdFieldAndTable,
  _MDQltyBusRule.MDQualityBusinessRule AS MDQualityBusinessRule,
  _MDQltyBusRule.MDQualityBusinessRuleName AS MDQualityBusinessRuleName,
  _Product.AuthorizationGroup AS AuthorizationGroup,
  _Product.BaseUnit AS BaseUnit,
  _Product.CreatedByUser AS CreatedByUser,
  _Product.CreationDate AS CreationDate,
  _Product.CrossPlantStatus AS CrossPlantStatus,
  _Product.Division AS Division,
  _Product.ExternalProductGroup AS ExternalProductGroup,
  _Product.HasEmptiesBOM AS HasEmptiesBOM,
  _Product.HasTextilePartsWthAnimalOrigin AS HasTextilePartsWthAnimalOrigin,
  _Product.HasVariableTareWeight AS HasVariableTareWeight,
  _Product.IndustrySector AS IndustrySector,
  _Product.IndustryStandardName AS IndustryStandardName,
  _Product.InternationalArticleNumberCat AS InternationalArticleNumberCat,
  _Product.IsBatchManagementRequired AS IsBatchManagementRequired,
  _Product.IsPilferable AS IsPilferable,
  _Product.IsRelevantForHzdsSubstances AS IsRelevantForHzdsSubstances,
  _Product.ItemCategoryGroup AS ItemCategoryGroup,
  _Product.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  _Product.LastChangeDate AS LastChangeDate,
  _Product.LastChangedByUser AS LastChangedByUser,
  _Product.LastChangeTime AS LastChangeTime,
  _Product.ProdNoInGenProdInPrepackProd AS ProdNoInGenProdInPrepackProd,
  _Product.ProductGroup AS ProductGroup,
  _Product.ProductHierarchy AS ProductHierarchy,
  _Product.ProductIsConfigurable AS ProductIsConfigurable,
  _Product.ProductOldID AS ProductOldID,
  _Product.ProductSeasonUsageCategory AS ProductSeasonUsageCategory,
  _Product.ProductStandardID AS ProductStandardID,
  _Product.ProductType AS ProductType,
  _Product.QualityInspectionGroup AS QualityInspectionGroup,
  _Product.SerialNoExplicitnessLevel AS SerialNoExplicitnessLevel,
  _Product._ProductRetail.ValuationClass AS ValuationClass,
  _Product.WarehouseProductGroup AS WarehouseProductGroup,
  _Product.WarehouseStorageCondition AS WarehouseStorageCondition,
  _Product._BaseUnitOfMeasureText AS _BaseUnitOfMeasureText,
  _Product._DivisionText AS _DivisionText,
  _Product._ExtProdGrpText AS _ExtProdGrpText,
  _Product._ItemCategoryGroupText AS _ItemCategoryGroupText,
  _Product._IntArticleNumberText AS _IntArticleNumberText,
  _Product._ProductGroupText_2 AS _ProductGroupText_2,
  _Product._ProductStatusText AS _ProductStatusText,
  _Product._ProductTypeName_2 AS _ProductTypeName_2,
  _Product._ProductRetail._ValuationClassText AS _ValuationClassText,
  MDQltyNmbrOfSuccssflEvalRslts,
  MDQltyNmbrOfFailedEvalRslts,
  MDQltyNmbrOfBusRuleEvalResults
FROM I_MDQltyAnlytsScrProdDesc
LEFT OUTER JOIN I_ProductDescription AS _ProductDescription ON _ProductDescription.Product = Product AND _ProductDescription.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DocumentInfoRecordLbtryOffcT AS _LaboratoryOrDesignOfficeText ON _LaboratoryOrDesignOfficeText.LaboratoryOrDesignOffice = laboratoryordesignoffice  -- association [0..*]
LEFT OUTER JOIN I_MDQltyBusinessRuleBaseTableT AS _MDQBusinessRuleBaseTableText ON _MDQBusinessRuleBaseTableText.MDQltyBusinessObjectTypeCode = '194' AND _MDQBusinessRuleBaseTableText.MDQltyBusinessRuleBaseTable = MDQltyBusinessRuleBaseTable  -- association [1..*]
LEFT OUTER JOIN I_MDQltyFioriLaunchpadHostPath AS _FLPHostPath ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_MDQltyScoreEvalDetails AS _MDQltyScoreEvalDetails ON _MDQltyScoreEvalDetails.MasterDataChangeProcess = MasterDataChangeProcess  -- association [1..1]
LEFT OUTER JOIN I_MDQualityBusinessRule AS _MDQltyBusRule ON _MDQltyBusRule.MDQualityBusinessRuleUUID = MDQualityBusinessRuleUUID  -- association [1..1]
LEFT OUTER JOIN I_IndustrySectorText_2 AS _IndustrySectorText ON _IndustrySectorText.IndustrySector = industrysector  -- association [0..*]
LEFT OUTER JOIN I_Product AS _Product ON _Product.Product = Product  -- association [1..1]
LEFT OUTER JOIN I_ProductText AS _ProductText ON _ProductText.Product = Product  -- association [0..*]
LEFT OUTER JOIN I_User AS _UserChangedBy ON _UserChangedBy.UserID = lastchangedbyuser  -- association [0..1]
LEFT OUTER JOIN I_User AS _UserCreatedBy ON _UserCreatedBy.UserID = createdbyuser  -- association [0..1]
LEFT OUTER JOIN I_User AS _UserRuleOwner ON _UserRuleOwner.UserID = MDQltyBusinessRuleOwner  -- association [0..1]
LEFT OUTER JOIN E_Product AS _ProductExtension ON _ProductExtension.Product = Product  -- association [0..1]
;