C_Productstore

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 C_Productstore.
-- 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: CPRDSTORE

CREATE VIEW C_Productstore AS
SELECT
  Store.Product AS Product,
  Store.Plant AS Plant,
  Store.PlantForEdit AS PlantForEdit,
  Store.ProfileCode AS ProfileCode,
  Store.ProfileValidityStartDate AS ProfileValidityStartDate,
  Store.PeriodType AS PeriodType,
  Store.FiscalYearVariant AS FiscalYearVariant,
  Store.ProfitCenter AS ProfitCenter,
  Store.IsMarkedForDeletion AS IsMarkedForDeletion,
  Store.IsBatchManagementRequired AS IsBatchManagementRequired,
  Store.SerialNumberProfile AS SerialNumberProfile,
  Store.IsNegativeStockAllowed AS IsNegativeStockAllowed,
  Store.ConfigurableProduct AS ConfigurableProduct,
  Store.ConfigurationSideEffect AS ConfigurationSideEffect,
  cast('' as boole_d) AS IsVariantConfigurationEnabled,
  cast('' as lfmon) AS FiscalMonthCurrentPeriod,
  cast('' as lfgja) AS FiscalYearCurrentPeriod,
  Store.ProductCFOPCategory AS ProductCFOPCategory,
  Store.SalesOrganization AS SalesOrganization,
  Store.DistributionChannel AS DistributionChannel,
  Store.PlantCategory AS PlantCategory,
  Store.ReferenceStore AS ReferenceStore,
  Store.IsReferenceStore AS IsReferenceStore,
  Store.GoodsIssueUnit AS GoodsIssueUnit,
  Store.ControllingArea AS ControllingArea,
  Store.StockDeterminationGroup AS StockDeterminationGroup,
  Store._ProductStatus AS _ProductStatus,
  Store._ProductStatusText AS _ProductStatusText
FROM I_ProductPlantWD AS Store
LEFT OUTER JOIN C_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN C_Productstorestoragelocation AS _StorageLocation ON Product = _StorageLocation.Product AND Plant = _StorageLocation.Plant  -- association [0..*]
LEFT OUTER JOIN C_Productstoreprocurment AS _PlantProcurement ON Product = _PlantProcurement.Product AND Plant = _PlantProcurement.Plant  -- association [0..1]
LEFT OUTER JOIN C_Productstoresales AS _PlantSales ON Product = _PlantSales.Product AND Plant = _PlantSales.Plant  -- association [0..1]
LEFT OUTER JOIN C_Productstoreqtmanagement AS _PlantQualityMgmt ON Product = _PlantQualityMgmt.Product AND Plant = _PlantQualityMgmt.Plant  -- association [0..1]
LEFT OUTER JOIN C_Productstoresupplyplanning AS _MaterialLotSizingProcedure ON Product = _MaterialLotSizingProcedure.Product AND Plant = _MaterialLotSizingProcedure.Plant  -- association [1..1]
LEFT OUTER JOIN C_Productstoreworkscheduling AS _GoodsMovementQuantity ON Product = _GoodsMovementQuantity.Product AND Plant = _GoodsMovementQuantity.Plant  -- association [0..1]
LEFT OUTER JOIN C_Productstorestorage AS _PlantStorage ON Product = _PlantStorage.Product AND Plant = _PlantStorage.Plant  -- association [0..1]
LEFT OUTER JOIN C_ProductStoreIntlTrade AS _ProdPlantInternationalTrade ON Product = _ProdPlantInternationalTrade.Product AND Plant = _ProdPlantInternationalTrade.Plant  -- association [0..1]
LEFT OUTER JOIN C_ProductStoreCosting AS _ProductPlantCosting ON Product = _ProductPlantCosting.Product AND Plant = _ProductPlantCosting.Plant  -- association [0..1]
LEFT OUTER JOIN C_ProductStoreForecast AS _ProductPlantForecast ON Product = _ProductPlantForecast.Product AND Plant = _ProductPlantForecast.Plant  -- association [0..1]
LEFT OUTER JOIN C_ProductStoreMRP AS _MRPAreaData ON Product = _MRPAreaData.Product AND Plant = _MRPAreaData.Plant  -- association [1..*]
LEFT OUTER JOIN C_ProdReplnmtRecipient AS _ProductReplnmtRecipient ON Product = _ProductReplnmtRecipient.Product AND Plant = _ProductReplnmtRecipient.Plant  -- association [0..1]
LEFT OUTER JOIN C_ProdStoreFcstParameters AS _ProdPlntFcstParameters ON Product = _ProdPlntFcstParameters.Product AND Plant = _ProdPlntFcstParameters.Plant  -- association [0..1]
LEFT OUTER JOIN C_ProdStorePurchaseTax AS _ProdPlantPurchaseTax ON Product = _ProdPlantPurchaseTax.Product AND Plant = _ProdPlantPurchaseTax.Plant  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrgstoreText ON SalesOrganization = _SalesOrgstoreText.SalesOrganization  -- association [1..*]
LEFT OUTER JOIN I_DistributionChannelText AS _DistributionChannelName ON DistributionChannel = _DistributionChannelName.DistributionChannel  -- association [0..*]
LEFT OUTER JOIN C_Srlnmbrasgprftexttemp AS _SerialNumberProfileText ON SerialNumberProfile = _SerialNumberProfileText.SerialNumberProfile  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterName ON ProfitCenter = _ProfitCenterName.ProfitCenter AND ControllingArea = _ProfitCenterName.ControllingArea  -- association [0..*]
LEFT OUTER JOIN C_Storevh AS _StoreValueHelp ON PlantForEdit = _StoreValueHelp.Store  -- association [0..1]
LEFT OUTER JOIN C_ProductBasicInfo AS _ConfigurableProduct ON ConfigurableProduct = _ConfigurableProduct.Product  -- association [0..1]
LEFT OUTER JOIN C_ProductStorePlanning AS _ProductPlantPlanning ON Product = _ProductPlantPlanning.Product AND Plant = _ProductPlantPlanning.Plant  -- association [0..1]
;