1. Home
  2. Resources
  3. SAP Tables
  4. RISA0 - Serial Numbers Input/Output Table

SAP Table RISA0

Serial Numbers Input/Output Table

RISA0 (Serial Numbers Input/Output Table) 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 RISA0 to other SAP tables.

RISA0 table fields

Field Data element Checktable Datatype Length Decimals
ANZAHL Number of Serial Numbers/Pieces of Equipment to be Created ANZSER INT4 10 0
MATNR Material Number MATNR CHAR 18 0
REFMA Material Number MATNR CHAR 18 0
REFSE Serial Number GERNR CHAR 18 0
SERNR Serial Number GERNR CHAR 18 0
SERBIS To Serial Number SERBIS CHAR 18 0
SERVON From Serial Number SERVON CHAR 18 0
BUKRS Company Code BUKRS CHAR 4 0
INDUPD Update indicator (I/U/D) INDUPD CHAR 1 0
I Add
U Change
D Delete
EQNUPD Update indicator (I/U/D) INDUPD CHAR 1 0
I Add
U Change
D Delete
SERALT Old Serial Number SERALT1 CHAR 18 0
SERNEU New Serial Number SERNEU1 CHAR 18 0
CURSO Cursor Field when Choosing CURSO CHAR 30 0
STATEXT Status Text STATEXT25 CHAR 25 0
EQUPD Indicator: Create Equipment/Equipment Created EQUPD CHAR 1 0
SDBELN Delivery VBELN_VL CHAR 10 0
MBLNR Number of Material Document MBLNR CHAR 10 0
MATALT Old Material Number MATALT1 CHAR 18 0
MATNEU New Material Number MATNEU1 CHAR 18 0
KORKZ Individual Object Configuration KORKZ CHAR 1 0
X Yes
NULL No
KRFKZ Referenced Configuration KRFKZ CHAR 1 0
X Yes
NULL No
KOMATE Configured Material KOMATE CHAR 18 0
KOMWE Plant WERKS_D T001W CHAR 4 0
STATUSLINE Status Line of Individualized Object EQSTTXT CHAR 40 0
TYMAT Configured Material KOMATE CHAR 18 0
TYWER Plant WERKS_D CHAR 4 0
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
RSPOS Item Number of Reservation/Dependent Requirement RSPOS NUMC 4 0
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
POSNR Item number of the SD document POSNR NUMC 6 0
REFOB Key of Object to be Classified CUOBN CHAR 50 0
V_TO_STOCK Manual Operation: To Stock TO_STOCK CHAR 1 0
X Yes
NULL No
V_OF_STOCK Manual Operation: From Stock OF_STOCK CHAR 1 0
X Yes
NULL No
V_TO_CUST Manual Operation: To Customer TO_CUST CHAR 1 0
X Yes
NULL No
V_OF_CUST Manual Operation: From Customer OF_CUST CHAR 1 0
X Yes
NULL No
ANZSERGES Number of serial numbers/pieces of equipment to be created ANZSERGES INT4 10 0
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
BANFN Purchase Requisition Number BANFN CHAR 10 0
BNFPO Item Number of Purchase Requisition BNFPO NUMC 5 0
V_DEL_HU Manual Operation: Delete Assignment to Handling Unit DEL_HU CHAR 1 0
X Yes
NULL No
V_DEL_INV Manual Operation: Actively Delete Inventory DEL_INV CHAR 1 0
X Yes
NULL No
UII Unique Item Identifier UII_CHAR72 CHAR 72 0
UII_NEW Unique Item Identifier UII_CHAR72 CHAR 72 0
IUID_TYPE Structure Type of UII IUID_TYPE CHAR 10 0
UII_NUM Number of UIIs UII_NUM INT4 10 0
UII_NUMC Number of UIIs Created UII_NUMC INT4 10 0
UII_PLANT Plant Responsible for UII UII_PLANT T001W CHAR 4 0

RISA0 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RISA0 KOMWE SYST MANDT T001W Plants/Branches MANDT
RISA0 KOMWE RISA0 KOMWE T001W Plants/Branches WERKS
RISA0 UII_PLANT SYST MANDT T001W Plants/Branches MANDT
RISA0 UII_PLANT RISA0 UII_PLANT T001W Plants/Branches WERKS