TSW: Nomination Details

DataSource Transactional Data: 0OI_TSW_NOM

You use this DataSource to extract nomination data from the ERP system to the BI system.

Note Note

This data source is only available if you have implemented SAP enhancement package 3 for SAP ERP 6.0 and activated the Commodity Mgmt & Bulk Transports (COMM_MGMT&BULK_LOG_1) business function.

End of the note.

Technical Data

Application Component	Oil and Gas (0IS_OIL)
Available as of Release	SAP enhancement package 3 for SAP ERP 6.0, Business Function Commodity Mgmt & Bulk Transports (COMM_MGMT&BULK_LOG_1)
Shipment	SAP NetWeaver 7.0 BI Content Add-On 3 SP08
Content Versions	No Content versions exist
RemoteCube-Capable	No
Delta-Capable	Yes
Extraction from Archives	No
Verifiable	No

Data Modeling

Delta Update

The delta method used here is AIE-After-Images via Extractor.

Fields of Origin for the Extract Structure
Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
`NOMNR`	Nomination Number	`OIJNOMH`	`NOMNR`
`NOMIT`	Nomination Item	`OIJNOM`	`NOMIT`
`NOMTK`	Nomination Technical Key	`OIJNOMH`	`NOMTK`
`IDATE`	Scheduled Date	`OIJNOMI`	`IDATE`
`LOCID`	Location	`OIJNOMI`	`LOCID`
`TSYST`	Transport System	`OIJNOMH`	`TSYST`
`S_MATNR_I`	Material	`OIJNOMI`	`S_MATNR_I`
`CHARG_O`	Batch (From)	`OIJNOMI`	`CHARG_O`
`CHARG_D`	Batch (To)	`OIJNOMI`	`CHARG_D`
`NMVEHICLE`	Vessel	`OIJNOMH`	`NMVEHICLE`
`NMCARRIER`	Transport System Carrier	`OIJNOMH`	`CARRIER`
`UNIT_I`	Scheduled UoM	`OIJNOMI`	`UNIT_I`
`MENGE`	Scheduled Quantity	`OIJNOMI`	`MENGE`
`ACTUALQTY`	Actual Posted Quantity	`OIJNOMI`	`ACTUALQTY`
`ACTUALUOM`	Actual Posted Quantity Unit of Measure	`OIJNOMI`	`ACTUALUOM`
`EVENT_NR`	TD - Event Number	`OIJNE`	`EVENT_NR`
`TYPE`	TD - Event Type	`OIJNE`	`TYPE`
`EV_SEQ`	TD - Event Sequence Number	`OIJNE`	`EV_SEQ`

`EVENT_STATUS`	TD Event Status	`OIJNE`	`STATUS`
`PSTDTF`	TD Event: Planned Start Date - From	`OIJNE`	`PSTDTF`
`PSTTMF`	TD Event: Planned Start Time - From	`OIJNE`
`PSTDTT`	TD Event: Planned Start Date - To	`OIJNE`	`PSTDTT`
`PSTTMT`	TD Event: Planned Start Time - To	`OIJNE`	`PSTTMT`
`PEDDTF`	TD Event: Planned End Date - From	`OIJNE`	`PEDDTF`
`PEDTMF`	TD Event: Planned End Time - From	`OIJNE`	`PEDTMF`
`PEDDTT`	TD Event: Planned End Date - To	`OIJNE`	`PEDDTT`
`PEDTMT`	TD Event: Planned End Time - To	`OIJNE`	`PEDTMT`

`ASTDTF`	TD - Actual Start Date of Event (From)	`OIJNE`	`ASTDTF`
`ASTTMF`	TD - Actual Start Time of Event (From)	`OIJNE`	`ASTTMF`
`ASTDTT`	TD - Actual Start Date of Event (To)	`OIJNE`	`ASTDTT`
`ASTTMT`	TD - Actual Start Time of Event (To)	`OIJNE`	`ASTTMT`
`AEDDTF`	TD Event Actual End Date From	`OIJNE`	`AEDDTF`
`AEDTMF`	TD Event Actual End Time From	`OIJNE`	`AEDTMF`
`AEDDTT`	TD Event Actual End Date To	`OIJNE`	`AEDDTT`
`AEDTMT`	TD Event Actual End Time To	`OIJNE`	`AEDTMT`