C_MDQltyProductSalesResult

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 C_MDQltyProductSalesResult.
-- 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: CMDQLTYPRODSARES

CREATE VIEW C_MDQltyProductSalesResult AS
SELECT
  MasterDataChangeProcess,
  Product,
  ProductSalesOrg,
  ProductDistributionChnl,
  MDQualityBusinessRuleUUID,
  MDQltyBusRuleEvalResultCode,
  _SalesOrganization._Text[1: Language=$session.system_language].SalesOrganizationName AS SalesOrganizationName,
  MDQltyNmbrOfBusRuleEvalResults,
  _DistributionChannelText.DistributionChannelName AS DistributionChannelName,
  _MDQualityBusinessRuleTP.MDQltyBusinessObjectTypeCode AS MDQltyBusinessObjectTypeCode,
  _MDQualityBusinessRuleTP.MDQltyBusRuleCheckedFieldTable AS MDQltyBusRuleCheckedFieldTable,
  _MDQualityBusinessRuleTP.MDQltyBusRuleCheckedField AS MDQltyBusRuleCheckedField,
  _MDQualityBusinessRuleTP.MDQltyBusRuleChkdFieldAndTable AS MDQltyBusRuleChkdFieldAndTable,
  _MDQualityBusinessRuleTP.MDQualityBusinessRule AS MDQualityBusinessRule,
  _MDQualityBusinessRuleTP.MDQualityBusinessRuleName AS MDQualityBusinessRuleName,
  _MDQualityBusinessRuleTP.MDQltyBusinessRuleBaseTable AS MDQltyBusinessRuleBaseTable,
  _MDQualityBusinessRuleTP.MDQltyTechnicalRuleScopeUUID AS MDQltyTechnicalRuleScopeUUID,
  _MDQualityBusinessRuleTP.MDQltyTechnicalRuleCndnUUID AS MDQltyTechnicalRuleCndnUUID,
  _MDQualityBusinessRuleTP.MDQltyMDGovBRFPlusObjectUUID AS MDQltyMDGovBRFPlusObjectUUID,
  _MDQualityBusinessRuleTP._MDQltyBusRuleCheckedFieldVH AS _MDQltyBusRuleCheckedFieldVH,
  _MDQualityBusinessRuleTP._MDQltyBusRuleChkdFieldText AS _MDQltyBusRuleChkdFieldText,
  _MDQualityEvaluations.MDChgProcessFinishDateTime AS MDChgProcessFinishDateTime,
  _Product.ProductDescription AS ProductDescription,
  _Product.ProductType AS ProductType,
  _Product.CrossPlantStatus AS CrossPlantStatus,
  _Product.ProductHierarchy AS ProductHierarchy,
  _Product.ProductGroup AS ProductGroup,
  _Product.CrossPlantStatusValidityDate AS CrossPlantStatusValidityDate,
  _Product.BaseUnit AS BaseUnit,
  _Product.CreationDate AS CreationDate,
  _Product.CreatedByUser AS CreatedByUser,
  _Product.LastChangeDate AS LastChangeDate,
  _Product.LastChangeDateTime AS LastChangeDateTime,
  _Product.LastChangeTime AS LastChangeTime,
  _Product.LastChangedByUser AS LastChangedByUser,
  _Product.LastChangedByUserName AS LastChangedByUserName,
  _Product.CreatedByUserName AS CreatedByUserName,
  _Product.IsMarkedForDeletion AS IsMarkedForDeletion,
  _Product.ProductOldID AS ProductOldID,
  _Product.GrossWeight AS GrossWeight,
  _Product.WeightUnit AS WeightUnit,
  _Product.NetWeight AS NetWeight,
  _Product.VolumeUnit AS VolumeUnit,
  _Product.MaterialVolume AS MaterialVolume,
  _Product.ItemCategoryGroup AS ItemCategoryGroup,
  _Product.Division AS Division,
  _Product.ANPCode AS ANPCode,
  _Product.Brand AS Brand,
  _Product.ValidityStartDate AS ValidityStartDate,
  _Product.ProdNoInGenProdInPrepackProd AS ProdNoInGenProdInPrepackProd,
  _Product.SizeOrDimensionText AS SizeOrDimensionText,
  _Product.IndustryStandardName AS IndustryStandardName,
  _Product.ProductStandardID AS ProductStandardID,
  _Product.InternationalArticleNumberCat AS InternationalArticleNumberCat,
  _Product.ProductIsConfigurable AS ProductIsConfigurable,
  _Product.IsBatchManagementRequired AS IsBatchManagementRequired,
  _Product.ExternalProductGroup AS ExternalProductGroup,
  _Product.SerialNoExplicitnessLevel AS SerialNoExplicitnessLevel,
  _Product.ProductManufacturerNumber AS ProductManufacturerNumber,
  _Product.ManufacturerNumber AS ManufacturerNumber,
  _Product.ManufacturerPartProfile AS ManufacturerPartProfile,
  _Product.BaseUnitSpecificProductLength AS BaseUnitSpecificProductLength,
  _Product.BaseUnitSpecificProductWidth AS BaseUnitSpecificProductWidth,
  _Product.BaseUnitSpecificProductHeight AS BaseUnitSpecificProductHeight,
  _Product.ProductMeasurementUnit AS ProductMeasurementUnit,
  _Product.ArticleCategory AS ArticleCategory,
  _Product.ContentUnit AS ContentUnit,
  _Product.NetContent AS NetContent,
  _Product.ComparisonPriceQuantity AS ComparisonPriceQuantity,
  _Product.GrossContent AS GrossContent,
  _Product.ProductValidEndDate AS ProductValidEndDate,
  _Product.AssortmentListType AS AssortmentListType,
  _Product.HasTextilePartsWthAnimalOrigin AS HasTextilePartsWthAnimalOrigin,
  _Product.ProductSeasonUsageCategory AS ProductSeasonUsageCategory,
  _Product.ServiceAgreement AS ServiceAgreement,
  _Product.RegionOfOrigin AS RegionOfOrigin,
  _Product.CountryOfOrigin AS CountryOfOrigin,
  _Product.GoodsIssueUnit AS GoodsIssueUnit,
  _Product.ConsumptionValueCategory AS ConsumptionValueCategory,
  _Product.ValuationClass AS ValuationClass,
  _Product.ValuationMargin AS ValuationMargin,
  _Product.ChangeNumber AS ChangeNumber,
  _Product.MaterialRevisionLevel AS MaterialRevisionLevel,
  _Product.HandlingIndicator AS HandlingIndicator,
  _Product.WarehouseProductGroup AS WarehouseProductGroup,
  _Product.WarehouseStorageCondition AS WarehouseStorageCondition,
  _Product.StandardHandlingUnitType AS StandardHandlingUnitType,
  _Product.SerialNumberProfile AS SerialNumberProfile,
  _Product.AdjustmentProfile AS AdjustmentProfile,
  _Product.IsPilferable AS IsPilferable,
  _Product.IsRelevantForHzdsSubstances AS IsRelevantForHzdsSubstances,
  _Product.QuarantinePeriod AS QuarantinePeriod,
  _Product.TimeUnitForQuarantinePeriod AS TimeUnitForQuarantinePeriod,
  _Product.QualityInspectionGroup AS QualityInspectionGroup,
  _Product.HandlingUnitType AS HandlingUnitType,
  _Product.MaximumCapacity AS MaximumCapacity,
  _Product.OvercapacityTolerance AS OvercapacityTolerance,
  _Product.HasVariableTareWeight AS HasVariableTareWeight,
  _Product.UnitForMaxPackagingDimensions AS UnitForMaxPackagingDimensions,
  _Product.MaximumPackagingLength AS MaximumPackagingLength,
  _Product.MaximumPackagingWidth AS MaximumPackagingWidth,
  _Product.MaximumPackagingHeight AS MaximumPackagingHeight,
  _Product.HasEmptiesBOM AS HasEmptiesBOM,
  _Product.AuthorizationGroup AS AuthorizationGroup,
  _Product._ProductType AS _ProductType,
  _Product._ProductTypeName AS _ProductTypeName,
  _Product._ProductStatus AS _ProductStatus,
  _Product._ProductStatusText AS _ProductStatusText,
  _Product._ProductGroup AS _ProductGroup,
  _Product._ProductGroupText AS _ProductGroupText,
  _Product._BaseUnitOfMeasure AS _BaseUnitOfMeasure,
  _Product._QuantityUnitValueHelp AS _QuantityUnitValueHelp,
  _Product._ProductHierarchy AS _ProductHierarchy,
  _Product._SerialNoText AS _SerialNoText,
  _Product._ManufacturerPartProfileText AS _ManufacturerPartProfileText,
  _Product._MaterialCategory AS _MaterialCategory,
  _Product._AssortmentListType AS _AssortmentListType,
  _Product._AssortmentListTypeText AS _AssortmentListTypeText,
  _Product._Brand AS _Brand,
  _Product._BrandText AS _BrandText,
  _Product._GoodsIssueUnit AS _GoodsIssueUnit,
  _Product._ConsumptionValueCategory AS _ConsumptionValueCategory,
  _Product._CountryOfOriginText AS _CountryOfOriginText,
  _Product._RegionText AS _RegionText,
  _Product._InternationalArticleNumberCat AS _InternationalArticleNumberCat,
  _Product._HandlingIndicator AS _HandlingIndicator,
  _Product._HandlingIndicatorText AS _HandlingIndicatorText,
  _Product._WarehouseProductGroup AS _WarehouseProductGroup,
  _Product._WarehouseProductGroupText AS _WarehouseProductGroupText,
  _Product._WarehouseStorageCondition AS _WarehouseStorageCondition,
  _Product._WarehouseStorageConditionText AS _WarehouseStorageConditionText,
  _Product._StandardHandlingUnitType AS _StandardHandlingUnitType,
  _Product._StandardHandlingUnitTypeText AS _StandardHandlingUnitTypeText,
  _Product._SerialNumberProfile AS _SerialNumberProfile,
  _Product._SerialNumberProfileText AS _SerialNumberProfileText,
  _Product._AdjustmentProfile_2 AS _AdjustmentProfile_2,
  _Product._AdjustmentProfileText_2 AS _AdjustmentProfileText_2,
  _Product._QualityInspectionGroup AS _QualityInspectionGroup,
  _Product._QualityInspectionGroupText AS _QualityInspectionGroupText,
  _Product._UnitForMaxPackaging AS _UnitForMaxPackaging,
  _Product._TimeUnitForQuarantinePeriod AS _TimeUnitForQuarantinePeriod,
  _Product._UnitForMaxPackagingText AS _UnitForMaxPackagingText,
  _Product._ContentUnit AS _ContentUnit,
  _Product._ProductMeasurementUnit AS _ProductMeasurementUnit,
  _Product._ExtProdGrpText AS _ExtProdGrpText,
  _Product._ExternalProductGroup AS _ExternalProductGroup,
  _Product._Division AS _Division,
  _Product._DivisionText AS _DivisionText,
  _Product._ProductHierarchyText AS _ProductHierarchyText,
  _Product._WeightUnitText AS _WeightUnitText,
  _Product._WeightUnitValueHelp AS _WeightUnitValueHelp,
  _Product._QuantityUnitText AS _QuantityUnitText,
  _Product._GoodsIssueText AS _GoodsIssueText,
  _Product._ConsumptionValueCategoryText AS _ConsumptionValueCategoryText,
  _Product._TimeUnitQuarantinePeriodText AS _TimeUnitQuarantinePeriodText,
  _Product._IntArticleNumberText AS _IntArticleNumberText,
  _Product._ArticleCategoryText AS _ArticleCategoryText,
  _Product._BaseUnitOfMeasureText AS _BaseUnitOfMeasureText,
  _Product._ProductUnitOfMeasureVH AS _ProductUnitOfMeasureVH,
  _Product._ProductGroupText_2 AS _ProductGroupText_2,
  _Product._ProductGroup_2 AS _ProductGroup_2,
  _ProductSalesDelivery.ItemCategoryGroup AS SalesItemCategoryGroup,
  _ProductSalesDelivery.ProductSalesStatus AS ProductSalesStatus,
  _ProductSalesDelivery.ProductSalesStatusValidityDate AS ProductSalesStatusValidityDate,
  _ProductSalesDelivery.SalesMeasureUnit AS SalesMeasureUnit,
  _ProductSalesDelivery.FirstSalesSpecProductGroup AS FirstSalesSpecProductGroup,
  _ProductSalesDelivery.SecondSalesSpecProductGroup AS SecondSalesSpecProductGroup,
  _ProductSalesDelivery.ThirdSalesSpecProductGroup AS ThirdSalesSpecProductGroup,
  _ProductSalesDelivery.FourthSalesSpecProductGroup AS FourthSalesSpecProductGroup,
  _ProductSalesDelivery.FifthSalesSpecProductGroup AS FifthSalesSpecProductGroup,
  _ProductSalesDelivery.MinimumMakeToOrderOrderQty AS MinimumMakeToOrderOrderQty,
  _ProductSalesDelivery.LogisticsStatisticsGroup AS LogisticsStatisticsGroup,
  _ProductSalesDelivery.VolumeRebateGroup AS VolumeRebateGroup,
  _ProductSalesDelivery.ProductCommissionGroup AS ProductCommissionGroup,
  _ProductSalesDelivery.CashDiscountIsDeductible AS CashDiscountIsDeductible,
  _ProductSalesDelivery.PricingReferenceProduct AS PricingReferenceProduct,
  _ProductSalesDelivery.AssortmentGrade AS AssortmentGrade,
  _ProductSalesDelivery.StoreListingProcedure AS StoreListingProcedure,
  _ProductSalesDelivery.DistrCntrListingProcedure AS DistrCntrListingProcedure,
  _ProductSalesDelivery.StoreListingStartDate AS StoreListingStartDate,
  _ProductSalesDelivery.StoreListingEndDate AS StoreListingEndDate,
  _ProductSalesDelivery.DistrCntrListingStartDate AS DistrCntrListingStartDate,
  _ProductSalesDelivery.DistrCntrListingEndDate AS DistrCntrListingEndDate,
  _ProductSalesDelivery.StoreSaleStartDate AS StoreSaleStartDate,
  _ProductSalesDelivery.StoreSaleEndDate AS StoreSaleEndDate,
  _ProductSalesDelivery.DistrCntrSaleStartDate AS DistrCntrSaleStartDate,
  _ProductSalesDelivery.DistrCntrSaleEndDate AS DistrCntrSaleEndDate,
  _ProductSalesDelivery.RoundingProfile AS RoundingProfile,
  _ProductSalesDelivery.ProductUnitGroup AS ProductUnitGroup,
  _ProductSalesDelivery.MaxDeliveryQtyStoreOrder AS MaxDeliveryQtyStoreOrder,
  _ProductSalesDelivery.PriceFixingCategory AS PriceFixingCategory,
  _ProductSalesDelivery.VariableSalesUnitIsNotAllowed AS VariableSalesUnitIsNotAllowed,
  _ProductSalesDelivery.CompetitionPressureCategory AS CompetitionPressureCategory,
  _ProductSalesDelivery.ProductDistributionChnl AS DistributionChannel,
  _ProductSalesDelivery._DistributionChannel AS _DistributionChannel,
  _SalesOrganization.SalesOrganization AS SalesOrganization,
  _SalesOrganization._Text AS _SalesOrganizationText
