SAP ABAP Table BIW_ACTY_V (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	BIW_ACTY_V	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	AUFNR	☑	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
3	APLZL	☑	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order
4	AUFPL	☑	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
5	VORNR	☑	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
6	PSPID_INT	☑	PS_PSPHI	PS_PSPNR	NUMC	8	0	Current number of the appropriate project	PROJ
7	PSPID	☐	PS_PSPID	PS_PSPID	CHAR	24	0	Project definition
8	POSID_INT	☐	PS_PSP_ELE	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	PRPS
9	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
10	DISPO	☐	CO_DISPO	DISPO	CHAR	3	0	MRP controller for the order	T024D
11	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
12	ANFKO	☐	ANFKO	KOSTL	CHAR	10	0	Requesting cost center	CSKS
13	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
14	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
15	STEUS	☐	STEUS	STEUS	CHAR	4	0	Control key	T430
16	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
17	SAKTO	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKA
18	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
19	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
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	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
23	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
24	ANFKOKRS	☐	ANFKOKRS	CACCD	CHAR	4	0	Controlling area of the requesting cost center	TKA01
25	LARNT	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	CSLA
26	NPRIO	☐	NW_PRIO	NW_PRIO	CHAR	1	0	Priority	TCN07
27	SCOPE	☐	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
28	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
29	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
30	ARBID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	CRID
31	USR00	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
32	USR01	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
33	USR02	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
34	USR03	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
35	USR04	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
36	USE04	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
37	USR05	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
38	USE05	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
39	USR06	☐	USRCURR13	USRCURR13	CURR	13	3	User-defined field for values (length 10,3)
40	USE06	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
41	USR07	☐	USRCURR13	USRCURR13	CURR	13	3	User-defined field for values (length 10,3)
42	USE07	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
43	USR08	☐	USRDATE	USRDATE	DATS	8	0	User field for date
44	USR09	☐	USRDATE	USRDATE	DATS	8	0	User field for date
45	USR10	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
46	USR11	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
47	SUMNR	☐	SUMKNTNR	KNTNR	NUMC	8	0	Node number of the superior operation
48	TXTMD	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
49	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
50	KOKRS	☐	PS_VKOKR	CACCD	CHAR	4	0	Controlling area for the project	TKA01

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BIW_ACTY_V	ANFKO	CSKS	KOSTL
2	BIW_ACTY_V	ANFKOKRS	TKA01	KOKRS
3	BIW_ACTY_V	ARBID	CRID	OBJID
4	BIW_ACTY_V	AUFNR	AUFK	AUFNR	KEY	1	1
5	BIW_ACTY_V	BUKRS	T001	BUKRS
6	BIW_ACTY_V	DISPO	T024D	DISPO	REF	1	CN
7	BIW_ACTY_V	EBELN	EKKO	EBELN
8	BIW_ACTY_V	EBELP	EKPO	EBELP
9	BIW_ACTY_V	EKGRP	T024	EKGRP
10	BIW_ACTY_V	EKORG	T024E	EKORG
11	BIW_ACTY_V	GSBER	TGSB	GSBER
12	BIW_ACTY_V	INFNR	EINA	INFNR
13	BIW_ACTY_V	KOKRS	TKA01	KOKRS	REF	C	CN
14	BIW_ACTY_V	LARNT	CSLA	LSTAR
15	BIW_ACTY_V	LIFNR	LFA1	LIFNR
16	BIW_ACTY_V	MANDT	T000	MANDT	KEY	1	CN
17	BIW_ACTY_V	MATKL	T023	MATKL
18	BIW_ACTY_V	NPRIO	TCN07	NPRIO
19	BIW_ACTY_V	OBJNR	ONR00	OBJNR
20	BIW_ACTY_V	POSID_INT	PRPS	PSPNR
21	BIW_ACTY_V	PRCTR	CEPC	PRCTR
22	BIW_ACTY_V	PSPID_INT	PROJ	PSPNR	REF	1	CN
23	BIW_ACTY_V	SAKTO	CSKA	KSTAR
24	BIW_ACTY_V	STEUS	T430	STEUS
25	BIW_ACTY_V	USE04	T006	MSEHI
26	BIW_ACTY_V	USE05	T006	MSEHI
27	BIW_ACTY_V	USE06	TCURC	WAERS
28	BIW_ACTY_V	USE07	TCURC	WAERS
29	BIW_ACTY_V	WAERS	TCURC	WAERS
30	BIW_ACTY_V	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in