SAP ABAP View M_MJJ6B (Generated View for Matchcode ID MJJ6-B)
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 M_MJJ6B  
Short Description Generated View for Matchcode ID MJJ6-B    
Root table JJTAM   IS-M/AM: Media Contact Person 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 JJTAM JJTAM
2 JGTSADR  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 JGTSADR MANDT JL EQ 0 0
2 JJTAM MANDT JR EQ AND 0 0
3 JGTSADR ADRNR JL EQ 0 0
4 JJTAM ADRND JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT JJTAM MANDT   MANDT Client
2 GPNR JJTAM GPNR   GPNR IS-M: Business Partner Key
3 PARNR JJTAM PARNR   ISM_CNTCT_PRSN IS-M: Contact Person
4 NAME1_MACD JGTSADR NAME1_MACO   NAME1_ISPM IS-M: Business Partner Name (Upper Case for Matchcode)
5 NAME2_MACD JGTSADR NAME2_MACO   NAME2_ISPM IS-M: Bus.Partner's First Name (Upper Case for Matchcode)
6 ORT01_MACD JGTSADR ORT01_MACO   ORT01_ISPM IS-M/SD: City Name (Upper Case for Matchcode)
7 STRAS_MACD JGTSADR STRAS_MACO   STRAS_ISPM IS-M: Street Name
8 ADRNAME1 JGTSADR NAME1   NAME1_ISP IS-M: Business Partner Name
9 ADRNAME2 JGTSADR NAME2   NAME2_ISP IS-M: First Name of Business Partner
10 ORT01 JGTSADR ORT01   ORT01_ISP IS-M: City
11 STRAS JGTSADR STRAS   STRAS_ISP IS-M: Street Name
12 PAFKT JJTAM PAFKT   PAFKT Contact person function
13 ISPTELVW JJTAM ISPTELVW   ISPTELVW IS-M: Telephone Area Code
14 ISPTEL JJTAM ISPTEL   ISPTEL IS-M: Telephone Number
15 ADRND JJTAM ADRND   ISPADRND IS-M/AM: Address Number for Business 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  20130529 
SAP Release Created in