RISA0 SAP (Serial Numbers Input/Output Table) Structure details
Description: Serial Numbers Input/Output Table
Structure field list including key, data, relationships and ABAP select examples
RISA0 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Serial Numbers Input/Output Table" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_RISA0 TYPE RISA0.
The RISA0 table consists of various fields, each holding specific information or linking keys about Serial Numbers Input/Output Table data available in SAP. These include MATNR (Material Number), REFMA (Material Number), REFSE (Serial Number), SERNR (Serial Number).. 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: Can be enhanced (character-type or numeric)
SAP RISA0 structure 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 |
ANZAHL | Number of Serial Numbers/Pieces of Equipment to be Created | ANZSER | INT4 | 10 | CK_INT4 | ||||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
REFMA | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
REFSE | Serial Number | GERNR | CHAR | 18 | GERNR | GERNR | SER | ||
SERNR | Serial Number | GERNR | CHAR | 18 | GERNR | GERNR | SER | ||
SERBIS | To Serial Number | SERBIS | CHAR | 18 | ALPHA | GERNR | |||
SERVON | From Serial Number | SERVON | CHAR | 18 | ALPHA | GERNR | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
INDUPD | Update indicator (I/U/D) | INDUPD | CHAR | 1 | INDUPD | ||||
EQNUPD | Update indicator (I/U/D) | INDUPD | CHAR | 1 | INDUPD | ||||
SERALT | Old Serial Number | SERALT1 | CHAR | 18 | ALPHA | GERNR | |||
SERNEU | New Serial Number | SERNEU1 | CHAR | 18 | ALPHA | GERNR | |||
CURSO | Cursor Field when Choosing | CURSO | CHAR | 30 | CHAR30 | ||||
STATEXT | Status Text | STATEXT25 | CHAR | 25 | TEXT25 | ||||
EQUPD | Indicator: Create Equipment/Equipment Created | EQUPD | CHAR | 1 | CHAR1 | ||||
SDBELN | Delivery | VBELN_VL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VL | |
MBLNR | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
MATALT | Old Material Number | MATALT1 | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
MATNEU | New Material Number | MATNEU1 | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT1 | |
KORKZ | Individual Object Configuration | KORKZ | CHAR | 1 | X | ||||
KRFKZ | Referenced Configuration | KRFKZ | CHAR | 1 | X | ||||
KOMATE | Configured Material | KOMATE | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT1 | |
KOMWE | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
STATUSLINE | Status Line of Individualized Object | EQSTTXT | CHAR | 40 | TEXT40 | ||||
TYMAT | Configured Material | KOMATE | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT1 | |
TYWER | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
RSNUM | Number of Reservation/Dependent Requirement | RSNUM | NUMC | 10 | Assigned to domain | RSNUM | RES | ||
RSPOS | Item Number of Reservation/Dependent Requirement | RSPOS | NUMC | 4 | RSPOS | RPO | |||
VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
POSNR | Item number of the SD document | POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
REFOB | Key of Object to be Classified | CUOBN | CHAR | 50 | CUOBN | OJK | |||
V_TO_STOCK | Manual Operation: To Stock | TO_STOCK | CHAR | 1 | X | ||||
V_OF_STOCK | Manual Operation: From Stock | OF_STOCK | CHAR | 1 | X | ||||
V_TO_CUST | Manual Operation: To Customer | TO_CUST | CHAR | 1 | X | ||||
V_OF_CUST | Manual Operation: From Customer | OF_CUST | CHAR | 1 | X | ||||
ANZSERGES | Number of serial numbers/pieces of equipment to be created | ANZSERGES | INT4 | 10 | CK_INT4 | ||||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
BANFN | Purchase Requisition Number | BANFN | CHAR | 10 | ALPHA | BANFN | BAN | MBAN_C | |
BNFPO | Item Number of Purchase Requisition | BNFPO | NUMC | 5 | Assigned to domain | BNFPO | BAP | ||
V_DEL_HU | Manual Operation: Delete Assignment to Handling Unit | DEL_HU | CHAR | 1 | X | ||||
V_DEL_INV | Manual Operation: Actively Delete Inventory | DEL_INV | CHAR | 1 | X | ||||
UII | Unique Item Identifier | UII_CHAR72 | CHAR | 72 | UII_CHAR72 | UII | H_UII | ||
UII_NEW | Unique Item Identifier | UII_CHAR72 | CHAR | 72 | UII_CHAR72 | UII | H_UII | ||
IUID_TYPE | Structure Type of UII | IUID_TYPE | CHAR | 10 | Assigned to domain | IUID_TYPE | H_IUID_TYPE | ||
UII_NUM | Number of UIIs | UII_NUM | INT4 | 10 | INT4 | ||||
UII_NUMC | Number of UIIs Created | UII_NUMC | INT4 | 10 | INT4 | ||||
UII_PLANT | Plant Responsible for UII | UII_PLANT | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
.INCLU--AP | 0 | ||||||||
V_SET_BUMP | Set bump status for serial number | /SAPHT/SW_SET_BUMP | CHAR | 1 | X | ||||
V_DEL_BUMP | Reset bump status for serial number | /SAPHT/SW_DEL_BUMP | CHAR | 1 | X | ||||
V_SET_VCR | Set version change status for return item | /SAPHT/SW_SET_VCR | CHAR | 1 | X | ||||
V_DEL_VCR | Reset status for version change return item | /SAPHT/SW_DEL_VCR | CHAR | 1 | X | ||||
V_SET_VCS | Set version change status for sell item | /SAPHT/SW_SET_VCS | CHAR | 1 | X | ||||
V_DEL_VCS | Reset status for version change sell item | /SAPHT/SW_DEL_VCS | CHAR | 1 | X |
Key field | Non-key field |
How do I retrieve data from SAP structure RISA0 using ABAP code?
As RISA0 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on RISA0 as there is no data to select.How to access SAP table RISA0
Within an ECC or HANA version of SAP you can also view further information about RISA0 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