SAP ABAP Table MCJHAP (IS-M: Order item, LIS communication 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 MCJHAP   Table Relationship Diagram
Short Description IS-M: Order item, LIS communication 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-M/AM: Order-Publishing-Media 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 *
5 .INCLUDE       0   0   IS-M/AM: Include for Pure Item Attributes  
6 POS_ART AVMPOS_ART AVMPOS_ART CHAR 2   0   IS-M: Order-Publishing-Media - Item Type TJH17
7 PSTYV PSTYV_PAM PSTYV_PAM CHAR 4   0   IS-M: Item Category for Sales Document TJHAP
8 VBTYP ISPVBTYP ISPVBTYP CHAR 1   0   IS-M/AM: Sales Document Category  
9 WERBK_TYP WKOMBI_TYP WKOMBI_TYP CHAR 2   0   IS-M: Combination Sale Type TJH91
10 WERBK_KNZ WERBK_KNZ WERBEKKNZ NUMC 4   0   IS-M: Combination Sale Indicator  
11 XAGENAUFTR XAGENAUFTR XFELD CHAR 1   0   IS-M: Agency order indicator  
12 XEINTEILG XEINTEILG XFELD CHAR 1   0   IS-M: Indicator for modification at subordinate ord. level  
13 BRAN_PAM BRAN_POS BRACO CHAR 10   0   IS-M/AM: Current Industry Sector Associated With Order Item TBRC
14 STATUSK STATUSK PAM_STATUS CHAR 2   0   IS-M: Status  
15 .INCLUDE       0   0   IS-PAM: Agent attributes outside agent assignment  
16 VERMITTLER VERMK JJMVERM CHAR 10   0   IS-M: Sales Agent with ID Code for Screen *
17 VNR JVMVVNR JVMVVNR CHAR 10   0   IS-M: Media Sales Agent Contract Number JJTVV
18 BEDNR VM_BEDNR VM_BEDNR NUMC 6   0   IS-M: Number of Media Sales Agent Contract Requirement JJTVB
19 PROSL JPROVSCHL PRSCHL CHAR 5   0   IS-M/AM: Commission Key for Media Sales Agent TJH23
20 KAMPAGNE KAMPAGNE KAMPAGNE CHAR 6   0   IS-M: Campaign (customer) TJJKAMP
21 WERBK_POS WERBK_POS AVM_PNR NUMC 3   0   IS-M: Combination Sale Grouping Item Number JHAP
22 WERBK_UPOS WERBK_UPOS AVM_UPNR NUMC 4   0   IS-M: Combination Sale Grouping Sub-Item  
23 WERBK_EINT WERBK_EINT AVMENR NUMC 6   0   IS-M: Combination Sale Grouping for Schedule Line Number JHAE
24 REF_AVM_NR REF_AVM_NR AVM_NR CHAR 10   0   IS-M: Reference Order Number of Preceding Order JHAK
25 REF_POS_NR REF_POS_NR AVM_PNR NUMC 3   0   IS-M: Reference Item Number of Preceding Item JHAP
26 SUC_AVM_NR SUC_AVM_NR AVM_NR CHAR 10   0   IS-M: Order Number of Subsequent Document JHAK
27 SUC_POS_NR SUC_POS_NR AVM_PNR NUMC 3   0   IS-M: Item Number of Subsequent Item JHAP
28 VORL_AVMNR VORL_AVMNR AVM_NR CHAR 10   0   IS-M: Order Number of the Preceding Document JHAK
29 VORL_POSNR VORL_POSNR AVM_PNR NUMC 3   0   IS-M: Item number of the Preceding Item JHAP
30 CAMPAIGN ISM_MARKETING_CAMPAIGN ISM_MARKETING_CAMPAIGN RAW 16   0   IS-M: Marketing Campaign  
31 NOTIZKNZ NOTIZKNZ XFELD CHAR 1   0   IS-M: Indicates Whether Notes are Available for an OPM Objct  
32 .INCLUDE       0   0   IS-PAM: Include Customer Outline Agreement Indicator  
33 XRABATT XRABATT XFELD CHAR 1   0   IS-M: Assignment Qualifies for Discount  
34 XMITZRAB XMITZRAB XFELD CHAR 1   0   IS-M: Assignment Counts Towards Discount Fulfillment  
35 XBONUS XBONUS XFELD CHAR 1   0   IS-M: Assignment Qualifies for Bonus  
36 XMITZBON XMITZBON XFELD CHAR 1   0   IS-M: Assignment Counts Towards Bonus Fulfillment  
37 .INCLUDE       0   0   IS-M/AM: Surcharges And Discounts (Update)  
38 RAB1_BETR JRABPROZ DEC4_3 DEC 7   3   IS-M/AM: Percentage discount  
39 RAB1_GRUND JGRKOND JGRUND CHAR 2   0   IS-M: Reason for Entering Conditions  
40 RAB1_BKTYP BKTYP BKTYP CHAR 2   0   IS-M: Condition Input Type in the Order  
41 RAB2_BETR JRABPROZ DEC4_3 DEC 7   3   IS-M/AM: Percentage discount  
42 RAB2_GRUND JGRKOND JGRUND CHAR 2   0   IS-M: Reason for Entering Conditions  
43 RAB2_BKTYP BKTYP BKTYP CHAR 2   0   IS-M: Condition Input Type in the Order  
44 RAB3_BETR JRABPROZ DEC4_3 DEC 7   3   IS-M/AM: Percentage discount  
45 RAB3_GRUND JGRKOND JGRUND CHAR 2   0   IS-M: Reason for Entering Conditions  
46 RAB3_BKTYP BKTYP BKTYP CHAR 2   0   IS-M: Condition Input Type in the Order  
47 RAB4_BETR JRABMEIN WERTV6 CURR 11   2   IS-M/AM: Quantity-dependent discount  
48 RAB4_PEIN PAMPEIN KPEIN DEC 5   0   IS-M: Price Unit (Surcharge Discount, Basic Price)  
49 RAB4_MEIN PAMMEIN ISPEINH_PR UNIT 3   0   IS-M: Unit of Measure (Discount, Surcharge, Basic Price) *
50 RAB4_GRUND JGRKOND JGRUND CHAR 2   0   IS-M: Reason for Entering Conditions  
51 RAB4_BKTYP BKTYP BKTYP CHAR 2   0   IS-M: Condition Input Type in the Order  
52 RAB5_BETR JRABBETR WERTV6 CURR 11   2   IS-M/AM: Amount discount  
53 RAB5_GRUND JGRKOND JGRUND CHAR 2   0   IS-M: Reason for Entering Conditions  
54 RAB5_BKTYP BKTYP BKTYP CHAR 2   0   IS-M: Condition Input Type in the Order  
55 RABE_BETR JRABBETR WERTV6 CURR 11   2   IS-M/AM: Amount discount  
56 RABE_GRUND JGRKOND JGRUND CHAR 2   0   IS-M: Reason for Entering Conditions  
57 RABE_BKTYP BKTYP BKTYP CHAR 2   0   IS-M: Condition Input Type in the Order  
58 ZUS1_BETR JZUSPROZ DEC4_3 DEC 7   3   IS-M/AM: Percentage Surcharge  
59 ZUS1_GRUND JGRKOND JGRUND CHAR 2   0   IS-M: Reason for Entering Conditions  
60 ZUS1_BKTYP BKTYP BKTYP CHAR 2   0   IS-M: Condition Input Type in the Order  
61 ZUS2_BETR JZUSPROZ DEC4_3 DEC 7   3   IS-M/AM: Percentage Surcharge  
62 ZUS2_GRUND JGRKOND JGRUND CHAR 2   0   IS-M: Reason for Entering Conditions  
63 ZUS2_BKTYP BKTYP BKTYP CHAR 2   0   IS-M: Condition Input Type in the Order  
64 ZUS3_BETR JZUSPROZ DEC4_3 DEC 7   3   IS-M/AM: Percentage Surcharge  
65 ZUS3_GRUND JGRKOND JGRUND CHAR 2   0   IS-M: Reason for Entering Conditions  
66 ZUS3_BKTYP BKTYP BKTYP CHAR 2   0   IS-M: Condition Input Type in the Order  
67 ZUS4_BETR JZUSMEIN WERTV6 CURR 11   2   IS-M/AM: Quantity-dependent surcharge  
68 ZUS4_PEIN PAMPEIN KPEIN DEC 5   0   IS-M: Price Unit (Surcharge Discount, Basic Price)  
69 ZUS4_MEIN PAMMEIN ISPEINH_PR UNIT 3   0   IS-M: Unit of Measure (Discount, Surcharge, Basic Price) *
70 ZUS4_GRUND JGRKOND JGRUND CHAR 2   0   IS-M: Reason for Entering Conditions  
71 ZUS4_BKTYP BKTYP BKTYP CHAR 2   0   IS-M: Condition Input Type in the Order  
72 ZUS5_BETR JZUSBETR WERTV6 CURR 11   2   IS-M/AM: Amount Surcharge  
73 ZUS5_GRUND JGRKOND JGRUND CHAR 2   0   IS-M: Reason for Entering Conditions  
74 ZUS5_BKTYP BKTYP BKTYP CHAR 2   0   IS-M: Condition Input Type in the Order  
75 ZUSE_BETR JZUSBETR WERTV6 CURR 11   2   IS-M/AM: Amount Surcharge  
76 ZUSE_GRUND JGRKOND JGRUND CHAR 2   0   IS-M: Reason for Entering Conditions  
77 ZUSE_BKTYP BKTYP BKTYP CHAR 2   0   IS-M: Condition Input Type in the Order  
78 FPRG_BETR JGPRBETR WERTV6 CURR 11   2   IS-M/AM: Basic Price  
79 FPRG_PEIN PAMPEIN KPEIN DEC 5   0   IS-M: Price Unit (Surcharge Discount, Basic Price)  
80 FPRG_MEIN PAMMEIN ISPEINH_PR UNIT 3   0   IS-M: Unit of Measure (Discount, Surcharge, Basic Price) *
81 FPRG_GRUND JGRKOND JGRUND CHAR 2   0   IS-M: Reason for Entering Conditions  
82 FPRG_BKTYP BKTYP BKTYP CHAR 2   0   IS-M: Condition Input Type in the Order  
83 FPR1_BETR JVPRBETR WERTV6 CURR 11   2   IS-M/AM: Agreed price  
84 FPR1_GRUND JGRKOND JGRUND CHAR 2   0   IS-M: Reason for Entering Conditions  
85 FPR1_BKTYP BKTYP BKTYP CHAR 2   0   IS-M: Condition Input Type in the Order  
86 XRABZU XRABZU XFELD CHAR 1   0   IS-M: Discount/Surcharge Exists Indicator  
87 WAER_IPZA WAERK WAERS CUKY 5   0   SD document currency *
88 XUZUO_LOE XFELD XFELD CHAR 1   0   Checkbox  
89 .INCLUDE       0   0   IS-PAM: Status attributes for order item  
90 XUVFAKT XUVFAKT XFELD CHAR 1   0   IS-M: Billing is Incomplete  
91 XUVGP XUVGP XFELD CHAR 1   0   IS-M: Business Partner Is Incomplete  
92 XUVPREIS XUVPREIS XFELD CHAR 1   0   IS-M: Incomplete with regard to pricing  
93 XUVABSCHL XUVABSCHL XFELD CHAR 1   0   IS-M: Contract Assignment is Incomplete  
94 XUVVZ XUVVZ XFELD CHAR 1   0   IS-M: Sales Agent Assignment Incomplete  
95 XUVKPV XUVKPV XFELD CHAR 1   0   IS-M: Incomplete Manual Header/Item Sales Agent Assignment  
96 XGENEINT XGENEINT XFELD CHAR 1   0   IS-M: Schedule lines are not current  
97 XGENGRPF XGENGRPF XFELD CHAR 1   0   IS-M: Billing Dataset Is Yet To Be Generated  
98 XRESERV XRESERV XFELD CHAR 1   0   IS-M: Reservation indicator  
99 XRESBEST XRESBEST XFELD CHAR 1   0   IS-M: Reservation confirmed  
100 XFAKTMIN1 XFAKTMIN1 XFELD CHAR 1   0   IS-M: Partially Billed (At Least 1 Billing Dataset Billed)  
101 XFAKTALL XFAKTALL XFELD CHAR 1   0   IS-M: Billing Performed For All Billing Datasets  
102 XSPERR_BON XSPERR_BON XFELD CHAR 1   0   IS-M: "Blocked for reasons of creditworthiness" indicator  
103 XKOMMFRGB XKOMMFRGB XFELD CHAR 1   0   IS-M: Commercial release necessary but not performed  
104 XNACHBEARB XNACHBEARB XFELD CHAR 1   0   IS-M: Post-Editing Required  
105 .INCLUDE       0   0   Created-By Data (Medium Scope)  
106 ERFUSER ERFUSER USNAM CHAR 12   0   Created By  
107 ERFDATE ERFDATE DATUM DATS 8   0   Created On  
108 ERFTIME ERFTIME UZEIT TIMS 6   0   Time Created  
109 AENUSER AENUSER USNAM CHAR 12   0   Last Changed By  
110 AENDATE AENDATE DATUM DATS 8   0   Date of Last Change  
111 AENTIME AENTIME UZEIT TIMS 6   0   Time of Last Change  
112 XSTORNIERT XSTORNIERT XFELD CHAR 1   0   IS-M: Canceled Order Object Indicator  
113 STORNOGRND STOGRD_PAM STOGRD_PAM CHAR 3   0   IS-M: Cancellation Reason TJHSTOG
114 STAFO JHSTAFO STAFO CHAR 6   0   IS-M: Update group for statistics update TMCB
115 SELDAT_VON SELDAT_VON DATUM DATS 8   0   IS-M: Start Date for Item  
116 SELDAT_BIS SELDAT_BIS DATUM DATS 8   0   IS-M: End Date for Items  
117 .INCLUDE       0   0   IS-PAM: Purchase Order Data Include  
118 BSTNK BSTNK BSTNK CHAR 20   0   Customer purchase order number  
119 BSARK BSARK BSARK CHAR 4   0   Customer Order Type T176
120 BSTDK BSTDK DATUM DATS 8   0   Customer purchase order date  
121 BSTZD BSTZD BSTZD CHAR 4   0   Customer purchase order number supplement  
122 IHREZ IHREZ TEXT12 CHAR 12   0   Your Reference  
123 BNAME BNAME_V NAME CHAR 35   0   Name of orderer  
124 TELF1 TELF1_VP TELF1 CHAR 16   0   Telephone Number  
125 TELFX TELFX TEXT31 CHAR 31   0   Fax Number  
126 PARNR ISM_CNTCT_PRSN BU_PARTNER CHAR 10   0   IS-M: Contact Person *
127 ZUKOMM JZUKOMM TEXT50 CHAR 50   0   IS-M: Additional Communication Data  
128 .INCLUDE       0   0   IS-M/AM: Product Hierarchy (S&P): Include for JHAP  
129 PRDH_HERKUNFT ISM_PRDH_HERKUNFT CHAR002 CHAR 2   0   IS-M/AM: Origin Key  
130 PRDH_PRODUKT ISM_PRDH_PROD ISM_PRDH_PRODUKT CHAR 11   0   IS-M/AM: Product  
131 .INCLUDE       0   0   IS-M: Include for Specific Ad Item Attributes  
132 INHK_TECH1 INHK_TECH1 INHALTSKOM CHAR 8   0   IS-M: Technical Content Component (Positioning View) JJTIKO
133 INHK_TLEV1 INHK_LEV1 INHALTSKOM CHAR 8   0   IS-M: Level 1 content component in the hierarchy *
134 INHK_TECH2 INHK_SOVER INHALTSKOM CHAR 8   0   IS-M: Special Publication Content Component JJTIKO
135 INHK_KFM INHK_KFM INHALTSKOM CHAR 8   0   IS-M: Business Content Component JJTIKO
136 INHK_KLEV1 INHK_LEV1 INHALTSKOM CHAR 8   0   IS-M: Level 1 content component in the hierarchy *
137 MVA_INHALT MVA_INHALT MVA_INHALT CHAR 4   0   IS-M: Media Publication Content Type TJJ23
138 PLAZIERUNG PLAZIERANW PLAZIERANW CHAR 2   0   IS-M/AM: Positioning Instruction TJJ65
139 AZART_PLAZ AZART_PLAZ AZART_PLAZ CHAR 4   0   IS-M: Ad Type with Regard to General Positioning TJJ15
140 TEC_AVM_NR TEC_AVM_NR CHAR10 CHAR 10   0   IS-M: Order number in technical system  
141 XPLANUNG X_PLANUNG XFELD CHAR 1   0   IS-M: Relevant for planning indicator  
142 XBLATTBEST XBLATTBEST XFELD CHAR 1   0   IS-M: Page-Defining Indicator  
143 TBEL TEILBEL TEILBEL CHAR 2   0   IS-M: Selective Booking (Advertisement Item Type) TJHTBEL
144 .INCLUDE       0   0   IS-PAM: Include for Box Number Attributes  
145 CHIFFRE_NR CHIFFRE CHIFFRE_NR CHAR 10   0   IS-M/AM: Box Number  
146 CHIFFRE_KZ CHIFFRE_KZ CHIFFRE_KZ CHAR 1   0   IS-M: Box Number Indicator TJH59
147 CHIFFRE_OR CHIFFRE_OR VKBUR CHAR 4   0   IS-M: Box Number Location TVBUR
148 .INCLUDE       0   0   IS-M/AM: Include for Specific Ad Insert Attributes  
149 BEARB SINSBEARB SIBEAR_ART CHAR 2   0   IS-M: Ad Insert Processing Type TJH03
150 BLGMENGE BLGMGE_PAM STMENGE DEC 9   0   IS-M: Delivery Quantity for Ad Insert  
151 TZUSMENGE TZUSMENGE PRZ32 DEC 5   2   IS-M: Additional Tech.Quantity in % (Ad Insert)  
152 DISPMENGE DSPMGE_PAM STMENGE DEC 9   0   IS-M: Planning Quantity for Ad Inserts  
153 BERMENGE BERMENGE STMENGE DEC 9   0   IS-M: Calculation Quantity (Ad Insert)  
154 XBERMENGE_FIX JXBERMENGE_FIX XFELD CHAR 1   0   IS-M/AM: Calculation Quantity is Fixed indicator  
155 POSTMENGE POSTMENGE STMENGE DEC 9   0   IS-M: Postal Circulation Quantity  
156 SIMENGE_RH DSPMGE_RH STMENGE DEC 9   0   IS-M: Non-Reader Circulation for TMC  
157 MUSTER_T MUSTER_T MUSTER_ANZ NUMC 4   0   IS-M: Number of Samples (Technical)  
158 MUSTER_P MUSTER_P MUSTER_ANZ NUMC 4   0   IS-M: Number of Samples for Trial Runs (Ad Insert)  
159 XFREMDBEIL XFREMDBEIL XFELD CHAR 1   0   IS-M: Indicator - subject to postal charges (ad insert)  
160 XBEILAGHW XBLGHINW XFELD CHAR 1   0   IS-M: Insert Note Required Indicator  
161 XRESTHSHLT XRESTHSHLT XFELD CHAR 1   0   IS-M: Total Market Coverage  
162 RESTHSHLT_DATUM ISM_DELTA_COVERAGE_DATE DATUM DATS 8   0   IS-M: Alternative Date for Total Market Coverage  
163 XTRANZ XTRANZEIGE XFELD CHAR 1   0   IS-M: Carrier Ad Required Indicator  
164 XTBEL_SI XTBEL_SI XFELD CHAR 1   0   IS-M: Selective Booking of an AI BU  
165 SI_TYP SITYP SI_TYP CHAR 2   0   IS-M: Ad Insert Type TJH29
166 SI_GEWICHT ISM_SI_GEWICHT ISPMNG9 QUAN 9   3   IS-M: Ad Insert Weight  
167 MEINHGEWBL MEINHGEWBL MEINS UNIT 3   0   IS-M: Unit of Weight for Ad Insert T006
168 SI_ENTSPFL ISM_SI_ENTSPFL XFELD CHAR 1   0   IS-M: Waste Disposal Required Indicator  
169 SI_VERBWER ISM_SI_VERBWER XFELD CHAR 1   0   IS-M: Tie-In Ads Indicator  
170 ANZSEITEN ANZSEITEN NUM8 NUMC 8   0   Number of Pages in Issue  
171 .INCLUDE       0   0   IS-PAM: Include for service  
172 MATNR MATNR_DIEN MATNR_DIEN CHAR 18   0   IS-M: Service material number JJTDIEN
173 MENGE DIEN_MENGE MENG13 QUAN 13   3   IS-M: Service Quantity  
174 ERBTERM_V ERBTERM_V DATUM DATS 8   0   IS-M: Service Performance Period From  
175 ERBTERM_B ERBTERM_B DATUM DATS 8   0   IS-M: Service Performance Period To  
176 DIENTYP DIENTYP DIENTYP CHAR 4   0   IS-M: Service Type *
177 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure *
178 COPY_NO_START ISM_COPY_NO_START PAM_PERIOD CHAR 14   0   IS-M/AM: Start of Period for Copy  
179 COPY_NO_END ISM_COPY_NO_END PAM_PERIOD CHAR 14   0   IS-M/AM: End of Period for Copy  
180 .INCLUDE       0   0   IS-M: Short and Long Texts  
181 KURZTEXT BEZEICHN15 TEXT15 CHAR 15   0   IS-M: Short Text  
182 LANGTEXT BEZEICHN50 TEXT50 CHAR 50   0   IS-M: Long Text  
183 DIEN_BE DIEN_BE BELEINH CHAR 10   0   IS-M: Service: Assigned Booking Unit *
184 DIEN_IKO DIEN_IKO INHALTSKOM CHAR 8   0   IS-M: Service: Assigned Content Component *
185 .INCLUDE       0   0   IS-M/AM: Characteristics for Individual Use  
186 MERKMAL0 MERK0_EA XFELD CHAR 1   0   IS-M: Characteristic 0 for Individual Use (Ad Schedule Line)  
187 MERKMAL1 MERK1_EA XFELD CHAR 1   0   IS-M: Characteristic 1 for Individual Use (Ad Schedule Line)  
188 MERKMAL2 MERK2_EA XFELD CHAR 1   0   IS-M: Characteristic 2 for Individual Use (Ad Schedule Line)  
189 MERKMAL3 MERK3_EA XFELD CHAR 1   0   IS-M: Characteristic 3 for Individual Use (Ad Schedule Line)  
190 MERKMAL4 MERK4_EA XFELD CHAR 1   0   IS-M: Characteristic 4 for Individual Use (Ad Schedule Line)  
191 MERKMAL5 MERK5_EA XFELD CHAR 1   0   IS-M: Characteristic 5 for Individual Use (Ad Schedule Line)  
192 MERKMAL6 MERK6_EA XFELD CHAR 1   0   IS-M: Characteristic 6 for Individual Use (Ad Schedule Line)  
193 MERKMAL7 MERK7_EA XFELD CHAR 1   0   IS-M: Characteristic 7 for Individual Use (Ad Schedule Line)  
194 MERKMAL8 MERK8_EA XFELD CHAR 1   0   IS-M: Characteristic 8 for Individual Use (Ad Schedule Line)  
195 MERKMAL9 MERK9_EA XFELD CHAR 1   0   IS-M: Characteristic 9 for Individual Use (Ad Schedule Line)  
196 .INCLUDE       0   0   IS-PAM: Include for Specific Commercial Attributes  
197 WS_ART WSPOT_ART WSPOT_ART CHAR 4   0   IS-M: Commercial Type TJJ41
198 .INCLUDE       0   0   IS-M/AM: Distribution Item Status Indicator  
199 XUVSI XUVSI XFELD CHAR 1   0   IS-M: Ad Insert Data Incomplete Indicator  
200 XVT_PLAZ XVT_PLAZ XFELD CHAR 1   0   IS-M: Indicator distribution "positioned"  
201 XMUSTER_OK XMUSTER_OK XFELD CHAR 1   0   IS-M: Sample Received and Checked Indicator  
202 XSI_VORH XSI_VORH XFELD CHAR 1   0   IS-M: AI Copies Exist  
203 XUVTECH XUVTECH XFELD CHAR 1   0   IS-M: Incomplete Regarding Technical System (Gen.)  
204 XTECH_MIN1 XTECH_MIN1 XFELD CHAR 1   0   IS-M: Tech.process.started (for at least 1 schedule line)  
205 XTECH_EE XTECH_EE XFELD CHAR 1   0   IS-M: Tech.Complete (All Schedule Lines Fully Processed)  
206 .INCLUDE       0   0   IS-M/AM: Online Item Data for LIS Communication Structure  
207 BOOK_OL ISM_BOOK_OL ISM_BOOK_OL CHAR 4   0   IS-M/AM: Booking Type for Online Advertising TJHBOOKOL
208 OLP_START ONLPOS_START DATUM DATS 8   0   IS-M/AM: Start Date for Online Ad  
209 OLP_ENDE ONLPOS_ENDE DATUM DATS 8   0   IS-M/AM: End Date for Online Ad  
210 XTEXT_INT XTEXT_INT XFELD CHAR 1   0   IS-M: Internal positioning comment indicator  
211 XTEXT_EXT XTEXT_EXT XFELD CHAR 1   0   IS-M: External positioning comment exists indicator  
212 AE_NR_OL AENVERS_NR AENVERS_NR NUMC 4   0   IS-M: Last Change Version for Technical System  
213 .INCLUDE       0   0   IS-M: LIS communication structure, order data item extra  
214 XBASIS_BE XBASIS_BE XFELD CHAR 1   0   IS-M: Basic Booking Unit (Sales View) Indicator  
215 ANFANG_PER ANFANG_PER PAM_PERIOD CHAR 14   0   IS-M: Start of Copy/Publication Date Period  
216 GPAG GPAG GPNR CHAR 10   0   Business Partner: Sold-to Party *
217 STGKUP STGKU STGKU CHAR 1   0   Customer Statistics Group *
218 PRODH J_PRODH J_PRODH CHAR 18   0   IS-M/AM: Product Hierarchy *
219 VRTMENGE VRTMGE_PAM STMENGE DEC 9   0   IS-M: Planning Quantity for Ad Inserts  
220 TERM_TYP TERMINTYP TERMINTYP CHAR 1   0   IS-M/AM: Date Category Copy Number/Publication Date *
221 ENDE_PER ENDE_PER PAM_PERIOD CHAR 14   0   IS-M: End of Period - Issue/Publication Date  
222 BIS_PLUS BIS_PLUS BIS_PLUS CHAR 1   0   IS-M: Indicates a Period ("-") or 2 Dates ("+")  
223 ANZ_SCHALT ANZ_SCHALT ANZ_SCHALT NUMC 3   0   IS-M: Number of Placements  
224 TERM_ZYKL ANZ_ZYKLUS ANZ_ZYKLUS CHAR 4   0   IS-M: Frequency for Ad Publication *
225 TERMINART TERMINART TERMINART CHAR 1   0   IS-M/AM: Type of Publication Date  
226 ERSCH_T ERSCH_T DATUM DATS 8   0   IS-M: Publication Date  
227 WUNSCH_T WUNSCH_T DATUM DATS 8   0   IS-M/AM: Date Required  
228 .INCLUDE       0   0   IS-M/AM: Include for Weekday String  
229 X_MONTAG JHT_MONTAG XFELD CHAR 1   0   IS-M: Date Field Indicator - Monday  
230 X_DIENSTAG JHT_DIENSTAG XFELD CHAR 1   0   IS-M: Date Field Indicator - Tuesday  
231 X_MITTWOCH JHT_MITTWOCH XFELD CHAR 1   0   IS-M: Date Field Indicator - Wednesday  
232 X_DONNERST JHT_DONNERST XFELD CHAR 1   0   IS-M: Date Field Indicator - Thursday  
233 X_FREITAG JHT_FREITAG XFELD CHAR 1   0   IS-M: Date Field Indicator - Friday  
234 X_SAMSTAG JHT_SAMSTAG XFELD CHAR 1   0   IS-M: Date Field Indicator - Saturday  
235 X_SONNTAG JHT_SONNTAG XFELD CHAR 1   0   IS-M: Date Field Indicator - Sunday  
236 KONKAUS KONKAUS KONKAUS CHAR 2   0   IS-M: Competitor exclusion *
237 KONKAUSKOM KONKAUSKOM TEXT35 CHAR 35   0   IS-M: Comment on competitor exclusion  
238 SORTWORT SORTWORT TEXT10 CHAR 10   0   IS-M: Sort Word  
239 STICHW STICHW TEXT40 CHAR 40   0   IS-M: Keyword  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 MCJHAP AVM_NR JHAK AVM_NR KEY 1 CN
2 MCJHAP AZART_PLAZ TJJ15 AZART_PLAZ 1 CN
3 MCJHAP BEARB TJH03 BEARB KEY 1 CN
4 MCJHAP BEDNR JJTVB BEDNR KEY 1 CN
5 MCJHAP BOOK_OL TJHBOOKOL BOOK_OL 1 CN
6 MCJHAP BRAN_PAM TBRC BRACO 1 CN
7 MCJHAP BSARK T176 BSARK C CN
8 MCJHAP CHIFFRE_KZ TJH59 CHIFFRE_KZ 1 CN
9 MCJHAP CHIFFRE_OR TVBUR VKBUR 1 CN
10 MCJHAP INHK_KFM JJTIKO INHALTSKOM 1 CN
11 MCJHAP INHK_TECH1 JJTIKO INHALTSKOM 1 CN
12 MCJHAP INHK_TECH2 JJTIKO INHALTSKOM 1 CN
13 MCJHAP KAMPAGNE TJJKAMP KAMPAGNE 1 CN
14 MCJHAP MANDT T000 MANDT    
15 MCJHAP MATNR JJTDIEN MATNR 1 CN
16 MCJHAP MEINHGEWBL T006 MSEHI    
17 MCJHAP MVA_INHALT TJJ23 MVA_INHALT KEY 1 CN
18 MCJHAP PLAZIERUNG TJJ65 PLAZIERANW 1 CN
19 MCJHAP POS_ART TJH17 AVMPOS_ART 1 CN
20 MCJHAP PROSL TJH23 PRSCHL KEY 1 CN
21 MCJHAP PSTYV TJHAP PSTYV 1 CN
22 MCJHAP REF_AVM_NR JHAK AVM_NR 1 CN
23 MCJHAP REF_POS_NR JHAP POS_NR 1 CN
24 MCJHAP SI_TYP TJH29 SI_TYP    
25 MCJHAP STAFO TMCB STAFO 1 CN
26 MCJHAP STORNOGRND TJHSTOG STORNOGRD 1 CN
27 MCJHAP SUC_AVM_NR JHAK AVM_NR 1 CN
28 MCJHAP SUC_POS_NR JHAP POS_NR 1 CN
29 MCJHAP TBEL TJHTBEL TBEL 1 CN
30 MCJHAP VNR JJTVV VNR KEY 1 CN
31 MCJHAP VORL_AVMNR JHAK AVM_NR 1 CN
32 MCJHAP VORL_POSNR JHAP POS_NR 1 CN
33 MCJHAP WERBK_EINT JHAE EIN_NR 1 CN
34 MCJHAP WERBK_POS JHAP POS_NR 1 CN
35 MCJHAP WERBK_TYP TJH91 WKOMBI_TYP 1 CN
36 MCJHAP WS_ART TJJ41 WSPOT_ART 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in