OIU_CM_SN_NR SAP (Number ranges by table names) Table details
Description: Number ranges by table names
Table field list including key, data, relationships and ABAP select examples
OIU_CM_SN_NR is a standard SAP Table which is used to store Number ranges by table names data and is available within R/3 SAP systems depending on the version and release level.
The OIU_CM_SN_NR table consists of various fields, each holding specific information or linking keys about Number ranges by table names data available in SAP. These include EXTERNIND (Internal (' ') or external ('X') number range flag), NR_OBJECT (Name of number range object), SYSTEM_NRIV (System Number Range Interval Flag), SUGGESTED_FROM (System Number Range Interval Suggested From Value).. 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: S - System table, maint. only by SAP, change = modificationDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
Text table = OIUCM_SN_NR_T
SAP OIU_CM_SN_NR table 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 |
TABNAME | Logical Table Name | OIU_VLTABNAME | CHAR | 30 | OIU_VLTAB | ||||
EXTERNIND | Internal (' ') or external ('X') number range flag | NRIND | CHAR | 1 | XFELD | ||||
NR_OBJECT | Name of number range object | NROBJ | CHAR | 10 | TNRO | NROBJ | |||
SYSTEM_NRIV | System Number Range Interval Flag | OIUCM_SYSTEM_NRIV | CHAR | 1 | YESNO | ||||
SUGGESTED_FROM | System Number Range Interval Suggested From Value | OIUCM_SYSTEM_NRIV_SUGGESTED_FR | CHAR | 20 | CHAR20 | ||||
SUGGESTED_TO | System Number Range Interval Suggested To Value | OIUCM_SYSTEM_NRIV_SUGGESTED_TO | CHAR | 20 | CHAR20 | ||||
CONDITIONAL | Conditional Check For System Entries | OIUCM_CONDITIONAL | CHAR | 1 | YESNO | ||||
COND_PROGRAM | Program To Execute During Number Range Check | OIUCM_CONDITIONAL_PROGRAM | CHAR | 40 | TRDIR | PROGNAME | |||
COND_FORM | Program Form To Execute During Number Range Check | OIUCM_CONDITIONAL_PROGRAM_FORM | CHAR | 30 | |||||
IMG_SUBOBJECT | IMG Activity Subobject | OIUCM_IMG_ACTIVITY_SUBOBJECT | CHAR | 10 | Assigned to domain | OB_SUBOBJ |
Key field | Non-key field |
How do I retrieve data from SAP table OIU_CM_SN_NR using ABAP code
The following ABAP code Example will allow you to do a basic selection on OIU_CM_SN_NR to SELECT all data from the tableDATA: WA_OIU_CM_SN_NR TYPE OIU_CM_SN_NR.
SELECT SINGLE *
FROM OIU_CM_SN_NR
INTO CORRESPONDING FIELDS OF WA_OIU_CM_SN_NR
WHERE...
How to access SAP table OIU_CM_SN_NR
Within an ECC or HANA version of SAP you can also view further information about OIU_CM_SN_NR and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects