I_OIL_TransportSystem

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_TransportSystem.
-- 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_TransportSystem AS
SELECT
  tsyst AS TransportSystem,
  tsnam AS TransportSystemText,
  bookts AS TransportSystemHasBook,
  vsart AS TransptSystShipgTypeTrMode,
  vktra AS ModeOfTransport,
  shtype AS BulkShipmentType,
  vehid AS TransptSystDfltTranspVeh,
  tssuomv AS TransportSystemVolumeUnit,
  tssuomm AS TransportSystemWeightUnit,
  cycperd AS TransptSystCycleDurationQty,
  cycpuom AS TransportSystemDurationUnit,
  carrier AS TransportSystemCarrier,
  werk AS InTransitPlant,
  lgort AS InTransitStorageLocation,
  nommsk AS TransptSystNominationMaskText,
  shipper AS TransportSystemShipperCode,
  conltm AS TransptSystCarrLeadTmeQty,
  conluom AS TransptSystConfLeadTmeUnt,
  tplst AS TransportationPlnPoint,
  botol AS ToleranceOverRate,
  butol AS ToleranceUnderRate,
  botolabs AS TransptSystTolOvrQuantity,
  butolabs AS PhysStkAbsltQtyTolUndrQty,
  bultoluom AS TransportSystemToleranceUnit,
  unlimited AS UnlimitedOverdeliveryIsAllowed,
  balch AS TransptSystHasBalanceChecked,
  cliplgort AS TransptSystTmpStorLoc,
  shtyp AS TransportSystemShipmentType,
  erdat AS CreationDate,
  erzeit AS CreationTime,
  ernam AS CreatedByUser,
  aedat AS LastChangeDate,
  aezeit AS LastChangeTime,
  aenam AS LastChangedByUser,
  bloind AS IsBlocked,
  delind AS IsDeleted,
  tktselect AS TicketIsSelectable,
  kalsm AS TransptSystOutpDetnProced,
  kappl AS TransptSystOutpDetnProcedAppl,
  kschl AS TransptSystOutpDetnOutputType,
  maxrate AS MaxRatePerPeriodQuantity,
  minrate AS MinRatePerPeriodQuantity,
  operate AS OpgRatePerPeriodQuantity,
  rateuom AS RateUnit,
  rateperd AS RateTimeUnit,
  seqind AS TransptSystHasLocSqnc,
  maxusage AS MaxVolumePerPeriodQuantity,
  minusage AS MinVolumePerPeriodQuantity,
  usageuom AS UsageUnit,
  usageperd AS UsageTimeUnit,
  pipe_batch AS TransptSystHasPplineBatActv,
  vel_avg AS TransptSystAvgVelocityQty,
  vel_max AS TransptSystMaxVelocityQty,
  vel_min AS TransptSystMinVelocityQty,
  bustyp AS RetailNetworkBusinessType,
  vel_uom AS TransportSystemVelocityUnit,
  vel_uomt AS TransptSystVelocityTimeUnit,
  route_tolerance AS TransptSystRouteToleranceRatio,
  rdtsact AS StockProjectionIsActive,
  act_subitem AS TransptSystHasTktActualization
FROM oijts
LEFT OUTER JOIN I_OIL_BulkTransportVehicle AS _BulkTransportVehicle ON _BulkTransportVehicle.TransportationVehicle = TransptSystDfltTranspVeh  -- association [0..1]
LEFT OUTER JOIN I_BulkShipmentVehicleHeaderTxt AS _BulkShipmentVehicleHeaderTxt ON _BulkShipmentVehicleHeaderTxt.TransportationVehicle = TransptSystDfltTranspVeh  -- association [0..*]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = TransportSystemCarrier  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = InTransitPlant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON _StorageLocation.StorageLocation = InTransitStorageLocation AND _StorageLocation.Plant = InTransitPlant  -- association [0..1]
LEFT OUTER JOIN I_OIL_BusinessTypeVH AS _BusinessTypeVH ON _BusinessTypeVH.RetailNetworkBusinessType = RetailNetworkBusinessType  -- association [0..1]
LEFT OUTER JOIN I_ConditionApplication AS _ConditionApplication ON _ConditionApplication.ConditionApplication = TransptSystOutpDetnProcedAppl  -- association [0..1]
LEFT OUTER JOIN I_OIL_TranspSchedgPointVH AS _TranspSchedgPointVH ON _TranspSchedgPointVH.TransportationPlnPoint = TransportationPlnPoint  -- association [0..1]
LEFT OUTER JOIN I_OIL_ShipgTypeTransptModeVH AS _ShipgTypeTransptMode ON _ShipgTypeTransptMode.TransptSystShipgTypeTrMode = TransptSystShipgTypeTrMode  -- association [0..1]
LEFT OUTER JOIN I_OIL_ModesOfTransportVH AS _ModesOfTransport ON _ModesOfTransport.ModeOfTransport = ModeOfTransport  -- association [0..1]
LEFT OUTER JOIN I_OIL_BulkShipmentTypeVH AS _BulkShipmentType ON _BulkShipmentType.BulkShipmentType = BulkShipmentType  -- association [0..1]
LEFT OUTER JOIN I_BulkShipmentTypeText AS _BulkShipmentTypeTxt ON _BulkShipmentTypeTxt.BulkShipmentType = BulkShipmentType  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _VolumeUnitOfMeasure ON _VolumeUnitOfMeasure.UnitOfMeasure = TransportSystemVolumeUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WeightUnitOfMeasure ON _WeightUnitOfMeasure.UnitOfMeasure = TransportSystemWeightUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _DurationUnitOfMeasure ON _DurationUnitOfMeasure.UnitOfMeasure = TransportSystemDurationUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ToleranceUnitOfMeasure ON _ToleranceUnitOfMeasure.UnitOfMeasure = TransportSystemToleranceUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _RateUnitOfMeasure ON _RateUnitOfMeasure.UnitOfMeasure = RateUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _RateTimeUnitOfMeasure ON _RateTimeUnitOfMeasure.UnitOfMeasure = RateTimeUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VelocityUnitOfMeasure ON _VelocityUnitOfMeasure.UnitOfMeasure = TransportSystemVelocityUnit  -- association [0..1]
LEFT OUTER JOIN I_OIL_ShipmentTypeVH AS _TranspSystemShipmentType ON _TranspSystemShipmentType.TransportSystemShipmentType = TransportSystemShipmentType  -- association [0..1]
LEFT OUTER JOIN I_OIL_PartnerRoleBasic AS _PartnerRoleShipper ON _PartnerRoleShipper.TransportSystem = TransportSystem AND _PartnerRoleShipper.Supplier = TransportSystemShipperCode  -- association [0..1]
;