SAP ABAP Table AFRUI (PSIS - Individual Overviews: Confirmations)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PS-IS-REP-LOG (Application Component) Logistics
     ⤷ PSIS_SINGLE (Package) PS Logistic Overview: Single Overview'

Basic Data

Table Category	INTTAB	Structure
Structure	AFRUI	Table Relationship Diagram
Short Description	PSIS - Individual Overviews: Confirmations

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	Order Confirmation Structure for Project Reporting
2	ARNUMMER	☐	ADMI_RUN_D	ADMI_RUN	CHAR	6	0	Archiving Session Number
3	VSGRUPPE	☐	VSGRUPPE	TEXT20	CHAR	20	0	Group for a project version
4	VSNUMMER	☐	VSNMR	VSNMR	CHAR	12	0	Number or description of a version
5	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
6	PRNAM	☐	IM_PRNAM	IM_PRNAM	CHAR	8	0	Investment program name	IMTP
7	PRPOS	☐	IM_POSID	IM_POSID	CHAR	24	0	Identification for an investment program position
8	PSPID	☐	PS_PSPID	PS_PSPID	CHAR	24	0	Project definition
9	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
10	KDAUF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
11	KDPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
12	AUFNR	☐	AUF_NETNR	AUFNR	CHAR	12	0	Order/Network number	AUFK
13	VORNR	☐	CN_VORNR	VORNR	CHAR	4	0	Activity number in network and standard network
14	UVORN	☐	CN_ELEMENT	VORNR	CHAR	4	0	Activity element number (work/external/general costs)
15	RUECK	☐	CO_RUECK	CO_RUECK	NUMC	10	0	Completion confirmation number for the operation
16	RMZHL	☐	CO_RMZHL	CIM_COUNT	NUMC	8	0	Confirmation counter
17	AUTYPTXT	☐	AUTYPTEXT	TEXT40	CHAR	40	0	Display field for order category description
18	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
19	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
20	LAEDA	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
21	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
22	BUDAT	☐	BUCHDATUM	DATUM	DATS	8	0	Posting date
23	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
24	ARBTXT	☐	PS_ARBTEXT	TEXT40	CHAR	40	0	Short text for the CIM operating resource
25	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
26	LTXA1	☐	CO_RTEXT	TEXT40	CHAR	40	0	Confirmation text
27	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
28	ABARB	☐	CO_ABARB	CO_ABARB	NUMC	3	0	Confirmation: Degree of processing
29	ISMNW	☐	PS_IARBEI_VZ	PS_ARBEIT_VZ	QUAN	13	3	Actual work
30	ISMNE	☐	ARBEITE	MEINS	UNIT	3	0	Unit for work	T006
31	LEARR	☐	LEARR	LSTAR	CHAR	6	0	Activity type for confirmation	CSLA
32	IDAUR	☐	PS_IDAUER_VZ	PS_DAUER_VZ	QUAN	10	1	Actual duration
33	IDAUE	☐	IDAURE	MEINS	UNIT	3	0	Unit for actual duration	T006
34	GRUND	☐	CO_AGRND	CO_AGRND	CHAR	4	0	Reason for Variance	TRUG
35	PERNR	☐	CO_PERNR	PERNR	NUMC	8	0	Personnel number
36	PERTXT	☐	EMNAM	TEXT40	CHAR	40	0	Formatted Name of Employee or Applicant
37	ISDD	☐	ISDD	DATUM	DATS	8	0	Actual start: Execution (date)
38	ISDZ	☐	ISDZ	ATIME	TIMS	6	0	Actual start: Execution/setup (time)
39	IEDD	☐	IEDD	DATUM	DATS	8	0	Actual finish: Execution (date)
40	IEDZ	☐	IEDZ	ATIME	TIMS	6	0	Actual finish: Execution (time)
41	PEDD	☐	CO_PEDD	DATUM	DATS	8	0	Forecast finish date of operation from confirmation
42	PEDZ	☐	CO_PEDZ	ATIME	TIMS	6	0	Forecast finish time of operation from confirmation
43	AUERU	☐	AUERU	AUERU_VS	CHAR	1	0	Activation of Final Confirmation
44	MANUR	☐	MANUR	MANUR	CHAR	1	0	Indicator for type of confirmation
45	OFMNW	☐	PS_RARBEI_VZ	PS_ARBEIT_VZ	QUAN	13	3	Remaining work
46	OFMNE	☐	ARBEITE	MEINS	UNIT	3	0	Unit for work	T006
47	LEKNW	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
48	ODAUR	☐	PS_RDAUER_VZ	PS_DAUER_VZ	QUAN	10	1	Remaining duration
49	ODAUE	☐	ODAUE	MEINS	UNIT	3	0	Unit for remaining duration	T006
50	STOKZ	☐	CO_STOKZ	FLAG	CHAR	1	0	Indicator: Document Has Been Reversed
51	STZHL	☐	CO_STZHL	CIM_COUNT	NUMC	8	0	Confirmation counter of cancelled confirmation
52	KAPNM	☐	KAPNAME	KAPNAME	CHAR	8	0	Capacity name
53	KAPTXT	☐	KAPTEXT	TEXT40	CHAR	40	0	Capacity short text
54	KAPAR	☐	KAPART	KAPART	CHAR	3	0	Capacity category	TC26
55	KAPARTXT	☐	KAPARTTEXT	TEXT20	CHAR	20	0	Description of the capacity category
56	SPLIT	☐	CY_SPLIT	INT1	INT1	3	0	Split number
57	ZAUSW	☐	DZAUSW	ZAUSW	NUMC	8	0	Time Recording ID Number
58	CATSBELNR	☐	CATSBELNR	BELNR	CHAR	10	0	Document number
59	CATSPRICE	☐	CATSPRICE	WERTV6	CURR	11	2	Price in Transaction Currency
60	CATSTCURR	☐	TWAER	WAERS	CUKY	5	0	Transaction Currency	*
61	CATSPEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
62	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	TBMOT
63	IPRZ1	☐	RU_IPRZS	MENGV13	QUAN	13	3	Current quantity to be confirmed for the business process
64	IPRE1	☐	RU_IPRZE	MEINS	UNIT	3	0	Unit of measurement for conf. quantity for business process	T006
65	IPRK1	☐	RU_IPRZK	XFELD	CHAR	1	0	No remaining quantity expected for business process
66	PRZ01	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	*
67	OPRZ1	☐	OPRZ1	MENGV13	QUAN	13	3	Remaining quantity for business process
68	OPRE1	☐	OPRE1	MEINS	UNIT	3	0	Unit for remaining quantity of business process	T006
69	SKOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
70	SKOSTL	☐	SKOSTL	KOSTL	CHAR	10	0	Sender Cost Center	*
71	ISMNU	☐	ARBEITE	MEINS	UNIT	3	0	Unit for work	*
72	OFMNU	☐	ARBEITE	MEINS	UNIT	3	0	Unit for work	*
73	INT_ID	☐	OBJEKT_ID	CHAR30	CHAR	30	0	ID/Object key
74	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
75	APLZL	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	*
76	KAPID	☐	KAPID	KAPID	NUMC	8	0	Capacity ID	*
77	CANUM	☐	CY_COUNT	CY_COUNT	NUMC	4	0	Counters for cap. rqmts. records (various caps. + indiv.caps	*
78	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
79	ARBID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
80	KALID	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	*
81	LIGHT	☐	LVC_EXLED	CHAR1	CHAR	1	0	ALV control: Exception as LED

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AFRUI	AUFNR	AUFK	AUFNR	REF	C	CN
2	AFRUI	BEMOT	TBMOT	BEMOT
3	AFRUI	GRUND	TRUG	GRUND	REF	C	CN
4	AFRUI	IDAUE	T006	MSEHI	REF	1	CN
5	AFRUI	IPRE1	T006	MSEHI
6	AFRUI	ISMNE	T006	MSEHI	REF	1	CN
7	AFRUI	KAPAR	TC26	KAPAR	REF	C	CN
8	AFRUI	KDAUF	VBUK	VBELN	REF	C	CN
9	AFRUI	KDPOS	VBUP	POSNR	REF	C	CN
10	AFRUI	LEARR	CSLA	LSTAR	REF	C	CN
11	AFRUI	ODAUE	T006	MSEHI	REF	1	CN
12	AFRUI	OFMNE	T006	MSEHI	REF	1	CN
13	AFRUI	OPRE1	T006	MSEHI
14	AFRUI	PRCTR	CEPC	PRCTR	REF	C	CN
15	AFRUI	PRNAM	IMTP	PRNAM			CN
16	AFRUI	TXTSP	T002	SPRAS	REF	C	CN
17	AFRUI	WERKS	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	50A