I_MRPTransferDemand

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_MRPTransferDemand.
-- 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.

CREATE VIEW I_MRPTransferDemand AS
SELECT
  CacheMaterial.MRPPlant AS MRPPlant,
  CacheMaterial.MRPArea AS MRPArea,
  CacheMaterial.Material AS Material,
  MRPPlanningSegment.MRPPlanningSegment AS MRPPlanningSegment,
  cast( MRPPlanningSegment.MRPPlanningSegmentType as plaab ) AS MRPPlanningSegmentType,
  MRPPlanningSegment.MaterialShortageProfile AS MaterialShortageProfile,
  CacheItem.NumberOfShortages AS MaterialShortageProfileCount,
  CacheItem.MRPElement AS MRPElement,
  CacheItem.MRPElementItem AS MRPElementItem,
  CacheItem.MRPElementScheduleLine AS MRPElementScheduleLine,
  CacheItem.MRPElementCategory AS MRPElementCategory,
  MRPPlanningSegment.PlanningSegmentDocument AS PlanningSegmentDocument,
  MRPPlanningSegment.PlanningSegmentDocumentItem AS PlanningSegmentDocumentItem,
  CacheMaterial.FactoryCalendar AS FactoryCalendar,
  CacheMaterial.MaterialName AS MaterialName,
  CacheMaterial.MaterialSafetyStockQty AS MaterialSafetyStockQty,
  CacheMaterial.MRPController AS MRPController,
  CacheMaterial.MaterialProcurementCategory AS MaterialProcurementCategory,
  CacheMaterial.MaterialBaseUnit AS MaterialBaseUnit,
  Uom.UnitOfMeasureNumberOfDecimals AS UnitOfMeasureNumberOfDecimals,
  Uom.UnitOfMeasureDspNmbrOfDcmls AS UnitOfMeasureDspNmbrOfDcmls,
  CacheMaterial.MaterialReplnmtLeadDurnEndDate AS MaterialReplnmtLeadDurnEndDate,
  CacheMaterial.TotalReplnmtLeadDurnEndDate AS TotalReplnmtLeadDurnEndDate,
  CacheMaterial.ManualPlanningHorizonEndDate AS ManualPlanningHorizonEndDate,
  CacheMaterial.MRPSafetyDurationEndDate AS MRPSafetyDurationEndDate,
  CacheMaterial.ProductionSupervisor AS ProductionSupervisor,
  CacheItem.Customer AS Customer,
  CacheItem.MRPElementAvailyOrRqmtDate AS MRPElementAvailyOrRqmtDate,
  CacheMaterial.MRPType AS MRPType,
  CacheItem.MRPElementOpenQuantity AS MRPElementOpenQuantity,
  CacheItem.SourceMRPElementCategory AS SourceMRPElementCategory,
  CacheItem.SourceMRPElement AS SourceMRPElement,
  CacheItem.SourceMRPElementItem AS SourceMRPElementItem,
  CacheItem.MRPElementUncoveredQuantity AS MRPElementUncoveredQuantity,
  CacheItem.MRPElementDelayedQuantity AS MRPElementDelayedQuantity,
  CacheItem.MRPElementTypeImportance AS MRPElementTypeImportance,
  CacheItem.MaximumDelayDate AS MaximumDelayDate,
  CacheItem.MaximumDelayInDays AS MaximumDelayInDays,
  CacheItem.MaximumDelayInWorkdays AS MaximumDelayInWorkdays,
  CacheItem.ProcurementProgress AS ProcurementProgress,
  CacheItem.StorageLocation AS StorageLocation,
  CacheItem.IssuingOrReceivingPlant AS IssuingOrReceivingPlant,
  PDScheduleLine.LoadingDate AS LoadingDate,
  MRPPlantCurrency.CompanyCurrency AS CompanyCurrency,
  MRPPlantCurrency.Decimals AS CurrencyDecimals,
  cast('2' as mrpdemandtype) AS MRPDemandType,
  cast( PurchasingDocument.PurchasingDocumentCategory as vbtypl ) AS MRPOrderCategory,
  PurchasingDocument.PurchasingDocumentType AS OrderType,
  PurchasingDocument.CreationDate AS OrderCreationDate,
  PurchasingDocumentItem.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  PurchasingDocumentItem.PartialDeliveryIsAllowed AS PartialDeliveryIsAllowed,
  PurchasingDocumentItem.NetAmount AS NetValueInDocCurrency,
  PurchasingDocument.DocumentCurrency AS DocumentCurrency,
  PDScheduleLine.ScheduleLineOrderQuantity AS OrderQuantity,
  PDScheduleLine.GoodsIssueDate AS RequestedGoodsIssueDate,
  PDScheduleLine.LoadingDate AS RequestedLoadingDate,
  PDScheduleLine.ScheduleLineDeliveryDate AS RequestedDeliveryDate,
  coalesce(PDShipping.DeliveryPriority, '00') AS DeliveryPriority,
  coalesce(PDShipping.SalesOrganization, '') AS SalesOrganization,
  coalesce(PDShipping.DistributionChannel, '') AS DistributionChannel,
  coalesce(PDShipping.OrganizationDivision, '') AS Division,
  _MRPMaterial.LotSizingProcedure AS LotSizingProcedure,
  _MRPMaterial.MaterialLotSizingProcedureName AS MaterialLotSizingProcedureName
FROM I_CacheMaterial AS CacheMaterial
INNER JOIN I_MRPAreaOfResponsibility AS _AreaOfResponsibility ON /* join condition not captured in parsed metadata */
INNER JOIN I_MRPPlanningSegment AS MRPPlanningSegment ON /* join condition not captured in parsed metadata */
INNER JOIN I_CacheSupplyDemandItem AS CacheItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurchasingDocumentItem AS PurchasingDocumentItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurgDocScheduleLine AS PDScheduleLine ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Plant AS _Plant ON IssuingOrReceivingPlant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_MRPMaterial AS _MRPMaterial ON MRPPlant = _MRPMaterial.MRPPlant AND Material = _MRPMaterial.Material AND MRPArea = _MRPMaterial.MRPArea  -- association [1..1]
;