I_ProductPlantBasic

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_ProductPlantBasic.
-- 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: IPRDPLANTBASIC

CREATE VIEW I_ProductPlantBasic AS
SELECT
  Product,
  Plant,
  PurchasingGroup,
  CountryOfOrigin,
  RegionOfOrigin,
  ProductionInvtryManagedLoc,
  ProfileCode,
  ProfileValidityStartDate,
  AvailabilityCheckType,
  FiscalYearVariant,
  PeriodType,
  ProfitCenter,
  GoodsReceiptDuration,
  MaintenanceStatus AS MaintenanceStatusName,
  IsMarkedForDeletion,
  MRPType,
  MRPResponsible,
  ABCIndicator,
  MinimumLotSizeQuantity,
  MaximumLotSizeQuantity,
  FixedLotSizeQuantity,
  ConsumptionTaxCtrlCode,
  IsCoProduct,
  ConfigurableProduct,
  StockDeterminationGroup,
  HasPostToInspectionStock,
  IsBatchManagementRequired,
  SerialNumberProfile,
  IsNegativeStockAllowed,
  ConsignmentControl AS HasConsignmentCtrl,
  IsPurgAcrossPurgGroup,
  IsInternalBatchManaged,
  ProductCFOPCategory,
  ProductIsExciseTaxRelevant,
  OverDelivToleranceLimit,
  ProcurementType,
  ProcurementSubType AS SpecialProcurementType,
  ProductionSchedulingProfile,
  ProductionSupervisor,
  SafetyStockQuantity,
  GoodsIssueUnit,
  SourceOfSupplyCategory,
  ConsumptionReferenceProduct,
  ConsumptionReferencePlant,
  ConsumptionRefUsageEndDate,
  ConsumptionQtyMultiplier,
  ProductUnitGroup,
  DistrCntrDistributionProfile,
  ConsignmentControl,
  GoodIssueProcessingDays,
  PlannedDeliveryDurationInDays,
  ProductIsCriticalPrt,
  ProductLogisticsHandlingGroup,
  MaterialFreightGroup,
  OriginalBatchReferenceMaterial,
  OriglBatchManagementIsRequired,
  ProductConfiguration,
  ProductMinControlTemperature,
  ProductMaxControlTemperature,
  ProductControlTemperatureUnit,
  ValuationCategory,
  _Product.BaseUnit AS BaseUnit,
  ItemUniqueIdentifierIsRelevant,
  ItemUniqueIdentifierType,
  ExtAllocOfItmUnqIdtIsRelevant
