SAP Table ROIJNMDOCF

OIL-TSW: Structure for Document Flow

ROIJNMDOCF (OIL-TSW: Structure for Document Flow) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ROIJNMDOCF to other SAP tables.

ROIJNMDOCF table fields

Field Data element Checktable Datatype Length Decimals
TICKETNR OIL-TSW: External ticket number OIJ_TKTNR CHAR 20 0
LOCID Location ID OIJ_LOCID CHAR 10 0
TKT_YEAR Fiscal Year GJAHR NUMC 4 0
TKT_MONTH Calendar month OIJ_MONTH NUMC 2 0
01 January
02 February
03 March
04 April
05 May
06 June
07 July
08 August
09 September
10 October
11 November
12 December
CARRIER Transport system Carrier OIJ_CARRNR CHAR 10 0
SHIPPER Shipper OIJ_SHIPNR CHAR 10 0
MENGE Scheduled qty OIJ_MENGE QUAN 13 3
MEINS Base Unit of Measure MEINS UNIT 3 0
END_DATE Date DATUM DATS 8 0
STATUSTEXT OIL-TSW : Display of status text OIJ_STTXT CHAR 10 0
DELIND Deletion indicator OIJ_DELIND CHAR 1 0
X Yes
NULL No
TKTSUBRC OIL-TSW: Ticket process return code OIJ_TKTRC CHAR 2 0
00 Ticket Actualization Process Completed
01 Nomination not found
02 Nomination item not found
03 Wrong Carrier
04 Carrier not found
05 Wrong Shipper
06 Shipper not found
07 Wrong Tankage
08 Tankage not found
09 Wrong Consignee
10 Consignee not found
11 Nomination Item Status Rejected
12 Nomination Item Status Complete
13 Nomination Item: Confirmation missing
14 Posting of ticket quantity would exceed scheduled quantitiy
15 Wrong Transport System
16 Transport system not found
17 Wrong Location
18 Location not found
19 Wrong Purchase order
20 Purchase Order: Item number missing
21 Purchase order: Item quantity exceeds tolerance
22 Wrong Sales order
23 Sales order: Item number missing
24 Sales order: Item quantity exceeds tolerance
25 Error while Posting Shipping Notification
26 Error while Creating Shipment
27 Load confirmation posted
28 Reservation posted
29 Ticket: Nomination Number missing
30 Nomination Number not unique
31 Nomination Item not unique
32 Nomination Item: Copy not unique
33 Nomination Item: SITYP missing
34 Nomination Item: Wrong SITYP
35 Material Number missing
36 Wrong Material Number
37 Ticket: Quantity missing
38 Movement Scenario not found
39 Unit of Measure missing
40 Ticket: End Date missing
41 TD vehicle number missing in nomination
42 TD shipment Type missing in nomination
43 TD Transportation planning point missing in nomination
44 Plant and Storage Location for movement destination missing
45 Unit Conversion: required Fields not filled
46 Unit Conversion: Default values for material not found
47 Unit Conversion: Calculation Error
48 Other uncomplete similar Ticket found: complete this first
49 Plant and Storage Location for movement origin missing
50 Ticket saved - no validation performed
51 Error occurred in carrier ticket customer function.
52 Error while Posting Load Confirmation
53 Error while Posting Reservation
54 Error while Posting Delivery
55 Error while Posting Delivery Confirmation
56 Error while Update Nomination (Act. Qty.)
57 Error while Changing Shipment
58 Shipping notification posted
59 Shipment posted
60 Delivery posted
61 Delivery Confirmation posted
62 Nomination updated
63 Shipment Change posted
64 Sales Order : Shipping Point missing
65 Failure while Locking Nomination
69 Posting Date is not valid
70 Cannot actualize a ticket for a future date or time.
71 Purchase Order : Del. Date < Ticket End Date
72 Sales Order : Del. Date > Ticket End Date
73 Error while Posting Goods Receipt
74 Error while Posting Billing Document
75 Error while Create Ticket : Duplicate Record found
76 Error while actualizing. For details look up error log.
77 Nomination/Item currently locked by other user
78 Partially posted
80 Error while validating. For details look up error log.
87 Error while updating database table
95 Validation failed
96 Ticket abandonned by user
98 Ticket Validated and Saved
99 Initial
1A Ticket corrupted
STATUS Nomination Item status OIJ_ISTAT CHAR 1 0
1 Planned
2 Scheduled
3 Accepted
4 Confirmed
5 Partially complete
6 Complete
7 Rejected
8 Dummy
9 Received
A Sent
B Checked
C Processed
SUBSTATUS Nomination Item sub-status OIJ_SSTAT CHAR 1 0
1 Original
2 2nd run
3 3rd run
4 Positive
5 Negative
6 Complete
7 Part1
8 Part2
9 Part3
A Partially complete
B Complete
C Planned
D Scheduled
E Confirmed
F Rejected
NOMNR Nomination number OIJ_NOMNR CHAR 20 0