SAP ABAP View M_MJK6B (Generated View for Matchcode ID MJK6 -B)
Hierarchy
IS-M (Software Component) SAP MEDIA
   IS-M (Application Component) SAP Media
     JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System
Basic Data
View Type D Database View 
Database View M_MJK6B  
Short Description Generated View for Matchcode ID MJK6 -B    
Root table JKAKPR   Ad Pre-Print Order: Header Data 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 JKAKPR JKAKPR
2 JDTVAUSGB  
3 JDTDRER  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 JDTVAUSGB MANDT JL EQ 0 1 DRUERZART
2 JKAKPR MANDT JR EQ AND 0 1 DRUERZART
3 JDTVAUSGB VAUSGB JL EQ 0 1 DRUERZART
4 JKAKPR VAUSGB_PRO JR EQ AND 0 1 DRUERZART
5 JDTDRER MANDT JL EQ 0 1 DRUERZART
6 JDTVAUSGB MANDT JR EQ AND 0 1 DRUERZART
7 JDTDRER DRERZ JL EQ 0 1 DRUERZART
8 JDTVAUSGB DRERZ JR EQ AND 0 1 DRUERZART
9 JDTDRER DRUERZART EQ '2' 0 1 DRUERZART
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT JKAKPR MANDT   MANDT Client
2 VBELN JKAKPR VBELN   AVNR_PR Ad Pre-Print Order
3 DRERZ JDTVAUSGB DRERZ   DRERZ Publication
4 ERSCHDAT JDTVAUSGB ERSCHDAT   ERSCHDAT Publication Date
5 BEZEI10 JDTDRER BEZEI10   KBEZDRERZ Short Text for Publication
6 WERKS JKAKPR WERKS   JWERK Plant
7 VKORG JKAKPR VKORG   VKORG Sales Organization
8 VTWEG JKAKPR VTWEG   VTWEG Distribution Channel
9 SPART JKAKPR SPART   SPART Division
10 DRUERZART JDTDRER DRUERZART   DRUERZART Publication Type
11 XBEILAGE JKAKPR XBEILAGE   XBEILAGE IS-M: Ad pre-print sales document type - insertion
12 XVERTEILNG JKAKPR XVERTEILNG   XVERTEILNG IS-M: Ad pre-print sales document type - distribution
                 
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  20130529 
SAP Release Created in