SAP ABAP View M_MJHSS (Generated view for matchcode ID MJHS-S)
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_MJHSS  
Short Description Generated view for matchcode ID MJHS-S    
Root table JDTPVA   IS-M/SD: Editions 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 JDTPVA JDTPVA
2 JDTVAUSGB  
3 JDTDRER  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 JDTPVA MANDT JL EQ 0 1 XHRKNFTPAM
2 JDTVAUSGB MANDT JR EQ AND 0 1 XHRKNFTPAM
3 JDTPVA DRERZ JL EQ 0 1 XHRKNFTPAM
4 JDTVAUSGB DRERZ JR EQ AND 0 1 XHRKNFTPAM
5 JDTPVA PVA JL EQ 0 1 XHRKNFTPAM
6 JDTVAUSGB PVA JR EQ AND 0 1 XHRKNFTPAM
7 JDTDRER MANDT JL EQ 0 1 XHRKNFTPAM
8 JDTVAUSGB MANDT JR EQ AND 0 1 XHRKNFTPAM
9 JDTDRER DRERZ JL EQ 0 1 XHRKNFTPAM
10 JDTVAUSGB DRERZ JR EQ AND 0 1 XHRKNFTPAM
11 JDTDRER DRUERZART EQ '2' AND 0 1 DRUERZART
12 JDTVAUSGB XHRKNFTPAM EQ 'X' 0 1 XHRKNFTPAM
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT JDTPVA MANDT   MANDT Client
2 PVABEZEI10 JDTPVA BEZEI10   KBEZPVA Short text for edition
3 JAHRGANG JDTVAUSGB JAHRGANG   JAHRGANG Year number of issue
4 NRIMJAHR JDTVAUSGB NRIMJAHR   NRIMJAHR Issue number (in year)
5 ERSCHDAT JDTVAUSGB ERSCHDAT   ERSCHDAT Publication Date
6 DRERZ JDTDRER DRERZ   DRERZ Publication
7 PVALBEZEII JDTPVA LBEZEIINT   LBEZEIINT Internal long text
8 SI_INSERNT JDTVAUSGB SI_INSERNT   INSERENT IS-M: Advertiser
9 SI_NUMMER JDTVAUSGB SI_NUMMER   ISM_SI_NUMMER IS-M: Ad Insert 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