FROM I_MDQltyProductSalesResult
LEFT OUTER JOIN C_MDQualityEvaluations AS _MDQualityEvaluations ON _MDQualityEvaluations.MasterDataChangeProcess = MasterDataChangeProcess AND _MDQualityEvaluations.MDQltyBusinessObjectTypeCode = '194'  -- association [1..1]
LEFT OUTER JOIN C_MDQltyProductDetail AS _Product ON _Product.Product = Product  -- association [0..1]
LEFT OUTER JOIN C_MDQualityBusinessRuleTP AS _MDQualityBusinessRuleTP ON _MDQualityBusinessRuleTP.MDQualityBusinessRuleUUID = MDQualityBusinessRuleUUID  -- association [1..1]
LEFT OUTER JOIN C_MDQltyBusinessRuleVH AS _MDQltyBusinessRuleQuickView ON _MDQltyBusinessRuleQuickView.MDQualityBusinessRule = MDQualityBusinessRule AND _MDQltyBusinessRuleQuickView.MDQltyBusinessObjectTypeCode = mdqltybusinessobjecttypecode  -- association [1..1]
LEFT OUTER JOIN C_MDQltyBusinessRuleBaseTblVH AS _MDQltyBusinessRuleBaseTblVH ON MDQltyBusinessRuleBaseTable = _MDQltyBusinessRuleBaseTblVH.MDQltyBusinessRuleBaseTable AND _MDQltyBusinessRuleBaseTblVH.MDQltyBusinessObjectTypeCode = '194'  -- association [1..1]
LEFT OUTER JOIN I_ProductSalesDelivery AS _ProductSalesDelivery ON _ProductSalesDelivery.Product = Product AND _ProductSalesDelivery.ProductSalesOrg = ProductSalesOrg AND _ProductSalesDelivery.ProductDistributionChnl = ProductDistributionChnl  -- association [0..1]
LEFT OUTER JOIN C_SalesOrganizationVH AS _SalesOrganization ON ProductSalesOrg = _SalesOrganization.SalesOrganization  -- association [1..1]
LEFT OUTER JOIN C_Dischannelvaluehelp AS _DistributionChannelVH ON ProductSalesOrg = _DistributionChannelVH.SalesOrganization AND ProductDistributionChnl = _DistributionChannelVH.DistributionChannel  -- association [1..1]
LEFT OUTER JOIN I_Division AS _DivisionVH ON Division = _DivisionVH.Division  -- association [1..1]
LEFT OUTER JOIN I_DistributionChannelText AS _DistributionChannelText ON ProductDistributionChnl = _DistributionChannelText.DistributionChannel AND _DistributionChannelText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_SalesDistributionStatusVH AS _ProductSalesStatus ON productsalesstatus = _ProductSalesStatus.ProductSalesStatus  -- association [0..1]
LEFT OUTER JOIN I_ItemCategoryGroup AS _ItemCategoryGroup ON SalesItemCategoryGroup = _ItemCategoryGroup.ItemCategoryGroup  -- association [0..1]
LEFT OUTER JOIN I_ItemCategoryGroupText AS _ItemCategoryGroupText ON SalesItemCategoryGroup = _ItemCategoryGroupText.ItemCategoryGroup  -- association [0..*]
LEFT OUTER JOIN E_Product AS _ProductExtension ON Product = _ProductExtension.Product  -- association [0..1]
LEFT OUTER JOIN E_Productsalesdelivery AS _SalesExtension ON Product = _SalesExtension.Product AND ProductSalesOrg = _SalesExtension.ProductSalesOrganization AND ProductDistributionChnl = _SalesExtension.ProductDistributionChannel  -- association [0..1]
;