SAP ABAP Table RJHA6204 (IS-M/AM: Central Access Screen Structure - Distrib.Overview)
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 RJHA6204   Table Relationship Diagram
Short Description IS-M/AM: Central Access Screen Structure - Distrib.Overview    
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-M/AM: OPM Distribution Item  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 AVM_NR AVM_NR AVM_NR CHAR 10   0   IS-M/AM: Sales Document Number JHAK
4 POS_NR POS_NR AVM_PNR NUMC 3   0   IS-M: Order Item Number JHAP
5 .INCLUDE       0   0   IS-M/AM: Include for specific distribution attributes  
6 JVTBEPMART JVTBEPMART JVTBEPMART CHAR 4   0   IS-M/AM: Distribution Planned Quantity Types TJJBEVTPA
7 VRTMENGE_V VRTMGV_PAM STMENGE DEC 9   0   IS-M/AM: Planned Quantity for Distribution Full Booking  
8 VRTMENGE VRTMGI_PAM STMENGE DEC 9   0   IS-M/AM: Actual Quantity for Distribution  
9 BERMENGE BERMENGE STMENGE DEC 9   0   IS-M: Calculation Quantity (Ad Insert)  
10 XBERMENGE_FIX JXBERMENGE_FIX XFELD CHAR 1   0   IS-M/AM: Calculation Quantity is Fixed indicator  
11 BLGMENGE JVTLFMNG STMENGE DEC 9   0   IS-M/AM: Delivery quantity for distribution  
12 XTBEL_VT XTBEL_VT XFELD CHAR 1   0   IS-M: Selective Booking For Distribution BU Indicator  
13 SI_TYP SITYP SI_TYP CHAR 2   0   IS-M: Ad Insert Type *
14 SI_GEWICHT ISM_SI_GEWICHT ISPMNG9 QUAN 9   3   IS-M: Ad Insert Weight  
15 MEINHGEWBL MEINHGEWBL MEINS UNIT 3   0   IS-M: Unit of Weight for Ad Insert T006
16 SI_ENTSPFL ISM_SI_ENTSPFL XFELD CHAR 1   0   IS-M: Waste Disposal Required Indicator  
17 SI_VERBWER ISM_SI_VERBWER XFELD CHAR 1   0   IS-M: Tie-In Ads Indicator  
18 ANZSEITEN ANZSEITEN NUM8 NUMC 8   0   Number of Pages in Issue  
19 .INCLUDE       0   0   IS-PAM: Date Attributes  
20 TERM_TYP TERMINTYP TERMINTYP CHAR 1   0   IS-M/AM: Date Category Copy Number/Publication Date TJH55
21 ANFANG_PER ANFANG_PER PAM_PERIOD CHAR 14   0   IS-M: Start of Copy/Publication Date Period  
22 ENDE_PER ENDE_PER PAM_PERIOD CHAR 14   0   IS-M: End of Period - Issue/Publication Date  
23 SELDAT_VON SELDAT_VON DATUM DATS 8   0   IS-M: Start Date for Item  
24 SELDAT_BIS SELDAT_BIS DATUM DATS 8   0   IS-M: End Date for Items  
25 BIS_PLUS BIS_PLUS BIS_PLUS CHAR 1   0   IS-M: Indicates a Period ("-") or 2 Dates ("+")  
26 ANZ_SCHALT ANZ_SCHALT ANZ_SCHALT NUMC 3   0   IS-M: Number of Placements  
27 TERM_ZYKL ANZ_ZYKLUS ANZ_ZYKLUS CHAR 4   0   IS-M: Frequency for Ad Publication TJJ57
28 TERMINART TERMINART TERMINART CHAR 1   0   IS-M/AM: Type of Publication Date  
29 ERSCH_T ERSCH_T DATUM DATS 8   0   IS-M: Publication Date  
30 WUNSCH_T WUNSCH_T DATUM DATS 8   0   IS-M/AM: Date Required  
31 .INCLUDE       0   0   IS-M/AM: Include for Weekday String  
32 X_MONTAG JHT_MONTAG XFELD CHAR 1   0   IS-M: Date Field Indicator - Monday  
33 X_DIENSTAG JHT_DIENSTAG XFELD CHAR 1   0   IS-M: Date Field Indicator - Tuesday  
34 X_MITTWOCH JHT_MITTWOCH XFELD CHAR 1   0   IS-M: Date Field Indicator - Wednesday  
35 X_DONNERST JHT_DONNERST XFELD CHAR 1   0   IS-M: Date Field Indicator - Thursday  
36 X_FREITAG JHT_FREITAG XFELD CHAR 1   0   IS-M: Date Field Indicator - Friday  
37 X_SAMSTAG JHT_SAMSTAG XFELD CHAR 1   0   IS-M: Date Field Indicator - Saturday  
38 X_SONNTAG JHT_SONNTAG XFELD CHAR 1   0   IS-M: Date Field Indicator - Sunday  
39 .INCLUDE       0   0   IS-M/AM: Distribution Item Status Indicator  
40 XUVSI XUVSI XFELD CHAR 1   0   IS-M: Ad Insert Data Incomplete Indicator  
41 XVT_PLAZ XVT_PLAZ XFELD CHAR 1   0   IS-M: Indicator distribution "positioned"  
42 XMUSTER_OK XMUSTER_OK XFELD CHAR 1   0   IS-M: Sample Received and Checked Indicator  
43 XSI_VORH XSI_VORH XFELD CHAR 1   0   IS-M: AI Copies Exist  
44 XUVTECH XUVTECH XFELD CHAR 1   0   IS-M: Incomplete Regarding Technical System (Gen.)  
45 XTECH_MIN1 XTECH_MIN1 XFELD CHAR 1   0   IS-M: Tech.process.started (for at least 1 schedule line)  
46 XTECH_EE XTECH_EE XFELD CHAR 1   0   IS-M: Tech.Complete (All Schedule Lines Fully Processed)  
47 .INCLUDE       0   0   IS-M/AM: Characteristics for individual use. Distribution  
48 MERKMAL0 MERK0_PV XFELD CHAR 1   0   IS-M: Characteristic 0 for Individual Use (Distributn Item)  
49 MERKMAL1 MERK1_PV XFELD CHAR 1   0   IS-M: Characteristic 1 for Individual Use (Distributn Item)  
50 MERKMAL2 MERK2_PV XFELD CHAR 1   0   IS-M: Characteristic 2 for Individual Use (Distributn Item)  
51 MERKMAL3 MERK3_PV XFELD CHAR 1   0   IS-M: Characteristic 3 for Individual Use (Distributn Item)  
52 MERKMAL4 MERK4_PV XFELD CHAR 1   0   IS-M: Characteristic 4 for Individual Use (Distributn Item)  
53 MERKMAL5 MERK5_PV XFELD CHAR 1   0   IS-M: Characteristic 5 for Individual Use (Distributn Item)  
54 MERKMAL6 MERK6_PV XFELD CHAR 1   0   IS-M: Characteristic 6 for Individual Use (Distributn Item)  
55 MERKMAL7 MERK7_PV XFELD CHAR 1   0   IS-M: Characteristic 7 for Individual Use (Distributn Item)  
56 MERKMAL8 MERK8_PV XFELD CHAR 1   0   IS-M: Characteristic 8 for Individual Use (Distributn Item)  
57 MERKMAL9 MERK9_PV XFELD CHAR 1   0   IS-M: Characteristic 9 for Individual Use (Distributn Item)  
58 KONKAUS KONKAUS KONKAUS CHAR 2   0   IS-M: Competitor exclusion TJH89
59 KONKAUSKOM KONKAUSKOM TEXT35 CHAR 35   0   IS-M: Comment on competitor exclusion  
60 PRODH J_PRODH J_PRODH CHAR 18   0   IS-M/AM: Product Hierarchy JJT179
61 SORTWORT SORTWORT TEXT10 CHAR 10   0   IS-M: Sort Word  
62 STICHW STICHW TEXT40 CHAR 40   0   IS-M: Keyword  
63 INHK_KFM INHK_KFM INHALTSKOM CHAR 8   0   IS-M: Business Content Component JJTIKO
64 SI_NUMMER ISM_SI_NUMMER SI_NUMMER CHAR 10   0   IS-M: Ad Insert Number  
65 GPAG GPAG GPNR CHAR 10   0   Business Partner: Sold-to Party JGTGPNR
66 NAME1 NAME1_ISP NAME CHAR 35   0   IS-M: Business Partner Name  
67 EIN_NR EIN_NR AVMENR NUMC 6   0   IS-M: Schedule Line *
68 ERSCHDAT ERSCHDAT DATUM DATS 8   0   Publication Date  
69 NE_TERMIN NE_TERMIN DATUM DATS 8   0   IS-M: Next/Last Publication Date  
70 .INCLUDE       0   0   IS-M/AM: Include for Pure Item Attributes  
71 POS_ART AVMPOS_ART AVMPOS_ART CHAR 2   0   IS-M: Order-Publishing-Media - Item Type TJH17
72 PSTYV PSTYV_PAM PSTYV_PAM CHAR 4   0   IS-M: Item Category for Sales Document TJHAP
73 VBTYP ISPVBTYP ISPVBTYP CHAR 1   0   IS-M/AM: Sales Document Category  
74 WERBK_TYP WKOMBI_TYP WKOMBI_TYP CHAR 2   0   IS-M: Combination Sale Type TJH91
75 WERBK_KNZ WERBK_KNZ WERBEKKNZ NUMC 4   0   IS-M: Combination Sale Indicator  
76 XAGENAUFTR XAGENAUFTR XFELD CHAR 1   0   IS-M: Agency order indicator  
77 XEINTEILG XEINTEILG XFELD CHAR 1   0   IS-M: Indicator for modification at subordinate ord. level  
78 BRAN_PAM BRAN_POS BRACO CHAR 10   0   IS-M/AM: Current Industry Sector Associated With Order Item TBRC
79 STATUSK STATUSK PAM_STATUS CHAR 2   0   IS-M: Status  
80 .INCLUDE       0   0   IS-PAM: Agent attributes outside agent assignment  
81 VERMITTLER VERMK JJMVERM CHAR 10   0   IS-M: Sales Agent with ID Code for Screen *
82 VNR JVMVVNR JVMVVNR CHAR 10   0   IS-M: Media Sales Agent Contract Number JJTVV
83 BEDNR VM_BEDNR VM_BEDNR NUMC 6   0   IS-M: Number of Media Sales Agent Contract Requirement JJTVB
84 PROSL JPROVSCHL PRSCHL CHAR 5   0   IS-M/AM: Commission Key for Media Sales Agent TJH23
85 KAMPAGNE KAMPAGNE KAMPAGNE CHAR 6   0   IS-M: Campaign (customer) TJJKAMP
86 WERBK_POS WERBK_POS AVM_PNR NUMC 3   0   IS-M: Combination Sale Grouping Item Number JHAP
87 WERBK_UPOS WERBK_UPOS AVM_UPNR NUMC 4   0   IS-M: Combination Sale Grouping Sub-Item  
88 WERBK_EINT WERBK_EINT AVMENR NUMC 6   0   IS-M: Combination Sale Grouping for Schedule Line Number JHAE
89 REF_AVM_NR REF_AVM_NR AVM_NR CHAR 10   0   IS-M: Reference Order Number of Preceding Order JHAK
90 REF_POS_NR REF_POS_NR AVM_PNR NUMC 3   0   IS-M: Reference Item Number of Preceding Item JHAP
91 SUC_AVM_NR SUC_AVM_NR AVM_NR CHAR 10   0   IS-M: Order Number of Subsequent Document JHAK
92 SUC_POS_NR SUC_POS_NR AVM_PNR NUMC 3   0   IS-M: Item Number of Subsequent Item JHAP
93 VORL_AVMNR VORL_AVMNR AVM_NR CHAR 10   0   IS-M: Order Number of the Preceding Document JHAK
94 VORL_POSNR VORL_POSNR AVM_PNR NUMC 3   0   IS-M: Item number of the Preceding Item JHAP
95 CAMPAIGN ISM_MARKETING_CAMPAIGN ISM_MARKETING_CAMPAIGN RAW 16   0   IS-M: Marketing Campaign  
96 .INCLUDE       0   0   IS-PAM: Status attributes for order item  
97 XUVFAKT XUVFAKT XFELD CHAR 1   0   IS-M: Billing is Incomplete  
98 XUVGP XUVGP XFELD CHAR 1   0   IS-M: Business Partner Is Incomplete  
99 XUVPREIS XUVPREIS XFELD CHAR 1   0   IS-M: Incomplete with regard to pricing  
100 XUVABSCHL XUVABSCHL XFELD CHAR 1   0   IS-M: Contract Assignment is Incomplete  
101 XUVVZ XUVVZ XFELD CHAR 1   0   IS-M: Sales Agent Assignment Incomplete  
102 XUVKPV XUVKPV XFELD CHAR 1   0   IS-M: Incomplete Manual Header/Item Sales Agent Assignment  
103 XGENEINT XGENEINT XFELD CHAR 1   0   IS-M: Schedule lines are not current  
104 XGENGRPF XGENGRPF XFELD CHAR 1   0   IS-M: Billing Dataset Is Yet To Be Generated  
105 XRESERV XRESERV XFELD CHAR 1   0   IS-M: Reservation indicator  
106 XRESBEST XRESBEST XFELD CHAR 1   0   IS-M: Reservation confirmed  
107 XFAKTMIN1 XFAKTMIN1 XFELD CHAR 1   0   IS-M: Partially Billed (At Least 1 Billing Dataset Billed)  
108 XFAKTALL XFAKTALL XFELD CHAR 1   0   IS-M: Billing Performed For All Billing Datasets  
109 XSPERR_BON XSPERR_BON XFELD CHAR 1   0   IS-M: "Blocked for reasons of creditworthiness" indicator  
110 XKOMMFRGB XKOMMFRGB XFELD CHAR 1   0   IS-M: Commercial release necessary but not performed  
111 XNACHBEARB XNACHBEARB XFELD CHAR 1   0   IS-M: Post-Editing Required  
112 .INCLUDE       0   0   IS-PAM: Include for Business Data  
113 WAERG WAERK WAERS CUKY 5   0   SD document currency TCURC
114 FAKSPP PAM_FAKSP FAKSP CHAR 2   0   IS-M: Billing Block TVFS
115 XSEPFKKOPF XSEPFKKOPF XFELD CHAR 1   0   Separate billing document for sales order  
116 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
117 VALDT VALDT DATUM DATS 8   0   Fixed value date  
118 VALTG VALTG TAGE2 NUMC 2   0   Additional value days  
119 PERFK PERFK WFCID CHAR 2   0   Invoice dates (calendar identification) TFACD
120 FAKDATUM JHFKTER DATUM DATS 8   0   IS-M: Planned Billing/Settlement Date  
121 VORAUSKNZ VORAUSKNZ XFELD CHAR 1   0   IS-M: Indicates Whether Advance Billing Required  
122 VORAUSRCH VORAUSRCH XFELD CHAR 1   0   IS-M: "Advance billing required" indicator  
123 XRECHN XRECHN XFELD CHAR 1   0   IS-M: Invoice Requested Indicator  
124 XKFMAEND XKFMAEND XFELD CHAR 1   0   IS-M: Business Data was Changed Manually Indicator  
125 KONDA KONDA KONDA CHAR 2   0   Price Group (Customer) T188
126 XORTSPREIS XORTSPREIS XFELD CHAR 1   0   IS-M/AM: Local Customer Indicator  
127 KALKS KALKS KALKS CHAR 1   0   Pricing procedure assigned to this customer TVKD
128 KUKARR_K JKUKARR JKUKARR CHAR 2   0   IS-M: Customer Profile TJJ95
129 KARENZ JKARENZ JKARENZ NUMC 4   0   IS-M: Grace Period for Price Changes  
130 KARENZ_ME MEINS MEINS UNIT 3   0   Base Unit of Measure T006
131 KDGRP KDGRP KDGRP CHAR 2   0   Customer group T151
132 KURST KURST KURST CHAR 4   0   Exchange Rate Type TCURV
133 PLTYP PLTYP PLTYP CHAR 2   0   Price list type T189
134 ZLSCH SCHZW_BSEG ZLSCH CHAR 1   0   Payment Method T042Z
135 AE AGEN_AE AGEN_AE CHAR 1   0   IS-M: Agency Commission Entitlement  
136 .INCLUDE       0   0   IS-PAM: INCLUDE for bank data  
137 BANKS BANKS LAND1 CHAR 3   0   Bank country key T005
138 BANKL BANKK BANKK CHAR 15   0   Bank Keys BNKA
139 BANKN BANKN BANKN CHAR 18   0   Bank account number  
140 BKONT BKONT BKONT CHAR 2   0   Bank Control Key  
141 BVTYP BVTYP BVTYP CHAR 4   0   Partner bank type  
142 XEINZUG XEZER XFELD CHAR 1   0   Indicator: Is there collection authorization ?  
143 .INCLUDE       0   0   IS-M/AM: Include for IBAN  
144 IBAN IBAN IBAN CHAR 34   0   IBAN (International Bank Account Number)  
145 BELEGEINH BELEGEINH BELEINH CHAR 10   0   IS-M/AM: Booking Unit *
146 BE_KURZ BEZEICHN15 TEXT15 CHAR 15   0   IS-M: Short Text  
147 BEKENNZ BEKENNZ XFELD CHAR 1   0   IS-M: Booking Unit Indicator  
148 ALTINSGPNR ALTINSGPNR CHAR15 CHAR 15   0   IS-M: Alternative Customer Number for Advertiser  
149 INSERENT INSERENT GPNR CHAR 10   0   IS-M: Advertiser *
150 INS_NAME NAME1_ISP NAME CHAR 35   0   IS-M: Business Partner Name  
151 INS_ORT01 ORT01_ISP TEXT35 CHAR 35   0   IS-M: City  
152 INSERKNZ INSERKNZ XFELD CHAR 1   0   IS-M: Advertiser Indicator  
153 XINSBLANK XINSBLANK XFELD CHAR 1   0   IS-M: Agency Order Without Advertiser Indicator  
154 VERM_NAME TEXT30 TEXT30 CHAR 30   0   Text (30 Characters)  
155 VERMITTKNZ VERMITTKNZ XFELD CHAR 1   0   IS-M: Sales Agent Indicator  
156 VTNR ABS_VTNR ABS_VTNR NUMC 6   0   IS-M: Contract Number *
157 ABS_POSNR ABS_POSNR ABS_POSNR NUMC 4   0   IS-M: Contract, Item Number *
158 EINTL_ANZ EINTL_ANZ NUMC6 NUMC 6   0   IS-M: Number of Schedule Lines in an Item  
159 ABSCHL_KNZ ABSCHL_KNZ XFELD CHAR 1   0   IS-M: Item is Assigned to Several Contracts  
160 PRODH_TEXT BEZEI20 TEXT20 CHAR 20   0   Description  
161 AMPEL ISP_AMPEL CHAR004 CHAR 4   0   IS-M: Light for representing the status visually  
162 STAT_AMPEL STAT_AMPEL SYCHAR132 CHAR 132   0   IS-M: Status visualization  
163 STORNOGRND STOGRD_PAM STOGRD_PAM CHAR 3   0   IS-M: Cancellation Reason TJHSTOG
164 XSTORNIERT XSTORNIERT XFELD CHAR 1   0   IS-M: Canceled Order Object Indicator  
165 ERFUSER ERFUSER USNAM CHAR 12   0   Created By  
166 ERFDATE ERFDATE DATUM DATS 8   0   Created On  
167 AENUSER AENUSER USNAM CHAR 12   0   Last Changed By  
168 AENDATE AENDATE DATUM DATS 8   0   Date of Last Change  
169 MARK XFELD XFELD CHAR 1   0   Checkbox  
170 AVM_HRKNFT AVM_HRKNFT AVM_HRKNFT CHAR 1   0   IS-M/AM: Order Origin  
171 XZEILFARB CHAR3 CHAR3 CHAR 3   0   3-Byte field  
172 PREIS_AVM1 PREIS_AVM1 WERTV8 CURR 15   2   IS-M: Price Field 1 in the Order  
173 PREIS_AVM2 PREIS_AVM2 WERTV8 CURR 15   2   IS-M: Price Field 2 in the Order  
174 WAEHRG WAERK WAERS CUKY 5   0   SD document currency *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 RJHA6204 AVM_NR JHAK AVM_NR KEY 1 CN
2 RJHA6204 BANKL BNKA BANKL    
3 RJHA6204 BANKS T005 LAND1 REF C CN
4 RJHA6204 BEDNR JJTVB BEDNR KEY 1 CN
5 RJHA6204 BRAN_PAM TBRC BRACO REF 1 CN
6 RJHA6204 FAKSPP TVFS FAKSP KEY 1 CN
7 RJHA6204 GPAG JGTGPNR GPNR    
8 RJHA6204 INHK_KFM JJTIKO INHALTSKOM REF 1 CN
9 RJHA6204 JVTBEPMART TJJBEVTPA JVTBEPMART    
10 RJHA6204 KALKS TVKD KALKS KEY 1 CN
11 RJHA6204 KAMPAGNE TJJKAMP KAMPAGNE REF 1 CN
12 RJHA6204 KARENZ_ME T006 MSEHI KEY 1 CN
13 RJHA6204 KDGRP T151 KDGRP REF 1 CN
14 RJHA6204 KONDA T188 KONDA KEY 1 CN
15 RJHA6204 KONKAUS TJH89 KONKAUS KEY    
16 RJHA6204 KUKARR_K TJJ95 KUKARR KEY 1 CN
17 RJHA6204 KURST TCURV KURST REF 1 CN
18 RJHA6204 MANDT T000 MANDT KEY 1 CN
19 RJHA6204 MEINHGEWBL T006 MSEHI    
20 RJHA6204 PERFK TFACD IDENT KEY 1 CN
21 RJHA6204 PLTYP T189 PLTYP REF 1 CN
22 RJHA6204 POS_ART TJH17 AVMPOS_ART REF 1 CN
23 RJHA6204 POS_NR JHAP POS_NR KEY 1 CN
24 RJHA6204 PRODH JJT179 PRODH    
25 RJHA6204 PROSL TJH23 PRSCHL KEY 1 CN
26 RJHA6204 PSTYV TJHAP PSTYV REF 1 CN
27 RJHA6204 REF_AVM_NR JHAK AVM_NR REF 1 CN
28 RJHA6204 REF_POS_NR JHAP POS_NR REF 1 CN
29 RJHA6204 STORNOGRND TJHSTOG STORNOGRD    
30 RJHA6204 SUC_AVM_NR JHAK AVM_NR REF 1 CN
31 RJHA6204 SUC_POS_NR JHAP POS_NR REF 1 CN
32 RJHA6204 TERM_TYP TJH55 TERM_TYP REF 1 CN
33 RJHA6204 TERM_ZYKL TJJ57 RHYTHMUS    
34 RJHA6204 VNR JJTVV VNR KEY 1 CN
35 RJHA6204 VORL_AVMNR JHAK AVM_NR REF 1 CN
36 RJHA6204 VORL_POSNR JHAP POS_NR KEY 1 CN
37 RJHA6204 WAERG TCURC WAERS KEY 1 CN
38 RJHA6204 WERBK_EINT JHAE EIN_NR 1 CN
39 RJHA6204 WERBK_POS JHAP POS_NR 1 CN
40 RJHA6204 WERBK_TYP TJH91 WKOMBI_TYP 1 CN
41 RJHA6204 ZLSCH T042Z ZLSCH REF 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in