C_Product

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_Product.
-- 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: CPRODUCT

CREATE VIEW C_Product AS
SELECT
  cast( '' as productimageurl ) AS ProductImageURL,
  cast('' as boole_d) AS HasGlobalHierarchy,
  cast('' as boole_d) AS IsVariantConfigurationEnabled,
  cast( 0 as cmd_prd_num_prod_variants ) AS NumberOfProductVariants,
  cast( 0 as abap.int2) AS NumberOfProcessedProdVariants,
  cast( '' as msehi ) AS OvercapacityToleranceUnit,
  Product.Product AS Product,
  Product.ProductForEdit AS ProductForEdit,
  Product.ProductDescription AS ProductDescription,
  Product.ProductType AS ProductType,
  Product.CrossPlantStatus AS CrossPlantStatus,
  Product.CrossPlantStatusValidityDate AS CrossPlantStatusValidityDate,
  Product.ProductGroup AS ProductGroup,
  Product.BaseUnit AS BaseUnit,
  Product.CreationDate AS CreationDate,
  Product.CreationTime AS CreationTime,
  Product.CreationDateTime AS CreationDateTime,
  Product.CreatedByUser AS CreatedByUser,
  Product.LastChangeDate AS LastChangeDate,
  Product.LastChangeDateTime AS LastChangeDateTime,
  Product.LastChangeTime AS LastChangeTime,
  Product.LastChangedByUser AS LastChangedByUser,
  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.CompetitorID AS CompetitorID,
  Product.ItemCategoryGroup AS ItemCategoryGroup,
  Product.ProductHierarchy AS ProductHierarchy,
  Product.Division AS Division,
  Product.BasicMaterial AS BasicMaterial,
  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.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  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.ClassificationSideEffect AS ClassificationSideEffect,
  Product.ConfigurationSideEffect AS ConfigurationSideEffect,
  Product.AuthorizationGroup AS AuthorizationGroup,
  Product.IsChemicalComplianceRelevant AS IsChemicalComplianceRelevant,
  Product.ReferenceProduct AS ReferenceProduct,
  Product.SalesUnit AS SalesUnit,
  Product.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  Product.PackagingMaterialGroup AS PackagingMaterialGroup,
  Product.ProductDocumentNumber AS ProductDocumentNumber,
  Product.ProductDocumentVersion AS ProductDocumentVersion,
  Product.ProductDocumentType AS ProductDocumentType,
  Product.ProductDocumentChangeNumber AS ProductDocumentChangeNumber,
  Product.ProductDocumentPageCount AS ProductDocumentPageCount,
  Product.ProductDocumentPageNumber AS ProductDocumentPageNumber,
  Product.ProductDocumentPageFormat AS ProductDocumentPageFormat,
  Product.OwnInventoryManagedProduct AS OwnInventoryManagedProduct,
  Product._ItemCategoryGroup AS _ItemCategoryGroup,
  Product._ChemicalComplianceRelevant AS _ChemicalComplianceRelevant,
  Product._ChemicalComplianceRlvtText AS _ChemicalComplianceRlvtText,
  Product._SalesUnit AS _SalesUnit,
  Product._ValuationClass AS _ValuationClass,
  Product._ValuationClassText AS _ValuationClassText,
  _CreatedByUserName.UserDescription AS CreatedByUserName,
  _ExternalProduct.ProductExternalID AS ProductExternalID,
  _LastChangedByUserName.UserDescription AS LastChangedByUserName
