I_ProductWD

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_ProductWD.
-- 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: IPRODUCTWD

CREATE VIEW I_ProductWD AS
SELECT
  Product.Product AS Product,
  Product.Product AS ProductForEdit,
  Product.ProductType AS ProductType,
  Product.CrossPlantStatus AS CrossPlantStatus,
  Product.CrossPlantStatusValidityDate AS CrossPlantStatusValidityDate,
  Product.CreationDate AS CreationDate,
  Product.CreationTime AS CreationTime,
  Product.CreationDateTime AS CreationDateTime,
  Product.CreatedByUser AS CreatedByUser,
  Product.LastChangeDate AS LastChangeDate,
  Product.LastChangeTime AS LastChangeTime,
  Product.LastChangeDateTime AS LastChangeDateTime,
  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._ProductRetail.CountryOfOrigin AS CountryOfOrigin,
  Product.CompetitorID AS CompetitorID,
  Product.ProductGroup AS ProductGroup,
  Product.BaseUnit AS BaseUnit,
  Product.ItemCategoryGroup AS ItemCategoryGroup,
  Product.ProductHierarchy AS ProductHierarchy,
  Product.Division AS Division,
  Product.BasicMaterial AS BasicMaterial,
  Product.VolumeUnit AS VolumeUnit,
  Product.MaterialVolume AS MaterialVolume,
  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.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.HasVariableTareWeight AS HasVariableTareWeight,
  Product.MaximumPackagingLength AS MaximumPackagingLength,
  Product.MaximumPackagingWidth AS MaximumPackagingWidth,
  Product.MaximumPackagingHeight AS MaximumPackagingHeight,
  Product.MaximumCapacity AS MaximumCapacity,
  Product.OvercapacityTolerance AS OvercapacityTolerance,
  Product.UnitForMaxPackagingDimensions AS UnitForMaxPackagingDimensions,
  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._ProductRetail.ServiceAgreement AS ServiceAgreement,
  Product._ProductRetail.ConsumptionValueCategory AS ConsumptionValueCategory,
  Product._ProductRetail.GoodsIssueUnit AS GoodsIssueUnit,
  Product._ProductRetail.RegionOfOrigin AS RegionOfOrigin,
  Product._ProductRetail.AssortmentGrade AS AssortmentGrade,
  Product._ProductRetail.ProdExtAssortmentPriority AS ProdExtAssortmentPriority,
  Product._ProductRetail.SalesUnit AS SalesUnit,
  Product._ProductRetail.ValuationClass AS ValuationClass,
  Product._ProductRetail.ValuationMargin AS ValuationMargin,
  Product._ProductRetail.DistrCntrSaleEndDate AS DistrCntrSaleEndDate,
  cast('' as vchclf_side_effect_data) AS ClassificationSideEffect,
  cast('' as vchclf_side_effect_data) AS ConfigurationSideEffect,
  cast('' as referenceproduct) AS ReferenceProduct,
  _DescriptionText.ProductDescription AS ProductDescription,
  Product.AuthorizationGroup AS AuthorizationGroup,
  Product.HasEmptiesBOM AS HasEmptiesBOM,
  Product.IsChemicalComplianceRelevant AS IsChemicalComplianceRelevant,
  Product.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  Product._BaseUnitOfMeasure AS _BaseUnitOfMeasure,
  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.VarblPurOrdUnitIsActive AS VarblPurOrdUnitIsActive,
  Product.ProductIsLocked AS ProductIsLocked,
  _ProductRetail._GoodsIssueUnit AS _GoodsIssueUnit,
  _ProductRetail._GoodsIssueText AS _GoodsIssueText,
  _ProductRetail._ConsumptionValueCategory AS _ConsumptionValueCategory,
  _ProductRetail._ConsumptionValueCategoryText AS _ConsumptionValueCategoryText,
  Product._ChemicalComplianceRelevant AS _ChemicalComplianceRelevant,
  Product._ChemicalComplianceRlvtText AS _ChemicalComplianceRlvtText,
  Product._ItemCategoryGroup AS _ItemCategoryGroup,
  Product._ItemCategoryGroupText AS _ItemCategoryGroupText,
  _ProductRetail._SalesUnit AS _SalesUnit,
  _ProductRetail._SalesUnitText AS _SalesUnitText,
  _ProductRetail._ProductServiceAgreement AS _ProductServiceAgreement,
  _ProductRetail._ProductServiceAgreementT AS _ProductServiceAgreementT,
  _ProductRetail._CountryText AS _CountryText,
  _ProductRetail._RegionOfOrigin AS _RegionOfOrigin,
  _ProductRetail._CountryOfOrigin AS _CountryOfOrigin,
  _ProductRetail._RegionText AS _RegionText,
  _ProductRetail._ValuationClass AS _ValuationClass,
  _ProductRetail._ValuationClassText AS _ValuationClassText