FROM P_ProductPlantBasic AS Plant
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_MRPController AS _MRPController ON Plant = _MRPController.Plant AND MRPResponsible = _MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_ProductStatus AS _ProductStatus ON ProfileCode = _ProductStatus.Status  -- association [0..1]
LEFT OUTER JOIN I_ProductStatusText AS _ProductStatusText ON ProfileCode = _ProductStatusText.Status  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _GoodsIssueUnit ON GoodsIssueUnit = _GoodsIssueUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON GoodsIssueUnit = _UnitOfMeasureText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariantText AS _FiscalYearVariantDescription ON FiscalYearVariant = _FiscalYearVariantDescription.FiscalYearVariant  -- association [0..*]
LEFT OUTER JOIN I_Product AS _ConfigurableProduct ON ConfigurableProduct = _ConfigurableProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductDescription AS _ConfigurableProductName ON ConfigurableProduct = _ConfigurableProductName.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductDescription AS _Text ON Product = _Text.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductDescription_2 AS _ConfigurableProductName_2 ON ConfigurableProduct = _ConfigurableProductName_2.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductDescription_2 AS _Text_2 ON Product = _Text_2.Product  -- association [0..*]
LEFT OUTER JOIN I_Prodabclassfctn AS _ABCIndicator ON ABCIndicator = _ABCIndicator.MaterialABCClassification  -- association [0..1]
LEFT OUTER JOIN I_Prodabclassfctntxt AS _ABCIndicatorDesc ON ABCIndicator = _ABCIndicatorDesc.MaterialABCClassification  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Site AS _Site ON Plant = _Site.Site  -- association [0..1]
LEFT OUTER JOIN I_MRPType AS _MRPType ON MRPType = _MRPType.MRPType  -- association [0..1]
LEFT OUTER JOIN I_SourceOfSupplyCategory AS _SourceOfSupplyCategory ON SourceOfSupplyCategory = _SourceOfSupplyCategory.SourceOfSupplyCategory  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductWorkScheduling AS _GoodsMovementQuantity ON Product = _GoodsMovementQuantity.Product AND Plant = _GoodsMovementQuantity.Plant  -- association [0..1]
LEFT OUTER JOIN I_Productplantprocurement AS _PlantProcurement ON Product = _PlantProcurement.Product AND Plant = _PlantProcurement.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductPlantIntlTrd AS _ProdPlantInternationalTrade ON Product = _ProdPlantInternationalTrade.Product AND Plant = _ProdPlantInternationalTrade.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductPlantCosting AS _ProductPlantCosting ON Product = _ProductPlantCosting.Product AND Plant = _ProductPlantCosting.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductPlantForecast AS _ProductPlantForecast ON Product = _ProductPlantForecast.Product AND Plant = _ProductPlantForecast.Plant  -- association [0..1]
LEFT OUTER JOIN I_Productplantqtmanagement AS _PlantQualityMgmt ON Product = _PlantQualityMgmt.Product AND Plant = _PlantQualityMgmt.Plant  -- association [0..1]
LEFT OUTER JOIN I_Productplantsales AS _PlantSales ON Product = _PlantSales.Product AND Plant = _PlantSales.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductSupplyPlanning AS _MaterialLotSizingProcedure ON Product = _MaterialLotSizingProcedure.Product AND Plant = _MaterialLotSizingProcedure.Plant  -- association [1..1]
LEFT OUTER JOIN E_Productplant AS _ProductPlantExt ON Product = _ProductPlantExt.Product AND Plant = _ProductPlantExt.Plant  -- association [0..1]
LEFT OUTER JOIN I_MaterialStock AS _Stock ON Product = _Stock.Material AND Plant = _Stock.Plant  -- association [0..*]
LEFT OUTER JOIN I_CountryText AS _CountryOfOriginText ON CountryOfOrigin = _CountryOfOriginText.Country  -- association [0..*]
LEFT OUTER JOIN I_RegionText AS _RegionText ON CountryOfOrigin = _RegionText.Country  -- association [0..*]
LEFT OUTER JOIN I_ProductStorageLocation AS _ProductStorageLocation ON Product = _ProductStorageLocation.Product AND Plant = _ProductStorageLocation.Plant  -- association [0..*]
LEFT OUTER JOIN I_StockDeterminationGroup AS _StockDeterminationGroup ON Plant = _StockDeterminationGroup.Plant AND StockDeterminationGroup = _StockDeterminationGroup.StockDeterminationGroup  -- association [0..1]
LEFT OUTER JOIN I_StockDeterminationGroupText AS _StockDeterminationGroupT ON Plant = _StockDeterminationGroupT.Plant AND StockDeterminationGroup = _StockDeterminationGroupT.StockDeterminationGroup  -- association [0..*]
LEFT OUTER JOIN I_BR_CFOPCategory AS _ProductCFOPCategory ON ProductCFOPCategory = _ProductCFOPCategory.BR_CFOPCategory  -- association [0..1]
LEFT OUTER JOIN I_BR_CFOPCategoryText AS _CFOPDesc ON ProductCFOPCategory = _CFOPDesc.BR_CFOPCategory  -- association [0..*]
LEFT OUTER JOIN I_ProductConsumptionPeriod AS _PeriodType ON PeriodType = _PeriodType.PeriodType  -- association [0..1]
LEFT OUTER JOIN I_ProductConsumptionPeriodText AS _PeriodTypeText ON PeriodType = _PeriodTypeText.PeriodType  -- association [0..*]
LEFT OUTER JOIN I_ProductDistributionProfile AS _DistributionProfile ON DistrCntrDistributionProfile = _DistributionProfile.ProductDistributionProfile  -- association [0..1]
LEFT OUTER JOIN I_ProductDistributionProfileT AS _DistributionProfileText ON DistrCntrDistributionProfile = _DistributionProfileText.ProductDistributionProfile  -- association [0..*]
LEFT OUTER JOIN I_ProductPlantESPP AS _PlantESPP ON Product = _PlantESPP.Product AND Plant = _PlantESPP.Plant  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ProdControlTemperatureUnit ON ProductControlTemperatureUnit = _ProdControlTemperatureUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _ProdCtrlTemperatureUnitText ON ProductControlTemperatureUnit = _ProdCtrlTemperatureUnitText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_MaterialFreightGroup AS _ProductFreightGroup ON MaterialFreightGroup = _ProductFreightGroup.MaterialFreightGroup  -- association [0..1]
LEFT OUTER JOIN I_MaterialFreightGroupText AS _ProductFreightGroupText ON MaterialFreightGroup = _ProductFreightGroupText.MaterialFreightGroup  -- association [0..*]
;