SAP ABAP Table RIQS4 (Notifications/orders interface for ILOA update)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSE (Application Component) Mobile Service
     ⤷ IWOC (Package) Application Development R/3 Work Order Cycle

Basic Data

Table Category	INTTAB	Structure
Structure	RIQS4	Table Relationship Diagram
Short Description	Notifications/orders interface for ILOA update

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	OBJNR	☐	QMOBJNR	J_OBJNR	CHAR	22	0	Object Number for Status Management	*
2	AEKNZ	☐	AEKNZ	FLAG	CHAR	1	0	Change indicator
3	.INCLUDE	☐				0	0	PM Object Location and Account Assignment
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	*
6	.INCLUDE	☐				0	0	Data part location and account assignment for PM object
7	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
8	ABCKZ	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	T370C
9	ABCKZI	☐	INH_ABCKZI	INHER	CHAR	1	0	Data origin for ABC indicator field
10	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
11	EQFNRI	☐	INH_EQFNRI	INHER	CHAR	1	0	Data origin for sort field
12	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
13	SWERKI	☐	INH_SWERKI	INHER	CHAR	1	0	Data origin for maintenance plant field
14	STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	T499S
15	STORTI	☐	INH_STORTI	INHER	CHAR	1	0	Data origin for location field
16	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
17	MSGRPI	☐	INH_MSGRPI	INHER	CHAR	1	0	Data origin for room number field
18	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
19	BEBERI	☐	INH_BEBERI	INHER	CHAR	1	0	Data origin for company area field
20	CR_OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
21	PPSID	☐	PPSID	CR_OBJID	NUMC	8	0	Object ID of PP work center	CRID
22	PPSIDI	☐	INH_PPSIDI	INHER	CHAR	1	0	Data origin for PP work center field
23	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
24	GSBERI	☐	INH_GSBERI	INHER	CHAR	1	0	Data origin for business area field
25	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
26	KOKRSI	☐	INH_KOKRSI	INHER	CHAR	1	0	Data origin for controlling area field
27	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
28	KOSTLI	☐	INH_KOSTLI	INHER	CHAR	1	0	Data origin for cost center field
29	PROID	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
30	PROIDI	☐	INH_PROIDI	INHER	CHAR	1	0	Data origin for WBS element field
31	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
32	BUKRSI	☐	INH_BUKRSI	INHER	CHAR	1	0	Data origin for company code field
33	ANLNR	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
34	ANLNRI	☐	INH_ANLNRI	INHER	CHAR	1	0	Data origin for asset main no./sub-no. fields
35	ANLUN	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
36	ANLUNI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
37	DAUFN	☐	DAUFN	AUFNR	CHAR	12	0	Standing order number	AUFK
38	DAUFNI	☐	INH_DAUFNI	INHER	CHAR	1	0	Data origin of standing order number field
39	AUFNR	☐	ILOM_ORDST	AUFNR	CHAR	12	0	Settlement order	AUFK
40	AUFNRI	☐	INH_AUFNRI	INHER	CHAR	1	0	Data origin for settlement order field
41	TPLNRI	☐	INH_TPLNRI	INHER	CHAR	1	0	Data origin for functional location field
42	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
43	VKORGI	☐	INH_VKORGI	INHER	CHAR	1	0	Data origin for sales organization field
44	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
45	VTWEGI	☐	INH_VTWEGI	INHER	CHAR	1	0	Data origin of distribution channel field
46	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
47	SPARTI	☐	INH_SPARTI	INHER	CHAR	1	0	Data origin for division field
48	ADRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	ADRC
49	ADRNRI	☐	INH_ADRNRI	INHER	CHAR	1	0	Data origin for address field
50	OWNER	☐	ILOM_OWNER	ILOM_OWNER	CHAR	1	0	Object reference indicator
51	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
52	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
53	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RIQS4	ABCKZ	T370C	ABCKZ	REF	C	CN
2	RIQS4	ADRNR	ADRC	ADDRNUMBER	REF	1	CN
3	RIQS4	ANLNR	ANLH	ANLN1	REF	C	CN
4	RIQS4	ANLUN	ANLA	ANLN2	REF	C	CN
5	RIQS4	AUFNR	AUFK	AUFNR	REF	C	CN
6	RIQS4	BEBER	T357	BEBER	REF	C	CN
7	RIQS4	BUKRS	T001	BUKRS	REF	C	CN
8	RIQS4	DAUFN	AUFK	AUFNR	REF	C	CN
9	RIQS4	GSBER	TGSB	GSBER	REF	C	CN
10	RIQS4	KOKRS	TKA01	KOKRS	REF	C	CN
11	RIQS4	KOSTL	CSKS	KOSTL	REF	C	CN
12	RIQS4	MANDT	T000	MANDT	KEY	1	CN
13	RIQS4	PPSID	CRID	OBJID	REF	C	CN
14	RIQS4	PROID	PRPS	PSPNR		C	CN
15	RIQS4	SPART	TVTA	SPART	REF	1	CN
16	RIQS4	STORT	T499S	STAND	REF	C	CN
17	RIQS4	SWERK	T001W	WERKS	REF	1	CN
18	RIQS4	TPLNR	IFLOT	TPLNR	REF	C	CN
19	RIQS4	VKBUR	TVKBZ	VKBUR	REF	1	CN
20	RIQS4	VKGRP	TVBVK	VKGRP	REF	1	CN
21	RIQS4	VKORG	TVKO	VKORG	REF	1	CN
22	RIQS4	VTWEG	TVKOV	VTWEG	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in