M_OIJTF SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




ABAP Code to SELECT data from M_OIJTF
Related tables to M_OIJTF
Access table M_OIJTF




Table View field list including key, data, relationships and ABAP select examples

M_OIJTF is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The M_OIJTF table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include TICKETNR (OIL-TSW: External ticket number), LOCID (Location ID), TKT_YEAR (Fiscal Year), TKT_MONTH (Calendar month).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP M_OIJTF table view fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
TICKETNROIL-TSW: External ticket number OIJ_TKTNRCHAR20ALPHAOIJ_TKTNROIU
LOCIDLocation ID OIJ_LOCIDCHAR10OIJLOCOIJ_LOCIDOIX
TKT_YEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
TKT_MONTHCalendar month OIJ_MONTHNUMC2AM_MONAT
NOMNRNomination number OIJ_NOMNRCHAR20OIJ_NOMNROIO
STATUSNomination Item status OIJ_ISTATCHAR1OIJSTATOIJ_ISTAT
SUBSTATUSNomination Item sub-status OIJ_SSTATCHAR1OIJSUBSTATOIJ_SSTAT
TKTSUBRCOIL-TSW: Ticket process return code OIJ_TKTRCCHAR2OIJ_TKTRC
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERZEITTime of creation OI0_ERTIMTIMS6UZEIT
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
AEZEITTime of day the record was changed OI0_AETIMTIMS6UZEIT
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
BLOINDBlocking indicator OIJ_BLOINDCHAR1XFELD
DELINDDeletion indicator OIJ_DELINDCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table M_OIJTF using ABAP code

The following ABAP code Example will allow you to do a basic selection on M_OIJTF to SELECT all data from the table
DATA: WA_M_OIJTF TYPE M_OIJTF.

SELECT SINGLE *
FROM M_OIJTF
INTO CORRESPONDING FIELDS OF WA_M_OIJTF
WHERE...

How to access SAP table M_OIJTF

Within an ECC or HANA version of SAP you can also view further information about M_OIJTF and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!