SAP ABAP Table RISERX1 (Structure for Serial Number History)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ IQSM (Package) Application Development R/3 Serial Numbers

Basic Data

Table Category	INTTAB	Structure
Structure	RISERX1	Table Relationship Diagram
Short Description	Structure for Serial Number History

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	I/O Table for Serial Number Headers SERXX
2	.INCLUDE	☐				0	0	Document Header for Serial Numbers for Delivery
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	OBKNR	☐	OBJKNR	OBJKN	INT4	10	0	Object list number	SER00
5	LIEF_NR	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
6	POSNR	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP
7	DATUM	☐	DATUM	DATUM	DATS	8	0	Date
8	LETZNR	☐	OBZAE	NUM4	NUMC	4	0	Counter key
9	KUNDE	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
10	ANZSN	☐	ANZSN	INT4	INT4	10	0	Number of serial numbers
11	VORGANG	☐	BELEG	BELEG	CHAR	4	0	Serialization Procedure for Serial Number Management	T377X
12	UZEIT	☐	UZEIT	UZEIT	TIMS	6	0	Time
13	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
14	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	*
15	.INCLU--AP	☐				0	0	High Tech extension SER01
16	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
17	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
18	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
19	LTSPS	☐	/SAPHT/SW_LTSPS	/SAPHT/SW_LTSPS	CHAR	1	0	Indicator : stockable type switched into standard product
20	LOKNZ	☐	LOEKNZ	XFELD	CHAR	1	0	Object list deletion indicator
21	DBKNZ	☐	DBKNZ	FLAG	CHAR	1	0	Data base indicator
22	SDAUFNR	☐	VBELN_VLA	VBELN	CHAR	10	0	Order	*
23	SD_AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	*
24	SD_POSTYP	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*
25	MSEGZN	☐	MSEGZN	MSEGZN	INT4	10	0	Counter for MSEG Serial Number Assignment
26	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	*
27	LIEFERANT	☐	ELIEF	LIFNR	CHAR	10	0	Vendor number	*
28	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
29	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
30	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
31	BLART	☐	BLART	BLART	CHAR	2	0	Document type	*
32	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
33	WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
34	LAGERORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
35	CHARGE	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
36	WAPOS	☐	WAPOS	POSNU	CHAR	16	0	Maintenance item
37	PMAUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
38	XAUTO	☐	XAUTO	XFELD	CHAR	1	0	Indicator: Line item automatically created
39	PREFETCH	☐	PREFT	FLAG	CHAR	1	0	Prefetch Indicator
40	PPAUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
41	PPPOSNR	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
42	PPAUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
43	PPAUFART	☐	AUFART	AUFART	CHAR	4	0	Order Type	*
44	PPWERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
45	PMRSORD	☐	RSORD	XFELD	CHAR	1	0	Refurbishment order indicator (PM)
46	VENUM	☐	VENUM	VENUM	CHAR	10	0	Internal Handling Unit Number	*
47	VEPOS	☐	VEPOS	VEPOS	NUMC	6	0	Handling Unit Item	*
48	EXIDV	☐	EXIDV	EXIDV	CHAR	20	0	External Handling Unit Identification
49	IBLNR	☐	IBLNR	BELNR	CHAR	10	0	Physical inventory document
50	ZEILI	☐	DZEILE	ZEILE	NUMC	3	0	Line Number
51	OLTPI	☐	OLTPI	OLTPI	CHAR	1	0	Object List Feature - Physical Inventory
52	BSTAR	☐	I_BSTAR	BSTAR	CHAR	1	0	Stock Type (Physical Inventory	*
53	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
54	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
55	ETENR	☐	EETEN	EETEN	NUMC	4	0	Delivery Schedule Line Counter	*
56	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
57	BSART	☐	ESART	BSART	CHAR	4	0	Purchasing Document Type	*
58	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
59	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
60	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	*
61	LOEKZ	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
62	STAPO	☐	STAPO	XFELD	CHAR	1	0	Item is statistical
63	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
64	IHNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	*
65	BAUTL	☐	BAUTL	MATNR	CHAR	18	0	Assembly	*
66	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	*
67	SORTF	☐	OBSORT	CHAR20	CHAR	20	0	Object list sort field
68	BEARB	☐	BEARBZS	BEARB	CHAR	1	0	Processing indicator
69	OBJVW	☐	OBJVW	OBJVW	CHAR	1	0	Object list usage
70	SERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
71	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
72	EQSNR	☐	EQSNR	EQSNR	CHAR	18	0	EQSE Number	*
73	TASER	☐	TASER	TASER	CHAR	5	0	Table for Serial Numbers
74	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	*
75	INST_DISM	☐	INST_DISM	XCHAR	CHAR	1	0	Install/Dismantle
76	UII	☐	UII_CHAR72	UII_CHAR72	CHAR	72	0	Unique Item Identifier
77	IUID_TYPE	☐	IUID_TYPE	IUID_TYPE	CHAR	10	0	Structure Type of UII	*
78	UII_PLANT	☐	UII_PLANT	WERKS	CHAR	4	0	Plant Responsible for UII	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RISERX1	KUNDE	KNA1	KUNNR
2	RISERX1	LAGERORT	T001L	LGORT
3	RISERX1	LIEF_NR	VBUK	VBELN
4	RISERX1	MANDT	T000	MANDT
5	RISERX1	OBKNR	SER00	OBKNR
6	RISERX1	POSNR	VBUP	POSNR
7	RISERX1	VORGANG	T377X	BELEG
8	RISERX1	WERK	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in