SAP ABAP View JJVJJTBBGP (IS-M/AM: Business Partner for Sales Agent Contract Reqmnt)
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 JJVJJTBBGP  
Short Description IS-M/AM: Business Partner for Sales Agent Contract Reqmnt    
Root table JJTBB   IS-M/AM: Requirement Element of Media Sales Agent Contract 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 JJTBB JJTBB
2 JJTVB  
3 JJTVV  
4 TJJ73  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 JJTVB MANDT JL EQ 0 0
2 JJTBB MANDT JR EQ AND 0 0
3 JJTVB VNR JL EQ 0 0
4 JJTBB VNR JR EQ AND 0 0
5 JJTVB BEDNR JL EQ 0 0
6 JJTBB BEDNR JR EQ AND 0 0
7 JJTVV MANDT JL EQ 0 0
8 JJTBB MANDT JR EQ AND 0 0
9 JJTVV VNR JL EQ 0 0
10 JJTBB VNR JR EQ AND 0 0
11 TJJ73 MANDT JL EQ 0 0
12 JJTVB MANDT JR EQ AND 0 0
13 TJJ73 BEDART JL EQ 0 0
14 JJTVB BEDART JR EQ AND 0 0
15 JJTBB ZUOFUNKT EQ ' ' AND 0 0
16 JJTBB XLOEVM EQ ' ' AND 0 0
17 JJTBB XLOEKZ EQ ' ' AND 0 0
18 JJTVB XLOEVM EQ ' ' AND 0 0
19 JJTVB XLOEKZ EQ ' ' AND 0 0
20 JJTVV XLOESCHVM EQ ' ' AND 0 0
21 JJTVV XLOESCHKZ EQ ' ' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT JJTBB MANDT   MANDT Client
2 VNR JJTBB VNR   JVMVVNR IS-M: Media Sales Agent Contract Number
3 BEDNR JJTBB BEDNR   VM_BEDNR IS-M: Number of Media Sales Agent Contract Requirement
4 BESNREXT JJTBB BESNREXT   JBESTNR_EX IS-M: Element Number in Media Agent Contract
5 IN_GPNR JJTBB IN_GPNR   INSERENT IS-M: Advertiser
6 AR_GPNR JJTBB AR_GPNR   AGENTUR IS-M: Agency
7 ABW_GUEAB JJTBB ABW_GUEAB   DIFFDATEFR IS-M: "Valid-From" Date Within Higher-Level Validity Period
8 ABW_GUEBIS JJTBB ABW_GUEBIS   DIFFDATETO IS-M: "Valid To" Date Within Higher Level Validity
9 GUELTIGAB JJTVB GUELTIGAB   DATEVALFRM IS-M: "Valid From" Date
10 GUELTIGBIS JJTVB GUELTIGBIS   DATEVALTO IS-M: "Valid To" Date
11 VERM JJTVV VERM   VERM_MEDIA IS-M: Media Sales Agent
12 EKORG JJTVV EKORG   EKORG Purchasing organization
13 INHALT TJJ73 INHALT   JVMVINH IS-M: Requirement Type Content
                 
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 463