SAP ABAP View JPV_MAT_BUPA (View for Search Help MJP_MAT_BUPA)
Hierarchy
☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JMM (Package) IS-M(edia) Development - Product Master Data
Basic Data
View Type D Database View 
Database View JPV_MAT_BUPA  
Short Description View for Search Help MJP_MAT_BUPA    
Root table MARA   General Material Data 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 MARA MARA
2 MAKT  
3 JPTBUPAASSIGN  
4 TB003  
5 TB003T  
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 MAKT MANDT JR EQ AND 0 0
3 MARA MATNR JL EQ 0 0
4 MAKT MATNR JR EQ AND 0 0
5 MARA MANDT JL EQ 0 0
6 JPTBUPAASSIGN CLIENT JR EQ AND 0 0
7 MARA MATNR JL EQ 0 0
8 JPTBUPAASSIGN MATNR JR EQ AND 0 0
9 TB003 CLIENT JL EQ 0 0
10 JPTBUPAASSIGN CLIENT JR EQ AND 0 0
11 TB003 ROLE JL EQ 0 0
12 JPTBUPAASSIGN RLTYP JR EQ AND 0 0
13 TB003 CLIENT JL EQ 0 0
14 TB003T CLIENT JR EQ AND 0 0
15 TB003 ROLE JL EQ 0 0
16 TB003T ROLE JR EQ AND 0 0
17 TB003T SPRAS JL EQ 0 0
18 MAKT SPRAS JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT MARA MANDT   MANDT Client
2 SPRAS MAKT SPRAS   SPRAS Language Key
3 MATNR MARA MATNR   MATNR Material Number
4 ORDER_NR JPTBUPAASSIGN ORDER_NR   ISM_BP_ORDER_NR Chronological Sequence of Relationships
5 PARTNER JPTBUPAASSIGN PARTNER   BU_PARTNER Business Partner Number
6 RLTYP JPTBUPAASSIGN RLTYP   BU_PARTNERROLE BP Role
7 MAKTG MAKT MAKTG   MAKTG Material description in upper case for matchcodes
8 BEZ_RLTYP TB003T RLTITL   BU_PARTNERROLETITL BP Role Title
                 
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 462