SAP ABAP Table RJHA401 (IS-PAM: Screen Structure for the Advertisement Item List)
Hierarchy
☛ 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 RJHA401   Table Relationship Diagram
Short Description IS-PAM: Screen Structure for the Advertisement Item List    
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 MARK XFELD XFELD CHAR 1   0   Checkbox  
2 .INCLUDE       0   0   IS-M/AM: Order-Publishing-Media Ad Item  
3 MANDT MANDT MANDT CLNT 3   0   Client T000
4 AVM_NR AVM_NR AVM_NR CHAR 10   0   IS-M/AM: Sales Document Number JHAK
5 POS_NR POS_NR AVM_PNR NUMC 3   0   IS-M: Order Item Number JHAP
6 .INCLUDE       0   0   IS-M: Include for Specific Ad Item Attributes  
7 INHK_TECH1 INHK_TECH1 INHALTSKOM CHAR 8   0   IS-M: Technical Content Component (Positioning View) JJTIKO
8 INHK_TLEV1 INHK_LEV1 INHALTSKOM CHAR 8   0   IS-M: Level 1 content component in the hierarchy *
9 INHK_TECH2 INHK_SOVER INHALTSKOM CHAR 8   0   IS-M: Special Publication Content Component JJTIKO
10 INHK_KFM INHK_KFM INHALTSKOM CHAR 8   0   IS-M: Business Content Component JJTIKO
11 INHK_KLEV1 INHK_LEV1 INHALTSKOM CHAR 8   0   IS-M: Level 1 content component in the hierarchy *
12 MVA_INHALT MVA_INHALT MVA_INHALT CHAR 4   0   IS-M: Media Publication Content Type TJJ23
13 PLAZIERUNG PLAZIERANW PLAZIERANW CHAR 2   0   IS-M/AM: Positioning Instruction TJJ65
14 AZART_PLAZ AZART_PLAZ AZART_PLAZ CHAR 4   0   IS-M: Ad Type with Regard to General Positioning TJJ15
15 TEC_AVM_NR TEC_AVM_NR CHAR10 CHAR 10   0   IS-M: Order number in technical system  
16 XPLANUNG X_PLANUNG XFELD CHAR 1   0   IS-M: Relevant for planning indicator  
17 XBLATTBEST XBLATTBEST XFELD CHAR 1   0   IS-M: Page-Defining Indicator  
18 TBEL TEILBEL TEILBEL CHAR 2   0   IS-M: Selective Booking (Advertisement Item Type) TJHTBEL
19 XTEXT_INT XTEXT_INT XFELD CHAR 1   0   IS-M: Internal positioning comment indicator  
20 XTEXT_EXT XTEXT_EXT XFELD CHAR 1   0   IS-M: External positioning comment exists indicator  
21 XFESTPLATZ XFEST_PLAZ XFELD CHAR 1   0   IS-M: Positioning Ad Type is a Fixed Positioning Indicator  
22 XROHTKNZ XROHTKNZ XFELD CHAR 1   0   IS-M: Raw Text Available for the Item Indicator  
23 XGESTREUT XGESTREUT XFELD CHAR 1   0   IS-M: Ad Spec Should Be Scattered Indicator  
24 .INCLUDE       0   0   IS-PAM: Date Attributes  
25 TERM_TYP TERMINTYP TERMINTYP CHAR 1   0   IS-M/AM: Date Category Copy Number/Publication Date TJH55
26 ANFANG_PER ANFANG_PER PAM_PERIOD CHAR 14   0   IS-M: Start of Copy/Publication Date Period  
27 ENDE_PER ENDE_PER PAM_PERIOD CHAR 14   0   IS-M: End of Period - Issue/Publication Date  
28 SELDAT_VON SELDAT_VON DATUM DATS 8   0   IS-M: Start Date for Item  
29 SELDAT_BIS SELDAT_BIS DATUM DATS 8   0   IS-M: End Date for Items  
30 BIS_PLUS BIS_PLUS BIS_PLUS CHAR 1   0   IS-M: Indicates a Period ("-") or 2 Dates ("+")  
31 ANZ_SCHALT ANZ_SCHALT ANZ_SCHALT NUMC 3   0   IS-M: Number of Placements  
32 TERM_ZYKL ANZ_ZYKLUS ANZ_ZYKLUS CHAR 4   0   IS-M: Frequency for Ad Publication TJJ57
33 TERMINART TERMINART TERMINART CHAR 1   0   IS-M/AM: Type of Publication Date  
34 ERSCH_T ERSCH_T DATUM DATS 8   0   IS-M: Publication Date  
35 WUNSCH_T WUNSCH_T DATUM DATS 8   0   IS-M/AM: Date Required  
36 .INCLUDE       0   0   IS-M/AM: Include for Weekday String  
37 X_MONTAG JHT_MONTAG XFELD CHAR 1   0   IS-M: Date Field Indicator - Monday  
38 X_DIENSTAG JHT_DIENSTAG XFELD CHAR 1   0   IS-M: Date Field Indicator - Tuesday  
39 X_MITTWOCH JHT_MITTWOCH XFELD CHAR 1   0   IS-M: Date Field Indicator - Wednesday  
40 X_DONNERST JHT_DONNERST XFELD CHAR 1   0   IS-M: Date Field Indicator - Thursday  
41 X_FREITAG JHT_FREITAG XFELD CHAR 1   0   IS-M: Date Field Indicator - Friday  
42 X_SAMSTAG JHT_SAMSTAG XFELD CHAR 1   0   IS-M: Date Field Indicator - Saturday  
43 X_SONNTAG JHT_SONNTAG XFELD CHAR 1   0   IS-M: Date Field Indicator - Sunday  
44 .INCLUDE       0   0   IS-PAM: Include for Box Number Attributes  
45 CHIFFRE_NR CHIFFRE CHIFFRE_NR CHAR 10   0   IS-M/AM: Box Number  
46 CHIFFRE_KZ CHIFFRE_KZ CHIFFRE_KZ CHAR 1   0   IS-M: Box Number Indicator TJH59
47 CHIFFRE_OR CHIFFRE_OR VKBUR CHAR 4   0   IS-M: Box Number Location TVBUR
48 .INCLUDE       0   0   IS-PAM: Status indicator for advertisement item  
49 XUVMOT XUVMOT XFELD CHAR 1   0   IS-M: "Ad spec data incomplete" indicator  
50 XUVTECH XUVTECH XFELD CHAR 1   0   IS-M: Incomplete Regarding Technical System (Gen.)  
51 XNOCHG_TEC XNOCHG_TEC XFELD CHAR 1   0   IS-M: Cannot be changed for technical reasons indicator  
52 XTECH_MIN1 XTECH_MIN1 XFELD CHAR 1   0   IS-M: Tech.process.started (for at least 1 schedule line)  
53 XTECH_EE XTECH_EE XFELD CHAR 1   0   IS-M: Tech.Complete (All Schedule Lines Fully Processed)  
54 XSPERR_TEC XSPERR_TEC XFELD CHAR 1   0   IS-M: Blocked in technical system indicator  
55 AENVERS_NR AENVERS_NR AENVERS_NR NUMC 4   0   IS-M: Last Change Version for Technical System  
56 .INCLUDE       0   0   IS-M/AM: Characteristics for Individual Use  
57 MERKMAL0 MERK0_PA XFELD CHAR 1   0   IS-M: Characteristic 0 for Individual Use (Ad Item)  
58 MERKMAL1 MERK1_PA XFELD CHAR 1   0   IS-M: Characteristic 1 for Individual Use (Ad Item)  
59 MERKMAL2 MERK2_PA XFELD CHAR 1   0   IS-M: Characteristic 2 for Individual Use (Ad Item)  
60 MERKMAL3 MERK3_PA XFELD CHAR 1   0   IS-M: Characteristic 3 for Individual Use (Ad Item)  
61 MERKMAL4 MERK4_PA XFELD CHAR 1   0   IS-M: Characteristic 4 for Individual Use (Ad Item)  
62 MERKMAL5 MERK5_PA XFELD CHAR 1   0   IS-M: Characteristic 5 for Individual Use (Ad Item)  
63 MERKMAL6 MERK6_PA XFELD CHAR 1   0   IS-M: Characteristic 6 for Individual Use (Ad Item)  
64 MERKMAL7 MERK7_PA XFELD CHAR 1   0   IS-M: Characteristic 7 for Individual Use (Ad Item)  
65 MERKMAL8 MERK8_PA XFELD CHAR 1   0   IS-M: Characteristic 8 for Individual Use (Ad Item)  
66 MERKMAL9 MERK9_PA XFELD CHAR 1   0   IS-M: Characteristic 9 for Individual Use (Ad Item)  
67 KONKAUS KONKAUS KONKAUS CHAR 2   0   IS-M: Competitor exclusion TJH89
68 KONKAUSKOM KONKAUSKOM TEXT35 CHAR 35   0   IS-M: Comment on competitor exclusion  
69 PRODH J_PRODH J_PRODH CHAR 18   0   IS-M/AM: Product Hierarchy JJT179
70 SORTWORT SORTWORT TEXT10 CHAR 10   0   IS-M: Sort Word  
71 .INCLUDE       0   0   IS-M/AM: Include for Pure Item Attributes  
72 POS_ART AVMPOS_ART AVMPOS_ART CHAR 2   0   IS-M: Order-Publishing-Media - Item Type TJH17
73 PSTYV PSTYV_PAM PSTYV_PAM CHAR 4   0   IS-M: Item Category for Sales Document TJHAP
74 VBTYP ISPVBTYP ISPVBTYP CHAR 1   0   IS-M/AM: Sales Document Category  
75 WERBK_TYP WKOMBI_TYP WKOMBI_TYP CHAR 2   0   IS-M: Combination Sale Type TJH91
76 WERBK_KNZ WERBK_KNZ WERBEKKNZ NUMC 4   0   IS-M: Combination Sale Indicator  
77 XAGENAUFTR XAGENAUFTR XFELD CHAR 1   0   IS-M: Agency order indicator  
78 XEINTEILG XEINTEILG XFELD CHAR 1   0   IS-M: Indicator for modification at subordinate ord. level  
79 BRAN_PAM BRAN_POS BRACO CHAR 10   0   IS-M/AM: Current Industry Sector Associated With Order Item TBRC
80 STATUSK STATUSK PAM_STATUS CHAR 2   0   IS-M: Status  
81 .INCLUDE       0   0   IS-PAM: Agent attributes outside agent assignment  
82 VERMITTLER VERMK JJMVERM CHAR 10   0   IS-M: Sales Agent with ID Code for Screen *
83 VNR JVMVVNR JVMVVNR CHAR 10   0   IS-M: Media Sales Agent Contract Number JJTVV
84 BEDNR VM_BEDNR VM_BEDNR NUMC 6   0   IS-M: Number of Media Sales Agent Contract Requirement JJTVB
85 PROSL JPROVSCHL PRSCHL CHAR 5   0   IS-M/AM: Commission Key for Media Sales Agent TJH23
86 KAMPAGNE KAMPAGNE KAMPAGNE CHAR 6   0   IS-M: Campaign (customer) TJJKAMP
87 WERBK_POS WERBK_POS AVM_PNR NUMC 3   0   IS-M: Combination Sale Grouping Item Number JHAP
88 WERBK_UPOS WERBK_UPOS AVM_UPNR NUMC 4   0   IS-M: Combination Sale Grouping Sub-Item  
89 WERBK_EINT WERBK_EINT AVMENR NUMC 6   0   IS-M: Combination Sale Grouping for Schedule Line Number JHAE
90 REF_AVM_NR REF_AVM_NR AVM_NR CHAR 10   0   IS-M: Reference Order Number of Preceding Order JHAK
91 REF_POS_NR REF_POS_NR AVM_PNR NUMC 3   0   IS-M: Reference Item Number of Preceding Item JHAP
92 SUC_AVM_NR SUC_AVM_NR AVM_NR CHAR 10   0   IS-M: Order Number of Subsequent Document JHAK
93 SUC_POS_NR SUC_POS_NR AVM_PNR NUMC 3   0   IS-M: Item Number of Subsequent Item JHAP
94 VORL_AVMNR VORL_AVMNR AVM_NR CHAR 10   0   IS-M: Order Number of the Preceding Document JHAK
95 VORL_POSNR VORL_POSNR AVM_PNR NUMC 3   0   IS-M: Item number of the Preceding Item JHAP
96 CAMPAIGN ISM_MARKETING_CAMPAIGN ISM_MARKETING_CAMPAIGN RAW 16   0   IS-M: Marketing Campaign  
97 PREIS_OM PREIS_OM WERTV8 CURR 15   2   IS-M: Price excluding VAT  
98 PREIS_IM PREIS_IM WERTV8 CURR 15   2   IS-M: Price including VAT  
99 PREIS_AVM1 PREIS_AVM1 WERTV8 CURR 15   2   IS-M: Price Field 1 in the Order  
100 PREIS_AVM2 PREIS_AVM2 WERTV8 CURR 15   2   IS-M: Price Field 2 in the Order  
101 MWST_BETR GRMWSTBETR WERTV7 CURR 13   2   IS-M: Value-Added Tax Amount  
102 WAEHRG WAERK WAERS CUKY 5   0   SD document currency TCURC
103 BELEGEINH BELEGEINH BELEINH CHAR 10   0   IS-M/AM: Booking Unit *
104 BE_KURZ BEZEICHN15 TEXT15 CHAR 15   0   IS-M: Short Text  
105 BEKENNZ BEKENNZ XFELD CHAR 1   0   IS-M: Booking Unit Indicator  
106 INHKK_TEXT BEZEICHN15 TEXT15 CHAR 15   0   IS-M: Short Text  
107 STAT_AMPEL STAT_AMPEL SYCHAR132 CHAR 132   0   IS-M: Status visualization  
108 EINTL_ANZ EINTL_ANZ NUMC6 NUMC 6   0   IS-M: Number of Schedule Lines in an Item  
109 NE_TERMIN NE_TERMIN DATUM DATS 8   0   IS-M: Next/Last Publication Date  
110 NE_HEFT NE_HEFT PAM_PERIOD CHAR 14   0   IS-M: Copy Number for the Next/Last Publication  
111 MOTIV MOTIV_NR PAM_MOTIV NUMC 6   0   IS-M: Ad Spec Number (Ad) *
112 NOTIZ MOTIVNOTIZ TEXT50 CHAR 50   0   IS-M: Note for Ad Spec Design  
113 TEXTSPITZE TEXTSPITZE TEXT25 CHAR 25   0   IS-M: Ad Text Header  
114 STICHW STICHW TEXT40 CHAR 40   0   IS-M: Keyword  
115 AZART_FARB AZART_FARB AZART_FARB CHAR 4   0   IS-M: Color Scheme Ad Type TJJ11
116 AZART_GEST AZART_GEST AZART_GEST CHAR 4   0   IS-M: Design Ad Type TJJ19
117 AZART_AREA AZART_AREA AZART_AREA CHAR 4   0   IS-M/AM: Fixed Format Proposal /Ad Dimensions TJJ13
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 RJHA401 AVM_NR JHAK AVM_NR KEY 1 CN
2 RJHA401 AZART_AREA TJJ13 AZART_AREA    
3 RJHA401 AZART_FARB TJJ11 AZART_FARB    
4 RJHA401 AZART_GEST TJJ19 AZART_GEST    
5 RJHA401 AZART_PLAZ TJJ15 AZART_PLAZ 1 CN
6 RJHA401 BEDNR JJTVB BEDNR KEY 1 CN
7 RJHA401 BRAN_PAM TBRC BRACO REF 1 CN
8 RJHA401 CHIFFRE_KZ TJH59 CHIFFRE_KZ    
9 RJHA401 CHIFFRE_OR TVBUR VKBUR    
10 RJHA401 INHK_KFM JJTIKO INHALTSKOM REF 1 CN
11 RJHA401 INHK_TECH1 JJTIKO INHALTSKOM REF 1 CN
12 RJHA401 INHK_TECH2 JJTIKO INHALTSKOM REF 1 CN
13 RJHA401 KAMPAGNE TJJKAMP KAMPAGNE REF 1 CN
14 RJHA401 KONKAUS TJH89 KONKAUS REF 1 CN
15 RJHA401 MANDT T000 MANDT KEY 1 CN
16 RJHA401 MVA_INHALT TJJ23 MVA_INHALT KEY 1 CN
17 RJHA401 PLAZIERUNG TJJ65 PLAZIERANW REF 1 CN
18 RJHA401 POS_ART TJH17 AVMPOS_ART REF 1 CN
19 RJHA401 POS_NR JHAP POS_NR KEY 1 CN
20 RJHA401 PRODH JJT179 PRODH    
21 RJHA401 PROSL TJH23 PRSCHL KEY 1 CN
22 RJHA401 PSTYV TJHAP PSTYV REF 1 CN
23 RJHA401 REF_AVM_NR JHAK AVM_NR REF 1 CN
24 RJHA401 REF_POS_NR JHAP POS_NR REF 1 CN
25 RJHA401 SUC_AVM_NR JHAK AVM_NR REF 1 CN
26 RJHA401 SUC_POS_NR JHAP POS_NR REF 1 CN
27 RJHA401 TBEL TJHTBEL TBEL REF 1 CN
28 RJHA401 TERM_TYP TJH55 TERM_TYP REF 1 CN
29 RJHA401 TERM_ZYKL TJJ57 RHYTHMUS    
30 RJHA401 VNR JJTVV VNR KEY 1 CN
31 RJHA401 VORL_AVMNR JHAK AVM_NR REF 1 CN
32 RJHA401 VORL_POSNR JHAP POS_NR KEY 1 CN
33 RJHA401 WAEHRG TCURC WAERS REF 1 CN
34 RJHA401 WERBK_EINT JHAE EIN_NR 1 CN
35 RJHA401 WERBK_POS JHAP POS_NR 1 CN
36 RJHA401 WERBK_TYP TJH91 WKOMBI_TYP 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in