I_SupplyAssignmentBasic

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_SupplyAssignmentBasic.
-- 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_SupplyAssignmentBasic AS
SELECT
  Plant,
  Material,
  arun_status AS SupplyAssignmentStatus,
  salesdoc_num AS SalesDocument,
  purchdoc_num AS STONumber,
  reserv_num AS Reservation,
  salesdoc_item AS SalesDocumentItem,
  purchdoc_item AS STOItem,
  reserv_item AS ReservationItem,
  req_ind AS RequirementType,
  stock_source AS AssignedSupplyType,
  Batch,
  storage_location AS StorageLocation,
  purchord_num AS PurchasingDocument,
  prodord_num AS ProductionOrder,
  purchord_item AS PurchasingDocumentItem,
  prodord_item AS ProductionOrderItem,
  purchord_sch AS ScheduleLine,
  confirmation_no AS InboundDelivery,
  alloc_qty AS AssignedQuantityInBaseUnit,
  material_baseunit AS BaseUnit,
  requested_date AS RequestedDate,
  material_avail_date AS ProductAvailabilityDate,
  delivery_date_po AS SupplyDeliveryDate,
  creation_time AS CreationDateTime,
  changed_by AS LastChangeByUser,
  req_segment AS RequirementSegment,
  stk_segment AS StockSegment
FROM arun_bdbs
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_MaterialPlant AS _MaterialPlant ON Plant = _MaterialPlant.Plant AND Material = _MaterialPlant.Material  -- association [1..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON StorageLocation = _StorageLocation.StorageLocation AND Plant = _StorageLocation.Plant  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MaterialBaseUnitOfMeasure ON BaseUnit = _MaterialBaseUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentBasic AS _SalesDocumentBasic ON SalesDocument = _SalesDocumentBasic.SalesDocument  -- association [1..1]
LEFT OUTER JOIN I_StockTransportOrder AS _STONumberBasic ON STONumber = _STONumberBasic.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_ReservationHeader AS _ReservationHeaderBasic ON Reservation = _ReservationHeaderBasic.Reservation  -- association [1..1]
LEFT OUTER JOIN I_SalesDocumentItemBasic AS _SalesDocumentItemBasic ON SalesDocument = _SalesDocumentItemBasic.SalesDocument AND SalesDocumentItem = _SalesDocumentItemBasic.SalesDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_StockTransportOrderItem AS _STONumberItemBasic ON STONumber = _STONumberItemBasic.PurchaseOrder AND STOItem = _STONumberItemBasic.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN I_ReservationItem AS _ReservationItemBasic ON Reservation = _ReservationItemBasic.Reservation AND ReservationItem = _ReservationItemBasic.ReservationItem AND RequirementType = _ReservationItemBasic.RecordType  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocumentBasic ON PurchasingDocument = _PurchasingDocumentBasic.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItemBasic ON PurchasingDocument = _PurchasingDocumentItemBasic.PurchasingDocument AND PurchasingDocumentItem = _PurchasingDocumentItemBasic.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_PurgDocScheduleLine AS _PurchasingScheduleLineBasic ON PurchasingDocument = _PurchasingScheduleLineBasic.PurchasingDocument AND PurchasingDocumentItem = _PurchasingScheduleLineBasic.PurchasingDocumentItem AND ScheduleLine = _PurchasingScheduleLineBasic.ScheduleLine  -- association [0..1]
;