SAP ABAP Table RJHA470 (IS-M/AM: Commercial Screen Structure)
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 RJHA470   Table Relationship Diagram
Short Description IS-M/AM: Commercial Screen Structure    
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 .INCLUDE       0   0   IS-PAM: Structure of OPM Commercial Item  
2 .INCLUDE       0   0   IS-M/AM: OPM Commercial 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-PAM: Include for Specific Commercial Attributes  
7 WS_ART WSPOT_ART WSPOT_ART CHAR 4   0   IS-M: Commercial Type TJJ41
8 .INCLUDE       0   0   IS-M/AM: Status Indicator for Ad Insert Item  
9 XTECH_MIN1 XTECH_MIN1 XFELD CHAR 1   0   IS-M: Tech.process.started (for at least 1 schedule line)  
10 XTECH_EE XTECH_EE XFELD CHAR 1   0   IS-M: Tech.Complete (All Schedule Lines Fully Processed)  
11 .INCLUDE       0   0   IS-M/AM: Characteristics for Individual Use  
12 MERKMAL0 MERK0_PW XFELD CHAR 1   0   IS-M: Characteristic 0 for Individual Use (Commercial Item)  
13 MERKMAL1 MERK1_PW XFELD CHAR 1   0   IS-M: Characteristic 1 for Individual Use (Commercial Item)  
14 MERKMAL2 MERK2_PW XFELD CHAR 1   0   IS-M: Characteristic 2 for Individual Use (Commercial Item)  
15 MERKMAL3 MERK3_PW XFELD CHAR 1   0   IS-M: Characteristic 3 for Individual Use (Commercial Item)  
16 MERKMAL4 MERK4_PW XFELD CHAR 1   0   IS-M: Characteristic 4 for Individual Use (Commercial Item)  
17 MERKMAL5 MERK5_PW XFELD CHAR 1   0   IS-M: Characteristic 5 for Individual Use (Commercial Item)  
18 MERKMAL6 MERK6_PW XFELD CHAR 1   0   IS-M: Characteristic 6 for Individual Use (Commercial Item)  
19 MERKMAL7 MERK7_PW XFELD CHAR 1   0   IS-M: Characteristic 7 for Individual Use (Commercial Item)  
20 MERKMAL8 MERK8_PW XFELD CHAR 1   0   IS-M: Characteristic 9 for Individual Use (Commercial Item)  
21 MERKMAL9 MERK9_PW XFELD CHAR 1   0   IS-M: Characteristic 9 for Individual Use (Commercial Item)  
22 KONKAUS KONKAUS KONKAUS CHAR 2   0   IS-M: Competitor exclusion TJH89
23 KONKAUSKOM KONKAUSKOM TEXT35 CHAR 35   0   IS-M: Comment on competitor exclusion  
24 INHK_KFM INHK_KFM INHALTSKOM CHAR 8   0   IS-M: Business Content Component JJTIKO
25 KONKA_TEXT BEZEICHN15 TEXT15 CHAR 15   0   IS-M: Short Text  
26 INHKK_TEXT BEZEICHN15 TEXT15 CHAR 15   0   IS-M: Short Text  
27 WSART_TEXT BEZEICHN15 TEXT15 CHAR 15   0   IS-M: Short Text  
28 .INCLUDE       0   0   IS-M/AM: Cross-Item Type Screen Fields  
29 .INCLUDE       0   0   IS-M/AM: Include for Pure Item Attributes  
30 POS_ART AVMPOS_ART AVMPOS_ART CHAR 2   0   IS-M: Order-Publishing-Media - Item Type TJH17
31 PSTYV PSTYV_PAM PSTYV_PAM CHAR 4   0   IS-M: Item Category for Sales Document TJHAP
32 VBTYP ISPVBTYP ISPVBTYP CHAR 1   0   IS-M/AM: Sales Document Category  
33 WERBK_TYP WKOMBI_TYP WKOMBI_TYP CHAR 2   0   IS-M: Combination Sale Type TJH91
34 WERBK_KNZ WERBK_KNZ WERBEKKNZ NUMC 4   0   IS-M: Combination Sale Indicator  
35 XAGENAUFTR XAGENAUFTR XFELD CHAR 1   0   IS-M: Agency order indicator  
36 XEINTEILG XEINTEILG XFELD CHAR 1   0   IS-M: Indicator for modification at subordinate ord. level  
37 BRAN_PAM BRAN_POS BRACO CHAR 10   0   IS-M/AM: Current Industry Sector Associated With Order Item TBRC
38 STATUSK STATUSK PAM_STATUS CHAR 2   0   IS-M: Status  
39 .INCLUDE       0   0   IS-PAM: Agent attributes outside agent assignment  
40 VERMITTLER VERMK JJMVERM CHAR 10   0   IS-M: Sales Agent with ID Code for Screen *
41 VNR JVMVVNR JVMVVNR CHAR 10   0   IS-M: Media Sales Agent Contract Number JJTVV
42 BEDNR VM_BEDNR VM_BEDNR NUMC 6   0   IS-M: Number of Media Sales Agent Contract Requirement JJTVB
43 PROSL JPROVSCHL PRSCHL CHAR 5   0   IS-M/AM: Commission Key for Media Sales Agent TJH23
44 KAMPAGNE KAMPAGNE KAMPAGNE CHAR 6   0   IS-M: Campaign (customer) TJJKAMP
45 WERBK_POS WERBK_POS AVM_PNR NUMC 3   0   IS-M: Combination Sale Grouping Item Number JHAP
46 WERBK_UPOS WERBK_UPOS AVM_UPNR NUMC 4   0   IS-M: Combination Sale Grouping Sub-Item  
47 WERBK_EINT WERBK_EINT AVMENR NUMC 6   0   IS-M: Combination Sale Grouping for Schedule Line Number JHAE
48 REF_AVM_NR REF_AVM_NR AVM_NR CHAR 10   0   IS-M: Reference Order Number of Preceding Order JHAK
49 REF_POS_NR REF_POS_NR AVM_PNR NUMC 3   0   IS-M: Reference Item Number of Preceding Item JHAP
50 SUC_AVM_NR SUC_AVM_NR AVM_NR CHAR 10   0   IS-M: Order Number of Subsequent Document JHAK
51 SUC_POS_NR SUC_POS_NR AVM_PNR NUMC 3   0   IS-M: Item Number of Subsequent Item JHAP
52 VORL_AVMNR VORL_AVMNR AVM_NR CHAR 10   0   IS-M: Order Number of the Preceding Document JHAK
53 VORL_POSNR VORL_POSNR AVM_PNR NUMC 3   0   IS-M: Item number of the Preceding Item JHAP
54 CAMPAIGN ISM_MARKETING_CAMPAIGN ISM_MARKETING_CAMPAIGN RAW 16   0   IS-M: Marketing Campaign  
55 .INCLUDE       0   0   IS-M/AM: Order-Publishing-Media Item Structure (Not DB)  
56 PREIS_OM PREIS_OM WERTV8 CURR 15   2   IS-M: Price excluding VAT  
57 PREIS_IM PREIS_IM WERTV8 CURR 15   2   IS-M: Price including VAT  
58 PREIS_AVM1 PREIS_AVM1 WERTV8 CURR 15   2   IS-M: Price Field 1 in the Order  
59 PREIS_AVM2 PREIS_AVM2 WERTV8 CURR 15   2   IS-M: Price Field 2 in the Order  
60 MWST_BETR GRMWSTBETR WERTV7 CURR 13   2   IS-M: Value-Added Tax Amount  
61 WAEHRG WAERK WAERS CUKY 5   0   SD document currency TCURC
62 PREIS_KPW1 PREIS_AVM1 WERTV8 CURR 15   2   IS-M: Price Field 1 in the Order  
63 PREIS_KPW2 PREIS_AVM2 WERTV8 CURR 15   2   IS-M: Price Field 2 in the Order  
64 WAEHRG_KOP WAERK WAERS CUKY 5   0   SD document currency TCURC
65 VERM_NAME TEXT30 TEXT30 CHAR 30   0   Text (30 Characters)  
66 BSARK_TXT BEZEI20 TEXT20 CHAR 20   0   Description  
67 AP_NAME TEXT30 TEXT30 CHAR 30   0   Text (30 Characters)  
68 XSUCFKP XSUCFKP XFELD CHAR 1   0   IS-M/AM: Indicator: Subsequent Billing Items Exist  
69 BRAN_PAM_TEXT VTEXT TEXT20 CHAR 20   0   Description  
70 KAMPAGNE_TEXT BEZEICHN15 TEXT15 CHAR 15   0   IS-M: Short Text  
71 UPSELL_PROP UPSELL_PROP ISM_UPSELL_PROP CHAR 10   0   IS-M/AM: Upselling Proposal  
72 COPYVAR_NEW_ITEM COPYVAR_NEW_ITEM KOPIERVAR CHAR 4   0   IS-M: Copying Variant Used to Create Item in Current Dialog *
73 XADV_CHNGD ISM_XADV_CHNGD XFELD CHAR 1   0   IS-M/AM: Advertiser Changed Due to Sold-to Party Change  
74 XSUCRR XSUCRR XFELD CHAR 1   0   IS-M/AM: Indicator: Successor Revenue Recognition Exists  
75 .INCLUDE       0   0   IS-PAM: Include for Business Data  
76 WAERG WAERK WAERS CUKY 5   0   SD document currency TCURC
77 FAKSPP PAM_FAKSP FAKSP CHAR 2   0   IS-M: Billing Block TVFS
78 XSEPFKKOPF XSEPFKKOPF XFELD CHAR 1   0   Separate billing document for sales order  
79 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
80 VALDT VALDT DATUM DATS 8   0   Fixed value date  
81 VALTG VALTG TAGE2 NUMC 2   0   Additional value days  
82 PERFK PERFK WFCID CHAR 2   0   Invoice dates (calendar identification) TFACD
83 FAKDATUM JHFKTER DATUM DATS 8   0   IS-M: Planned Billing/Settlement Date  
84 VORAUSKNZ VORAUSKNZ XFELD CHAR 1   0   IS-M: Indicates Whether Advance Billing Required  
85 VORAUSRCH VORAUSRCH XFELD CHAR 1   0   IS-M: "Advance billing required" indicator  
86 XRECHN XRECHN XFELD CHAR 1   0   IS-M: Invoice Requested Indicator  
87 XKFMAEND XKFMAEND XFELD CHAR 1   0   IS-M: Business Data was Changed Manually Indicator  
88 KONDA KONDA KONDA CHAR 2   0   Price Group (Customer) T188
89 XORTSPREIS XORTSPREIS XFELD CHAR 1   0   IS-M/AM: Local Customer Indicator  
90 KALKS KALKS KALKS CHAR 1   0   Pricing procedure assigned to this customer TVKD
91 KUKARR_K JKUKARR JKUKARR CHAR 2   0   IS-M: Customer Profile TJJ95
92 KARENZ JKARENZ JKARENZ NUMC 4   0   IS-M: Grace Period for Price Changes  
93 KARENZ_ME MEINS MEINS UNIT 3   0   Base Unit of Measure T006
94 KDGRP KDGRP KDGRP CHAR 2   0   Customer group T151
95 KURST KURST KURST CHAR 4   0   Exchange Rate Type TCURV
96 PLTYP PLTYP PLTYP CHAR 2   0   Price list type T189
97 ZLSCH SCHZW_BSEG ZLSCH CHAR 1   0   Payment Method T042Z
98 AE AGEN_AE AGEN_AE CHAR 1   0   IS-M: Agency Commission Entitlement  
99 .INCLUDE       0   0   IS-PAM: Status attributes for order item  
100 XUVFAKT XUVFAKT XFELD CHAR 1   0   IS-M: Billing is Incomplete  
101 XUVGP XUVGP XFELD CHAR 1   0   IS-M: Business Partner Is Incomplete  
102 XUVPREIS XUVPREIS XFELD CHAR 1   0   IS-M: Incomplete with regard to pricing  
103 XUVABSCHL XUVABSCHL XFELD CHAR 1   0   IS-M: Contract Assignment is Incomplete  
104 XUVVZ XUVVZ XFELD CHAR 1   0   IS-M: Sales Agent Assignment Incomplete  
105 XUVKPV XUVKPV XFELD CHAR 1   0   IS-M: Incomplete Manual Header/Item Sales Agent Assignment  
106 XGENEINT XGENEINT XFELD CHAR 1   0   IS-M: Schedule lines are not current  
107 XGENGRPF XGENGRPF XFELD CHAR 1   0   IS-M: Billing Dataset Is Yet To Be Generated  
108 XRESERV XRESERV XFELD CHAR 1   0   IS-M: Reservation indicator  
109 XRESBEST XRESBEST XFELD CHAR 1   0   IS-M: Reservation confirmed  
110 XFAKTMIN1 XFAKTMIN1 XFELD CHAR 1   0   IS-M: Partially Billed (At Least 1 Billing Dataset Billed)  
111 XFAKTALL XFAKTALL XFELD CHAR 1   0   IS-M: Billing Performed For All Billing Datasets  
112 XSPERR_BON XSPERR_BON XFELD CHAR 1   0   IS-M: "Blocked for reasons of creditworthiness" indicator  
113 XKOMMFRGB XKOMMFRGB XFELD CHAR 1   0   IS-M: Commercial release necessary but not performed  
114 XNACHBEARB XNACHBEARB XFELD CHAR 1   0   IS-M: Post-Editing Required  
115 XRABZU XRABZU XFELD CHAR 1   0   IS-M: Discount/Surcharge Exists Indicator  
116 PREIS_OM_C PREIS_OM_C CHAR10 CHAR 10   0   IS-M: Price excluding VAT  
117 PREIS_IM_C PREIS_IM_C CHAR10 CHAR 10   0   IS-M: Price including VAT  
118 PREISAVM1C PREISAVM1C CHAR10 CHAR 10   0   IS-M: Price Field 1 in the Order  
119 PREISAVM2C PREISAVM2C CHAR10 CHAR 10   0   IS-M: Price Field 2 in the Order  
120 PREAVM1C15 PREAVM1C15 CHAR15 CHAR 15   0   IS-M: Price Field 1 in the Order  
121 PREAVM2C15 PREAVM2C15 CHAR15 CHAR 15   0   IS-M: Price Field 2 in the Order  
122 PREISHEAD1 PREISHEAD CHAR15 CHAR 15   0   IS-M: Title template for price fields in order  
123 PREISHEAD2 PREISHEAD CHAR15 CHAR 15   0   IS-M: Title template for price fields in order  
124 NOTIZKNZ NOTIZKNZ XFELD CHAR 1   0   IS-M: Indicates Whether Notes are Available for an OPM Objct  
125 BELEGEINH BELEGEINH BELEINH CHAR 10   0   IS-M/AM: Booking Unit JJTBE
126 BE_KURZ BEZEICHN15 TEXT15 CHAR 15   0   IS-M: Short Text  
127 BEKENNZ BEKENNZ XFELD CHAR 1   0   IS-M: Booking Unit Indicator  
128 INSERENT INSERENT GPNR CHAR 10   0   IS-M: Advertiser JGTGPNR
129 INS_NAME TEXT30 TEXT30 CHAR 30   0   Text (30 Characters)  
130 INSERKNZ INSERKNZ XFELD CHAR 1   0   IS-M: Advertiser Indicator  
131 XINSBLANK XINSBLANK XFELD CHAR 1   0   IS-M: Agency Order Without Advertiser Indicator  
132 ALTINSGPNR ALTINSGPNR CHAR15 CHAR 15   0   IS-M: Alternative Customer Number for Advertiser  
133 VERMITTKNZ VERMITTKNZ XFELD CHAR 1   0   IS-M: Sales Agent Indicator  
134 ABSCHL_NR ABS_VTNR ABS_VTNR NUMC 6   0   IS-M: Contract Number JHTVKO
135 ABS_POSNR ABS_POSNR ABS_POSNR NUMC 4   0   IS-M: Contract, Item Number JHTVPO
136 ABINHNR_NAME TEXT30 TEXT30 CHAR 30   0   Text (30 Characters)  
137 ABSCHL_KNZ ABSCHL_KNZ XFELD CHAR 1   0   IS-M: Item is Assigned to Several Contracts  
138 EINTL_ANZ EINTL_ANZ NUMC6 NUMC 6   0   IS-M: Number of Schedule Lines in an Item  
139 XSTORNIERT XSTORNIERT XFELD CHAR 1   0   IS-M: Canceled Order Object Indicator  
140 STORNOGRND STOGRD_PAM STOGRD_PAM CHAR 3   0   IS-M: Cancellation Reason TJHSTOG
141 STAT_AMPEL STAT_AMPEL SYCHAR132 CHAR 132   0   IS-M: Status visualization  
142 .INCLUDE       0   0   IS-M/AM: Product Hierarchy (S&P): Include for JHAP  
143 PRDH_HERKUNFT ISM_PRDH_HERKUNFT CHAR002 CHAR 2   0   IS-M/AM: Origin Key  
144 PRDH_PRODUKT ISM_PRDH_PROD ISM_PRDH_PRODUKT CHAR 11   0   IS-M/AM: Product  
145 PRDH_PRODUKTBEZ ISM_PRDH_BEZEICHNUNG ISM_PRDH_BEZEICHNUNG CHAR 40   0   IS-M/AM: Product Hierarchy: Description  
146 ERSCH_T ERSCH_T DATUM DATS 8   0   IS-M: Publication Date  
147 WS_TIMESLC WS_TIMESLC WS_TIMESLC CHAR 2   0   IS-M: Commercial Time Slice TJJW1
148 WS_BLOCK WS_BLOCK WS_BLOCK CHAR 2   0   IS-M: Commercial Cluster TJJW3
149 WS_STELLE WS_STELLE NUMC3 NUMC 3   0   IS-M: Position (Sequence) Within a Commercial Cluster  
150 WS_LENGTHI WS_LENGTHI WS_LENGTH NUMC 4   0   IS-M: Actual length of commercial in seconds  
151 WS_LENGTHS WS_LENGTHS WS_LENGTH NUMC 4   0   IS-M: Planned length of commercial in seconds  
152 BLOCK_TEXT BEZEICHN15 TEXT15 CHAR 15   0   IS-M: Short Text  
153 TIMES_TEXT BEZEICHN15 TEXT15 CHAR 15   0   IS-M: Short Text  
154 PRODH_TEXT BEZEI20 TEXT20 CHAR 20   0   Description  
155 XMANU_SEL XMANU_SEL XFELD CHAR 1   0   IS-M: Additional Dates Assigned Manually Indicator  
156 XMOT_MULT XMOT_MULT XFELD CHAR 1   0   IS-M: Additional Ad Specs Assigned Indicator  
157 XMOTPOSUNI XMOTPOSUNI XFELD CHAR 1   0   IS-M: Unique ad spec/item assignment indicator  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 RJHA470 ABSCHL_NR JHTVKO VTNR    
2 RJHA470 ABS_POSNR JHTVPO POSNR    
3 RJHA470 AVM_NR JHAK AVM_NR KEY 1 CN
4 RJHA470 BEDNR JJTVB BEDNR KEY 1 CN
5 RJHA470 BELEGEINH JJTBE BELEINH    
6 RJHA470 BRAN_PAM TBRC BRACO REF 1 CN
7 RJHA470 FAKSPP TVFS FAKSP    
8 RJHA470 INHK_KFM JJTIKO INHALTSKOM REF 1 CN
9 RJHA470 INSERENT JGTGPNR GPNR    
10 RJHA470 KALKS TVKD KALKS    
11 RJHA470 KAMPAGNE TJJKAMP KAMPAGNE REF 1 CN
12 RJHA470 KARENZ_ME T006 MSEHI KEY 1 CN
13 RJHA470 KDGRP T151 KDGRP REF 1 CN
14 RJHA470 KONDA T188 KONDA    
15 RJHA470 KONKAUS TJH89 KONKAUS REF 1 CN
16 RJHA470 KUKARR_K TJJ95 KUKARR    
17 RJHA470 KURST TCURV KURST REF 1 CN
18 RJHA470 MANDT T000 MANDT KEY 1 CN
19 RJHA470 PERFK TFACD IDENT    
20 RJHA470 PLTYP T189 PLTYP REF 1 CN
21 RJHA470 POS_ART TJH17 AVMPOS_ART REF 1 CN
22 RJHA470 POS_NR JHAP POS_NR KEY 1 CN
23 RJHA470 PROSL TJH23 PRSCHL KEY 1 CN
24 RJHA470 PSTYV TJHAP PSTYV REF 1 CN
25 RJHA470 REF_AVM_NR JHAK AVM_NR REF 1 CN
26 RJHA470 REF_POS_NR JHAP POS_NR REF 1 CN
27 RJHA470 STORNOGRND TJHSTOG STORNOGRD REF 1 CN
28 RJHA470 SUC_AVM_NR JHAK AVM_NR REF 1 CN
29 RJHA470 SUC_POS_NR JHAP POS_NR REF 1 CN
30 RJHA470 VNR JJTVV VNR KEY 1 CN
31 RJHA470 VORL_AVMNR JHAK AVM_NR REF 1 CN
32 RJHA470 VORL_POSNR JHAP POS_NR KEY 1 CN
33 RJHA470 WAEHRG TCURC WAERS REF 1 CN
34 RJHA470 WAEHRG_KOP TCURC WAERS REF 1 CN
35 RJHA470 WAERG TCURC WAERS 1 CN
36 RJHA470 WERBK_EINT JHAE EIN_NR 1 CN
37 RJHA470 WERBK_POS JHAP POS_NR 1 CN
38 RJHA470 WERBK_TYP TJH91 WKOMBI_TYP 1 CN
39 RJHA470 WS_ART TJJ41 WSPOT_ART REF 1 CN
40 RJHA470 WS_BLOCK TJJW3 WS_BLOCK REF 1 CN
41 RJHA470 WS_TIMESLC TJJW1 WS_TIMESLC REF 1 CN
42 RJHA470 ZLSCH T042Z ZLSCH REF 1 CN
History
Last changed by/on SAP  20060208 
SAP Release Created in