RISA0 SAP (Serial Numbers Input/Output Table) Structure details

Dictionary Type: Structure
Description: Serial Numbers Input/Output Table




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




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
ANZAHLNumber of Serial Numbers/Pieces of Equipment to be Created ANZSERINT410CK_INT4
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
REFMAMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
REFSESerial Number GERNRCHAR18GERNRGERNRSER
SERNRSerial Number GERNRCHAR18GERNRGERNRSER
SERBISTo Serial Number SERBISCHAR18ALPHAGERNR
SERVONFrom Serial Number SERVONCHAR18ALPHAGERNR
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
INDUPDUpdate indicator (I/U/D) INDUPDCHAR1INDUPD
EQNUPDUpdate indicator (I/U/D) INDUPDCHAR1INDUPD
SERALTOld Serial Number SERALT1CHAR18ALPHAGERNR
SERNEUNew Serial Number SERNEU1CHAR18ALPHAGERNR
CURSOCursor Field when Choosing CURSOCHAR30CHAR30
STATEXTStatus Text STATEXT25CHAR25TEXT25
EQUPDIndicator: Create Equipment/Equipment Created EQUPDCHAR1CHAR1
SDBELNDelivery VBELN_VLCHAR10Assigned to domainALPHAVBELNVL
MBLNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
MATALTOld Material Number MATALT1CHAR18Assigned to domainMATN1MATNR
MATNEUNew Material Number MATNEU1CHAR18Assigned to domainMATN1MATNRMAT1
KORKZIndividual Object Configuration KORKZCHAR1X
KRFKZReferenced Configuration KRFKZCHAR1X
KOMATEConfigured Material KOMATECHAR18Assigned to domainMATN1MATNRMAT1
KOMWEPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
STATUSLINEStatus Line of Individualized Object EQSTTXTCHAR40TEXT40
TYMATConfigured Material KOMATECHAR18Assigned to domainMATN1MATNRMAT1
TYWERPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
RSNUMNumber of Reservation/Dependent Requirement RSNUMNUMC10Assigned to domainRSNUMRES
RSPOSItem Number of Reservation/Dependent Requirement RSPOSNUMC4RSPOSRPO
VBELNSales and Distribution Document Number VBELNCHAR10Assigned to domainALPHAVBELNAUN
POSNRItem number of the SD document POSNRNUMC6Assigned to domainPOSNR
REFOBKey of Object to be Classified CUOBNCHAR50CUOBNOJK
V_TO_STOCKManual Operation: To Stock TO_STOCKCHAR1X
V_OF_STOCKManual Operation: From Stock OF_STOCKCHAR1X
V_TO_CUSTManual Operation: To Customer TO_CUSTCHAR1X
V_OF_CUSTManual Operation: From Customer OF_CUSTCHAR1X
ANZSERGESNumber of serial numbers/pieces of equipment to be created ANZSERGESINT410CK_INT4
EBELNPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
BANFNPurchase Requisition Number BANFNCHAR10ALPHABANFNBANMBAN_C
BNFPOItem Number of Purchase Requisition BNFPONUMC5Assigned to domainBNFPOBAP
V_DEL_HUManual Operation: Delete Assignment to Handling Unit DEL_HUCHAR1X
V_DEL_INVManual Operation: Actively Delete Inventory DEL_INVCHAR1X
UIIUnique Item Identifier UII_CHAR72CHAR72UII_CHAR72UIIH_UII
UII_NEWUnique Item Identifier UII_CHAR72CHAR72UII_CHAR72UIIH_UII
IUID_TYPEStructure Type of UII IUID_TYPECHAR10Assigned to domainIUID_TYPEH_IUID_TYPE
UII_NUMNumber of UIIs UII_NUMINT410INT4
UII_NUMCNumber of UIIs Created UII_NUMCINT410INT4
UII_PLANTPlant Responsible for UII UII_PLANTCHAR4T001WWERKSWRKH_T001W_C
.INCLU--AP 0
V_SET_BUMPSet bump status for serial number /SAPHT/SW_SET_BUMPCHAR1X
V_DEL_BUMPReset bump status for serial number /SAPHT/SW_DEL_BUMPCHAR1X
V_SET_VCRSet version change status for return item /SAPHT/SW_SET_VCRCHAR1X
V_DEL_VCRReset status for version change return item /SAPHT/SW_DEL_VCRCHAR1X
V_SET_VCSSet version change status for sell item /SAPHT/SW_SET_VCSCHAR1X
V_DEL_VCSReset status for version change sell item /SAPHT/SW_DEL_VCSCHAR1X

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 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!