FROM I_ProductWD AS Product
LEFT OUTER JOIN C_Productdescription AS _Description ON Product = _Description.Product  -- association [0..*]
LEFT OUTER JOIN C_Productplant AS _Plant ON Product = _Plant.Product  -- association [0..*]
LEFT OUTER JOIN C_Productstore AS _Store ON Product = _Store.Product AND _Store.PlantCategory = 'A'  -- association [0..*]
LEFT OUTER JOIN C_Productdistributioncenter AS _DistributionCenter ON Product = _DistributionCenter.Product AND _DistributionCenter.PlantCategory = 'B'  -- association [0..*]
LEFT OUTER JOIN C_Productstoragelocationref AS _StorageLocation ON Product = _StorageLocation.Product AND _StorageLocation.PlantCategory = ''  -- association [0..*]
LEFT OUTER JOIN C_Productsales AS _ProductSales ON Product = _ProductSales.Product  -- association [0..1]
LEFT OUTER JOIN C_Productqm AS _ProductQualityMgmt ON Product = _ProductQualityMgmt.Product  -- association [0..1]
LEFT OUTER JOIN C_Productsalesdelivery AS _SalesDelivery ON Product = _SalesDelivery.Product  -- association [0..*]
LEFT OUTER JOIN C_Productunitsofmeasure AS _UnitOfMeasure ON Product = _UnitOfMeasure.Product  -- association [0..*]
LEFT OUTER JOIN C_Productvaluation AS _Valuation ON Product = _Valuation.Product  -- association [0..*]
LEFT OUTER JOIN C_Productstorage AS _ProductStorage ON Product = _ProductStorage.Product  -- association [0..1]
LEFT OUTER JOIN C_Productprocurement AS _ProductProcurement ON Product = _ProductProcurement.Product  -- association [0..1]
LEFT OUTER JOIN C_Productscm AS _SupplyChainManagement ON Product = _SupplyChainManagement.Product  -- association [0..1]
LEFT OUTER JOIN C_Productvariantmatrix AS _ProductVariant ON Product = _ProductVariant.Product  -- association [0..*]
LEFT OUTER JOIN C_Productstoragelocationref AS _ReferenceDistributionCenter ON Product = _ReferenceDistributionCenter.Product  -- association [0..*]
LEFT OUTER JOIN C_Productstoragelocationref AS _ReferenceStore ON Product = _ReferenceStore.Product  -- association [0..*]
LEFT OUTER JOIN C_Product AS _ConfProductVariant ON Product = _ConfProductVariant.CrossPlantConfigurableProduct AND Product <> ''  -- association [0..*]
LEFT OUTER JOIN C_ProductBOM AS _ProductBOM ON Product = _ProductBOM.Material  -- association [0..*]
LEFT OUTER JOIN C_ProductSeasons AS _ProductSeasons ON Product = _ProductSeasons.Product  -- association [0..*]
LEFT OUTER JOIN C_ProductPlantMRP AS _PlantMRPArea ON Product = _PlantMRPArea.Product  -- association [0..*]
LEFT OUTER JOIN C_ProdEWMWarehouse AS _Warehouse ON Product = _Warehouse.Product  -- association [0..*]
LEFT OUTER JOIN C_ProductReplenishment AS _ProductReplenishment ON Product = _ProductReplenishment.Product  -- association [0..*]
LEFT OUTER JOIN C_Productsalestax AS _ProductSalesTax ON Product = _ProductSalesTax.Product  -- association [0..*]
LEFT OUTER JOIN C_Srnoexpllvltexttemp AS _SerialNoText ON SerialNoExplicitnessLevel = _SerialNoText.SerialNoExplicitnessLevel  -- association [0..*]
LEFT OUTER JOIN C_Productcategoryvh AS _MaterialCategory ON ArticleCategory = _MaterialCategory.ArticleCategory  -- association [0..1]
LEFT OUTER JOIN I_ProductCategoryText AS _ArticleCategoryText ON ArticleCategory = _ArticleCategoryText.ProductCategory  -- association [0..*]
LEFT OUTER JOIN C_ProductUnitOfMeasureVH AS _ProductUnitOfMeasureVH ON BaseUnit = _ProductUnitOfMeasureVH.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN C_Revisionlevellist AS _RevisionLevelOrder ON Product = _RevisionLevelOrder.Product  -- association [0..*]
LEFT OUTER JOIN C_MDProductHierarchyInfo AS _ProductHierarchyInfo ON Product = _ProductHierarchyInfo.Product  -- association [0..*]
LEFT OUTER JOIN C_ProductBasicInfo AS _CrossPlantConfigurableProduct ON CrossPlantConfigurableProduct = _CrossPlantConfigurableProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_Product AS _ExternalProduct ON Product = _ExternalProduct.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductChangeNumberVH AS _ChangeNumber ON ChangeNumber = _ChangeNumber.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN C_ProductBasicInfo AS _ProductInfo ON ProductForEdit = _ProductInfo.Product  -- association [0..1]
LEFT OUTER JOIN C_ProductESPP AS _ProductESPP ON Product = _ProductESPP.Product  -- association [0..1]
LEFT OUTER JOIN C_ProdSCMProductGroup AS _ProdSCMProductGroup ON Product = _ProdSCMProductGroup.Product  -- association [0..*]
LEFT OUTER JOIN I_UserDescription AS _CreatedByUserName ON CreatedByUser = _CreatedByUserName.UserID  -- association [0..1]
LEFT OUTER JOIN I_UserDescription AS _LastChangedByUserName ON LastChangedByUser = _LastChangedByUserName.UserID  -- association [0..1]
LEFT OUTER JOIN I_ManufacturerPartProfileText AS _ManufacturerPartProfileText ON ManufacturerPartProfile = _ManufacturerPartProfileText.ManufacturerPartProfile  -- association [0..*]
LEFT OUTER JOIN I_MaterialGroupPackMatText AS _MaterialGroupPackMatText ON PackagingMaterialGroup = _MaterialGroupPackMatText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN C_ProductBasicInfo AS _OwnInventoryManagedProduct ON OwnInventoryManagedProduct = _OwnInventoryManagedProduct.Product  -- association [0..1]
;