SAP ABAP Table JHAMOTW (IS-M/AM: OPM Ad Spec (Commercial))
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷
IS-M (Application Component) SAP Media
⤷
JAS (Package) Application development R/3 Publishing Advertising System***
IS-M (Software Component) SAP MEDIA⤷
IS-M (Application Component) SAP Media⤷
JAS (Package) Application development R/3 Publishing Advertising System***
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | JHAMOTW |
Table Relationship Diagram 
|
| Short Description | IS-M/AM: OPM Ad Spec (Commercial) |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | AVM_NR |
AVM_NR | AVM_NR | CHAR | 10 | 0 | IS-M/AM: Sales Document Number | JHAK | |
| 3 | MOTIV |
WSMOTIV_NR | PAM_WS_MOT | NUMC | 6 | 0 | IS-M: Order ad spec number (commercial) | ||
| 4 | MOTIVSTAT |
MOTIVSTAT | PAM_STATUS | CHAR | 2 | 0 | IS-M: Ad spec status | ||
| 5 | NOTIZ |
MOTIVNOTIZ | TEXT50 | CHAR | 50 | 0 | IS-M: Note for Ad Spec Design | ||
| 6 | MOTIVID |
MOTIVID | MOTIVID | CHAR | 12 | 0 | IS-M: Assigned ad spec/ad spec file in technical system | ||
| 7 | VORL_AVMNR |
VORL_AVMNR | AVM_NR | CHAR | 10 | 0 | IS-M: Order Number of the Preceding Document | JHAK | |
| 8 | VORL_MOTNR |
VORL_WMONR | PAM_WS_MOT | NUMC | 6 | 0 | IS-M: Ad spec template (commercial) | * | |
| 9 | VORL_TECID |
VORL_TECID | MOTIVID | CHAR | 12 | 0 | IS-M: Ad spec template (description in technical system) | ||
| 10 | WS_SENDFRM |
WS_SENDFRM | WS_SENDFRM | CHAR | 2 | 0 | IS-M: Commercial Design Type | TJJW5 | |
| 11 | WS_LENGTHS |
WS_LENGTHS | WS_LENGTH | NUMC | 4 | 0 | IS-M: Planned length of commercial in seconds | ||
| 12 | WS_LENGTHI |
WS_LENGTHI | WS_LENGTH | NUMC | 4 | 0 | IS-M: Actual length of commercial in seconds | ||
| 13 | STICHW |
STICHW | TEXT40 | CHAR | 40 | 0 | IS-M: Keyword | ||
| 14 | PRODH |
J_PRODH | J_PRODH | CHAR | 18 | 0 | IS-M/AM: Product Hierarchy | * | |
| 15 | MOTEXTINF1 |
MOTEXTINF1 | CHAR30 | CHAR | 30 | 0 | IS-M: Freely Definable Additional Information on Ad Spec | ||
| 16 | MOTEXTINF2 |
MOTEXTINF2 | CHAR30 | CHAR | 30 | 0 | IS-M: Freely Definable Additional Information on Ad Spec | ||
| 17 | MOTEXTINF3 |
MOTEXTINF3 | CHAR30 | CHAR | 30 | 0 | IS-M: Freely Definable Additional Information on Ad Spec | ||
| 18 | MOTEXTINF4 |
MOTEXTINF4 | CHAR30 | CHAR | 30 | 0 | IS-M: Freely Definable Additional Information on Ad Spec | ||
| 19 | .INCLUDE |
0 | 0 | IS-M/AM: Ad Spec Status Attributes | |||||
| 20 | XUVMOT |
XUVMOT | XFELD | CHAR | 1 | 0 | IS-M: "Ad spec data incomplete" indicator | ||
| 21 | XMOTPROD |
XMOTPROD | XFELD | CHAR | 1 | 0 | IS-M: Ad Spec Technically Complete Indicator | ||
| 22 | .INCLUDE |
0 | 0 | IS-M/AM: Characteristics for Individual Use (Ad Spec) | |||||
| 23 | MERKMAL0 |
MERK0_MOTW | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 0 for Individual Use (Commercl Ad Spec) | ||
| 24 | MERKMAL1 |
MERK1_MOTW | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 1 for Individual Use (Commercl Ad Spec) | ||
| 25 | MERKMAL2 |
MERK2_MOTW | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 2 for Individual Use (Commercl Ad Spec) | ||
| 26 | MERKMAL3 |
MERK3_MOTW | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 3 for Individual Use (Commercl Ad Spec) | ||
| 27 | MERKMAL4 |
MERK4_MOTW | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 4 for Individual Use (Commercl Ad Spec) | ||
| 28 | MERKMAL5 |
MERK5_MOTW | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 5 for Individual Use (Commercl Ad Spec) | ||
| 29 | MERKMAL6 |
MERK6_MOTW | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 6 for Individual Use (Commercl Ad Spec) | ||
| 30 | MERKMAL7 |
MERK7_MOTW | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 7 for Individual Use (Commercl Ad Spec) | ||
| 31 | MERKMAL8 |
MERK8_MOTW | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 8 for Individual Use (Commercl Ad Spec) | ||
| 32 | MERKMAL9 |
MERK9_MOTW | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 9 for Individual Use (Commercl Ad Spec) | ||
| 33 | XSTORNIERT |
XSTORNIERT | XFELD | CHAR | 1 | 0 | IS-M: Canceled Order Object Indicator | ||
| 34 | XMOTIVTEXT |
XMOTIVTEXT | XFELD | CHAR | 1 | 0 | IS-M/AM: Text Exists for the Ad Spec Indicator |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | JHAMOTW | AVM_NR |  JHAK |
AVM_NR |
KEY | 1 | CN |
| 2 | JHAMOTW | MANDT | T000 |
MANDT |
KEY | 1 | CN |
| 3 | JHAMOTW | VORL_AVMNR | JHAK |
AVM_NR |
REF | 1 | CN |
| 4 | JHAMOTW | WS_SENDFRM | TJJW5 |
WS_SENDFRM |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |
