SAP ABAP Table CAPP_REL (Relationships)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ CAPP (Package) Master Data Selection: BOM/Work Plan/Recipe

Basic Data

Table Category	INTTAB	Structure
Structure	CAPP_REL	Table Relationship Diagram
Short Description	Relationships

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	Relationships
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	*
4	PLNNR	☐	AOB_PLNNR	PLNNR	CHAR	8	0	Number of the Standard Network
5	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
6	PLNKN	☐	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
7	PLNRN	☐	AOB_PLNNR	PLNNR	CHAR	8	0	Number of the Standard Network
8	ALNRN	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
9	KNNRN	☐	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
10	AOBAR	☐	AOBAR	AOBAR	CHAR	2	0	Type of relationship
11	MIMAX	☐	DAUMIMAX	XFELD	CHAR	1	0	Indicates whether maximum time interval will be considered
12	ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
13	DATUV	☐	CIM_DATE	DATUM	DATS	8	0	Valid-from date
14	TECHV	☐	TECHV	TECHS	CHAR	12	0	Technical status from
15	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
16	ZEINH	☐	AOBDAUEH	MEINS	UNIT	3	0	Unit for the time interval between relationships	T006
17	DAUER	☐	AOBDAUER	AOBDAUER	QUAN	5	1	Time interval between relationships
18	DAUKZ	☐	AOBDAUKZ	AOBDAUKZ	CHAR	1	0	Indicator for the duration of the relationship
19	VORNC	☐	VORG_NACH	XFELD	CHAR	1	0	Indicator: maintained after successor
20	NCVOR	☐	NACH_VORG	XFELD	CHAR	1	0	Indicates whether data after predecessor is maintained
21	LOEKZ	☐	LOEKZ	XFELD	CHAR	1	0	Asset class marked for deletion
22	KALID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	TFACD
23	PRZNT	☐	AOB_PRZNT	AOB_PRZNT	NUMC	3	0	% used to calc. time interval between predecessor/successor
24	PROVG	☐	AOB_PROVG	AOB_PROVG	CHAR	1	0	Key for defining time intervals in a relationship
25	ARBID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
26	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
27	ANDAT	☐	ANDAT	DATUM	DATS	8	0	Date Record Created on
28	ANNAM	☐	ANNAM	USNAM	CHAR	12	0	User Who Created Record
29	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
30	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
31	DAUERMAX	☐	AOBDAUERM	AOBDAUER	QUAN	5	1	Maximum time interval for relationship
32	DATUB	☐	DATUB	DATUM	DATS	8	0	Valid-to date
33	AENNR_AUS	☐	AENNR	AENNR	CHAR	12	0	Change Number	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CAPP_REL	AENNR	AENR	AENNR	REF	C	C
2	CAPP_REL	KALID	TFACD	IDENT	REF	C	CN
3	CAPP_REL	MANDT	T000	MANDT	KEY	1	CN
4	CAPP_REL	WERKS	T001W	WERKS	REF	1	CN
5	CAPP_REL	ZEINH	T006	MSEHI	REF	C	CN

History

Last changed by/on	SAP	20031111
SAP Release Created in