SAP ABAP Table JJVAPREL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JJVAPREL	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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	RELNR	☑	BU_RELNR	BU_RELNR	CHAR	12	0	BP Relationship Number
3	PARTNER1	☑	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
4	PARTNER2	☑	J_BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner	BUT000
5	DATE_TO	☑	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
6	DATE_FROM	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
7	RELTYP	☐	BU_RELTYP	BU_RELTYP	CHAR	6	0	Business Partner Relationship Category
8	XRF	☐	BU_XRF	XFELD	CHAR	1	0	Business partner role definition instead of BP relationship
9	DFTVAL	☐	BU_DFTVAL	CHAR20	CHAR	20	0	BP: Differentiation type characteristic (change doc.-rel.)
10	RLTYP	☐	BU_RLTYPE	BU_ROLE	CHAR	6	0	Business partner role (change doc.-relevant)
11	RELKIND	☐	BU_RELKIND	BU_RELKIND	CHAR	4	0	Business partner relationship type
12	CRUSR	☐	BU_CRUSR	USNAM	CHAR	12	0	User who created the object
13	CRDAT	☐	BU_CRDAT	DATUM	DATS	8	0	Date on which the object was created
14	CRTIM	☐	BU_CRTIM	UZEIT	TIMS	6	0	Time at which the object was created
15	CHUSR	☐	BU_CHUSR	USNAM	CHAR	12	0	Last user to change object
16	CHDAT	☐	BU_CHDAT	DATUM	DATS	8	0	Date when object was last changed
17	CHTIM	☐	BU_CHTIM	UZEIT	TIMS	6	0	Time at which object was last changed

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JJVAPREL	CLIENT	T000	MANDT	KEY	1	CN
2	JJVAPREL	PARTNER1	BUT000	PARTNER	KEY	1	CN
3	JJVAPREL	PARTNER2	BUT000	PARTNER	KEY	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in