I_VisualSimulation
IPW Simulation in Visualization
I_VisualSimulation is a Composite CDS View that provides data about "IPW Simulation in Visualization" in SAP S/4HANA. It reads from 22 data sources and exposes 171 fields with key fields NominationDoc, NominationDocItem. It has 1 association to related views.
Data Sources (22)
| Source | Alias | Join Type |
|---|---|---|
| mara | a | left_outer |
| I_Customer | b | left_outer |
| adrc | c | left_outer |
| I_Supplier | d | left_outer |
| adrc | e | left_outer |
| I_Oij06_Myeventss1_Main | ev | left_outer |
| I_OilLocMatlPlanning | f | left_outer |
| v_oigvt | j | left_outer |
| oij07_mot_eve_v | k | left_outer |
| I_VisualLocations | loc | left_outer |
| I_MaterialDescription | m | left_outer |
| I_MaterialDescription | m_d | left_outer |
| I_MaterialDescription | m_l | left_outer |
| I_NominationModeOfTranspVH | nh | left_outer |
| v_oijpeg | o | left_outer |
| v_oij_pegtyp | p | left_outer |
| I_Oij06_Recent_Event | re | left_outer |
| v_oijrra | rt | left_outer |
| voij_sched | sim | from |
| v_oij_shipments | sp | left_outer |
| v_oijtsloc | ts | left_outer |
| v_visu_usrva | uv | left_outer |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_VisualLocationTimeZone | _VisualLocationTimeZone | $projection.LocationId = _VisualLocationTimeZone.TSWLocationID |
Annotations (12)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IVISUSIM | view | |
| EndUserText.label | IPW Simulation in Visualization | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| VDM.viewType | #COMPOSITE | view | |
| Search.searchable | false | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ClientHandling.type | #INHERITED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AccessControl.personalData.blocking | #REQUIRED | view |
Fields (171)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | NominationDoc | voij_sched | nomtk | |
| KEY | NominationDocItem | voij_sched | nomit | |
| NominationDocDischargeItem | ||||
| NominationExtNumber | voij_sched | nomnr | ||
| NominationType | voij_sched | nomtyp | ||
| NominationHeaderStatus | voij_sched | nomst | ||
| LocationId | voij_sched | locid | ||
| LocationName | I_VisualLocations | BusinessEntityLocationName | ||
| LocationDischargeId | ||||
| DestinationLocationName | ||||
| CompanyCode | I_VisualLocations | CompanyCode | ||
| ScheduledMaterial | voij_sched | s_matnr_i | ||
| ScheduledQuantity | voij_sched | menge | ||
| ScheduledQuantityUnit | voij_sched | unit_i | ||
| DischargeSchedQuantity | ||||
| DischargeQuantityUnit | ||||
| IsReferenceDocument | voij_sched | docind | ||
| NominationReferenceDocument | voij_sched | docnr | ||
| NominationPipelineCycleID | voij_sched | cycle | ||
| NominationShipper | voij_sched | nmshipper | ||
| NominationCarrier | voij_sched | nmcarrier | ||
| CarrierName | ||||
| InTransitPlant | voij_sched | nmwerk | ||
| InTransitStorageLocation | voij_sched | nmlgort | ||
| VehicleId | voij_sched | nmvehicle | ||
| VehicleDescription | ||||
| TransportSystem | voij_sched | tsyst | ||
| NominationLastHeaderActionDate | voij_sched | sentdat | ||
| TransportationPlanningPoint | voij_sched | nmtplst | ||
| ShippingRoute | voij_sched | route | ||
| IsBookedTransportSystem | voij_sched | bookts | ||
| NominationEventDefaultGroup | voij_sched | ev_group | ||
| NominationHeaderUom | voij_sched | unit | ||
| BulkShipmentType | voij_sched | nmshtype | ||
| NominationModeOfTransport | voij_sched | vktra | ||
| ModeOfTransportText | I_NominationModeOfTranspVH | ModeOfTransportDesc | ||
| BusinessType | voij_sched | bustyp | ||
| VehicleIdentifier | voij_sched | nmvessel | ||
| NominationChangedDate | voij_sched | aedat | ||
| NominationCreationDate | voij_sched | erdat | ||
| NominationCreationTime | voij_sched | erzeit | ||
| NominationCreatedByUser | voij_sched | ernam | ||
| NominationIsBlocked | voij_sched | bloind | ||
| ContractPartner | voij_sched | conpat | ||
| ConsigneePartner | voij_sched | cons | ||
| NominationIsMarkedForDeletion | voij_sched | delind | ||
| NominationReferenceDocItem | voij_sched | docitm | ||
| NominationReferenceDocType | voij_sched | doctyp | ||
| IsImportExportPartner | voij_sched | flag_imex | ||
| BatchOriginLocation | voij_sched | charg_o | ||
| BatchDestinationLocation | voij_sched | charg_d | ||
| NominationScheduleDate | voij_sched | idate | ||
| ImportExportPartner | voij_sched | impoexpo | ||
| NominationIsIncomplete | voij_sched | incomplete_flag | ||
| NominationInspector | voij_sched | inspe | ||
| NominationItemStatus | voij_sched | istat | ||
| NominationItemSubStatus | voij_sched | isubstat | ||
| LoadDemandMaterialId | voij_sched | matnr_i | ||
| DischargeDemandMaterialId | voij_sched | matnr_i | ||
| LocationPartner | voij_sched | partnr | ||
| LocationPlant | ||||
| NominationScheduleType | voij_sched | sityp | ||
| ValuationType | voij_sched | owner | ||
| ValuationTypeDestination | voij_sched | valuationtype_d | ||
| ValuationTypeOrigin | voij_sched | valuationtype_o | ||
| IsNominationWorklistEntry | voij_sched | worklist_i | ||
| ActualScheduledQuantity | voij_sched | actualqty | ||
| ActualScheduledQuantityUnit | voij_sched | actualuom | ||
| ActualDischargeQuantity | ||||
| ActualDischargeQuantityUnit | ||||
| NominationItemIsComplete | voij_sched | ilock | ||
| ScheduledBatchStartDateTime | voij_sched | sched_tst_from | ||
| ScheduledBatchEndDateTime | voij_sched | sched_tst_to | ||
| IsNominationActual | voij_sched | actuals | ||
| MaterialDesc | I_MaterialDescription | MaterialDescription | ||
| DischargeNominationItemStatus | ||||
| NominationItemStatusDesc | ||||
| ItemDischargeStatusText | ||||
| MaterialGroup | mara | matkl | ||
| MaterialGroupName | ||||
| ProductHierarchy | mara | prdha | ||
| ProductHierarchyName | ||||
| Customer | I_Customer | Customer | ||
| CustomerName | ||||
| SupplierAccount | I_Supplier | Supplier | ||
| SupplierName | ||||
| CustAddressNumber | adrc | addrnumber | ||
| CustomerCityName | adrc | city1 | ||
| CustomerCountry | adrc | country | ||
| AddressNumber | adrc | addrnumber | ||
| SupplierCityName | adrc | city1 | ||
| SourceLocationCountry | adrc | country | ||
| CityName | I_VisualLocations | CityName | ||
| CountryName | I_VisualLocations | CountryName | ||
| Region | I_VisualLocations | Region | ||
| BusinessPartnerRoleType | v_oijrra | rpart | ||
| FromLatitude | ||||
| FromLongitude | ||||
| ToLatitude | ||||
| ToLongitude | ||||
| ConnectionPoints | v_visu_usrva | variant | ||
| LocationPosition | v_visu_usrva | variant | ||
| RouteText | ||||
| IsAlert | ||||
| AlertText | ||||
| DischargeQtyAlertText | ||||
| IsLoadTimeAlert | ||||
| LoadTimeAlertText | ||||
| IsDischargeTimeAlert | ||||
| DischargeTimeAlertText | ||||
| IsLocationAlert | ||||
| LocationAlertDesc | ||||
| IsDischargeLocAlert | ||||
| DischargeLocAlertDesc | ||||
| IsLoad | ||||
| IsNominationDocItem | ||||
| IsPegged | ||||
| SafetyStock | I_OilLocMatlPlanning | SafetyStock | ||
| CapacityStock | I_OilLocMatlPlanning | CapacityStock | ||
| NominationEventNumber | I_Oij06_Myeventss1_Main | NominationEventNumber | ||
| NominationEventType | I_Oij06_Myeventss1_Main | NominationEventType | ||
| NominationEventSequence | I_Oij06_Myeventss1_Main | NominationEventSequence | ||
| ActualStartDateFrom | I_Oij06_Myeventss1_Main | ActualStartDateFrom | ||
| ActualStartTimeFrom | I_Oij06_Myeventss1_Main | ActualStartTimeFrom | ||
| NominationEventChangedDate | I_Oij06_Recent_Event | NominationEventChangedDate | ||
| NominationEventChangedTime | I_Oij06_Recent_Event | NominationEventChangedTime | ||
| DischargeEventNumber | ||||
| DischargeEventType | ||||
| DischargeDate | ||||
| DischargeTime | ||||
| ActualStartDateTo | I_Oij06_Myeventss1_Main | ActualStartDateTo | ||
| ActualStartTimeTo | I_Oij06_Myeventss1_Main | ActualStartTimeTo | ||
| ActualEndDateFrom | I_Oij06_Myeventss1_Main | ActualEndDateFrom | ||
| ActualEndTimeFrom | I_Oij06_Myeventss1_Main | ActualEndTimeFrom | ||
| ActualEndDateTo | I_Oij06_Myeventss1_Main | ActualEndDateTo | ||
| ActualEndTimeTo | I_Oij06_Myeventss1_Main | ActualEndTimeTo | ||
| NominationTicketLoadStartDate | ||||
| NominationTicketLoadStartTime | ||||
| NominationTicketDischargeDate | ||||
| NominationTicketDischargeTime | ||||
| NominationScheduledTime | ||||
| PlannedDischargeDate | ||||
| NominationDischargeTime | ||||
| DestinationLocation | ||||
| IsVariant | ||||
| IsNominationLoad | ||||
| IsNominationDischarge | ||||
| NominationPegID | v_oijpeg | pegid | ||
| NominationPeggingTypeUsage | v_oij_pegtyp | peg_type_usage | ||
| TransshipmentGroupID | ||||
| DischargeReferenceDocument | ||||
| NominationDischargeSchedType | ||||
| DischargeContractPartner | ||||
| DischargeLocationPartner | ||||
| DischargeLocationPlant | ||||
| NotificationStatusObject | v_oij_shipments | mstus | ||
| StatusObject | ||||
| NotificationDateTime | v_oij_shipments | mtims | ||
| NotificationText | ||||
| MaintenanceNotificationText | ||||
| IndicatorValue | ||||
| IsCloudSystem | ||||
| Simulation | voij_sched | sim_sched_typ | ||
| Comments | ||||
| LoadDemandMaterialDesc | I_MaterialDescription | MaterialDescription | ||
| DischargeDemandMaterialDesc | I_MaterialDescription | MaterialDescription | ||
| ShipmentLoadCost | ||||
| ShipmentLoadCostCrcy | ||||
| ShipmentDischargeCost | ||||
| ShipmentDischargeCostCrcy | ||||
| LocationTimeZone | _VisualLocationTimeZone | LocationTimeZone |
@AbapCatalog.sqlViewName: 'IVISUSIM'
@EndUserText.label: 'IPW Simulation in Visualization'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@Search.searchable:false
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
define view I_VisualSimulation
as select from voij_sched as sim
//left outer join oigv as v on h.nmvehicle = v.vehicleoij_sched
left outer join v_oijpeg as o on o.docno = sim.nomtk and o.item = sim.nomit and o.doctype = 'm'
and ( o.pegtype <> 'MS' and o.pegtype <> 'LI' and o.pegtype <> 'LH')
left outer join v_oij_pegtyp as p on p.peg_type = o.pegtype
left outer join mara as a on sim.s_matnr_i = a.matnr
left outer join I_MaterialDescription as m on sim.s_matnr_i = m.Material
left outer join I_MaterialDescription as m_l on sim.matnr_i = m_l.Material
left outer join I_MaterialDescription as m_d on sim.matnr_i = m_d.Material
left outer join I_Customer as b on b.Customer = sim.conpat
left outer join adrc as c on c.langu = $session.system_language and c.addrnumber = b.AddressID
left outer join I_Supplier as d on d.Supplier = sim.conpat
left outer join adrc as e on e.langu = $session.system_language and e.addrnumber = d.AddressID
left outer join I_VisualLocations as loc on loc.LocationId = sim.locid
left outer join oij07_mot_eve_v as k on k.vktra = sim.vktra
left outer join I_Oij06_Recent_Event as re on sim.nomtk = re.NominationDoc and sim.nomit = re.NominationDocItem
left outer join I_Oij06_Myeventss1_Main as ev on ev.NominationDoc = re.NominationDoc and ev.NominationDocItem = re.NominationDocItem and ev.NominationEventType = k.type
left outer join I_OilLocMatlPlanning as f on f.LocationId = sim.locid and f.Material = sim.s_matnr_i
left outer join I_NominationModeOfTranspVH as nh on nh.ModeOfTransport = sim.vktra
left outer join v_oigvt as j on j.vehicle = sim.nmvehicle and j.lang = $session.system_language
//3P location fetch
//left outer join I_Plant as pl on pl.Plant = sim.nmwerk
//left outer join I_Purreqvaluationarea as va on va.ValuationArea = pl.ValuationArea
left outer join v_oijtsloc as ts on ts.tsyst = sim.tsyst and ts.locid = sim.locid
left outer join v_oijrra as rt on rt.locid = ts.locid and rt.tsyst = ts.tsyst
and (( rt.kunnr = sim.conpat and rt.rpart = 'KN' ) or ( rt.lifnr = sim.conpat and rt.rpart = 'LF' ))
//Joined to fetch notification related details
left outer join v_oij_shipments as sp on sp.nomtk = sim.nomtk and sp.nomit = sim.nomit
// Joined to get the string type field
left outer join v_visu_usrva as uv on uv.uname = ' '
association [1..1] to I_VisualLocationTimeZone as _VisualLocationTimeZone on $projection.LocationId = _VisualLocationTimeZone.TSWLocationID
{
key sim.nomtk as NominationDoc,
key sim.nomit as NominationDocItem,
cast ( '' as abap.char(10) ) as NominationDocDischargeItem,
sim.nomnr as NominationExtNumber,
sim.nomtyp as NominationType,
sim.nomst as NominationHeaderStatus,
sim.locid as LocationId,
loc.BusinessEntityLocationName as LocationName,
cast('' as abap.char(10)) as LocationDischargeId,
cast('' as abap.char(35)) as DestinationLocationName,
loc.CompanyCode,
sim.s_matnr_i as ScheduledMaterial,
sim.menge as ScheduledQuantity,
sim.unit_i as ScheduledQuantityUnit,
cast(0 as abap.quan( 13, 3 )) as DischargeSchedQuantity, //Scheduled Discharge Quantity
cast('' as abap.char(3 )) as DischargeQuantityUnit, //Scheduled Discharge Uom
sim.docind as IsReferenceDocument,
sim.docnr as NominationReferenceDocument,
sim.cycle as NominationPipelineCycleID,
sim.nmshipper as NominationShipper,
sim.nmcarrier as NominationCarrier,
cast('' as abap.char(35) ) as CarrierName,
sim.nmwerk as InTransitPlant,
sim.nmlgort as InTransitStorageLocation,
sim.nmvehicle as VehicleId,
cast('' as abap.char(40) ) as VehicleDescription,
//v.veh_xblck as VehicleIsBlocked,
sim.tsyst as TransportSystem, //Transport System
sim.sentdat as NominationLastHeaderActionDate, //Last header action date -- used as -- Date
sim.nmtplst as TransportationPlanningPoint,
sim.route as ShippingRoute,
sim.bookts as IsBookedTransportSystem,
sim.ev_group as NominationEventDefaultGroup,
sim.unit as NominationHeaderUom,
sim.nmshtype as BulkShipmentType,
sim.vktra as NominationModeOfTransport,
nh.ModeOfTransportDesc as ModeOfTransportText,
sim.bustyp as BusinessType,
sim.nmvessel as VehicleIdentifier,
sim.aedat as NominationChangedDate,
sim.erdat as NominationCreationDate,
sim.erzeit as NominationCreationTime,
sim.ernam as NominationCreatedByUser,
sim.bloind as NominationIsBlocked,
sim.conpat as ContractPartner,
sim.cons as ConsigneePartner,
sim.delind as NominationIsMarkedForDeletion,
sim.docitm as NominationReferenceDocItem,
sim.doctyp as NominationReferenceDocType,
sim.flag_imex as IsImportExportPartner,
sim.charg_o as BatchOriginLocation,
sim.charg_d as BatchDestinationLocation,
sim.idate as NominationScheduleDate,
sim.impoexpo as ImportExportPartner,
sim.incomplete_flag as NominationIsIncomplete,
sim.inspe as NominationInspector,
sim.istat as NominationItemStatus,
sim.isubstat as NominationItemSubStatus,
sim.matnr_i as LoadDemandMaterialId,
sim.matnr_i as DischargeDemandMaterialId,
sim.partnr as LocationPartner,
cast( '' as abap.char(4)) as LocationPlant,
sim.sityp as NominationScheduleType,
sim.owner as ValuationType,
sim.valuationtype_d as ValuationTypeDestination,
sim.valuationtype_o as ValuationTypeOrigin,
sim.worklist_i as IsNominationWorklistEntry,
sim.actualqty as ActualScheduledQuantity,
sim.actualuom as ActualScheduledQuantityUnit,
cast(0 as abap.quan( 13, 3 )) as ActualDischargeQuantity, //Actual Discharge Quantity
cast('' as abap.char(3 )) as ActualDischargeQuantityUnit,
//sim.quickconf as QuickConfirmationCode,
sim.ilock as NominationItemIsComplete,
sim.sched_tst_from as ScheduledBatchStartDateTime,
sim.sched_tst_to as ScheduledBatchEndDateTime,
sim.actuals as IsNominationActual,
m.MaterialDescription as MaterialDesc,
cast('' as char1) as DischargeNominationItemStatus,
cast('' as char50) as NominationItemStatusDesc,
cast('' as char50) as ItemDischargeStatusText,
a.matkl as MaterialGroup,
cast('' as char50) as MaterialGroupName,
a.prdha as ProductHierarchy,
cast('' as char50) as ProductHierarchyName,
//Partners details field for nomination
b.Customer as Customer,
cast('' as abap.char(35) ) as CustomerName,
d.Supplier as SupplierAccount,
cast('' as abap.char(35) ) as SupplierName,
c.addrnumber as CustAddressNumber,
c.city1 as CustomerCityName,
c.country as CustomerCountry,
e.addrnumber as AddressNumber,
e.city1 as SupplierCityName,
e.country as SourceLocationCountry,
//Location details
loc.CityName,
loc.CountryName,
loc.Region,
rt.rpart as BusinessPartnerRoleType,
//Route specific fields
cast('' as char20 ) as FromLatitude,
cast('' as char20 ) as FromLongitude,
cast('' as char20 ) as ToLatitude,
cast('' as char20 ) as ToLongitude,
uv.variant as ConnectionPoints,
uv.variant as LocationPosition,
cast('' as char30 ) as RouteText,
//Shipment qty Alerts
cast('' as char2 ) as IsAlert,
cast('' as char255) as AlertText,
cast('' as char255) as DischargeQtyAlertText,
//Shipment Time/Event alerts
cast('' as char2 ) as IsLoadTimeAlert,
cast('' as char255) as LoadTimeAlertText,
cast('' as char2 ) as IsDischargeTimeAlert,
cast('' as char255) as DischargeTimeAlertText,
//Location level alerts
cast('' as char1 ) as IsLocationAlert,
cast('' as char255) as LocationAlertDesc,
cast('' as char1 ) as IsDischargeLocAlert,
cast('' as char255) as DischargeLocAlertDesc,
//Indicator fields
cast('' as char2 ) as IsLoad,
cast('' as char10 ) as IsNominationDocItem,
cast('' as char1 ) as IsPegged,
f.SafetyStock,
f.CapacityStock,
//Events fields from Nominations events
ev.NominationEventNumber,
ev.NominationEventType,
ev.NominationEventSequence,
ev.ActualStartDateFrom, //Actual Load Date
ev.ActualStartTimeFrom, //Actual Load Time
re.NominationEventChangedDate,
re.NominationEventChangedTime,
cast(dats_tims_to_tstmp( re.NominationEventChangedDate,
re.NominationEventChangedTime,
abap_system_timezone($session.client, 'NULL'),
$session.client,
'NULL' ) as timestamp) as NominationEventChangedDateTime,
cast(dats_tims_to_tstmp( ev.ActualStartDateFrom,
ev.ActualStartTimeFrom,
abap_system_timezone($session.client, 'NULL'),
$session.client,
'NULL' ) as timestamp) as ActualStartFromDateTime,
//cast('' as char19) as ActualStartDateTime, //Actual Load TimeStamp
cast('' as char4 ) as DischargeEventNumber, //Actual Discharge Event No
cast('' as char4 ) as DischargeEventType, //Actual Discharge Event Type
cast('00000000' as abap.dats) as DischargeDate, //Actual Discharge Date
cast('000000' as abap.tims) as DischargeTime, //Actual Discharge Time
cast(dats_tims_to_tstmp( cast('00000000' as abap.dats),
cast('000000' as abap.tims),
abap_system_timezone($session.client, 'NULL'),
$session.client,
'NULL' ) as timestamp) as DischargeStartDateTime, //Actual Discharge TimeStamp
ev.ActualStartDateTo,
ev.ActualStartTimeTo,
ev.ActualEndDateFrom,
ev.ActualEndTimeFrom,
ev.ActualEndDateTo,
ev.ActualEndTimeTo,
cast(dats_tims_to_tstmp( ev.ActualEndDateTo,
ev.ActualEndTimeTo,
abap_system_timezone($session.client, 'NULL'),
$session.client,
'NULL' ) as timestamp) as ActualEndToDateTime,
cast('00000000' as abap.dats) as NominationTicketLoadStartDate,
cast('000000' as abap.tims) as NominationTicketLoadStartTime,
cast(dats_tims_to_tstmp( cast('00000000' as abap.dats),
cast('000000' as abap.tims),
abap_system_timezone($session.client, 'NULL'),
$session.client,
'NULL' ) as timestamp) as NomTicketLoadStartDateTime, //Actual Discharge TimeStamp
cast('00000000' as abap.dats) as NominationTicketDischargeDate,
cast('000000' as abap.tims) as NominationTicketDischargeTime,
cast(dats_tims_to_tstmp( cast('00000000' as abap.dats),
cast('000000' as abap.tims),
abap_system_timezone($session.client, 'NULL'),
$session.client,
'NULL' ) as timestamp) as NomTicketDischargeDateTime, //Actual Discharge TimeStamp
cast('000000' as abap.tims) as NominationScheduledTime,
cast('00000000' as abap.dats) as PlannedDischargeDate,
cast(dats_tims_to_tstmp( cast('00000000' as abap.dats),
cast('000000' as abap.tims),
abap_system_timezone($session.client, 'NULL'),
$session.client,
'NULL' ) as timestamp) as DischargeBatchStartDateTime,
cast('000000' as abap.tims) as NominationDischargeTime,
cast('' as abap.char(10) ) as DestinationLocation,
cast('' as char1) as IsVariant,
cast('' as char1) as IsNominationLoad,
cast('' as char1) as IsNominationDischarge,
o.pegid as NominationPegID,
p.peg_type_usage as NominationPeggingTypeUsage,
cast('0' as abap.int1) as TransshipmentGroupID,
cast(' ' as char1 ) as DischargeReferenceDocument,
cast(' ' as char2 ) as NominationDischargeSchedType,
cast(' ' as char10) as DischargeContractPartner,
cast(' ' as char10) as DischargeLocationPartner,
cast(' ' as char4 ) as DischargeLocationPlant,
sp.mstus as NotificationStatusObject, //for notification service
cast(' ' as char2 ) as StatusObject, //for notification service
sp.mtims as NotificationDateTime, //for notification service
cast(' ' as char10) as NotificationText, //for notification service
cast(' ' as char10) as MaintenanceNotificationText,//for notification service
cast(' ' as char2 ) as IndicatorValue , //for notification service
cast(' ' as char2 ) as IsCloudSystem ,
sim.sim_sched_typ as Simulation ,
cast('' as abap.char( 256 ) ) as Comments,
m_l.MaterialDescription as LoadDemandMaterialDesc,
m_d.MaterialDescription as DischargeDemandMaterialDesc,
cast( 0 as oij09_cost ) as ShipmentLoadCost,
cast(' ' as oij09_waers ) as ShipmentLoadCostCrcy,
cast( 0 as oij09_cost ) as ShipmentDischargeCost,
cast(' ' as oij09_waers ) as ShipmentDischargeCostCrcy,
_VisualLocationTimeZone.LocationTimeZone as LocationTimeZone
}
where sim.nomst <> '3'
and sim.vktra <> '01'
and sim.delind <> 'X'
and ( ( sim.sim_sched_typ = 'SS' and (sim.ernam = $session.user or sim.aenam = $session.user)) or sim.sim_sched_typ = 'IC' )
and sim.sim_version = '000'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMER",
"I_MATERIALDESCRIPTION",
"I_NOMINATIONMODEOFTRANSPVH",
"I_OIJ06_MYEVENTSS1_MAIN",
"I_OIJ06_RECENT_EVENT",
"I_OILLOCMATLPLANNING",
"I_SUPPLIER",
"I_VISUALLOCATIONS",
"I_VISUALLOCATIONTIMEZONE",
"ADRC",
"MARA",
"OIJ07_MOT_EVE_V",
"VOIJ_SCHED",
"V_OIGVT",
"V_OIJPEG",
"V_OIJRRA",
"V_OIJTSLOC",
"V_OIJ_PEGTYP",
"V_OIJ_SHIPMENTS",
"V_VISU_USRVA"
],
"ASSOCIATED":
[
"I_VISUALLOCATIONTIMEZONE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA