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