SAP ABAP Table BAPIBUSISM008_AD_SPEC_CM_OUT (IS-M/AM: Commercial Ad Spec)
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 | INTTAB | Structure |
| Structure | BAPIBUSISM008_AD_SPEC_CM_OUT |
Table Relationship Diagram 
|
| Short Description | IS-M/AM: Commercial Ad Spec |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| 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 |  DOCUMENT_NO |
AVM_NR | AVM_NR | CHAR | 10 | 0 | IS-M/AM: Sales Document Number | JHAK | |
| 2 | AD_SPEC_NO |
WSMOTIV_NR | PAM_WS_MOT | NUMC | 6 | 0 | IS-M: Order ad spec number (commercial) | JHAMOTW | |
| 3 | TECHNICAL_AD_SPEC_ID |
MOTIVID | MOTIVID | CHAR | 12 | 0 | IS-M: Assigned ad spec/ad spec file in technical system | ||
| 4 | AD_SPEC_NOTE |
MOTIVNOTIZ | TEXT50 | CHAR | 50 | 0 | IS-M: Note for Ad Spec Design | ||
| 5 | KEYWORD |
STICHW | TEXT40 | CHAR | 40 | 0 | IS-M: Keyword | ||
| 6 | PRODUCT_HIERARCHY |
J_PRODH | J_PRODH | CHAR | 18 | 0 | IS-M/AM: Product Hierarchy | JJT179 | |
| 7 | CM_DESIGN_TYPE |
WS_SENDFRM | WS_SENDFRM | CHAR | 2 | 0 | IS-M: Commercial Design Type | TJJW5 | |
| 8 | PLANNED_LENGTH |
WS_LENGTHS | WS_LENGTH | NUMC | 4 | 0 | IS-M: Planned length of commercial in seconds | ||
| 9 | ACTUAL_LENGTH |
WS_LENGTHI | WS_LENGTH | NUMC | 4 | 0 | IS-M: Actual length of commercial in seconds | ||
| 10 | ADD_INFORMATION1 |
MOTEXTINF1 | CHAR30 | CHAR | 30 | 0 | IS-M: Freely Definable Additional Information on Ad Spec | ||
| 11 | ADD_INFORMATION2 |
MOTEXTINF2 | CHAR30 | CHAR | 30 | 0 | IS-M: Freely Definable Additional Information on Ad Spec | ||
| 12 | ADD_INFORMATION3 |
MOTEXTINF3 | CHAR30 | CHAR | 30 | 0 | IS-M: Freely Definable Additional Information on Ad Spec | ||
| 13 | ADD_INFORMATION4 |
MOTEXTINF4 | CHAR30 | CHAR | 30 | 0 | IS-M: Freely Definable Additional Information on Ad Spec | ||
| 14 | AD_SPEC_INCOMPLETE |
XUVMOT | XFELD | CHAR | 1 | 0 | IS-M: "Ad spec data incomplete" indicator | ||
| 15 | TECHNICALLY_COMPLETE |
XMOTPROD | XFELD | CHAR | 1 | 0 | IS-M: Ad Spec Technically Complete Indicator | ||
| 16 | STATUS_CHARACTERISTIC0 |
MERK0_MOTW | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 0 for Individual Use (Commercl Ad Spec) | ||
| 17 | STATUS_CHARACTERISTIC1 |
MERK1_MOTW | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 1 for Individual Use (Commercl Ad Spec) | ||
| 18 | STATUS_CHARACTERISTIC2 |
MERK2_MOTW | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 2 for Individual Use (Commercl Ad Spec) | ||
| 19 | STATUS_CHARACTERISTIC3 |
MERK3_MOTW | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 3 for Individual Use (Commercl Ad Spec) | ||
| 20 | STATUS_CHARACTERISTIC4 |
MERK4_MOTW | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 4 for Individual Use (Commercl Ad Spec) | ||
| 21 | STATUS_CHARACTERISTIC5 |
MERK5_MOTW | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 5 for Individual Use (Commercl Ad Spec) | ||
| 22 | STATUS_CHARACTERISTIC6 |
MERK6_MOTW | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 6 for Individual Use (Commercl Ad Spec) | ||
| 23 | STATUS_CHARACTERISTIC7 |
MERK7_MOTW | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 7 for Individual Use (Commercl Ad Spec) | ||
| 24 | STATUS_CHARACTERISTIC8 |
MERK8_MOTW | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 8 for Individual Use (Commercl Ad Spec) | ||
| 25 | STATUS_CHARACTERISTIC9 |
MERK9_MOTW | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 9 for Individual Use (Commercl Ad Spec) | ||
| 26 | CANCELLED |
XSTORNIERT | XFELD | CHAR | 1 | 0 | IS-M: Canceled Order Object Indicator | ||
| 27 | STATUS |
MOTIVSTAT | PAM_STATUS | CHAR | 2 | 0 | IS-M: Ad spec status | ||
| 28 | TEMPLATE_DOCUMENT_NO |
VORL_AVMNR | AVM_NR | CHAR | 10 | 0 | IS-M: Order Number of the Preceding Document | JHAK | |
| 29 | TEMPLATE_AD_SPEC_NO |
VORL_WMONR | PAM_WS_MOT | NUMC | 6 | 0 | IS-M: Ad spec template (commercial) | JHAMOTW | |
| 30 | TEMPLATE_TECHNICAL_AD_SPEC_ID |
VORL_TECID | MOTIVID | CHAR | 12 | 0 | IS-M: Ad spec template (description in technical system) |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | BAPIBUSISM008_AD_SPEC_CM_OUT | AD_SPEC_NO |  JHAMOTW |
MOTIV |
KEY | 1 | CN |
| 2 | BAPIBUSISM008_AD_SPEC_CM_OUT | CM_DESIGN_TYPE | TJJW5 |
WS_SENDFRM |
REF | 1 | CN |
| 3 | BAPIBUSISM008_AD_SPEC_CM_OUT | DOCUMENT_NO | JHAK |
AVM_NR |
KEY | 1 | CN |
| 4 | BAPIBUSISM008_AD_SPEC_CM_OUT | PRODUCT_HIERARCHY | JJT179 |
PRODH |
REF | 1 | CN |
| 5 | BAPIBUSISM008_AD_SPEC_CM_OUT | TEMPLATE_AD_SPEC_NO | JHAMOTW |
MOTIV |
REF | 1 | CN |
| 6 | BAPIBUSISM008_AD_SPEC_CM_OUT | TEMPLATE_DOCUMENT_NO | JHAK |
AVM_NR |
REF | 1 | CN |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in | 464 |
