SAP ABAP View M_MJK6A (Generated View for Matchcode ID MJK6 -A)
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_MJK6A  
Short Description Generated View for Matchcode ID MJK6 -A    
Root table JKAKPR   Ad Pre-Print Order: Header Data 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 JKAKPR JKAKPR
2 JGTGPNR  
3 JGTSADR  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 JGTGPNR MANDT JL EQ 0 0
2 JKAKPR MANDT JR EQ AND 0 0
3 JGTGPNR GPNR JL EQ 0 0
4 JKAKPR GPAG JR EQ AND 0 0
5 JGTGPNR MANDT JL EQ 0 0
6 JGTSADR MANDT JR EQ AND 0 0
7 JGTGPNR GPNR JL EQ 0 0
8 JGTSADR GP_REF JR EQ 0 0
                     
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 BSTNK JKAKPR BSTNK   BSTNK Customer purchase order number
4 BNAME JKAKPR BNAME   BNAME_V Name of orderer
5 REFNR JKAKPR REFNR   JREFNR IS-M: Reference number for ad pre-print order
6 NAME1 JGTSADR NAME1   NAME1_ISP IS-M: Business Partner Name
7 NAME2 JGTSADR NAME2   NAME2_ISP IS-M: First Name of Business Partner
8 ORT01 JGTSADR ORT01   ORT01_ISP IS-M: City
9 STRAS JGTSADR STRAS   STRAS_ISP IS-M: Street Name
10 HAUSN JGTSADR HAUSN   HSNMR1 IS-M: House Number
11 PSTLZ JGTSADR PSTLZ   PLZ_ISP IS-M: Postal Code
12 LAND1 JGTSADR LAND1   LAND1 Country Key
13 XBEILAGE JKAKPR XBEILAGE   XBEILAGE IS-M: Ad pre-print sales document type - insertion
14 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