I_OIL_LocMatlSourceDestBasic

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_OIL_LocMatlSourceDestBasic.
-- 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_OIL_LocMatlSourceDestBasic AS
SELECT
  locid AS TSWLocationID,
  matnr AS Material,
  rtsyst AS ReferenceTransportSystem,
  rlocid AS ReferenceLocationIdentifier,
  usageind AS LocationUsage,
  sdind AS LocationTerminal,
  docind AS ReferenceDocumentCode,
  sityp AS NominationScheduleType,
  quota AS QuotaInPercent,
  priority AS LocationTransferPriority,
  locbalind AS LocationHasBalance,
  erdat AS CreationDate,
  erzeit AS CreationTime,
  ernam AS CreatedByUser,
  aedat AS LastChangeDate,
  aezeit AS LastChangeTime,
  aenam AS LastChangedByUser,
  bloind AS EntityIsBlocked,
  delind AS EntityIsMarkedForDeletion,
  tktselect AS TicketIsSelectable
FROM oijsdloc
LEFT OUTER JOIN I_OIL_LocationTSWBasic AS _LocationTSW ON _LocationTSW.TSWLocationID = TSWLocationID  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON _Material.Material = Material  -- association [1..1]
LEFT OUTER JOIN I_OIL_TransportSystem AS _TransportSystem ON _TransportSystem.TransportSystem = ReferenceTransportSystem  -- association [1..1]
LEFT OUTER JOIN I_OIL_LocationTSWBasic AS _ReferenceLocationTSW ON _ReferenceLocationTSW.TSWLocationID = ReferenceLocationIdentifier  -- association [1..1]
LEFT OUTER JOIN I_OIL_LocationTerminalUsageVH AS _LocationTerminalUsage ON _LocationTerminalUsage.LocationUsage = LocationUsage  -- association [1..1]
LEFT OUTER JOIN I_OIL_LocationTerminalVH AS _LocationTerminal ON _LocationTerminal.LocationTerminal = LocationTerminal  -- association [1..1]
LEFT OUTER JOIN I_OIL_RefDocIndicatorVH AS _RefDocIndicator ON _RefDocIndicator.ReferenceDocumentCode = ReferenceDocumentCode  -- association [1..1]
LEFT OUTER JOIN I_NominationScheduleTypeVH AS _NominationScheduleType ON _NominationScheduleType.ScheduleType = NominationScheduleType  -- association [1..1]
LEFT OUTER JOIN I_OIL_LocTransferPriorityVH AS _LocTransferPriority ON _LocTransferPriority.LocationTransferPriority = LocationTransferPriority  -- association [1..1]
;