C_Oij06_Myeventss1_Main

DDL: C_OIJ06_MYEVENTSS1_MAIN SQL: COIJ06EVMAIN Type: view CONSUMPTION
71 Fields 1 Data Sources 2 Associations

Mass Change Events

C_Oij06_Myeventss1_Main is a Consumption CDS View that provides data about "Mass Change Events" in SAP S/4HANA. It reads from 1 data source (I_Oij06_Myeventss1_Main) and exposes 71 fields with key fields NominationDoc, NominationDocItem, NominationEventNumber. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_Oij06_Myeventss1_Main I_Oij06_Myeventss1_Main from

Associations (2)

CardinalityTargetAliasCondition
[1..*] C_Oij06_Myeventss1_Object _Events _Events.NominationDoc = $projection.NominationDoc and _Events.NominationDocItem = $projection.NominationDocItem
[1..1] C_Oij06_Myeventss1_Nomitem _Item _Item.NominationDoc = $projection.NominationDoc and _Item.NominationDocItem = $projection.NominationDocItem

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName COIJ06EVMAIN view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Mass Change Events view
VDM.viewType #CONSUMPTION view
Search.searchable false view
UI.headerInfo.typeName Nomination Key view
UI.headerInfo.title.value NominationDoc view
UI.headerInfo.description.value NominationDocItem view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view

Fields (71)

KeyFieldSource TableSource FieldDescription
KEY NominationDoc NominationDoc Nomination Key
KEY NominationDocItem NominationDocItem Nomination Item
KEY NominationEventNumber NominationEventNumber Nomination Event Number
NominationEventSequence NominationEventSequence Nomination Event Sequence
NominationExtNumber NominationExtNumber Nomination Number
NominationEventType NominationEventType Nomination Event Type
NominationEventChangedDate NominationEventChangedDate Nomination Event Change Date
NominationEventChangedTime NominationEventChangedTime Nomination Event Change Time
NominationEventChangedDateTime NominationEventChangedDateTime Nomination Event Change Date and Time
EventCreationTime EventCreationTime Event Creation Time
EventCreationDate EventCreationDate Event Creation Date
EventCreationDateTime EventCreationDateTime Event Creation Date and Time
PlannedStartDateFrom PlannedStartDateFrom Planned Start Date From
PlannedStartTimeFrom PlannedStartTimeFrom Planned Start Time From
PlannedStartFromDateTime PlannedStartFromDateTime Planned Start Date and Time From
PlannedStartDateTo PlannedStartDateTo Planned Start Date To
PlannedStartTimeTo PlannedStartTimeTo Planned Start Time To
PlannedStartToDateTime PlannedStartToDateTime Planned Start Date and Time To
PlannedEndDateFrom PlannedEndDateFrom Planned End Date From
PlannedEndTimeFrom PlannedEndTimeFrom Planned End Time From
PlannedEndFromDateTime PlannedEndFromDateTime Planned End Date and Time From
PlannedEndDateTo PlannedEndDateTo Planned End Date To
PlannedEndToDateTime PlannedEndToDateTime Planned End Date and Time To
LocationId LocationId Location
TransportSystem TransportSystem Transport System
MaterialDesc MaterialDesc Material Description
ScheduledMaterial ScheduledMaterial Schedule Material
NominationScheduleDate NominationScheduleDate Nomination Schedule Date
EventIsUpdated EventIsUpdated Event Updation Indicator
OriginCityCode OriginCityCode Origin City Code
DestinationCityCode DestinationCityCode Destination City Code
NominationItemStatus NominationItemStatus Nomination Item Status
SchedulingType SchedulingType Schedule Type
MaterialMovementType MaterialMovementType Material Movement Type
NominationEventLogUpdate Nomination Event Log Update
PlannedEndTimeTo PlannedEndTimeTo Planned End Time To
ActualStartDateFrom ActualStartDateFrom Actual Start Date From
ActualStartTimeFrom ActualStartTimeFrom Actual Start Time From
ActualStartFromDateTime ActualStartFromDateTime Actual Start Date and Time From
ActualStartDateTo ActualStartDateTo Actual Start Date To
ActualStartTimeTo ActualStartTimeTo Actual Start Time To
ActualStartToDateTime ActualStartToDateTime Actual Start Date and Time To
ActualEndDateFrom ActualEndDateFrom Actual End Date From
ActualEndTimeFrom ActualEndTimeFrom Actual End Time From
ActualEndFromDateTime ActualEndFromDateTime Actual End Date and Time From
ActualEndDateTo ActualEndDateTo Actual End Date To
ActualEndTimeTo ActualEndTimeTo Actual End Time To
ActualEndToDateTime ActualEndToDateTime Actual End Date and Time To
ScheduledQuantity ScheduledQuantity Schedule Quantity
NominationExtDocItem NominationExtDocItem Nomination Extended Item
ScheduledQuantityUnit ScheduledQuantityUnit Schedule Quantity Unit
NominationEventComments Nomination Event Comments
NominationDocIsBlocked NominationDocIsBlocked Nomination Key Indicator
LocationName LocationName Location Description
LocationTimeZone LocationTimeZone Location Time Zone
_Events _Events
_Item _Item
_LocationIdVH _LocationIdVH
_NominationTransptSystVH _NominationTransptSystVH
_ScheduledMaterialVH _ScheduledMaterialVH
_NominationExtNumberVH _NominationExtNumberVH
_NominationItemVH _NominationItemVH
_TransportSystem _TransportSystem
_DestCityCode _DestCityCode
_OriginCityCode _OriginCityCode
_NominationItemStatus _NominationItemStatus
_ScheduledUnitOfMeasure _ScheduledUnitOfMeasure
_BulkShipmentEventTypeText _BulkShipmentEventTypeText
_NominationScheduledType _NominationScheduledType
_NominationKeyVH _NominationKeyVH
_ScheduledMaterialDescVH _ScheduledMaterialDescVH

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_Oij06_Myeventss1_Main.
-- 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: COIJ06EVMAIN

