I_OIL_LocationTSWBasic

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_LocationTSWBasic.
-- 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_LocationTSWBasic AS
SELECT
  locid AS TSWLocationID,
  loctyp AS BusinessLocationType,
  locnam AS BusinessLocationName,
  knote AS TransportationConnectionPoint,
  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 BusinessLocTicketIsSelectable,
  rdact AS BusinessLocStkProjtnIsActive,
  maxrate AS MaxRatePerPeriodQuantity,
  minrate AS MinRatePerPeriodQuantity,
  operate AS OpgRatePerPeriodQuantity,
  rateuom AS BusinessLocationRateUnit,
  rateperd AS BusinessLocationRateTimeUnit,
  maxusage AS MaxVolumePerPeriodQuantity,
  minusage AS MinVolumePerPeriodQuantity,
  opeusage AS OpgVolumePerPeriodQuantity,
  usageuom AS BusinessLocationUsageUnit,
  usageperd AS BusinessLocationUsageTimeUnit,
  ss_rt AS BusinessLocComprnCalcRoutnType,
  bschflag AS BusinessLocHasBerthScheduling,
  bschperd AS BusinessLocBerthSchedgPeriod,
  bschpuom AS BusinessLocBerthSchedgPerdUnit,
  tankagg AS BizLocHasAggrgTankConstraints,
  pblnr AS BusinessLocationIdentifier,
  schema_busconf AS BusinessLocScmaBusinessConfVal,
  schema_techsch AS BusinessLocScmaTechSchedgVal,
  schema_alloc AS BusinessLocScmaMsmtAllocVal,
  external_ind AS BusinessLocIsExternalTerminal
FROM oijloc
LEFT OUTER JOIN I_OIL_LocationTypeTSWVH AS _LocationTypeTSW ON _LocationTypeTSW.BusinessLocationType = BusinessLocationType  -- association [1..1]
LEFT OUTER JOIN I_OIL_LocationTypeVH AS _LocationType ON _LocationType.BusinessLocationType = BusinessLocationType  -- association [1..1]
LEFT OUTER JOIN I_OIL_TransportConncnPointVH AS _TransportConncnPointVH ON _TransportConncnPointVH.ConnectPointID = TransportationConnectionPoint  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _RateUnitOfMeasure ON _RateUnitOfMeasure.UnitOfMeasure = BusinessLocationRateUnit  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TimeUnitOfMeasure ON _TimeUnitOfMeasure.UnitOfMeasure = BusinessLocationRateTimeUnit  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UsageUnitOfMeasure ON _UsageUnitOfMeasure.UnitOfMeasure = BusinessLocationUsageUnit  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UsageTimeUnitOfMeasure ON _UsageTimeUnitOfMeasure.UnitOfMeasure = BusinessLocationUsageTimeUnit  -- association [1..1]
LEFT OUTER JOIN I_OIL_ShipShoreCalcRoutineType AS _ShipShoreCalcRoutineType ON _ShipShoreCalcRoutineType.BusinessLocComprnCalcRoutnType = BusinessLocComprnCalcRoutnType  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BerthSchedgPerdUnit ON _BerthSchedgPerdUnit.UnitOfMeasure = BusinessLocBerthSchedgPerdUnit  -- association [1..1]
LEFT OUTER JOIN I_OIL_BusinessLocationBasic AS _Location ON _Location.BusinessLocationIdentifier = BusinessLocationIdentifier  -- association [0..1]
;