FROM I_Product AS Product
LEFT OUTER JOIN E_Product AS _ActiveProductExt ON Product = _ActiveProductExt.Product  -- association [0..1]
LEFT OUTER JOIN E_Product AS _DraftProductExt ON Product = _DraftProductExt.Product  -- association [0..1]
LEFT OUTER JOIN E_ProductRetail AS _ProductRetailExt ON Product = _ProductRetailExt.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductDescriptionWD AS _Description ON Product = _Description.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductWD AS _ConfProductVariant ON Product = _ConfProductVariant.CrossPlantConfigurableProduct  -- association [0..*]
LEFT OUTER JOIN I_ProductDescriptionWD AS _DescriptionText ON Product = _DescriptionText.Product AND _DescriptionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductPlantWD AS _Plant ON Product = _Plant.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductPlantWD AS _Store ON Product = _Store.Product AND _Store.PlantCategory = 'A'  -- association [0..*]
LEFT OUTER JOIN I_ProductPlantWD AS _DistributionCenter ON Product = _DistributionCenter.Product AND _DistributionCenter.PlantCategory = 'B'  -- association [0..*]
LEFT OUTER JOIN I_ProductSalesWD AS _ProductSales ON Product = _ProductSales.Product  -- association [0..1]
LEFT OUTER JOIN I_Productprocurementwd AS _ProductProcurement ON Product = _ProductProcurement.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductStorageWD AS _ProductStorage ON Product = _ProductStorage.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductQMwd AS _ProductQualityMgmt ON Product = _ProductQualityMgmt.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductSalesDeliveryWD AS _SalesDelivery ON Product = _SalesDelivery.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductUnitsOfMeasureWD AS _UnitOfMeasure ON Product = _UnitOfMeasure.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductValuationWD AS _Valuation ON Product = _Valuation.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductSalesTaxWD AS _ProductSalesTax ON Product = _ProductSalesTax.Product  -- association [0..*]
LEFT OUTER JOIN I_Productscmwd AS _SupplyChainManagement ON Product = _SupplyChainManagement.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductVariantMatrixWD AS _ProductVariant ON Product = _ProductVariant.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductSeasonsTP AS _ProductSeasons ON Product = _ProductSeasons.Product  -- association [0..*]
LEFT OUTER JOIN I_ProdEWMWarehouseTP AS _Warehouse ON Product = _Warehouse.Product  -- association [0..*]
LEFT OUTER JOIN I_BillOfMaterialTP AS _ProductBOM ON Product = _ProductBOM.Material  -- association [0..*]
LEFT OUTER JOIN I_ProductReplenishmentTP AS _ProductReplenishment ON Product = _ProductReplenishment.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductESPPTP AS _ProductESPP ON Product = _ProductESPP.Product  -- association [0..1]
LEFT OUTER JOIN I_ProdSCMProductGroupTP AS _ProdSCMProductGroup ON Product = _ProdSCMProductGroup.Product  -- association [0..*]
;