SAP ABAP View JHV_MOT_ALI01 (IS-M/AM: Ad Spec Data for Order List)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷ IS-M (Application Component) SAP Media
⤷ JAS (Package) Application development R/3 Publishing Advertising System***
⤷ IS-M (Application Component) SAP Media
⤷ JAS (Package) Application development R/3 Publishing Advertising System***
Basic Data
View Type | D | Database View |
Database View | JHV_MOT_ALI01 | |
Short Description | IS-M/AM: Ad Spec Data for Order List | |
Root table | JHAMOZ | IS-M/AM: Assign Ad Specs to Order Objects |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | JHAMOZ | JHAMOZ | ||
2 | JHAMOT |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | JHAMOZ | MANDT | JL | EQ | 0 | 0 | ||||
2 | JHAMOT | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | JHAMOZ | AVM_NR | JL | EQ | 0 | 0 | ||||
4 | JHAMOT | AVM_NR | JR | EQ | AND | 0 | 0 | |||
5 | JHAMOZ | MOTIV | JL | EQ | 0 | 0 | ||||
6 | JHAMOT | MOTIV | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | JHAMOZ | MANDT | MANDT | Client | |||
2 | AVM_NR | JHAMOZ | AVM_NR | AVM_NR | IS-M/AM: Sales Document Number | |||
3 | POS_NR | JHAMOZ | POS_NR | POS_NR | IS-M: Order Item Number | |||
4 | UPOS_NR | JHAMOZ | UPOS_NR | UPOS_NR | IS-M: Order Sub-Item Number | |||
5 | EIN_NR | JHAMOZ | EIN_NR | EIN_NR | IS-M: Schedule Line | |||
6 | MOTIV | JHAMOZ | MOTIV | MOTIV_NR | IS-M: Ad Spec Number (Ad) | |||
7 | MOTIVID | JHAMOT | MOTIVID | MOTIVID | IS-M: Assigned ad spec/ad spec file in technical system | |||
8 | AZART_SOND | JHAMOT | AZART_SOND | AZART_SOND | IS-M: Ad Type - Special Handling Type | |||
9 | AZART_GEST | JHAMOT | AZART_GEST | AZART_GEST | IS-M: Design Ad Type | |||
10 | AZART_FORM | JHAMOT | AZART_FORM | AZART_FORM | IS-M: Shape Ad Type | |||
11 | AZART_AREA | JHAMOT | AZART_AREA | AZART_AREA | IS-M/AM: Fixed Format Proposal /Ad Dimensions | |||
12 | HOEHE_I | JHAMOT | HOEHE_I | HOEHE_I | IS-M: Actual height of the ad spec | |||
13 | HOEHE_I_EH | JHAMOT | HOEHE_I_EH | ISPEINH_H | IS-M: Unit of Measure for Height | |||
14 | BREITE_I | JHAMOT | BREITE_I | BREITE_I | IS-M: Actual Ad Spec Width | |||
15 | BREITE_IEH | JHAMOT | BREITE_IEH | BREITE_SEH | IS-M/AM: Unit of Measure for Width | |||
16 | HOEHE_S | JHAMOT | HOEHE_S | HOEHE_S | IS-M: Planned Height of the Ad Spec | |||
17 | HOEHE_S_EH | JHAMOT | HOEHE_S_EH | ISPEINH_H | IS-M: Unit of Measure for Height | |||
18 | BREITE_S | JHAMOT | BREITE_S | BREITE_S | IS-M: Planned Ad Spec Width | |||
19 | BREITE_SEH | JHAMOT | BREITE_SEH | BREITE_SEH | IS-M/AM: Unit of Measure for Width | |||
20 | AZART_FARB | JHAMOT | AZART_FARB | AZART_FARB | IS-M: Color Scheme Ad Type | |||
21 | STICHW | JHAMOT | STICHW | STICHW | IS-M: Keyword | |||
22 | XPRNOTW | JHAMOT | XPRNOTW | XPRNOTW | IS-M: Ad Spec Check Required But Not Performed | |||
23 | XPRINHNOTW | JHAMOT | XPRINHNOTW | XPRINHNOTW | IS-M: Content Check Required But Not Performed | |||
24 | XKUNK_NOTW | JHAMOT | XKUNK_NOTW | XKUNK_NOTW | IS-M: Customer correction necessary but not performed | |||
25 | XMOTPROD | JHAMOT | XMOTPROD | XMOTPROD | IS-M: Ad Spec Technically Complete Indicator | |||
26 | XDIFF_SIZE | JHAMOT | XDIFF_SIZE | XDIFF_SIZE | IS-M: Alternative Actual Size | |||
27 | MOTIVSTAT | JHAMOT | MOTIVSTAT | MOTIVSTAT | IS-M: Ad spec status | |||
28 | XUVMOT | JHAMOT | XUVMOT | XUVMOT | IS-M: "Ad spec data incomplete" indicator | |||
29 | SEITE_FSP | JHAMOT | SEITE_FSP | SEITE_FSP | IS-M: Page/column format | |||
30 | NOTIZ | JHAMOT | NOTIZ | MOTIVNOTIZ | IS-M: Note for Ad Spec Design | |||
31 | TEXTSPITZE | JHAMOT | TEXTSPITZE | TEXTSPITZE | IS-M: Ad Text Header | |||
32 | RULE_GROUP_CV | JHAMOT | RULE_GROUP_CV | ISM_RULE_GROUP_CV_AMC | IS-M: Ad Content Validation Rule Group in IS-M/AMC | |||
Maintenance Status
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 |