SAP ABAP Table JHAPA (IS-M/AM: Order-Publishing-Media Ad Item)
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 | JHAPA |
Table Relationship Diagram 
|
| Short Description | IS-M/AM: Order-Publishing-Media Ad Item |
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 | POS_NR |
POS_NR | AVM_PNR | NUMC | 3 | 0 | IS-M: Order Item Number | JHAP | |
| 4 | .INCLUDE |
0 | 0 | IS-M: Include for Specific Ad Item Attributes | |||||
| 5 | INHK_TECH1 |
INHK_TECH1 | INHALTSKOM | CHAR | 8 | 0 | IS-M: Technical Content Component (Positioning View) | JJTIKO | |
| 6 | INHK_TLEV1 |
INHK_LEV1 | INHALTSKOM | CHAR | 8 | 0 | IS-M: Level 1 content component in the hierarchy | * | |
| 7 | INHK_TECH2 |
INHK_SOVER | INHALTSKOM | CHAR | 8 | 0 | IS-M: Special Publication Content Component | JJTIKO | |
| 8 | INHK_KFM |
INHK_KFM | INHALTSKOM | CHAR | 8 | 0 | IS-M: Business Content Component | JJTIKO | |
| 9 | INHK_KLEV1 |
INHK_LEV1 | INHALTSKOM | CHAR | 8 | 0 | IS-M: Level 1 content component in the hierarchy | * | |
| 10 | MVA_INHALT |
MVA_INHALT | MVA_INHALT | CHAR | 4 | 0 | IS-M: Media Publication Content Type | TJJ23 | |
| 11 | PLAZIERUNG |
PLAZIERANW | PLAZIERANW | CHAR | 2 | 0 | IS-M/AM: Positioning Instruction | TJJ65 | |
| 12 | AZART_PLAZ |
AZART_PLAZ | AZART_PLAZ | CHAR | 4 | 0 | IS-M: Ad Type with Regard to General Positioning | TJJ15 | |
| 13 | TEC_AVM_NR |
TEC_AVM_NR | CHAR10 | CHAR | 10 | 0 | IS-M: Order number in technical system | ||
| 14 | XPLANUNG |
X_PLANUNG | XFELD | CHAR | 1 | 0 | IS-M: Relevant for planning indicator | ||
| 15 | XBLATTBEST |
XBLATTBEST | XFELD | CHAR | 1 | 0 | IS-M: Page-Defining Indicator | ||
| 16 | TBEL |
TEILBEL | TEILBEL | CHAR | 2 | 0 | IS-M: Selective Booking (Advertisement Item Type) | TJHTBEL | |
| 17 | XTEXT_INT |
XTEXT_INT | XFELD | CHAR | 1 | 0 | IS-M: Internal positioning comment indicator | ||
| 18 | XTEXT_EXT |
XTEXT_EXT | XFELD | CHAR | 1 | 0 | IS-M: External positioning comment exists indicator | ||
| 19 | XFESTPLATZ |
XFEST_PLAZ | XFELD | CHAR | 1 | 0 | IS-M: Positioning Ad Type is a Fixed Positioning Indicator | ||
| 20 | XROHTKNZ |
XROHTKNZ | XFELD | CHAR | 1 | 0 | IS-M: Raw Text Available for the Item Indicator | ||
| 21 | XGESTREUT |
XGESTREUT | XFELD | CHAR | 1 | 0 | IS-M: Ad Spec Should Be Scattered Indicator | ||
| 22 | .INCLUDE |
0 | 0 | IS-PAM: Date Attributes | |||||
| 23 | TERM_TYP |
TERMINTYP | TERMINTYP | CHAR | 1 | 0 | IS-M/AM: Date Category Copy Number/Publication Date | TJH55 | |
| 24 | ANFANG_PER |
ANFANG_PER | PAM_PERIOD | CHAR | 14 | 0 | IS-M: Start of Copy/Publication Date Period | ||
| 25 | ENDE_PER |
ENDE_PER | PAM_PERIOD | CHAR | 14 | 0 | IS-M: End of Period - Issue/Publication Date | ||
| 26 | SELDAT_VON |
SELDAT_VON | DATUM | DATS | 8 | 0 | IS-M: Start Date for Item | ||
| 27 | SELDAT_BIS |
SELDAT_BIS | DATUM | DATS | 8 | 0 | IS-M: End Date for Items | ||
| 28 | BIS_PLUS |
BIS_PLUS | BIS_PLUS | CHAR | 1 | 0 | IS-M: Indicates a Period ("-") or 2 Dates ("+") | ||
| 29 | ANZ_SCHALT |
ANZ_SCHALT | ANZ_SCHALT | NUMC | 3 | 0 | IS-M: Number of Placements | ||
| 30 | TERM_ZYKL |
ANZ_ZYKLUS | ANZ_ZYKLUS | CHAR | 4 | 0 | IS-M: Frequency for Ad Publication | TJJ57 | |
| 31 | TERMINART |
TERMINART | TERMINART | CHAR | 1 | 0 | IS-M/AM: Type of Publication Date | ||
| 32 | ERSCH_T |
ERSCH_T | DATUM | DATS | 8 | 0 | IS-M: Publication Date | ||
| 33 | WUNSCH_T |
WUNSCH_T | DATUM | DATS | 8 | 0 | IS-M/AM: Date Required | ||
| 34 | .INCLUDE |
0 | 0 | IS-M/AM: Include for Weekday String | |||||
| 35 | X_MONTAG |
JHT_MONTAG | XFELD | CHAR | 1 | 0 | IS-M: Date Field Indicator - Monday | ||
| 36 | X_DIENSTAG |
JHT_DIENSTAG | XFELD | CHAR | 1 | 0 | IS-M: Date Field Indicator - Tuesday | ||
| 37 | X_MITTWOCH |
JHT_MITTWOCH | XFELD | CHAR | 1 | 0 | IS-M: Date Field Indicator - Wednesday | ||
| 38 | X_DONNERST |
JHT_DONNERST | XFELD | CHAR | 1 | 0 | IS-M: Date Field Indicator - Thursday | ||
| 39 | X_FREITAG |
JHT_FREITAG | XFELD | CHAR | 1 | 0 | IS-M: Date Field Indicator - Friday | ||
| 40 | X_SAMSTAG |
JHT_SAMSTAG | XFELD | CHAR | 1 | 0 | IS-M: Date Field Indicator - Saturday | ||
| 41 | X_SONNTAG |
JHT_SONNTAG | XFELD | CHAR | 1 | 0 | IS-M: Date Field Indicator - Sunday | ||
| 42 | .INCLUDE |
0 | 0 | IS-PAM: Include for Box Number Attributes | |||||
| 43 | CHIFFRE_NR |
CHIFFRE | CHIFFRE_NR | CHAR | 10 | 0 | IS-M/AM: Box Number | ||
| 44 | CHIFFRE_KZ |
CHIFFRE_KZ | CHIFFRE_KZ | CHAR | 1 | 0 | IS-M: Box Number Indicator | TJH59 | |
| 45 | CHIFFRE_OR |
CHIFFRE_OR | VKBUR | CHAR | 4 | 0 | IS-M: Box Number Location | TVBUR | |
| 46 | .INCLUDE |
0 | 0 | IS-PAM: Status indicator for advertisement item | |||||
| 47 | XUVMOT |
XUVMOT | XFELD | CHAR | 1 | 0 | IS-M: "Ad spec data incomplete" indicator | ||
| 48 | XUVTECH |
XUVTECH | XFELD | CHAR | 1 | 0 | IS-M: Incomplete Regarding Technical System (Gen.) | ||
| 49 | XNOCHG_TEC |
XNOCHG_TEC | XFELD | CHAR | 1 | 0 | IS-M: Cannot be changed for technical reasons indicator | ||
| 50 | XTECH_MIN1 |
XTECH_MIN1 | XFELD | CHAR | 1 | 0 | IS-M: Tech.process.started (for at least 1 schedule line) | ||
| 51 | XTECH_EE |
XTECH_EE | XFELD | CHAR | 1 | 0 | IS-M: Tech.Complete (All Schedule Lines Fully Processed) | ||
| 52 | XSPERR_TEC |
XSPERR_TEC | XFELD | CHAR | 1 | 0 | IS-M: Blocked in technical system indicator | ||
| 53 | AENVERS_NR |
AENVERS_NR | AENVERS_NR | NUMC | 4 | 0 | IS-M: Last Change Version for Technical System | ||
| 54 | .INCLUDE |
0 | 0 | IS-M/AM: Characteristics for Individual Use | |||||
| 55 | MERKMAL0 |
MERK0_PA | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 0 for Individual Use (Ad Item) | ||
| 56 | MERKMAL1 |
MERK1_PA | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 1 for Individual Use (Ad Item) | ||
| 57 | MERKMAL2 |
MERK2_PA | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 2 for Individual Use (Ad Item) | ||
| 58 | MERKMAL3 |
MERK3_PA | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 3 for Individual Use (Ad Item) | ||
| 59 | MERKMAL4 |
MERK4_PA | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 4 for Individual Use (Ad Item) | ||
| 60 | MERKMAL5 |
MERK5_PA | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 5 for Individual Use (Ad Item) | ||
| 61 | MERKMAL6 |
MERK6_PA | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 6 for Individual Use (Ad Item) | ||
| 62 | MERKMAL7 |
MERK7_PA | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 7 for Individual Use (Ad Item) | ||
| 63 | MERKMAL8 |
MERK8_PA | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 8 for Individual Use (Ad Item) | ||
| 64 | MERKMAL9 |
MERK9_PA | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 9 for Individual Use (Ad Item) | ||
| 65 | KONKAUS |
KONKAUS | KONKAUS | CHAR | 2 | 0 | IS-M: Competitor exclusion | TJH89 | |
| 66 | KONKAUSKOM |
KONKAUSKOM | TEXT35 | CHAR | 35 | 0 | IS-M: Comment on competitor exclusion | ||
| 67 | PRODH |
J_PRODH | J_PRODH | CHAR | 18 | 0 | IS-M/AM: Product Hierarchy | JJT179 | |
| 68 | SORTWORT |
SORTWORT | TEXT10 | CHAR | 10 | 0 | IS-M: Sort Word |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | JHAPA | AVM_NR |  JHAK |
AVM_NR |
KEY | 1 | CN |
| 2 | JHAPA | AZART_PLAZ | TJJ15 |
AZART_PLAZ |
1 | CN | |
| 3 | JHAPA | CHIFFRE_KZ | TJH59 |
CHIFFRE_KZ |
|||
| 4 | JHAPA | CHIFFRE_OR | TVBUR |
VKBUR |
|||
| 5 | JHAPA | INHK_KFM | JJTIKO |
INHALTSKOM |
REF | 1 | CN |
| 6 | JHAPA | INHK_TECH1 | JJTIKO |
INHALTSKOM |
REF | 1 | CN |
| 7 | JHAPA | INHK_TECH2 | JJTIKO |
INHALTSKOM |
REF | 1 | CN |
| 8 | JHAPA | KONKAUS | TJH89 |
KONKAUS |
1 | CN | |
| 9 | JHAPA | MANDT | T000 |
MANDT |
KEY | 1 | CN |
| 10 | JHAPA | MVA_INHALT | TJJ23 |
MVA_INHALT |
KEY | 1 | CN |
| 11 | JHAPA | PLAZIERUNG | TJJ65 |
PLAZIERANW |
REF | 1 | CN |
| 12 | JHAPA | POS_NR | JHAP |
POS_NR |
KEY | 1 | CN |
| 13 | JHAPA | PRODH | JJT179 |
PRODH |
REF | 1 | CN |
| 14 | JHAPA | TBEL | TJHTBEL |
TBEL |
REF | 1 | CN |
| 15 | JHAPA | TERM_TYP | TJH55 |
TERM_TYP |
REF | 1 | CN |
| 16 | JHAPA | TERM_ZYKL | TJJ57 |
RHYTHMUS |
History
| Last changed by/on | SAP | 20050224 |
| SAP Release Created in |
