1. Home
  2. Resources
  3. SAP Tables
  4. M_OIJCC_NEW - Generated Table for View

SAP Table M_OIJCC_NEW

Generated Table for View

M_OIJCC_NEW (Generated Table for View) 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 M_OIJCC_NEW to other SAP tables.

M_OIJCC_NEW table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
NOMTK Nomination (technical) Key OIJ_NOMTK CHAR 20 0
NOMNR Nomination number OIJ_NOMNR CHAR 20 0
TICKETNR OIL-TSW: External ticket number OIJ_TKTNR CHAR 20 0
TICKET_KEY OIL-TSW: Ticket key OIJ_EL_TKT_KEY OIJ_EL_TICKET_H CHAR 20 0
TICKET_ITEM OIL-TSW: Ticket item number OIJ_EL_TKT_POSNR NUMC 6 0
TICKET_VERSION OIL-TSW: Ticket version OIJ_EL_TKT_VERSION NUMC 3 0
TICKET_PURPOSE OIL-TSW: Ticket Purpose OIJ_EL_TKT_PURPOSE CHAR 1 0
1 Field ticket
2 Correction
3 Final confirmation
4 Internally generated for posting
5 Reversal
LOCID Location ID OIJ_LOCID OIJLOC CHAR 10 0
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
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
NOMIT Nomination Key Item OIJ_ITEM OIJNOMI NUMC 10 0
SITYP Schedule type OIJ_SITYP TOIJ_EL_SITYPES CHAR 2 0
MVSCENARIO TSW: Movement scenario number OIJ_MVSCEN TOIJ_EL_MVSCEN NUMC 2 0
CARRIER Transport system Carrier OIJ_CARRNR CHAR 10 0
SHIPPER Shipper OIJ_SHIPNR CHAR 10 0
SHTYPE TD shipment type OIG_TDSTYP TOIGS CHAR 4 0
TPLST Transportation planning point TPLST TTDS CHAR 4 0
TSYST Transport system OIJ_TSYST OIJTS CHAR 10 0
MENGE Scheduled qty OIJ_MENGE QUAN 13 3
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
MATNR Material Number MATNR MARA CHAR 18 0
WERKS_O Plant WERKS_D T001W CHAR 4 0
LGORT_O Storage Location LGORT_D T001L CHAR 4 0
WERKS_D Plant WERKS_D T001W CHAR 4 0
LGORT_D Storage Location LGORT_D T001L CHAR 4 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
BLOIND Blocking indicator OIJ_BLOIND CHAR 1 0
X Yes
NULL No
DELIND Deletion indicator OIJ_DELIND CHAR 1 0
X Yes
NULL No

M_OIJCC_NEW foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
M_OIJCC_NEW LGORT_D M_OIJCC_NEW MANDT T001L Storage Locations MANDT
M_OIJCC_NEW LGORT_D M_OIJCC_NEW WERKS_D T001L Storage Locations WERKS
M_OIJCC_NEW LGORT_D M_OIJCC_NEW LGORT_D T001L Storage Locations LGORT
M_OIJCC_NEW LGORT_O M_OIJCC_NEW WERKS_O T001L Storage Locations WERKS
M_OIJCC_NEW LGORT_O M_OIJCC_NEW LGORT_O T001L Storage Locations LGORT
M_OIJCC_NEW LGORT_O M_OIJCC_NEW MANDT T001L Storage Locations MANDT
M_OIJCC_NEW LOCID M_OIJCC_NEW MANDT OIJLOC Location table MANDT
M_OIJCC_NEW LOCID M_OIJCC_NEW LOCID OIJLOC Location table LOCID
M_OIJCC_NEW MANDT M_OIJCC_NEW MANDT T000 Clients MANDT
M_OIJCC_NEW MATNR M_OIJCC_NEW MANDT MARA General Material Data MANDT
M_OIJCC_NEW MATNR M_OIJCC_NEW MATNR MARA General Material Data MATNR
M_OIJCC_NEW MEINS M_OIJCC_NEW MANDT T006 Units of Measurement MANDT
M_OIJCC_NEW MEINS M_OIJCC_NEW MEINS T006 Units of Measurement MSEHI
M_OIJCC_NEW MVSCENARIO M_OIJCC_NEW MANDT TOIJ_EL_MVSCEN TSW: Define Movement scenarios CLIENT
M_OIJCC_NEW MVSCENARIO M_OIJCC_NEW MVSCENARIO TOIJ_EL_MVSCEN TSW: Define Movement scenarios MVSCENARIO
M_OIJCC_NEW NOMIT M_OIJCC_NEW MANDT OIJNOMI Nomination Item MANDT
M_OIJCC_NEW NOMIT M_OIJCC_NEW NOMTK OIJNOMI Nomination Item NOMTK
M_OIJCC_NEW NOMIT M_OIJCC_NEW NOMIT OIJNOMI Nomination Item NOMIT
M_OIJCC_NEW SHTYPE M_OIJCC_NEW MANDT TOIGS TD Shipment Types CLIENT
M_OIJCC_NEW SHTYPE M_OIJCC_NEW SHTYPE TOIGS TD Shipment Types SHTYP
M_OIJCC_NEW SITYP M_OIJCC_NEW MANDT TOIJ_EL_SITYPES TSW: Define valid sitypes CLIENT
M_OIJCC_NEW SITYP M_OIJCC_NEW SITYP TOIJ_EL_SITYPES TSW: Define valid sitypes SITYP
M_OIJCC_NEW TICKET_KEY M_OIJCC_NEW TICKET_PURPOSE OIJ_EL_TICKET_H Universal ticket table TICKET_PURPOSE
M_OIJCC_NEW TICKET_KEY M_OIJCC_NEW MANDT OIJ_EL_TICKET_H Universal ticket table MANDT
M_OIJCC_NEW TICKET_KEY M_OIJCC_NEW TICKET_KEY OIJ_EL_TICKET_H Universal ticket table TICKET_KEY
M_OIJCC_NEW TICKET_KEY M_OIJCC_NEW TICKET_VERSION OIJ_EL_TICKET_H Universal ticket table TICKET_VERSION
M_OIJCC_NEW TPLST M_OIJCC_NEW MANDT TTDS Organizational Unit: Transportation Scheduling Point MANDT
M_OIJCC_NEW TPLST M_OIJCC_NEW TPLST TTDS Organizational Unit: Transportation Scheduling Point TPLST
M_OIJCC_NEW TSYST M_OIJCC_NEW MANDT OIJTS Transport system (IS-Oil TSW standard/core object ) MANDT
M_OIJCC_NEW TSYST M_OIJCC_NEW TSYST OIJTS Transport system (IS-Oil TSW standard/core object ) TSYST
M_OIJCC_NEW WERKS_D M_OIJCC_NEW MANDT T001W Plants/Branches MANDT
M_OIJCC_NEW WERKS_D M_OIJCC_NEW WERKS_D T001W Plants/Branches WERKS
M_OIJCC_NEW WERKS_O M_OIJCC_NEW WERKS_O T001W Plants/Branches WERKS
M_OIJCC_NEW WERKS_O M_OIJCC_NEW MANDT T001W Plants/Branches MANDT