SAP ABAP Table AFRUR (Order Confirmation Structure for Project Reporting)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PS-IS (Application Component) Information System
     ⤷ CNIS (Package) Application development R/3 PS information system

Basic Data

Table Category	INTTAB	Structure
Structure	AFRUR	Table Relationship Diagram
Short Description	Order Confirmation Structure for Project Reporting

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in