I_OIL_LocationBerthTP

DDL: I_OIL_LOCATIONBERTHTP Type: view_entity TRANSACTIONAL
27 Fields 1 Data Sources

Location Berth - TP

I_OIL_LocationBerthTP is a Transactional CDS View that provides data about "Location Berth - TP" in SAP S/4HANA. It reads from 1 data source (R_OIL_LocationBerthTP) and exposes 27 fields with key fields BusinessLocationIdentifier, BerthIdentifier.

Data Sources (1)

SourceAliasJoin Type
R_OIL_LocationBerthTP R_OIL_LocationBerthTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Location Berth - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name OIL_BusinessLocationBerth view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY BusinessLocationIdentifier BusinessLocationIdentifier Location ID
KEY BerthIdentifier BerthIdentifier Berth Identifier
BusinessLocationBerthNumber BusinessLocationBerthNumber Berth Number
LocationBerthDescription LocationBerthDescription Description
BerthLighteringIsAllowed BerthLighteringIsAllowed Allow Lightering
Equipment Equipment Equipment check
CompatibilityGroupIdentifier CompatibilityGroupIdentifier Compatibility Grp ID
LocationBerthLengthQuantity LocationBerthLengthQuantity Length of Berth
LocBerthMaxDrftQty LocBerthMaxDrftQty Max. draft of berth
LocationBerthDepthQuantity LocationBerthDepthQuantity Berth depth at LAT
LocBerthMinShipDeadWgtQty LocBerthMinShipDeadWgtQty Min Ship Deadweight
BulkTransportationWeightUoM BulkTransportationWeightUoM Weight UoM
BulkTranspDimensionUnit BulkTranspDimensionUnit Dimension UoM
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
LastChangedByUser LastChangedByUser User Name
IsBlocked IsBlocked Boolean Variable (X = True, - = False, Space = Unknown)
IsDeleted IsDeleted TRUE
TicketIsSelectable TicketIsSelectable Flag to Select Tkt
_BulkTranspDimensionUnit _BulkTranspDimensionUnit
_BulkTransportationWeightUoM _BulkTransportationWeightUoM
_BusinessLocation _BusinessLocation
_Equipment _Equipment
_OIL_BulkShptVehCmptbltyGrpVH _OIL_BulkShptVehCmptbltyGrpVH

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_LocationBerthTP.
-- 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_LocationBerthTP AS
SELECT
  BusinessLocationIdentifier,
  BerthIdentifier,
  BusinessLocationBerthNumber,
  LocationBerthDescription,
  BerthLighteringIsAllowed,
  Equipment,
  CompatibilityGroupIdentifier,
  LocationBerthLengthQuantity,
  LocBerthMaxDrftQty,
  LocationBerthDepthQuantity,
  LocBerthMinShipDeadWgtQty,
  BulkTransportationWeightUoM,
  BulkTranspDimensionUnit,
  CreationDate,
  CreationTime,
  CreatedByUser,
  LastChangeDate,
  LastChangeTime,
  LastChangedByUser,
  IsBlocked,
  IsDeleted,
  TicketIsSelectable
FROM R_OIL_LocationBerthTP
;

Learn More