A_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 A_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: APRODPLANT

CREATE VIEW A_ProductPlant AS
SELECT
  Product,
  Plant,
  PurchasingGroup,
  CountryOfOrigin,
  RegionOfOrigin,
  ProductionInvtryManagedLoc,
  ProfileCode,
  ProfileValidityStartDate,
  AvailabilityCheckType,
  FiscalYearVariant,
  PeriodType,
  ProfitCenter,
  Commodity,
  GoodsReceiptDuration,
  MaintenanceStatusName,
  IsMarkedForDeletion,
  MRPType,
  MRPResponsible,
  ABCIndicator,
  MinimumLotSizeQuantity,
  MaximumLotSizeQuantity,
  FixedLotSizeQuantity,
  ConsumptionTaxCtrlCode,
  IsCoProduct,
  ProductIsConfigurable,
  StockDeterminationGroup,
  StockInTransferQuantity,
  StockInTransitQuantity,
  HasPostToInspectionStock,
  IsBatchManagementRequired,
  SerialNumberProfile,
  IsNegativeStockAllowed,
  GoodsReceiptBlockedStockQty,
  HasConsignmentCtrl,
  FiscalYearCurrentPeriod,
  FiscalMonthCurrentPeriod,
  ProcurementType,
  IsInternalBatchManaged,
  ProductCFOPCategory,
  ProductIsExciseTaxRelevant,
  BaseUnit,
  ConfigurableProduct,
  GoodsIssueUnit,
  MaterialFreightGroup,
  OriginalBatchReferenceMaterial,
  OriglBatchManagementIsRequired,
  ProductIsCriticalPrt,
  ProductLogisticsHandlingGroup
FROM I_ProductPlant AS Plant
LEFT OUTER JOIN A_ProductStorageLocation AS _StorageLocation ON Product = _StorageLocation.Product AND Plant = _StorageLocation.Plant  -- association [0..*]
LEFT OUTER JOIN A_ProductPlantProcurement AS _ProductPlantProcurement ON Product = _ProductPlantProcurement.Product AND Plant = _ProductPlantProcurement.Plant  -- association [0..1]
LEFT OUTER JOIN A_ProductWorkScheduling AS _ProductWorkScheduling ON Product = _ProductWorkScheduling.Product AND Plant = _ProductWorkScheduling.Plant  -- association [0..1]
LEFT OUTER JOIN A_ProductSupplyPlanning AS _ProductSupplyPlanning ON Product = _ProductSupplyPlanning.Product AND Plant = _ProductSupplyPlanning.Plant  -- association [0..1]
LEFT OUTER JOIN A_ProductPlantIntlTrd AS _ProdPlantInternationalTrade ON Product = _ProdPlantInternationalTrade.Product AND Plant = _ProdPlantInternationalTrade.Plant  -- association [0..1]
LEFT OUTER JOIN A_ProductPlantCosting AS _ProductPlantCosting ON Product = _ProductPlantCosting.Product AND Plant = _ProductPlantCosting.Plant  -- association [0..1]
LEFT OUTER JOIN A_ProductPlantForecasting AS _ProductPlantForecast ON Product = _ProductPlantForecast.Product AND Plant = _ProductPlantForecast.Plant  -- association [0..1]
LEFT OUTER JOIN A_ProductPlantQualityMgmt AS _PlantQualityMgmt ON Product = _PlantQualityMgmt.Product AND Plant = _PlantQualityMgmt.Plant  -- association [0..1]
LEFT OUTER JOIN A_ProductPlantSales AS _PlantSales ON Product = _PlantSales.Product AND Plant = _PlantSales.Plant  -- association [0..1]
LEFT OUTER JOIN A_ProductPlantStorage AS _PlantStorage ON Product = _PlantStorage.Product AND Plant = _PlantStorage.Plant  -- association [0..1]
LEFT OUTER JOIN A_ProductPlantText AS _PlantText ON Product = _PlantText.Product AND Plant = _PlantText.Plant  -- association [0..1]
LEFT OUTER JOIN A_ProductPlantMRPArea AS _PlantMRPArea ON Product = _PlantMRPArea.Product AND Plant = _PlantMRPArea.Plant  -- association [0..*]
LEFT OUTER JOIN E_Productplant AS _ProductPlantExt ON Product = _ProductPlantExt.Product AND Plant = _ProductPlantExt.Plant  -- association [0..1]
LEFT OUTER JOIN A_Product AS _Product ON Product = _Product.Product  -- association [1..1]
;