SAP ABAP Table RECONST_ACT (Order Activity Structure for Project Reporting)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-CEP (Application Component) Collaborative Engineering and Project Management
     ⤷ RECONST (Package) Reconciliation for Structure Leveling

Basic Data

Table Category	INTTAB	Structure
Structure	RECONST_ACT	Table Relationship Diagram
Short Description	Order Activity 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	KDAUF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
2	KDPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
3	AUFNR	☐	AUF_NETNR	AUFNR	CHAR	12	0	Order/Network number	AUFK
4	VORNR	☐	CN_VORNR	VORNR	CHAR	4	0	Activity number in network and standard network
5	UVORN	☐	CN_ELEMENT	VORNR	CHAR	4	0	Activity element number (work/external/general costs)
6	AUTYPTXT	☐	AUTYPTEXT	TEXT40	CHAR	40	0	Display field for order category description
7	STEUS	☐	STEUS	STEUS	CHAR	4	0	Control key	T430
8	STEUTXT	☐	STEUTXT	TEXT40	CHAR	40	0	Control key description
9	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
10	ARBTXT	☐	PS_ARBTEXT	TEXT40	CHAR	40	0	Short text for the CIM operating resource
11	KTSCH	☐	KTSCH	KTSCH	CHAR	7	0	Standard text key	T435
12	LTXA1	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
13	SORTL	☐	SORTI	CHAR10	CHAR	10	0	Sort Term for Non-Stock Info Records
14	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
15	PREIS	☐	PREIS	WERT11	CURR	11	2	Price
16	SAKTO	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKA
17	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
18	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
19	ESOKZ	☐	ESOKZ	ESOKZ	CHAR	1	0	Purchasing info record category
20	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
21	EKGRP	☐	VG_EKGRP	EKGRP	CHAR	3	0	Purchasing group for external processing	T024
22	KZLGF	☐	KZLGF	XFELD	CHAR	1	0	Indicator: fixed lot external processing
23	KZWRTF	☐	KZWRTF	XFELD	CHAR	1	0	Indicator: Fixed price for external processing
24	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
25	DDEHN	☐	DAUDEHN	X	CHAR	1	0	Indicator: flexible duration
26	ANZZL	☐	ANZKAP	INT1	INT1	3	0	Number of capacities required
27	PRZNT	☐	APROZENT	INT1	INT1	3	0	Work percentage
28	MLSTN	☐	MILESTONE	MILESTONE	CHAR	5	0	Usage	T433
29	MLSTXT	☐	PS_MLSTTXT	TEXT40	CHAR	40	0	Milestone description
30	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
31	ANFKO	☐	ANFKO	KOSTL	CHAR	10	0	Requesting cost center	CSKS
32	ANFKOKRS	☐	ANFKOKRS	CACCD	CHAR	4	0	Controlling area of the requesting cost center	TKA01
33	INDET	☐	INDET	INDET	CHAR	1	0	Calculation key
34	LARNT	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	CSLA
35	PRKST	☐	PRKST	PRKST	CURR	11	2	Costs in the activity
36	RUECK	☐	CO_RUECK	CO_RUECK	NUMC	10	0	Completion confirmation number for the operation
37	RMZHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
38	BANFN	☐	CO_BANFN	BANFN	CHAR	10	0	Purchase requisition number
39	BNFPO	☐	CO_BNFPO	BNFPO	NUMC	5	0	Item number of the purchase requisition in the order	EBAN
40	VERTL	☐	CR_VERTN	CR_VERTL	CHAR	8	0	Distr.cap.reqmts (plant maint.,process order, network)	TC29
41	LEKNW	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
42	NPRIO	☐	NW_PRIO	NW_PRIO	CHAR	1	0	Priority	TCN07
43	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
44	AUDISP	☐	AUDISP	XFELD	CHAR	1	0	Ind: Reservation applicable to MRP;Purc. req. is created
45	OWAER	☐	OWAERS	WAERS	CUKY	5	0	Object currency for network activity	TCURC
46	AFNAM	☐	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
47	KZFIX	☐	CN_KZFIX	XFELD	CHAR	1	0	Indicator: Purchasing info record data are fixed
48	PERNR	☐	CO_PERNR	PERNR	NUMC	8	0	Personnel number
49	WKURS	☐	WKURS	KURSP	DEC	9	5	Exchange Rate
50	FPLNR	☐	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number	*
51	KLVAR	☐	CK_KLVAR	KLVAR	CHAR	4	0	Costing Variant	*
52	KALNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	*
53	PRZ01	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	*
54	MEINH	☐	VORME	MEINS	UNIT	3	0	Unit of measure for activity	T006
55	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
56	DAUNO	☐	DAUNOR	DAUER_4_1	QUAN	5	1	Normal duration of the activity
57	DAUNE	☐	DAUNORE	MEINS	UNIT	3	0	Normal duration/unit	T006
58	DAUMI	☐	DAUMIN	DAUER_4_1	QUAN	5	1	Minimum activity duration
59	DAUME	☐	DAUMINE	MEINS	UNIT	3	0	Unit for the minimum duration	T006
60	EINSA	☐	EINSCHRA	RESTRIKSTR	CHAR	1	0	Constraint on the basic start date for the activity
61	EINSE	☐	EINSCHRE	RESTRIKEND	CHAR	1	0	Constraint on the finish date of the activity
62	ARBEI	☐	ARBEIT	ARBEIT	QUAN	7	1	Work involved in the activity
63	ARBEH	☐	ARBEITE	MEINS	UNIT	3	0	Unit for work	T006
64	MGVRG	☐	MGVRG	MENG13	QUAN	13	3	Operation Quantity
65	ASVRG	☐	ASVRG	MENG13	QUAN	13	3	Operation scrap
66	ISMNW	☐	ISMNW	ARBEIT	QUAN	7	1	Actual work
67	FSAVD	☐	FSAVD	DATUM	DATS	8	0	Earliest scheduled start: Execution (date)
68	FSAVZ	☐	FSAVZ	ATIME	TIMS	6	0	Earliest scheduled start: Execution (time)
69	FSEDD	☐	FSEDD	DATUM	DATS	8	0	Earliest scheduled finish: Execution (date)
70	FSEDZ	☐	FSEDZ	ATIME	TIMS	6	0	Earliest scheduled finish: Execution (time)
71	SSAVD	☐	SSAVD	DATUM	DATS	8	0	Latest scheduled start: Execution (date)
72	SSAVZ	☐	SSAVZ	ATIME	TIMS	6	0	Latest scheduled start: Execution (time)
73	SSEDD	☐	SSEDD	DATUM	DATS	8	0	Latest scheduled finish: Execution (date)
74	SSEDZ	☐	SSEDZ	ATIME	TIMS	6	0	Latest scheduled finish: Execution (time)
75	ISDD	☐	ISDD	DATUM	DATS	8	0	Actual start: Execution (date)
76	ISDZ	☐	ISDZ	ATIME	TIMS	6	0	Actual start: Execution/setup (time)
77	IEDD	☐	IEDD	DATUM	DATS	8	0	Actual finish: Execution (date)
78	IEDZ	☐	IEDZ	ATIME	TIMS	6	0	Actual finish: Execution (time)
79	PEDD	☐	CO_PEDD	DATUM	DATS	8	0	Forecast finish date of operation from confirmation
80	PEDZ	☐	CO_PEDZ	ATIME	TIMS	6	0	Forecast finish time of operation from confirmation
81	PUFFR	☐	PUFFR_FREI	PUFFER	DEC	3	0	Free float
82	PUFGS	☐	PUFFR_GESM	PUFFER	DEC	3	0	Total float
83	NTANF	☐	VORGABESTD	VORGABESTR	DATS	8	0	Constraint for activity start (Basic)
84	NTANZ	☐	VORGABESTZ	ATIME	TIMS	6	0	Constraint for activity start time (Basic)
85	NTEND	☐	VORGABEEND	VORGABEEND	DATS	8	0	Constraint for finish of activity (Basic)
86	NTENZ	☐	VORGABEENZ	ATIME	TIMS	6	0	Basic finish time of the activity
87	EWSTD	☐	EWSTARTD	DATUM	DATS	8	0	Forecasted start date for the activity
88	EWSTZ	☐	EWSTARTZ	ATIME	TIMS	6	0	Forecast start time of the activity
89	EWEND	☐	EWENDED	DATUM	DATS	8	0	Forecast finish date
90	EWENZ	☐	EWENDEZ	ATIME	TIMS	6	0	Forecast finish time for the activity
91	EWDAN	☐	EWDAN	DAUER_4_1	QUAN	5	1	Normal duration (from forecast) of activity
92	EWDNE	☐	EWDNE	MEINS	UNIT	3	0	Unit for forecast normal duration	T006
93	EWDAM	☐	EWDAM	DAUER_4_1	QUAN	5	1	Minimum duration (from forecast) for activity
94	EWDME	☐	EWDME	MEINS	UNIT	3	0	Unit for forecast minimum duration	T006
95	EWSTE	☐	PS_RESTE	RESTRIKEND	CHAR	1	0	Forecast date constraint on activity finish
96	EWSTA	☐	PS_RESTA	RESTRIKSTR	CHAR	1	0	Forecast date constraint on activity start
97	DABEA	☐	CO_DAUBEA	DAUER_6_1	QUAN	7	1	Processing time
98	BEAZE	☐	BEAZE	EINHEIT	UNIT	3	0	Unit of measure for processing time
99	OFMNW	☐	OFMNW	ARBEIT	QUAN	7	1	Forecasted work (actual + remaining)
100	OFFSTB	☐	CP_OOFFSTB	VNZTV	QUAN	5	0	Offset to sub-operation start
101	EHOFFB	☐	CP_OEHOFFB	MEINS	UNIT	3	0	Unit for offset to start	T006
102	OFFSTE	☐	CP_OOFFSTE	VNZTV	QUAN	5	0	Offset to sub-operation finish
103	EHOFFE	☐	CP_OEHOFFE	MEINS	UNIT	3	0	Unit for offset to finish	T006
104	FPAVD	☐	FPAVD	DATUM	DATS	8	0	Earliest scheduled start date (forecast)
105	FPAVZ	☐	FPAVZ	ATIME	TIMS	6	0	Earliest scheduled start time (forecast)
106	FPEDD	☐	FPEDD	DATUM	DATS	8	0	Earliest scheduled finish date (forecast)
107	FPEDZ	☐	FPEDZ	ATIME	TIMS	6	0	Earliest scheduled finish time (forecast)
108	SPAVD	☐	SPAVD	DATUM	DATS	8	0	Latest scheduled start date (forecast)
109	SPAVZ	☐	SPAVZ	ATIME	TIMS	6	0	Latest scheduled start time (forecast)
110	SPEDD	☐	SPEDD	DATUM	DATS	8	0	Latest scheduled finish date (forecast)
111	SPEDZ	☐	SPEDZ	ATIME	TIMS	6	0	Latest scheduled finish time (forecast)
112	BEAZP	☐	BEAZEP	EINHEIT	UNIT	3	0	Unit of processing time (Forecast)
113	PUFGP	☐	PPUFF_GESM	PUFFER	DEC	3	0	Total float (from forecast)
114	PUFFP	☐	PPUFF_FREI	PUFFER	DEC	3	0	Free float (from forecast)
115	DAPBE	☐	CO_DAUBEAP	DAUER_6_1	QUAN	7	1	Duration of processing time (forecast)
116	EPANF	☐	EPANF	DATUM	DATS	8	0	Dispatched start date for operation
117	EPANZ	☐	EPANZ	ATIME	TIMS	6	0	Dispatched start time for operation
118	EPEND	☐	EPEND	DATUM	DATS	8	0	Dispatched finish date
119	EPENZ	☐	EPENZ	ATIME	TIMS	6	0	Dispatched finish time
120	PDAU	☐	PDAU	DAUER_4_1	QUAN	5	1	Forecasted duration of activity from confirmation
121	PDAE	☐	PDAE	MEINS	UNIT	3	0	Unit of the forecasted duration from the confirmation	T006
122	WEMNG_OPR	☐	WEMNG	MENG13	QUAN	13	3	Quantity of goods received
123	WEMEH_OPR	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
124	FLG_PURS	☐	FLG_PURS	KREUZ	CHAR	1	0	Indicator: Purchase order exists
125	IDAUE	☐	IDAURE	MEINS	UNIT	3	0	Unit for actual duration	T006
126	ODAUR	☐	ODAUR	DAUER_4_1	QUAN	5	1	Remaining duration of activity
127	ODAUE	☐	ODAUE	MEINS	UNIT	3	0	Unit for remaining duration	T006
128	ABARBD	☐	CO_ABARB	CO_ABARB	NUMC	3	0	Confirmation: Degree of processing
129	REMNW	☐	REMNW	ARBEIT	QUAN	7	1	Remaining work
130	REMNE	☐	ARBEITE	MEINS	UNIT	3	0	Unit for work	T006
131	ABARBA	☐	CO_ABARB	CO_ABARB	NUMC	3	0	Confirmation: Degree of processing
132	VGTYP	☐	VGTYP	VORG_TYP	CHAR	3	0	Activity or element category
133	FLG_RCKMLD	☐	PS_RCKMLDB	XFELD	CHAR	1	0	Indicator: Can be confirmed
134	.INCLUDE	☐				0	0
135	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RECONST_ACT	ANFKO	CSKS	KOSTL	REF	C	CN
2	RECONST_ACT	ANFKOKRS	TKA01	KOKRS	REF	C	CN
3	RECONST_ACT	ARBEH	T006	MSEHI	REF	C	CN
4	RECONST_ACT	AUFNR	AUFK	AUFNR	KEY	1	CN
5	RECONST_ACT	BNFPO	EBAN	BNFPO	REF	C	CN
6	RECONST_ACT	BUKRS	T001	BUKRS	REF	1	CN
7	RECONST_ACT	DAUME	T006	MSEHI	REF	C	CN
8	RECONST_ACT	DAUNE	T006	MSEHI	REF	C	CN
9	RECONST_ACT	EHOFFB	T006	MSEHI	REF	C	CN
10	RECONST_ACT	EHOFFE	T006	MSEHI	REF	C	CN
11	RECONST_ACT	EKGRP	T024	EKGRP	REF	C	CN
12	RECONST_ACT	EKORG	T024E	EKORG	REF	C	CN
13	RECONST_ACT	EWDME	T006	MSEHI	REF	C	CN
14	RECONST_ACT	EWDNE	T006	MSEHI	REF	C	CN
15	RECONST_ACT	GSBER	TGSB	GSBER	REF	C	CN
16	RECONST_ACT	IDAUE	T006	MSEHI	REF	C	CN
17	RECONST_ACT	INFNR	EINA	INFNR	REF	C	CN
18	RECONST_ACT	KDAUF	VBUK	VBELN	REF	C	CN
19	RECONST_ACT	KDPOS	VBUP	POSNR	REF	C	CN
20	RECONST_ACT	KTSCH	T435	VLSCH	REF	C	CN
21	RECONST_ACT	LARNT	CSLA	LSTAR	REF	C	CN
22	RECONST_ACT	LIFNR	LFA1	LIFNR	REF	C	CN
23	RECONST_ACT	MATKL	T023	MATKL	REF	C	CN
24	RECONST_ACT	MEINH	T006	MSEHI	REF	C	CN
25	RECONST_ACT	MLSTN	T433	MLSTN	REF	C	CN
26	RECONST_ACT	NPRIO	TCN07	NPRIO	REF	C	CN
27	RECONST_ACT	ODAUE	T006	MSEHI	REF	C	CN
28	RECONST_ACT	OWAER	TCURC	WAERS
29	RECONST_ACT	PDAE	T006	MSEHI	REF	C	CN
30	RECONST_ACT	REMNE	T006	MSEHI	REF	C	CN
31	RECONST_ACT	SAKTO	CSKA	KSTAR	REF	C	CN
32	RECONST_ACT	STEUS	T430	STEUS	REF	1	CN
33	RECONST_ACT	VERTL	TC29	VERTL	REF	C	CN
34	RECONST_ACT	WAERS	TCURC	WAERS	REF	C	CN
35	RECONST_ACT	WEMEH_OPR	T006	MSEHI	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in