SAP table OIJ_EL_TKT_I_O2 (Appendix: TSW Ticket item - Additional Quantities)

SAP table OIJ_EL_TKT_I_O2 has 6 primary key fields being MANDT,TICKET_KEY,TICKET_ITEM,TICKET_VERSION,TICKET_PURPOSE,MSEHI.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
TICKET_KEY OIL-TSW: Ticket key CHAR 20 0 OIJ_EL_TICKET_H OIJ_EL_TKT_KEY
TICKET_ITEM OIL-TSW: Ticket item number NUMC 6 0 OIJ_EL_TKT_POSNR
TICKET_VERSION OIL-TSW: Ticket version NUMC 3 0 OIJ_EL_TKT_VERSION
TICKET_PURPOSE OIL-TSW: Ticket Purpose CHAR 1 0 OIJ_EL_TKT_PURPOSE
1 Field ticket
2 Correction
3 Final confirmation
4 Internally generated for posting
5 Reversal
MSEHI Unit of Measurement UNIT 3 0 T006 MSEHI
ADQNT Additional Oil and Gas Quantity FLTP 16 16 OIB_ADQNT
ADQNTP Additional oil quantity (packed format) QUAN 13 3 OIB_ADQNTP
MANEN Quantity manual entry (indicator) CHAR 1 0 OIB_MANEN
Quantity calculated by QCI
C Quantity passed thr. interface, deviation within tolerance
U Quantity passed through interface, NOT checked
X Quantity checked by QCI, deviation within tolerance
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE

OIJ_EL_TKT_I_O2 foreign key relationships

Table Field Check Table Check Field
0 OIJ_EL_TKT_I_O2 MANDT T000 Clients MANDT
1 OIJ_EL_TKT_I_O2 MSEHI T006 Units of Measurement MANDT
0 OIJ_EL_TKT_I_O2 TICKET_KEY OIJ_EL_TICKET_H Universal ticket table MANDT
0 OIJ_EL_TKT_I_O2 TICKET_KEY OIJ_EL_TICKET_H Universal ticket table TICKET_KEY