C_BerthScheduling

DDL: C_BERTHSCHEDULING SQL: CBERTHSCHEDULING Type: view CONSUMPTION
44 Fields 1 Data Sources

Berth Scheduling Information

C_BerthScheduling is a Consumption CDS View that provides data about "Berth Scheduling Information" in SAP S/4HANA. It reads from 1 data source (I_BerthScheduling) and exposes 44 fields with key fields NominationKey, NominationItem.

Data Sources (1)

SourceAliasJoin Type
I_BerthScheduling I_BerthScheduling from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CBERTHSCHEDULING view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Berth Scheduling Information view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY NominationKey NominationKey Nomination key
KEY NominationItem NominationItem Nom. key item
NominationExtNumber NominationExtNumber
NominationScheduleType NominationScheduleType Sched.type
ScheduledBatchStartDateTime ScheduledBatchStartDateTime
PlannedStartDate PlannedStartDate Latest Planned Start
PlannedStartTime PlannedStartTime
ScheduledBatchEndDateTime ScheduledBatchEndDateTime
PlannedDischargeDate PlannedDischargeDate
NominationDischargeTime NominationDischargeTime
LocationDischargeId LocationDischargeId Location ID
BerthNumber BerthNumber Single-Character Flag
LocationId LocationId Location ID
NominationPegID NominationPegID Pegging Area
NominationPegType NominationPegType Peg type
NominationPeggingTypeUsage NominationPeggingTypeUsage Pegging Type Usage
ActualLayTime ActualLayTime Actual laytime
TripLayTimeUoM TripLayTimeUoM
PlannedLayTimeDuration PlannedLayTimeDuration Allowed laytime
DemurrageAmount DemurrageAmount Pot. demurrage
AlternativeCurrencyKey AlternativeCurrencyKey DemurrCurr
DemurrageAmountCrcy DemurrageAmountCrcy
ScheduledMaterial ScheduledMaterial Vehicle Model
MaterialDesc MaterialDesc Product Description
TransportationVehicle TransportationVehicle Vehicle Number
VehicleDescription VehicleDescription
NominationModeOfTransport NominationModeOfTransport
NominationTicketQuantity NominationTicketQuantity Scheduled Qty
NominationHeaderUom NominationHeaderUom SchedUoM
NominationBerthStartDate NominationBerthStartDate Brth. StDate
NominationBerthStartTime NominationBerthStartTime Brth. StTime
NominationBerthEndDate NominationBerthEndDate Brth.EndDate
NominationBerthEndTime NominationBerthEndTime Brth.EndTime
NominationTicketEventType NominationTicketEventType
TripEventDescription TripEventDescription
NominationEventChangedDate NominationEventChangedDate
NominationEventChangedTime NominationEventChangedTime
NominationEventChangedDateTime NominationEventChangedDateTime
NominationEvtPlndEndDateFrom NominationEvtPlndEndDateFrom
NominationEvtPlndEndTimeFrom NominationEvtPlndEndTimeFrom
NomEventPhaseType NomEventPhaseType
NomEventPhaseDesc NomEventPhaseDesc
TicketStatusColorCode TicketStatusColorCode
WeatherRedGradientColor WeatherRedGradientColor

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 C_BerthScheduling.
-- 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.
-- SQL view name: CBERTHSCHEDULING

CREATE VIEW C_BerthScheduling AS
SELECT
  NominationKey,
  NominationItem,
  NominationExtNumber,
  NominationScheduleType,
  ScheduledBatchStartDateTime,
  PlannedStartDate,
  PlannedStartTime,
  ScheduledBatchEndDateTime,
  PlannedDischargeDate,
  NominationDischargeTime,
  LocationDischargeId,
  BerthNumber,
  LocationId,
  NominationPegID,
  NominationPegType,
  NominationPeggingTypeUsage,
  ActualLayTime,
  TripLayTimeUoM,
  PlannedLayTimeDuration,
  DemurrageAmount,
  AlternativeCurrencyKey,
  DemurrageAmountCrcy,
  ScheduledMaterial,
  MaterialDesc,
  TransportationVehicle,
  VehicleDescription,
  NominationModeOfTransport,
  NominationTicketQuantity,
  NominationHeaderUom,
  NominationBerthStartDate,
  NominationBerthStartTime,
  NominationBerthEndDate,
  NominationBerthEndTime,
  NominationTicketEventType,
  TripEventDescription,
  NominationEventChangedDate,
  NominationEventChangedTime,
  NominationEventChangedDateTime,
  NominationEvtPlndEndDateFrom,
  NominationEvtPlndEndTimeFrom,
  NomEventPhaseType,
  NomEventPhaseDesc,
  TicketStatusColorCode,
  WeatherRedGradientColor
FROM I_BerthScheduling
;

Learn More