I_ProductPlant

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_ProductPlant.
-- 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: IPRDPLANT

CREATE VIEW I_ProductPlant AS
SELECT
  Plant.matnr AS Product,
  Plant.werks AS Plant,
  Plant.ekgrp AS PurchasingGroup,
  Plant.herkl AS CountryOfOrigin,
  Plant.herkr AS RegionOfOrigin,
  Plant.lgpro AS ProductionInvtryManagedLoc,
  Plant.mmsta AS ProfileCode,
  Plant.mmstd AS ProfileValidityStartDate,
  Plant.mtvfp AS AvailabilityCheckType,
  Plant.periv AS FiscalYearVariant,
  Plant.perkz AS PeriodType,
  Plant.prctr AS ProfitCenter,
  cast (Plant.stawn as stawn) AS Commodity,
  Plant.webaz AS GoodsReceiptDuration,
  Plant.pstat AS MaintenanceStatusName,
  Plant.lvorm AS IsMarkedForDeletion,
  Plant.dismm AS MRPType,
  Plant.dispo AS MRPResponsible,
  Plant.maabc AS ABCIndicator,
  Plant.bstmi AS MinimumLotSizeQuantity,
  Plant.bstma AS MaximumLotSizeQuantity,
  Plant.bstfe AS FixedLotSizeQuantity,
  Plant.steuc AS ConsumptionTaxCtrlCode,
  Plant.kzkup AS IsCoProduct,
  cast (Plant.stdpd as configurableproduct ) AS ProductIsConfigurable,
  Plant.stdpd AS ConfigurableProduct,
  Plant.eprio AS StockDeterminationGroup,
  Plant.umlmc AS StockInTransferQuantity,
  Plant.trame AS StockInTransitQuantity,
  cast (Plant.insmk as hasposttoinspectionstock ) AS HasPostToInspectionStock,
  Plant.xchpf AS IsBatchManagementRequired,
  Plant.sernp AS SerialNumberProfile,
  Plant.xmcng AS IsNegativeStockAllowed,
  Plant.bwesb AS GoodsReceiptBlockedStockQty,
  Plant.cons_procg AS HasConsignmentCtrl,
  Plant.lfgja AS FiscalYearCurrentPeriod,
  Plant.lfmon AS FiscalMonthCurrentPeriod,
  Plant.multiple_ekgrp AS IsPurgAcrossPurgGroup,
  Plant.xchar AS IsInternalBatchManaged,
  Plant.indus AS ProductCFOPCategory,
  Plant.excise_tax_rlvnce AS ProductIsExciseTaxRelevant,
  Plant.ueeto AS OverDelivToleranceLimit,
  Plant.beskz AS ProcurementType,
  Plant.sobsl AS SpecialProcurementType,
  Plant.sfcpf AS ProductionSchedulingProfile,
  Plant.fevor AS ProductionSupervisor,
  Plant.eisbe AS SafetyStockQuantity,
  Plant.ausme AS GoodsIssueUnit,
  Plant.bwscl AS SourceOfSupplyCategory,
  Plant.vrbmt AS ConsumptionReferenceProduct,
  Plant.vrbwk AS ConsumptionReferencePlant,
  Plant.vrbdt AS ConsumptionRefUsageEndDate,
  Plant.vrbfk AS ConsumptionQtyMultiplier,
  Plant.megru AS ProductUnitGroup,
  Plant.fprfm AS DistrCntrDistributionProfile,
  Plant.cons_procg AS ConsignmentControl,
  Plant.gi_pr_time AS GoodIssueProcessingDays,
  Plant.plifz AS PlannedDeliveryDurationInDays,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity,
  Plant.kzkri AS ProductIsCriticalPrt,
  Plant.loggr AS ProductLogisticsHandlingGroup,
  Plant.mfrgr AS MaterialFreightGroup,
  Plant.ucmat AS OriginalBatchReferenceMaterial,
  Plant.uchkz AS OriglBatchManagementIsRequired,
  Plant.cuobj AS ProductConfiguration,
  _Product.BaseUnit AS BaseUnit
FROM nsdm_e_marc 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_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_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_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_ProductPlantESPP AS _PlantESPP ON Product = _PlantESPP.Product AND Plant = _PlantESPP.Plant  -- association [0..1]
;