I_ProductPlantVH

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_ProductPlantVH.
-- 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: IPRDPLANTVH

CREATE VIEW I_ProductPlantVH 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.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
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_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..*]
;