SAP ABAP View M_MJK9B (Generated View for Matchcode ID MJK9 -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_MJK9B  
Short Description Generated View for Matchcode ID MJK9 -B    
Root table JGTSADR   IS-M: Extended Adress Management 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 JGTSADR JGTSADR
2 JKAP  
3 JKPA  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 JKAP MANDT JL EQ 0 2 JPARVW
2 JKPA MANDT JR EQ AND 0 2 JPARVW
3 JKAP VBELN JL EQ 0 2 JPARVW
4 JKPA VBELN JR EQ AND 0 2 JPARVW
5 JKAP POSNR JL EQ 0 2 JPARVW
6 JKPA POSNR JR EQ AND 0 2 JPARVW
7 JGTSADR MANDT JL EQ 0 2 JPARVW
8 JKPA MANDT JR EQ AND 0 2 JPARVW
9 JGTSADR ADRNR JL EQ 0 2 JPARVW
10 JKPA ADRNR JR EQ AND 0 2 JPARVW
11 JKPA JPARVW EQ 'WE' 0 2 JPARVW
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT JGTSADR MANDT   MANDT Client
2 NAME1 JGTSADR NAME1   NAME1_ISP IS-M: Business Partner Name
3 NAME2 JGTSADR NAME2   NAME2_ISP IS-M: First Name of Business Partner
4 LAND1 JGTSADR LAND1   LAND1 Country Key
5 PSTLZ JGTSADR PSTLZ   PLZ_ISP IS-M: Postal Code
6 ORT01 JGTSADR ORT01   ORT01_ISP IS-M: City
7 STRAS JGTSADR STRAS   STRAS_ISP IS-M: Street Name
8 HAUSN JGTSADR HAUSN   HSNMR1 IS-M: House Number
9 SORTL JGTSADR SORTL   SORTL Sort field
10 KUNWE JKAP KUNWE   GPNR_WE IS-M: Business Partner Ship-to Party
11 GUELTIG JKPA GUELTIGVON   JKPAVON Date from Which Partner Data in Sales Order is Valid
12 GUELTIGB JKPA GUELTIGBIS   JKPABIS Date to Which Partner Data in Sales Order is Valid
13 VBELN JKAP VBELN   AVNR IS-M/SD: Publishing Sales Order
                 
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