SAP ABAP View JJVAPREL (IS-M/AM: Classify Contact Person Relationship Using View)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***

Basic Data

View Type	D	Database View
Database View	JJVAPREL
Short Description	IS-M/AM: Classify Contact Person Relationship Using View
Root table	BUT050	BP relationships/role definitions: General data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	BUT050	BUT050

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	BUT050	RELTYP		EQ	'BUR001'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	BUT050	CLIENT		☐	MANDT	☐	Client
2	RELNR	BUT050	RELNR		☐	BU_RELNR	☐	BP Relationship Number
3	PARTNER1	BUT050	PARTNER1		☐	BU_PARTNER	☐	Business Partner Number
4	PARTNER2	BUT050	PARTNER2		☐	J_BU_PARTNER	☑	Business Partner
5	DATE_TO	BUT050	DATE_TO		☐	BU_DATTO	☐	Validity Date (Valid To)
6	DATE_FROM	BUT050	DATE_FROM		☐	BU_DATFROM	☐	Validity Date (Valid From)
7	RELTYP	BUT050	RELTYP		☐	BU_RELTYP	☐	Business Partner Relationship Category
8	XRF	BUT050	XRF		☐	BU_XRF	☐	Business partner role definition instead of BP relationship
9	DFTVAL	BUT050	DFTVAL		☐	BU_DFTVAL	☐	BP: Differentiation type characteristic (change doc.-rel.)
10	RLTYP	BUT050	RLTYP		☐	BU_RLTYPE	☐	Business partner role (change doc.-relevant)
11	RELKIND	BUT050	RELKIND		☐	BU_RELKIND	☐	Business partner relationship type
12	CRUSR	BUT050	CRUSR		☐	BU_CRUSR	☐	User who created the object
13	CRDAT	BUT050	CRDAT		☐	BU_CRDAT	☐	Date on which the object was created
14	CRTIM	BUT050	CRTIM		☐	BU_CRTIM	☐	Time at which the object was created
15	CHUSR	BUT050	CHUSR		☐	BU_CHUSR	☐	Last user to change object
16	CHDAT	BUT050	CHDAT		☐	BU_CHDAT	☐	Date when object was last changed
17	CHTIM	BUT050	CHTIM		☐	BU_CHTIM	☐	Time at which object was last changed

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20131127
SAP Release Created in	464