TSW: Ticket Details

DataSource Transactional Data: 0OI_TSW_TKT

You use this DataSource to extract ticketing details from the ERP system to the BI system. This data includes the additional Oil and Gas quantities for ticketing (the quantity that the conversion routines determine on the basis of the quantity used in the transaction or which you enter manually).

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
`TICKETNR`	Ticket Number	`OIJ_EL_TICKET_H`	`TICKETNR`
`TICKET_KEY`	Ticket Key	`OIJ_EL_TICKET_H`	`TICKET_KEY`
`TICKET_VERSION`	Ticket Version	`OIJ_EL_TICKET_H`	`TICKET_VERSION`
`TICKET_PURPOSE`	Ticket Purpose	`OIJ_EL_TICKET_H`	`TICKET_PURPOSE`
`TICKET_TYPE`	Ticket Type	`OIJ_EL_TICKET_H`	`TICKET_TYPE`
`TICKET_ITEM`	Ticket Item	`OIJ_EL_TICKET_I`	`TICKET_ITEM`
`TICKET_STATUS`	Ticket Status	`OIJ_EL_TICKET_I`	`STATUS`
`BUDAT`	Posting Date	`OIJ_EL_TICKET_I`	`BUDAT`
`LOCID`	Location ID	`OIJ_EL_TICKET_I`	`LOCID`
`TSYST`	Transport System	`OIJ_EL_TICKET_H`	`TSYST`
`MATNR`	Material Number	`OIJ_EL_TICKET_I`	`MATNR`
`CHARG_O`	Batch Origin Location	`OIJ_EL_TICKET_I`	`CHARG_O`
`CHARG_D`	Batch Destination Location	`OIJ_EL_TICKET_I`	`CHARG_D`
`NOMNR`	Nomination Number	`OIJ_EL_TICKET_I`	`NOMNR`
`NOMTK`	Nomination (technical) Key	`OIJ_EL_TICKET_I`	`NOMTK`
`NOMIT`	Nomination Item	`OIJ_EL_TICKET_I`	`NOMIT`
`MENGE`	Quantity	`OIJ_EL_TICKET_I`	`MENGE`
`MEINS`	Base Unit of Measure	`OIJ_EL_TICKET_I`	`MEINS`
`ADQNT`	Additional Oil and Gas Quantity	`OIJ_EL_TKT_I_O2`	`ADQNT`
`MSEHI`	Unit of Measurement	`OIJ_EL_TKT_I_O2`	`MSEHI`