SAP ABAP View JKSDCON1_MC (IS-M: Search Help for Contract Media Product)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSDI (Package) IS-M/SD SD Integration

Basic Data

View Type	D	Database View
Database View	JKSDCON1_MC
Short Description	IS-M: Search Help for Contract Media Product
Root table	VBAP	Sales Document: Item Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VBAP	VBAP
2	MARA
3	VBAK
4	VBKD

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	MARA	MANDT	JL	EQ				0	0
2	VBAP	MANDT	JR	EQ			AND	0	0
3	MARA	MATNR	JL	EQ				0	0
4	VBAP	MATNR	JR	EQ			AND	0	0
5	VBAP	VBELN	JL	EQ				0	0
6	VBAK	VBELN	JR	EQ			AND	0	0
7	VBAP	MANDT	JL	EQ				0	0
8	VBAK	MANDT	JR	EQ			AND	0	0
9	VBKD	MANDT	JL	EQ				0	0
10	VBAP	MANDT	JR	EQ			AND	0	0
11	VBKD	VBELN	JL	EQ				0	0
12	VBAP	VBELN	JR	EQ			AND	0	0
13	VBAK	VBTYP		EQ	'G'		AND	0	0
14	VBKD	POSNR		EQ	'000000'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	VBAP	MANDT		☐	MANDT	☐	Client
2	VBELN	VBAP	VBELN		☐	VBELN_VA	☐	Sales Document
3	MATNR	VBAP	MATNR		☐	ISMMATNR_PRODUCT	☑	Media Product
4	POSNR	VBAP	POSNR		☐	POSNR_VA	☐	Sales Document Item
5	POSAR	VBAP	POSAR		☐	POSAR	☐	Item type
6	VBTYP	VBAK	VBTYP		☐	VBTYP	☐	SD document category
7	AUART	VBAK	AUART		☐	AUART	☐	Sales Document Type
8	VKORG	VBAK	VKORG		☐	VKORG	☐	Sales Organization
9	VTWEG	VBAK	VTWEG		☐	VTWEG	☐	Distribution Channel
10	SPART	VBAK	SPART		☐	SPART	☐	Division
11	VKGRP	VBAK	VKGRP		☐	VKGRP	☐	Sales group
12	VKBUR	VBAK	VKBUR		☐	VKBUR	☐	Sales office
13	BSTKD	VBKD	BSTKD		☐	BSTKD	☐	Customer purchase order number

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	20140121
SAP Release Created in	463