SAP ABAP Table ROIJ_EL_TICKET_I (IS-OIL TSW: Structure ticket item)
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL-DS-TSW (Application Component) Trader's and Scheduler's Workbench
⤷ OIJ_EL (Package) TSW Trader's and Scheduler's Workbench - Execution Layer
⤷ IS-OIL-DS-TSW (Application Component) Trader's and Scheduler's Workbench
⤷ OIJ_EL (Package) TSW Trader's and Scheduler's Workbench - Execution Layer
Basic Data
Table Category | INTTAB | Structure |
Structure | ROIJ_EL_TICKET_I | Table Relationship Diagram |
Short Description | IS-OIL TSW: Structure ticket item |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | TICKETNR | OIJ_TKTNR | OIJ_TKTNR | CHAR | 20 | 0 | OIL-TSW: External ticket number | * | |
2 | TICKET_TYPE | OIJ_EL_TKT_TYPE | OIJ_EL_TKT_TYPE | CHAR | 3 | 0 | OIL-TSW: Ticket type | * | |
3 | .INCLUDE | 0 | 0 | Universal ticket item table | |||||
4 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
5 | TICKET_KEY | OIJ_EL_TKT_KEY | OIJ_EL_TKT_KEY | CHAR | 20 | 0 | OIL-TSW: Ticket key | OIJ_EL_TICKET_H | |
6 | TICKET_ITEM | OIJ_EL_TKT_POSNR | OIJ_EL_TKT_POSNR | NUMC | 6 | 0 | OIL-TSW: Ticket item number | ||
7 | TICKET_VERSION | OIJ_EL_TKT_VERSION | OIJ_EL_TKT_VERSION | NUMC | 3 | 0 | OIL-TSW: Ticket version | ||
8 | TICKET_PURPOSE | OIJ_EL_TKT_PURPOSE | OIJ_EL_TKT_PURPOSE | CHAR | 1 | 0 | OIL-TSW: Ticket Purpose | ||
9 | EXT_POSNR | OIJ_EL_EXT_POS | CHAR6 | CHAR | 6 | 0 | External position number | ||
10 | STATUS | OIJ_ISTAT | OIJ_ISTAT | CHAR | 1 | 0 | Nomination Item status | * | |
11 | SUBSTATUS | OIJ_SSTAT | OIJ_SSTAT | CHAR | 1 | 0 | Nomination Item sub-status | * | |
12 | SITYP | OIJ_SITYP | OIJ_SITYP | CHAR | 2 | 0 | Schedule type | TOIJ_EL_SITYPES | |
13 | TKTSUBRC | OIJ_TKTRC | OIJ_TKTRC | CHAR | 2 | 0 | OIL-TSW: Ticket process return code | ||
14 | MVSCENARIO | OIJ_MVSCEN | NUM02 | NUMC | 2 | 0 | TSW: Movement scenario number | TOIJ_EL_MVSCEN | |
15 | NOMNR | OIJ_NOMNR | OIJ_NOMNR | CHAR | 20 | 0 | Nomination number | ||
16 | NOMTK | OIJ_NOMTK | OIJ_NOMTK | CHAR | 20 | 0 | Nomination (technical) Key | OIJNOMH | |
17 | NOMIT | OIJ_ITEM | OIJ_ITEM | NUMC | 10 | 0 | Nomination Key Item | OIJNOMI | |
18 | RECEIVER | OIJ_PARTNR | OIJ_PARTNR | CHAR | 10 | 0 | Location Partner | ||
19 | LOCID | OIJ_LOCID | OIJ_LOCID | CHAR | 10 | 0 | Location ID | OIJLOC | |
20 | TANKNR | OIJ_BSEQNR | OII_SEQNR | CHAR | 10 | 0 | Sequence number of tank assigned to a business location | ||
21 | VEHICLE | OIG_VHLNMR | OIG_VHLNMR | CHAR | 10 | 0 | TD Vehicle Number | OIGV | |
22 | MENGE | OIJ_MENGE | MENG13 | QUAN | 13 | 3 | Scheduled qty | ||
23 | GROSQUAN | OIJ_MENGE | MENG13 | QUAN | 13 | 3 | Scheduled qty | ||
24 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
25 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
26 | TANKAGE | OIJ_TANKAGE | OIJ_PARTNR | CHAR | 10 | 0 | Tankage Partner | ||
27 | SUPPLIER | OIJ_PARTNR | OIJ_PARTNR | CHAR | 10 | 0 | Location Partner | ||
28 | CONSIGNE | OIJ_CONSIGNEE | OIJ_PARTNR | CHAR | 10 | 0 | Consignee Partner | ||
29 | AGREED_QTY | OIJ_AGGRDQTY | MENGE | QUAN | 13 | 3 | agreed qty. between ship. measr. and shore measrd. quants. | ||
30 | AGREED_QTY_UOM | OIJ_LDUOM | MEINS | UNIT | 3 | 0 | Loaded/Discharged Material UOM | * | |
31 | SHIP_QTY | OIJ_SHIPQTY | MENGE | QUAN | 13 | 3 | ship measured ld/disc. material quantity | ||
32 | SHIP_QTY_UOM | OIJ_LDUOM | MEINS | UNIT | 3 | 0 | Loaded/Discharged Material UOM | * | |
33 | .INCLUDE | 0 | 0 | OIL-TSW: Data for QCI | |||||
34 | MTTMP | OIB_MTTMP | TEMP_VALUE | FLTP | 16 | 16 | Oil/Gas Material Temperature: Observed Quantity | ||
35 | MTTEH | OIB_MTTEH | MEINS | UNIT | 3 | 0 | Oil/Gas Material Temperature Unit: Observed Quantity | T006 | |
36 | O_API_GRAV | OIB_TDICH | OIB_DICHT | FLTP | 16 | 16 | Oil/Gas Test Density | ||
37 | API_GRT_D | OIB_TDICH | OIB_DICHT | FLTP | 16 | 16 | Oil/Gas Test Density | ||
38 | TSTMP | OIB_TSTMP | TEMP_VALUE | FLTP | 16 | 16 | Oil/Gas Test Temperature: Observed Density | ||
39 | TSTEH | OIB_TSTEH | MEINS | UNIT | 3 | 0 | Test Temperature Unit (Density): Measurement | T006 | |
40 | TDICH | OIB_TDICH | OIB_DICHT | FLTP | 16 | 16 | Oil/Gas Test Density | ||
41 | .INCLUDE | 0 | 0 | OIL-TSW: Standard status field set (TSW) | |||||
42 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
43 | ERZEIT | OI0_ERTIM | UZEIT | TIMS | 6 | 0 | Time of creation | ||
44 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
45 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
46 | AEZEIT | OI0_AETIM | UZEIT | TIMS | 6 | 0 | Time of day the record was changed | ||
47 | AENAM | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
48 | BLOIND | OIJ_BLOIND | XFELD | CHAR | 1 | 0 | Blocking indicator | ||
49 | DELIND | OIJ_DELIND | XFELD | CHAR | 1 | 0 | Deletion indicator | ||
50 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
51 | CLOSE_NOMIT | OIJ_EL_CLOSE_NOMIT | OIJ_EL_CLOSE_NOMIT | CHAR | 1 | 0 | IS OIL TSW: Indicator close nomination | ||
52 | EVENTTYPE | OIJ_EVENTTYPE | OIJ_EVENTTYPE | CHAR | 16 | 0 | TSW event date type | OIJ_EL_EVT_TYPE | |
53 | EVENT_DATE | OIJ_EVENT_DATE | DATUM | DATS | 8 | 0 | OIL-TSW: Event date | ||
54 | .INCLUDE | 0 | 0 | Meter Details in Ticket Item | |||||
55 | GMMNR | OII_GMMNR | OII_GMMNR | CHAR | 20 | 0 | GMM: Number of general meter | * | |
56 | O_ITMSTM | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
57 | O_METEV | OII_METEV | OII_METEV | CHAR | 2 | 0 | GMM: History record type | * | |
58 | C_ITMSTM | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
59 | C_METEV | OII_METEV | OII_METEV | CHAR | 2 | 0 | GMM: History record type | * | |
60 | STOPRDG | OII_ENCOUN | OII_MCOUNT | NUMC | 12 | 0 | GMM: End counter reading | ||
61 | STM_QUANTITY | OIJ_STM_QUANT | MENG13 | QUAN | 13 | 3 | Stop meter calculation Quantity | ||
62 | STM_UOM | OIJ_STM_UOM | MEINS | UNIT | 3 | 0 | Stop meter calculation UOM | * | |
63 | .INCLUDE | 0 | 0 | Tank details structure | |||||
64 | SOCNR | OII_SOCNR | OII_SOCNR | CHAR | 20 | 0 | SOC: Storage object characteristic segment number | * | |
65 | O_DIP_READ | OIJ_O_DIP_READ | MENGE | QUAN | 13 | 3 | Open dip reading | ||
66 | O_DIP_READ_UOM | OII_LENUN | MEINS | UNIT | 3 | 0 | Length UoM (Oil BDRP) | * | |
67 | O_ETMSTM | OIB_TMSTM | OII_TIMEST | NUMC | 14 | 0 | Tank dip time stamp | ||
68 | O_SOCEV | OIB_DIP_EVENTKEY | OIB_DIP_EVENTKEY | CHAR | 2 | 0 | Events in silo management tank dips | ||
69 | C_DIP_READ | OIJ_C_DIP_READ | MENGE | QUAN | 13 | 3 | Close Dip reading | ||
70 | C_DIP_READ_UOM | OII_LENUN | MEINS | UNIT | 3 | 0 | Length UoM (Oil BDRP) | * | |
71 | C_ETMSTM | OIB_TMSTM | OII_TIMEST | NUMC | 14 | 0 | Tank dip time stamp | ||
72 | C_SOCEV | OIB_DIP_EVENTKEY | OIB_DIP_EVENTKEY | CHAR | 2 | 0 | Events in silo management tank dips | ||
73 | STOPDIP | OII_TOTALHEIGHT | MENGE | QUAN | 13 | 3 | Tank dip, total height | ||
74 | STOPDIP_UOM | OII_LENUN | MEINS | UNIT | 3 | 0 | Length UoM (Oil BDRP) | * | |
75 | STP_GAU_QUAN | OIJ_STG_QUAN | MENG13 | QUAN | 13 | 3 | Stop gauge calculation - Quantity | ||
76 | STP_GAU_UOM | OIJ_STG_UOM | MEINS | UNIT | 3 | 0 | Stop gauge calculation UOM | * | |
77 | GAU_QUANTITY | OIJ_GAU_QUAN | MENG13 | QUAN | 13 | 3 | Calculated Gauge Quantity | ||
78 | GAU_UOM | OIJ_GAU_UOM | MEINS | UNIT | 3 | 0 | Gauge Calculation UoM | * | |
79 | SHTYPE | OIG_TDSTYP | OIG_TDSTYP | CHAR | 4 | 0 | TD shipment type | TOIGS | |
80 | VSTEL | VSTEL | VSTEL | CHAR | 4 | 0 | Shipping Point/Receiving Point | TVST | |
81 | CHARG_O | OIJ_CHARGO | CHARG | CHAR | 10 | 0 | Batch origin Location | MCH1 | |
82 | WERKS_O | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
83 | LGORT_O | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
84 | CHARG_D | OIJ_CHARGD | CHARG | CHAR | 10 | 0 | Batch destination Location | MCH1 | |
85 | WERKS_D | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
86 | LGORT_D | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
87 | TIME_ST_LOAD_STA | TMSTMP | CHAR14 | CHAR | 14 | 0 | Time at which data was created (date and time) | ||
88 | TIME_ST_LOAD_END | TMSTMP | CHAR14 | CHAR | 14 | 0 | Time at which data was created (date and time) | ||
89 | TIME_ST_LED_OT | TMSTMP | CHAR14 | CHAR | 14 | 0 | Time at which data was created (date and time) | ||
90 | CHARG_D_CREATE | OIJ_CHARG_D_C | XFELD | CHAR | 1 | 0 | Destination Batch create new flag | ||
91 | OIB_BLTIME | OIB_BLTIME | TIMES | TIMS | 6 | 0 | Posting time in the document | ||
92 | CHARG_L | OIJ_CHARGL | CHARG | CHAR | 10 | 0 | Batch load | * | |
93 | CHARG_L_CREATE | OIJ_CHARG_L_C | XFELD | CHAR | 1 | 0 | Load Batch create new flag | ||
94 | CARRIER | OIJ_CARRNR | LIFNR | CHAR | 10 | 0 | Transport system Carrier | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ROIJ_EL_TICKET_I | CHARG_D | MCH1 | CHARG | |||
2 | ROIJ_EL_TICKET_I | CHARG_O | MCH1 | CHARG | |||
3 | ROIJ_EL_TICKET_I | EVENTTYPE | OIJ_EL_EVT_TYPE | EVENTTYPE | |||
4 | ROIJ_EL_TICKET_I | LGORT_D | T001L | LGORT | |||
5 | ROIJ_EL_TICKET_I | LGORT_O | T001L | LGORT | |||
6 | ROIJ_EL_TICKET_I | LOCID | OIJLOC | LOCID | |||
7 | ROIJ_EL_TICKET_I | MANDT | T000 | MANDT | |||
8 | ROIJ_EL_TICKET_I | MATNR | MARA | MATNR | |||
9 | ROIJ_EL_TICKET_I | MEINS | T006 | MSEHI | |||
10 | ROIJ_EL_TICKET_I | MTTEH | T006 | MSEHI | |||
11 | ROIJ_EL_TICKET_I | MVSCENARIO | TOIJ_EL_MVSCEN | MVSCENARIO | |||
12 | ROIJ_EL_TICKET_I | NOMIT | OIJNOMI | NOMIT | |||
13 | ROIJ_EL_TICKET_I | NOMTK | OIJNOMH | NOMTK | |||
14 | ROIJ_EL_TICKET_I | SHTYPE | TOIGS | SHTYP | |||
15 | ROIJ_EL_TICKET_I | SITYP | TOIJ_EL_SITYPES | SITYP | |||
16 | ROIJ_EL_TICKET_I | TICKET_KEY | OIJ_EL_TICKET_H | TICKET_KEY | |||
17 | ROIJ_EL_TICKET_I | TSTEH | T006 | MSEHI | |||
18 | ROIJ_EL_TICKET_I | VEHICLE | OIGV | VEHICLE | |||
19 | ROIJ_EL_TICKET_I | VSTEL | TVST | VSTEL | |||
20 | ROIJ_EL_TICKET_I | WERKS_D | T001W | WERKS | |||
21 | ROIJ_EL_TICKET_I | WERKS_O | T001W | WERKS |
History
Last changed by/on | SAP | 20070914 |
SAP Release Created in | 46C |