I_NominationAnalysisPath
View for APF Nominations
I_NominationAnalysisPath is a Basic CDS View that provides data about "View for APF Nominations" in SAP S/4HANA. It reads from 4 data sources (I_Oij06_Recent_Event, oijnomh, oijts, oigv) and exposes 102 fields with key fields NominationDoc, NominationDocItem. It has 11 associations to related views.
Data Sources (4)
| Source | Alias | Join Type |
|---|---|---|
| I_Oij06_Recent_Event | e | left_outer |
| oijnomh | h | from |
| oijts | ts | left_outer |
| oigv | v | left_outer |
Associations (11)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_Oij06_Myeventss1_Object | _Events | _Events.NominationDoc = $projection.NominationDoc and _Events.NominationDocItem = $projection.NominationDocItem |
| [0..1] | I_Supplier | _Shipper | $projection.NominationShipper = _Shipper.Supplier |
| [0..1] | I_Supplier | _Carrier | $projection.NominationCarrier = _Carrier.Supplier |
| [0..1] | I_Supplier | _Inspector | $projection.NominationInspector = _Inspector.Supplier |
| [0..1] | I_Supplier | _ImportExportPartner | $projection.ImportExportPartner = _ImportExportPartner.Supplier |
| [0..1] | I_Supplier | _ConsigneePartnerVendor | $projection.ConsigneePartner = _ConsigneePartnerVendor.Supplier |
| [0..1] | I_Customer | _ConsigneePartnerCustomer | $projection.ConsigneePartner = _ConsigneePartnerCustomer.Customer |
| [0..1] | I_Supplier | _ContractPartnerVendor | $projection.ContractPartner = _ContractPartnerVendor.Supplier |
| [0..1] | I_Customer | _ContractPartnerCustomer | $projection.ContractPartner = _ContractPartnerCustomer.Customer |
| [0..1] | I_Supplier | _LocationPartnerVendor | $projection.LocationPartner = _LocationPartnerVendor.Supplier |
| [0..1] | I_Customer | _LocationPartnerCustomer | $projection.LocationPartner = _LocationPartnerCustomer.Customer |
Annotations (12)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | ANALYSISPATH | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| Search.searchable | false | view | |
| VDM.viewType | #BASIC | view | |
| ClientHandling.type | #INHERITED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| EndUserText.label | View for APF Nominations | view |
Fields (102)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | NominationDoc | oijnomh | nomtk | |
| KEY | NominationDocItem | i | nomit | |
| NominationExtNumber | oijnomh | nomnr | ||
| NominationType | oijnomh | nomtyp | ||
| NominationHeaderStatus | oijnomh | nomst | ||
| LocationId | i | locid | ||
| ScheduledMaterial | i | s_matnr_i | ||
| ScheduledQuantity | i | menge | ||
| ScheduledQuantityUnit | i | unit_i | ||
| IsReferenceDocument | i | docind | ||
| NominationReferenceDocument | i | docnr | ||
| NominationPipelineCycleID | oijnomh | cycle | ||
| NominationShipper | oijnomh | nmshipper | ||
| NominationCarrier | oijnomh | nmcarrier | ||
| InTransitPlant | oijnomh | nmwerk | ||
| InTransitStorageLocation | oijnomh | nmlgort | ||
| VehicleId | oijnomh | nmvehicle | ||
| VehicleIsBlocked | oigv | veh_xblck | ||
| TransportSystem | oijnomh | tsyst | ||
| NominationLastHeaderActionDate | oijnomh | sentdat | ||
| TransportationPlanningPoint | oijnomh | nmtplst | ||
| ShippingRoute | oijnomh | route | ||
| IsBookedTransportSystem | oijnomh | bookts | ||
| NominationEventDefaultGroup | oijnomh | ev_group | ||
| NominationHeaderUom | oijnomh | unit | ||
| BulkShipmentType | oijnomh | nmshtype | ||
| NominationModeOfTransport | oijnomh | vktra | ||
| NominationChangedDate | i | aedat | ||
| NominationCreationDate | i | erdat | ||
| NominationCreationTime | i | erzeit | ||
| NominationCreatedByUser | i | ernam | ||
| NominationIsBlocked | i | bloind | ||
| BusinessType | oijnomh | bustyp | ||
| ContractPartner | i | conpat | ||
| ConsigneePartner | i | cons | ||
| NominationIsMarkedForDeletion | i | delind | ||
| NominationReferenceDocItem | i | docitm | ||
| NominationReferenceDocType | i | doctyp | ||
| IsImportExportPartner | i | flag_imex | ||
| BatchOriginLocation | i | charg_o | ||
| BatchDestinationLocation | i | charg_d | ||
| NominationScheduleDate | i | idate | ||
| ImportExportPartner | i | impoexpo | ||
| NominationInspector | i | inspe | ||
| NominationItemStatus | i | istat | ||
| NominationItemSubStatus | i | isubstat | ||
| LoadDemandMaterialId | i | matnr_i | ||
| DischargeDemandMaterialId | i | matnr_i | ||
| LocationPartner | i | partnr | ||
| LocationPlant | i | locpt | ||
| NominationScheduleType | i | sityp | ||
| ValuationType | i | owner | ||
| ValuationTypeDestination | i | valuationtype_d | ||
| ValuationTypeOrigin | i | valuationtype_o | ||
| IsNominationWorklistEntry | i | worklist_i | ||
| ActualScheduledQuantity | i | actualqty | ||
| ActualScheduledQuantityUnit | i | actualuom | ||
| QuickConfirmationCode | i | quickconf | ||
| NominationItemIsComplete | i | ilock | ||
| VehicleIdentifier | oijnomh | nmvessel | ||
| ScheduledBatchStartDateTime | i | sched_tst_from | ||
| ScheduledBatchEndDateTime | i | sched_tst_to | ||
| DestinationCityCode | i | oic_dcityc | ||
| OriginCityCode | i | oic_ocityc | ||
| IsNominationActual | i | actuals | ||
| ToleranceOver | i | itbotol | ||
| ToleranceUnder | i | itbutol | ||
| ToleranceOverAbs | i | itbotolabs | ||
| ToleranceUnderAbs | i | itbutolabs | ||
| ToleranceUnitAbs | i | ittolunit | ||
| IsUnlimited | i | unlimited | ||
| ToleranceOverTs | oijts | botol | ||
| ToleranceUnderTs | oijts | butol | ||
| ToleranceOverAbsTs | oijts | botolabs | ||
| ToleranceUnderAbsTs | oijts | butolabs | ||
| ToleranceUnitAbsTs | oijts | bultoluom | ||
| IsUnlimitedTs | oijts | unlimited | ||
| NominationEventType | I_Oij06_Recent_Event | NominationEventType | ||
| NominationEventComments | ||||
| NominationGeneralComments | ||||
| NominationTicketStatus | ||||
| NumberOfNominationTickets | ||||
| NominationEventNumber | ||||
| NominationEventChangedDate | I_Oij06_Recent_Event | NominationEventChangedDate | ||
| NominationEventChangedTime | I_Oij06_Recent_Event | NominationEventChangedTime | ||
| NominationEvents | ||||
| NominationDocComments | ||||
| NominationLoadIsToBeCopied | ||||
| NominationIsUpdated | ||||
| NominationIsToBeCopied | ||||
| NominationItemIsToBeCopied | ||||
| _Events | _Events | |||
| _Shipper | _Shipper | |||
| _Carrier | _Carrier | |||
| _Inspector | _Inspector | |||
| _ImportExportPartner | _ImportExportPartner | |||
| _ConsigneePartnerVendor | _ConsigneePartnerVendor | |||
| _ConsigneePartnerCustomer | _ConsigneePartnerCustomer | |||
| _ContractPartnerVendor | _ContractPartnerVendor | |||
| _ContractPartnerCustomer | _ContractPartnerCustomer | |||
| _LocationPartnerVendor | _LocationPartnerVendor | |||
| _LocationPartnerCustomer | _LocationPartnerCustomer |
@AbapCatalog.sqlViewName: 'ANALYSISPATH'
@AbapCatalog.compiler.compareFilter: true
@Search.searchable:false
@VDM.viewType: #BASIC
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'View for APF Nominations'
define view I_NominationAnalysisPath
as select from oijnomh as h
join oijnomi as i on h.nomtk = i.nomtk
left outer join I_Oij06_Recent_Event as e on i.nomtk = e.NominationDoc and i.nomit = e.NominationDocItem
left outer join oijts as ts on h.tsyst = ts.tsyst
left outer join oigv as v on h.nmvehicle = v.vehicle
association [0..*] to I_Oij06_Myeventss1_Object as _Events on _Events.NominationDoc = $projection.NominationDoc and _Events.NominationDocItem = $projection.NominationDocItem
association [0..1] to I_Supplier as _Shipper on $projection.NominationShipper = _Shipper.Supplier
association [0..1] to I_Supplier as _Carrier on $projection.NominationCarrier = _Carrier.Supplier
association [0..1] to I_Supplier as _Inspector on $projection.NominationInspector = _Inspector.Supplier
association [0..1] to I_Supplier as _ImportExportPartner on $projection.ImportExportPartner = _ImportExportPartner.Supplier
association [0..1] to I_Supplier as _ConsigneePartnerVendor on $projection.ConsigneePartner = _ConsigneePartnerVendor.Supplier
association [0..1] to I_Customer as _ConsigneePartnerCustomer on $projection.ConsigneePartner = _ConsigneePartnerCustomer.Customer
association [0..1] to I_Supplier as _ContractPartnerVendor on $projection.ContractPartner = _ContractPartnerVendor.Supplier
association [0..1] to I_Customer as _ContractPartnerCustomer on $projection.ContractPartner = _ContractPartnerCustomer.Customer
association [0..1] to I_Supplier as _LocationPartnerVendor on $projection.LocationPartner = _LocationPartnerVendor.Supplier
association [0..1] to I_Customer as _LocationPartnerCustomer on $projection.LocationPartner = _LocationPartnerCustomer.Customer
{
@UI.selectionField.position:10 // Selection fields are Filters and you are specifying the position no so in which order they can be shown.
@UI.lineItem.position:10
key h.nomtk as NominationDoc,
@UI.lineItem.position:20 // line items can be content items that are displayed below the filter.
@UI.selectionField.position:20
key i.nomit as NominationDocItem,
@Search.defaultSearchElement : true
@UI.selectionField.position:30
@UI.lineItem.position:30
h.nomnr as NominationExtNumber,
@UI.lineItem.position:40
h.nomtyp as NominationType,
@UI.lineItem.position:50
h.nomst as NominationHeaderStatus,
@UI.lineItem.position:60
i.locid as LocationId,
@UI.lineItem.position:70
i.s_matnr_i as ScheduledMaterial,
@UI.lineItem.position:80
i.menge as ScheduledQuantity,
@UI.lineItem.position:90
i.unit_i as ScheduledQuantityUnit,
@UI.lineItem.position:100
i.docind as IsReferenceDocument,
@UI.lineItem.position:110
i.docnr as NominationReferenceDocument,
@UI.lineItem.position:120
h.cycle as NominationPipelineCycleID,
@UI.lineItem: [{position: 40,
label: 'Copy',
type: #FOR_INTENT_BASED_NAVIGATION,
semanticObjectAction: 'NAVACTION'}]
@Consumption.semanticObject: 'NAVSAM'
h.nmshipper as NominationShipper,
@UI.lineItem: [{position: 50,
label: 'Copy Multiple',
type: #FOR_INTENT_BASED_NAVIGATION,
semanticObjectAction: 'CopyMul'}]
@Consumption.semanticObject: 'GeneralInformation'
h.nmcarrier as NominationCarrier,
h.nmwerk as InTransitPlant,
h.nmlgort as InTransitStorageLocation,
h.nmvehicle as VehicleId,
v.veh_xblck as VehicleIsBlocked,
h.tsyst as TransportSystem, //Transport System
h.sentdat as NominationLastHeaderActionDate, //Last header action date -- used as -- Date
h.nmtplst as TransportationPlanningPoint,
h.route as ShippingRoute,
h.bookts as IsBookedTransportSystem,
h.ev_group as NominationEventDefaultGroup,
h.unit as NominationHeaderUom,
h.nmshtype as BulkShipmentType,
h.vktra as NominationModeOfTransport,
i.aedat as NominationChangedDate,
i.erdat as NominationCreationDate,
i.erzeit as NominationCreationTime,
i.ernam as NominationCreatedByUser,
i.bloind as NominationIsBlocked,
h.bustyp as BusinessType,
i.conpat as ContractPartner,
i.cons as ConsigneePartner,
i.delind as NominationIsMarkedForDeletion,
i.docitm as NominationReferenceDocItem,
i.doctyp as NominationReferenceDocType,
i.flag_imex as IsImportExportPartner,
i.charg_o as BatchOriginLocation,
i.charg_d as BatchDestinationLocation,
i.idate as NominationScheduleDate,
i.impoexpo as ImportExportPartner,
//as incomplete_flag
(case i.incomplete_flag when 'I' then 'I'
when 'E' then 'E'
when ' ' then ' ' end) as NominationIsIncomplete,
i.inspe as NominationInspector,
i.istat as NominationItemStatus,
i.isubstat as NominationItemSubStatus,
i.matnr_i as LoadDemandMaterialId,
i.matnr_i as DischargeDemandMaterialId,
i.partnr as LocationPartner,
i.locpt as LocationPlant,
i.sityp as NominationScheduleType,
i.owner as ValuationType,
i.valuationtype_d as ValuationTypeDestination,
i.valuationtype_o as ValuationTypeOrigin,
i.worklist_i as IsNominationWorklistEntry,
i.actualqty as ActualScheduledQuantity,
i.actualuom as ActualScheduledQuantityUnit,
i.quickconf as QuickConfirmationCode,
i.ilock as NominationItemIsComplete,
h.nmvessel as VehicleIdentifier,
i.sched_tst_from as ScheduledBatchStartDateTime,
i.sched_tst_to as ScheduledBatchEndDateTime,
i.oic_dcityc as DestinationCityCode,
i.oic_ocityc as OriginCityCode,
i.actuals as IsNominationActual,
//Shipment alert specific fields
i.itbotol as ToleranceOver,
i.itbutol as ToleranceUnder,
i.itbotolabs as ToleranceOverAbs,
i.itbutolabs as ToleranceUnderAbs,
i.ittolunit as ToleranceUnitAbs,
i.unlimited as IsUnlimited,
ts.botol as ToleranceOverTs,
ts.butol as ToleranceUnderTs,
ts.botolabs as ToleranceOverAbsTs,
ts.butolabs as ToleranceUnderAbsTs,
ts.bultoluom as ToleranceUnitAbsTs,
ts.unlimited as IsUnlimitedTs,
e.NominationEventType as NominationEventType,
//_Events.NominationEventType
cast('' as char200) as NominationEventComments,
cast('' as char200) as NominationGeneralComments,
cast('' as char50) as NominationTicketStatus,
cast('' as char3) as NumberOfNominationTickets,
(case when e.NominationEventNumber = '0000' then ' ' else e.NominationEventNumber end) as NominationEventNumber,
e.NominationEventChangedDate,
e.NominationEventChangedTime,
// f.cha_date as NominationEventChangedDate,
// f.cha_time as NominationEventChangedTime,
' ' as NominationEvents, // technical fields for advance copy
' ' as NominationDocComments, // technical fields for advance copy
' ' as NominationLoadIsToBeCopied, // technical fields for advance copy
' ' as NominationIsUpdated,
' ' as NominationIsToBeCopied, // field for copy action
' ' as NominationItemIsToBeCopied, // field for copy action
_Events,
_Shipper,
_Carrier,
_Inspector,
_ImportExportPartner,
_ConsigneePartnerVendor,
_ConsigneePartnerCustomer,
_ContractPartnerVendor,
_ContractPartnerCustomer,
_LocationPartnerVendor,
_LocationPartnerCustomer
}
where h.nmselect != '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