SAP ABAP Table HBSACTVEXP (Extend BAPI_NETWORK_ACTIVITY_EXP to include work info)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ LO (Application Component) Logistics - General
     ⤷ DI_HBS (Package) Real Estate Sales and Configuration Mngmt. (Home Building)

Basic Data

Table Category	INTTAB	Structure
Structure	HBSACTVEXP	Table Relationship Diagram
Short Description	Extend BAPI_NETWORK_ACTIVITY_EXP to include work info

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	BAPI structure for network activities
2	NETWORK	☐	NW_AUFNR	AUFNR	CHAR	12	0	Network number	AUFK
3	ACTIVITY	☐	CN_VORNR	VORNR	CHAR	4	0	Activity number in network and standard network
4	CONTROL_KEY	☐	STEUS	STEUS	CHAR	4	0	Control key	T430
5	WORK_CNTR	☐	ARBPL	ARBPL	CHAR	8	0	Work center
6	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
7	DESCRIPTION	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
8	VENDOR_NO	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
9	PRICE	☐	PREIS	WERT11	CURR	11	2	Price
10	PRICE_UNIT	☐	PEINH	PACK3	DEC	5	0	Price unit
11	COST_ELEM	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKA
12	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
13	CURRENCY_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
14	INFO_REC	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
15	PURCH_ORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
16	PUR_GROUP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
17	MATL_GROUP	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
18	FLEXIBLE_DURATION	☐	DAUDEHN	X	CHAR	1	0	Indicator: flexible duration
19	NUMBER_OF_CAPACITIES	☐	ANZKAP	INT1	INT1	3	0	Number of capacities required
20	PERCENT_OF_WORK	☐	APROZENT	INT1	INT1	3	0	Work percentage
21	MILESTONE	☐	MILESTONE	MILESTONE	CHAR	5	0	Usage	T433
22	ACTTYPE	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	CSLA
23	ACTIVITY_COSTS	☐	PRKST	PRKST	CURR	11	2	Costs in the activity
24	PROJECT_DEFINITION	☐	PS_PSPID	PS_PSPID	CHAR	24	0	Project definition
25	WBS_ELEMENT	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
26	FACTORY_CALENDAR	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	TFACD
27	DISTRIBUTING_KEY	☐	CR_VERTN	CR_VERTL	CHAR	8	0	Distr.cap.reqmts (plant maint.,process order, network)	TC29
28	PRIORITY	☐	NW_PRIO	NW_PRIO	CHAR	1	0	Priority	TCN07
29	TAXJURCODE	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
30	OBJECTCLASS	☐	SCOPE	SCOPE	CHAR	2	0	Object class (language-independent)
31	PROFIT_CTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
32	NOT_MRP_APPLICABLE	☐	NODISP	XFELD	CHAR	1	0	Ind: Reserv. not applicable to MRP;Purc. req. not created
33	PROJECT_SUMMARIZATION	☐	CLASF	XFELD	CHAR	1	0	Ind.: Take Activity Into Account for Project Summarization
34	OPERATION_MEASURE_UNIT	☐	VORME	MEINS	UNIT	3	0	Unit of measure for activity	T006
35	OPERATION_MEASURE_UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
36	PLND_DELRY	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
37	DURATION_NORMAL	☐	DAUNOR	DAUER_4_1	QUAN	5	1	Normal duration of the activity
38	DURATION_NORMAL_UNIT	☐	DAUNORE	MEINS	UNIT	3	0	Normal duration/unit	T006
39	DURATION_NORMAL_UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
40	DURATION_MINIMUM	☐	DAUMIN	DAUER_4_1	QUAN	5	1	Minimum activity duration
41	DURATION_MINIMUM_UNIT	☐	DAUMINE	MEINS	UNIT	3	0	Unit for the minimum duration	T006
42	DURATION_MINIMUM_UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
43	CONSTRAINT_TYPE_START	☐	EINSCHRA	RESTRIKSTR	CHAR	1	0	Constraint on the basic start date for the activity
44	CONSTRAINT_TYPE_FINISH	☐	EINSCHRE	RESTRIKEND	CHAR	1	0	Constraint on the finish date of the activity
45	WORK_ACTIVITY	☐	ARBEIT	ARBEIT	QUAN	7	1	Work involved in the activity
46	UN_WORK	☐	ARBEITE	MEINS	UNIT	3	0	Unit for work	T006
47	UN_WORK_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
48	EARLY_START_DATE	☐	FSAVD	DATUM	DATS	8	0	Earliest scheduled start: Execution (date)
49	EARLY_START_TIME	☐	FSAVZ	ATIME	TIMS	6	0	Earliest scheduled start: Execution (time)
50	EARLY_FINISH_DATE	☐	FSEDD	DATUM	DATS	8	0	Earliest scheduled finish: Execution (date)
51	EARLY_FINISH_TIME	☐	FSEDZ	ATIME	TIMS	6	0	Earliest scheduled finish: Execution (time)
52	LATEST_START_DATE	☐	SSAVD	DATUM	DATS	8	0	Latest scheduled start: Execution (date)
53	LATEST_START_TIME	☐	SSAVZ	ATIME	TIMS	6	0	Latest scheduled start: Execution (time)
54	LATEST_FINISH_DATE	☐	SSEDD	DATUM	DATS	8	0	Latest scheduled finish: Execution (date)
55	LATEST_FINISH_TIME	☐	SSEDZ	ATIME	TIMS	6	0	Latest scheduled finish: Execution (time)
56	FLOAT_FREE	☐	PUFFR_FREI	PUFFER	DEC	3	0	Free float
57	FLOAT_TOTAL	☐	PUFFR_GESM	PUFFER	DEC	3	0	Total float
58	CONSTRAINT_START_DATE	☐	VORGABESTD	VORGABESTR	DATS	8	0	Constraint for activity start (Basic)
59	CONSTRAINT_START_TIME	☐	VORGABESTZ	ATIME	TIMS	6	0	Constraint for activity start time (Basic)
60	CONSTRAINT_FINISH_DATE	☐	VORGABEEND	VORGABEEND	DATS	8	0	Constraint for finish of activity (Basic)
61	CONSTRAINT_FINISH_TIME	☐	VORGABEENZ	ATIME	TIMS	6	0	Basic finish time of the activity
62	USER_FIELD_KEY	☐	SLWID	SLWID	CHAR	7	0	Key word ID for user-defined fields	TCN00
63	USER_FIELD_CHAR20_1	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
64	USER_FIELD_CHAR20_2	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
65	USER_FIELD_CHAR10_1	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
66	USER_FIELD_CHAR10_2	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
67	USER_FIELD_QUAN1	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
68	USER_FIELD_UNIT1	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
69	USER_FIELD_UNIT1_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
70	USER_FIELD_QUAN2	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
71	USER_FIELD_UNIT2	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
72	USER_FIELD_UNIT2_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
73	USER_FIELD_CURR1	☐	USRCURR13	USRCURR13	CURR	13	3	User-defined field for values (length 10,3)
74	USER_FIELD_CUKY1	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
75	USER_FIELD_CUKY1_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
76	USER_FIELD_CURR2	☐	USRCURR13	USRCURR13	CURR	13	3	User-defined field for values (length 10,3)
77	USER_FIELD_CUKY2	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
78	USER_FIELD_CUKY2_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
79	USER_FIELD_DATE1	☐	USRDATE	USRDATE	DATS	8	0	User field for date
80	USER_FIELD_DATE2	☐	USRDATE	USRDATE	DATS	8	0	User field for date
81	USER_FIELD_FLAG1	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
82	USER_FIELD_FLAG2	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
83	DURATION_NORMAL_FC	☐	EWDAN	DAUER_4_1	QUAN	5	1	Normal duration (from forecast) of activity
84	DURATION_NORMAL_FC_UNIT	☐	EWDNE	MEINS	UNIT	3	0	Unit for forecast normal duration	*
85	DURATION_NORMAL_FC_UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
86	DURATION_MINIMUM_FC	☐	EWDAM	DAUER_4_1	QUAN	5	1	Minimum duration (from forecast) for activity
87	DURATION_MINIMUM_FC_UNIT	☐	EWDME	MEINS	UNIT	3	0	Unit for forecast minimum duration	*
88	DURATION_MINIMUM_FC_UNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
89	CONSTRAINT_TYPE_FINISH_FC	☐	PS_RESTE	RESTRIKEND	CHAR	1	0	Forecast date constraint on activity finish
90	CONSTRAINT_TYPE_START_FC	☐	PS_RESTA	RESTRIKSTR	CHAR	1	0	Forecast date constraint on activity start
91	CONSTRAINT_START_DATE_FC	☐	EWSTARTD	DATUM	DATS	8	0	Forecasted start date for the activity
92	CONSTRAINT_START_TIME_FC	☐	EWSTARTZ	ATIME	TIMS	6	0	Forecast start time of the activity
93	CONSTRAINT_FINISH_DATE_FC	☐	EWENDED	DATUM	DATS	8	0	Forecast finish date
94	CONSTRAINT_FINISH_TIME_FC	☐	EWENDEZ	ATIME	TIMS	6	0	Forecast finish time for the activity
95	EARLY_START_DATE_FC	☐	FPAVD	DATUM	DATS	8	0	Earliest scheduled start date (forecast)
96	EARLY_START_TIME_FC	☐	FPAVZ	ATIME	TIMS	6	0	Earliest scheduled start time (forecast)
97	EARLY_FINISH_DATE_FC	☐	FPEDD	DATUM	DATS	8	0	Earliest scheduled finish date (forecast)
98	EARLY_FINISH_TIME_FC	☐	FPEDZ	ATIME	TIMS	6	0	Earliest scheduled finish time (forecast)
99	LATEST_START_DATE_FC	☐	SPAVD	DATUM	DATS	8	0	Latest scheduled start date (forecast)
100	LATEST_START_TIME_FC	☐	SPAVZ	ATIME	TIMS	6	0	Latest scheduled start time (forecast)
101	LATEST_FINISH_DATE_FC	☐	SPEDD	DATUM	DATS	8	0	Latest scheduled finish date (forecast)
102	LATEST_FINISH_TIME_FC	☐	SPEDZ	ATIME	TIMS	6	0	Latest scheduled finish time (forecast)
103	FLOAT_FREE_FC	☐	PPUFF_FREI	PUFFER	DEC	3	0	Free float (from forecast)
104	FLOAT_TOTAL_FC	☐	PPUFF_GESM	PUFFER	DEC	3	0	Total float (from forecast)
105	OBJECTCLASS_EXT	☐	SCOPE_LD	CHAR5	CHAR	5	0	Object class, language-dependent
106	FUNC_AREA	☐	FKBER_SHORT	FKBER_SHORT	CHAR	4	0	Functional Area
107	FUNC_AREA_LONG	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
108	REFERENCE_POINT	☐	RFPNT	RFPNT	CHAR	20	0	Reference point for BOM transfer
109	WORK_ACTUAL	☐	CO_ISMNW	MENG13	QUAN	13	3	Actual work
110	WORK_FORECAST	☐	OFMNW	ARBEIT	QUAN	7	1	Forecasted work (actual + remaining)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HBSACTVEXP	ACTTYPE	CSLA	LSTAR
2	HBSACTVEXP	CONTROL_KEY	T430	STEUS
3	HBSACTVEXP	COST_ELEM	CSKA	KSTAR
4	HBSACTVEXP	CURRENCY	TCURC	WAERS
5	HBSACTVEXP	DISTRIBUTING_KEY	TC29	VERTL
6	HBSACTVEXP	DURATION_MINIMUM_UNIT	T006	MSEHI
7	HBSACTVEXP	DURATION_MINIMUM_UNIT_ISO	T006I	ISOCODE
8	HBSACTVEXP	DURATION_NORMAL_UNIT	T006	MSEHI
9	HBSACTVEXP	DURATION_NORMAL_UNIT_ISO	T006I	ISOCODE
10	HBSACTVEXP	FACTORY_CALENDAR	TFACD	IDENT
11	HBSACTVEXP	INFO_REC	EINA	INFNR
12	HBSACTVEXP	MATL_GROUP	T023	MATKL
13	HBSACTVEXP	MILESTONE	T433	MLSTN
14	HBSACTVEXP	NETWORK	AUFK	AUFNR
15	HBSACTVEXP	OPERATION_MEASURE_UNIT	T006	MSEHI
16	HBSACTVEXP	OPERATION_MEASURE_UNIT_ISO	T006I	ISOCODE
17	HBSACTVEXP	PLANT	T001W	WERKS
18	HBSACTVEXP	PRIORITY	TCN07	NPRIO
19	HBSACTVEXP	PROFIT_CTR	CEPC	PRCTR
20	HBSACTVEXP	PURCH_ORG	T024E	EKORG
21	HBSACTVEXP	PUR_GROUP	T024	EKGRP
22	HBSACTVEXP	TAXJURCODE	TTXJ	TXJCD
23	HBSACTVEXP	UN_WORK	T006	MSEHI
24	HBSACTVEXP	UN_WORK_ISO	T006I	ISOCODE
25	HBSACTVEXP	USER_FIELD_CUKY1	TCURC	WAERS
26	HBSACTVEXP	USER_FIELD_CUKY2	TCURC	WAERS
27	HBSACTVEXP	USER_FIELD_KEY	TCN00	SLWID
28	HBSACTVEXP	USER_FIELD_UNIT1	T006	MSEHI
29	HBSACTVEXP	USER_FIELD_UNIT2	T006	MSEHI
30	HBSACTVEXP	USER_FIELD_UNIT2_ISO	T006I	ISOCODE
31	HBSACTVEXP	VENDOR_NO	LFA1	LIFNR

History

Last changed by/on	SAP	20130529
SAP Release Created in