SAP ABAP Table AFABR (Relationship 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	AFABR	Table Relationship Diagram
Short Description	Relationship 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	*
12	VORNR	☐	CN_VORNR	VORNR	CHAR	4	0	Activity number in network and standard network
13	POSID2	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
14	AUFNR2	☐	AUF_NETNR	AUFNR	CHAR	12	0	Order/Network number	*
15	VORNR2	☐	CN_VORNR	VORNR	CHAR	4	0	Activity number in network and standard network
16	AUTYPTXT	☐	AUTYPTEXT	TEXT40	CHAR	40	0	Display field for order category description
17	AOBAR	☐	AOBAR	AOBAR	CHAR	2	0	Type of relationship
18	MIMAX	☐	DAUMIMAX	XFELD	CHAR	1	0	Indicates whether maximum time interval will be considered
19	ZEINH	☐	AOBDAUEH	MEINS	UNIT	3	0	Unit for the time interval between relationships	T006
20	DAUER	☐	AOBDAUER	AOBDAUER	QUAN	5	1	Time interval between relationships
21	DAUKZ	☐	AOBDAUKZ	AOBDAUKZ	CHAR	1	0	Indicator for the duration of the relationship
22	VORNC	☐	VORG_NACH	XFELD	CHAR	1	0	Indicator: maintained after successor
23	NCVOR	☐	NACH_VORG	XFELD	CHAR	1	0	Indicates whether data after predecessor is maintained
24	KALID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	TFACD
25	PRZNT	☐	AOB_PRZNT	AOB_PRZNT	NUMC	3	0	% used to calc. time interval between predecessor/successor
26	PROVG	☐	AOB_PROVG	AOB_PROVG	CHAR	1	0	Key for defining time intervals in a relationship
27	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
28	ARBTXT	☐	PS_ARBTEXT	TEXT40	CHAR	40	0	Short text for the CIM operating resource
29	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
30	FSABD	☐	FSABD	DATUM	DATS	8	0	Earliest start date for the relationship
31	FSABZ	☐	FSABZ	ATIME	TIMS	6	0	Earliest start time for the relationship
32	SSABD	☐	SSABD	DATUM	DATS	8	0	Latest start date of the relationship
33	SSABZ	☐	SSABZ	ATIME	TIMS	6	0	Latest start time of the relationship
34	FEABD	☐	FEABD	DATUM	DATS	8	0	Earliest finish date for the relationship
35	FEABZ	☐	FEABZ	ATIME	TIMS	6	0	Earliest finish time for the relationship
36	SEABD	☐	SEABD	DATUM	DATS	8	0	Latest finish date of the relationship
37	SEABZ	☐	SEABZ	ATIME	TIMS	6	0	Latest finish time of the relationship
38	DAUTM	☐	DAUTM	CX_DAUERS	INT4	10	0	Relationship duration (in seconds) as result of scheduling
39	LTXA1	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
40	LTXA12	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
41	NCH	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AFABR	KALID	TFACD	IDENT
2	AFABR	KDAUF	VBUK	VBELN	REF	C	CN
3	AFABR	KDPOS	VBUP	POSNR	REF	C	CN
4	AFABR	PRCTR	CEPC	PRCTR	REF	C	CN
5	AFABR	PRNAM	IMTP	PRNAM			CN
6	AFABR	WERKS	T001W	WERKS
7	AFABR	ZEINH	T006	MSEHI

History

Last changed by/on	SAP	20130529
SAP Release Created in