I_OIL_LocationBerthTankBasic

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_LocationBerthTankBasic.
-- 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_LocationBerthTankBasic AS
SELECT
  socnr AS AssignedStorObjCharcSgmtNumber,
  berid AS BerthIdentifier,
  lsyst AS LoadingSystem,
  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
FROM oijbersoc
LEFT OUTER JOIN I_OIL_StorageObjCharcSegment AS _StorageObjCharcSegment ON _StorageObjCharcSegment.StorObjectCharcSegmentNumber = AssignedStorObjCharcSgmtNumber  -- association [1..1]
LEFT OUTER JOIN I_OIL_Berth AS _Berth ON _Berth.BerthIdentifier = BerthIdentifier  -- association [1..1]
LEFT OUTER JOIN I_OIL_TransportSystem AS _TransportSystem ON _TransportSystem.TransportSystem = LoadingSystem  -- association [1..1]
;