CREATE VIEW C_Oij06_Myeventss1_Main AS
SELECT
  NominationDoc,
  NominationDocItem,
  NominationEventNumber,
  NominationEventSequence,
  NominationExtNumber,
  NominationEventType,
  NominationEventChangedDate,
  NominationEventChangedTime,
  NominationEventChangedDateTime,
  EventCreationTime,
  EventCreationDate,
  EventCreationDateTime,
  PlannedStartDateFrom,
  PlannedStartTimeFrom,
  PlannedStartFromDateTime,
  PlannedStartDateTo,
  PlannedStartTimeTo,
  PlannedStartToDateTime,
  PlannedEndDateFrom,
  PlannedEndTimeFrom,
  PlannedEndFromDateTime,
  PlannedEndDateTo,
  PlannedEndToDateTime,
  LocationId,
  TransportSystem,
  MaterialDesc,
  ScheduledMaterial,
  NominationScheduleDate,
  EventIsUpdated,
  OriginCityCode,
  DestinationCityCode,
  NominationItemStatus,
  SchedulingType,
  MaterialMovementType,
  cast( 0 as tzntstmps) AS NominationEventLogUpdate,
  PlannedEndTimeTo,
  ActualStartDateFrom,
  ActualStartTimeFrom,
  ActualStartFromDateTime,
  ActualStartDateTo,
  ActualStartTimeTo,
  ActualStartToDateTime,
  ActualEndDateFrom,
  ActualEndTimeFrom,
  ActualEndFromDateTime,
  ActualEndDateTo,
  ActualEndTimeTo,
  ActualEndToDateTime,
  ScheduledQuantity,
  NominationExtDocItem,
  ScheduledQuantityUnit,
  cast('' as char200) AS NominationEventComments,
  NominationDocIsBlocked,
  LocationName,
  LocationTimeZone
FROM I_Oij06_Myeventss1_Main
LEFT OUTER JOIN C_Oij06_Myeventss1_Object AS _Events ON _Events.NominationDoc = NominationDoc AND _Events.NominationDocItem = NominationDocItem  -- association [1..*]
LEFT OUTER JOIN C_Oij06_Myeventss1_Nomitem AS _Item ON _Item.NominationDoc = NominationDoc AND _Item.NominationDocItem = NominationDocItem  -- association [1..1]
;

Learn More