I_VisualNominations
Visual Nominations
I_VisualNominations is a Composite CDS View that provides data about "Visual Nominations" in SAP S/4HANA. It reads from 18 data sources and exposes 155 fields with key fields NominationDoc, NominationDocItem. It has 1 association to related views.
Data Sources (18)
| Source | Alias | Join Type |
|---|---|---|
| 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 |
| I_NominationModeOfTranspVH | h | left_outer |
| v_oigvt | j | left_outer |
| oij07_mot_eve_v | k | left_outer |
| I_VisualLocations | loc | left_outer |
| I_NominationAnalysisPath | nom | from |
| v_oijpeg | o | left_outer |
| v_oij_pegtyp | p | left_outer |
| I_Plant | pl | left_outer |
| v_oijrra | rt | left_outer |
| v_oij_shipments | sp | left_outer |
| v_visu_usrva | uv | left_outer |
| I_Purreqvaluationarea | va | 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 | IVISUALNOM | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| VDM.viewType | #COMPOSITE | view | |
| Search.searchable | false | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ClientHandling.type | #INHERITED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| EndUserText.label | Visual Nominations | view |
Fields (155)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | NominationDoc | I_NominationAnalysisPath | NominationDoc | |
| KEY | NominationDocItem | I_NominationAnalysisPath | NominationDocItem | |
| NominationDocDischargeItem | ||||
| NominationExtNumber | I_NominationAnalysisPath | NominationExtNumber | ||
| VehicleId | I_NominationAnalysisPath | VehicleId | ||
| VehicleDescription | ||||
| TransportSystem | I_NominationAnalysisPath | TransportSystem | ||
| NominationModeOfTransport | I_NominationAnalysisPath | NominationModeOfTransport | ||
| ModeOfTransportText | I_NominationModeOfTranspVH | ModeOfTransportDesc | ||
| NominationCarrier | I_NominationAnalysisPath | NominationCarrier | ||
| CarrierName | ||||
| ShippingRoute | I_NominationAnalysisPath | ShippingRoute | ||
| LocationId | I_NominationAnalysisPath | LocationId | ||
| ScheduledMaterial | I_NominationAnalysisPath | ScheduledMaterial | ||
| LocationDischargeId | ||||
| LocationName | I_VisualLocations | BusinessEntityLocationName | ||
| DestinationLocationName | ||||
| CompanyCode | I_Purreqvaluationarea | CompanyCode | ||
| NominationScheduleDate | I_NominationAnalysisPath | NominationScheduleDate | ||
| ScheduledBatchStartDateTime | I_NominationAnalysisPath | ScheduledBatchStartDateTime | ||
| NominationScheduledTime | ||||
| PlannedDischargeDate | ||||
| NominationDischargeTime | ||||
| ScheduledBatchEndDateTime | I_NominationAnalysisPath | ScheduledBatchEndDateTime | ||
| NominationEventChangedDate | I_NominationAnalysisPath | NominationEventChangedDate | ||
| NominationEventChangedTime | I_NominationAnalysisPath | NominationEventChangedTime | ||
| ScheduledQuantity | I_NominationAnalysisPath | ScheduledQuantity | ||
| ScheduledQuantityUnit | I_NominationAnalysisPath | ScheduledQuantityUnit | ||
| DischargeSchedQuantity | ||||
| DischargeQuantityUnit | ||||
| ActualScheduledQuantity | I_NominationAnalysisPath | ActualScheduledQuantity | ||
| ActualScheduledQuantityUnit | I_NominationAnalysisPath | ActualScheduledQuantityUnit | ||
| ActualDischargeQuantity | ||||
| ActualDischargeQuantityUnit | ||||
| ContractPartner | I_NominationAnalysisPath | ContractPartner | ||
| LocationPartner | I_NominationAnalysisPath | LocationPartner | ||
| LocationPlant | I_NominationAnalysisPath | LocationPlant | ||
| ValuationType | I_NominationAnalysisPath | ValuationType | ||
| IsReferenceDocument | I_NominationAnalysisPath | IsReferenceDocument | ||
| IsNominationActual | I_NominationAnalysisPath | IsNominationActual | ||
| NominationReferenceDocument | I_NominationAnalysisPath | NominationReferenceDocument | ||
| NominationReferenceDocItem | I_NominationAnalysisPath | NominationReferenceDocItem | ||
| NominationReferenceDocType | I_NominationAnalysisPath | NominationReferenceDocType | ||
| NominationScheduleType | I_NominationAnalysisPath | NominationScheduleType | ||
| IsBookedTransportSystem | I_NominationAnalysisPath | IsBookedTransportSystem | ||
| NominationItemIsComplete | I_NominationAnalysisPath | NominationItemIsComplete | ||
| MaterialDesc | m | MaterialDescription | ||
| NominationHeaderStatus | I_NominationAnalysisPath | NominationHeaderStatus | ||
| NominationItemStatus | I_NominationAnalysisPath | NominationItemStatus | ||
| NominationType | I_NominationAnalysisPath | NominationType | ||
| DischargeNominationItemStatus | ||||
| NominationItemStatusDesc | ||||
| ItemDischargeStatusText | ||||
| MaterialGroup | a | matkl | ||
| MaterialGroupName | ||||
| ProductHierarchy | a | 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 | ||
| 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 | ||||
| ToleranceOver | I_NominationAnalysisPath | ToleranceOver | ||
| ToleranceUnder | I_NominationAnalysisPath | ToleranceUnder | ||
| ToleranceOverAbs | I_NominationAnalysisPath | ToleranceOverAbs | ||
| ToleranceUnderAbs | I_NominationAnalysisPath | ToleranceUnderAbs | ||
| ToleranceUnitAbs | I_NominationAnalysisPath | ToleranceUnitAbs | ||
| IsUnlimited | I_NominationAnalysisPath | IsUnlimited | ||
| ToleranceOverTs | I_NominationAnalysisPath | ToleranceOverTs | ||
| ToleranceUnderTs | I_NominationAnalysisPath | ToleranceUnderTs | ||
| ToleranceOverAbsTs | I_NominationAnalysisPath | ToleranceOverAbsTs | ||
| ToleranceUnderAbsTs | I_NominationAnalysisPath | ToleranceUnderAbsTs | ||
| ToleranceUnitAbsTs | I_NominationAnalysisPath | ToleranceUnitAbsTs | ||
| IsUnlimitedTs | I_NominationAnalysisPath | IsUnlimitedTs | ||
| 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 | ||||
| Comments | ||||
| LoadDemandMaterialId | I_NominationAnalysisPath | LoadDemandMaterialId | ||
| DischargeDemandMaterialId | I_NominationAnalysisPath | DischargeDemandMaterialId | ||
| LoadDemandMaterialDesc | m_l | MaterialDescription | ||
| DischargeDemandMaterialDesc | m_d | MaterialDescription | ||
| ShipmentLoadCost | ||||
| ShipmentLoadCostCrcy | ||||
| ShipmentDischargeCost | ||||
| ShipmentDischargeCostCrcy | ||||
| LocationTimeZone | _VisualLocationTimeZone | LocationTimeZone |
@AbapCatalog.sqlViewName: 'IVISUALNOM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@Search.searchable:false
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Visual Nominations'
define view I_VisualNominations as select from I_NominationAnalysisPath as nom
left outer join v_oijpeg as o on o.docno = nom.NominationDoc and o.item = nom.NominationDocItem and o.doctype = 'n'
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
join mara as a on nom.ScheduledMaterial = a.matnr
join I_MaterialDescription as m on nom.ScheduledMaterial = m.Material
join I_MaterialDescription as m_l on nom.LoadDemandMaterialId = m_l.Material
join I_MaterialDescription as m_d on nom.DischargeDemandMaterialId = m_d.Material
left outer join I_Customer as b on b.Customer = nom.ContractPartner
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 = nom.ContractPartner
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 = nom.LocationId
left outer join oij07_mot_eve_v as k on k.vktra = nom.NominationModeOfTransport
left outer join I_Oij06_Myeventss1_Main as ev on ev.NominationDoc = nom.NominationDoc and ev.NominationDocItem = nom.NominationDocItem and ev.NominationEventType = k.type
left outer join I_OilLocMatlPlanning as f on f.LocationId = nom.LocationId and f.Material = nom.ScheduledMaterial
left outer join I_NominationModeOfTranspVH as h on h.ModeOfTransport = nom.NominationModeOfTransport
left outer join v_oigvt as j on j.vehicle = nom.VehicleId and j.lang = $session.system_language
//3P location fetch
left outer join I_Plant as pl on pl.Plant = nom.InTransitPlant
left outer join I_Purreqvaluationarea as va on va.ValuationArea = pl.ValuationArea
join v_oijtsloc as ts on ts.tsyst = nom.TransportSystem and ts.locid = nom.LocationId
left outer join v_oijrra as rt on rt.locid = ts.locid and rt.tsyst = ts.tsyst
and (( rt.kunnr = nom.ContractPartner and rt.rpart = 'KN' ) or ( rt.lifnr = nom.ContractPartner and rt.rpart = 'LF' ))
//Joined to fetch notification related details
left outer join v_oij_shipments as sp on sp.nomtk = nom.NominationDoc and sp.nomit = nom.NominationDocItem
// 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 nom.NominationDoc,
key nom.NominationDocItem,
cast ( '' as abap.char(10) ) as NominationDocDischargeItem,
nom.NominationExtNumber,
nom.VehicleId as VehicleId,
cast('' as abap.char(40) ) as VehicleDescription,
nom.TransportSystem,
nom.NominationModeOfTransport,
h.ModeOfTransportDesc as ModeOfTransportText,
nom.NominationCarrier,
cast('' as abap.char(35) ) as CarrierName,
nom.ShippingRoute,
nom.LocationId,
//nom.ScheduledMaterial as ProductId ,
nom.ScheduledMaterial,
cast('' as abap.char(10)) as LocationDischargeId,
loc.BusinessEntityLocationName as LocationName,
cast('' as abap.char(35)) as DestinationLocationName,
va.CompanyCode as CompanyCode,
nom.NominationScheduleDate, //Load Schedule Date
nom.ScheduledBatchStartDateTime, //Load Time Stamp
cast('000000' as abap.tims) as NominationScheduledTime, //Load Time
cast('00000000' as abap.dats) as PlannedDischargeDate, //Discharge Date
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, //Discharge Time Stamp
cast('000000' as abap.tims) as NominationDischargeTime, //Discharge Time
nom.ScheduledBatchEndDateTime,
nom.NominationEventChangedDate,
nom.NominationEventChangedTime,
cast(dats_tims_to_tstmp( nom.NominationEventChangedDate,
nom.NominationEventChangedTime,
abap_system_timezone($session.client, 'NULL'),
$session.client,
'NULL' ) as timestamp) as NominationEventChangedDateTime,
nom.ScheduledQuantity, //Scheduled Load Quantity
nom.ScheduledQuantityUnit, //Scheduled Load Quantity Uom
cast(0 as abap.quan( 13, 3 )) as DischargeSchedQuantity, //Scheduled Discharge Quantity
cast('' as abap.char(3 )) as DischargeQuantityUnit, //Scheduled Discharge Uom
nom.ActualScheduledQuantity, //Actual Load Quantity
nom.ActualScheduledQuantityUnit, //Actual Load Quantity Uom
cast(0 as abap.quan( 13, 3 )) as ActualDischargeQuantity, //Actual Discharge Quantity
cast('' as abap.char(3 )) as ActualDischargeQuantityUnit, //Actual Discharge Quantity Unit
nom.ContractPartner,
nom.LocationPartner,
nom.LocationPlant,
nom.ValuationType,
nom.IsReferenceDocument,
nom.IsNominationActual,
nom.NominationReferenceDocument,
nom.NominationReferenceDocItem,
nom.NominationReferenceDocType,
nom.NominationScheduleType,
nom.IsBookedTransportSystem,
// nom.ScheduledMaterial,
nom.NominationItemIsComplete,
m.MaterialDescription as MaterialDesc,
nom.NominationHeaderStatus,
nom.NominationItemStatus,
nom.NominationType,
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
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,
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
//cast('' as char19 ) as DischargeStartDateTime,
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
//Fields marked for deletion
nom.ToleranceOver,
nom.ToleranceUnder,
nom.ToleranceOverAbs,
nom.ToleranceUnderAbs,
nom.ToleranceUnitAbs,
nom.IsUnlimited,
nom.ToleranceOverTs,
nom.ToleranceUnderTs,
nom.ToleranceOverAbsTs,
nom.ToleranceUnderAbsTs,
nom.ToleranceUnitAbsTs,
nom.IsUnlimitedTs,
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,
cast(' ' as char2 ) as Simulation,
cast('' as abap.char( 256 ) ) as Comments,
nom.LoadDemandMaterialId,
nom.DischargeDemandMaterialId,
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
nom.NominationHeaderStatus <> '3'
and nom.NominationModeOfTransport <> '01'
and nom.NominationIsMarkedForDeletion <> 'X'
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