SAP ABAP View JHVWMOZMOT (IS-M: Ad spec Assignment for Commercial Ad Spec View)
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 JHVWMOZMOT  
Short Description IS-M: Ad spec Assignment for Commercial Ad Spec View    
Root table JHAMOZW   IS-M/AM: Assign Commercial Ad Specs to Order Objects 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 JHAMOZW JHAMOZW
2 JHAMOTW  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 JHAMOTW MANDT JL EQ 0 0
2 JHAMOZW MANDT JR EQ AND 0 0
3 JHAMOTW AVM_NR JL EQ 0 0
4 JHAMOZW AVM_NR JR EQ AND 0 0
5 JHAMOTW MOTIV JL EQ 0 0
6 JHAMOZW MOTIV JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT JHAMOZW MANDT   MANDT Client
2 AVM_NR JHAMOZW AVM_NR   AVM_NR IS-M/AM: Sales Document Number
3 POS_NR JHAMOZW POS_NR   POS_NR IS-M: Order Item Number
4 UPOS_NR JHAMOZW UPOS_NR   UPOS_NR IS-M: Order Sub-Item Number
5 EIN_NR JHAMOZW EIN_NR   EIN_NR IS-M: Schedule Line
6 MOTIV JHAMOZW MOTIV   WSMOTIV_NR IS-M: Order ad spec number (commercial)
7 NOTIZ JHAMOTW NOTIZ   MOTIVNOTIZ IS-M: Note for Ad Spec Design
8 MOTIVID JHAMOTW MOTIVID   MOTIVID IS-M: Assigned ad spec/ad spec file in technical system
9 WS_SENDFRM JHAMOTW WS_SENDFRM   WS_SENDFRM IS-M: Commercial Design Type
10 WS_LENGTHS JHAMOTW WS_LENGTHS   WS_LENGTHS IS-M: Planned length of commercial in seconds
11 WS_LENGTHI JHAMOTW WS_LENGTHI   WS_LENGTHI IS-M: Actual length of commercial in seconds
12 STICHW JHAMOTW STICHW   STICHW IS-M: Keyword
13 PRODH JHAMOTW PRODH   J_PRODH IS-M/AM: Product Hierarchy
                 
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