SAP ABAP Table RJHAW170 (IS-M/AM: IAC Enter Classified Ad: Order 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	RJHAW170	Table Relationship Diagram
Short Description	IS-M/AM: IAC Enter Classified Ad: Order 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	AVM_NR	☐	AVM_NR_WITHOUT_SEARCHHELP	AVM_NR	CHAR	10	0	IS-M: Order	*
2	POS_NR	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	*
3	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	*
4	GPAG_TXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
5	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	*
6	BELEGEINH	☐	BELEGEINH_WITHOUT_SEARCHHELP	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	*
7	BELEGEINH_TXT	☐	BEZEICHN50	TEXT50	CHAR	50	0	IS-M: Long Text
8	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	*
9	INHK_KFM_TXT	☐	BEZEICHN50	TEXT50	CHAR	50	0	IS-M: Long Text
10	INHK_KLEV1	☐	INHK_LEV1	INHALTSKOM	CHAR	8	0	IS-M: Level 1 content component in the hierarchy	*
11	ERSCH_T	☐	ERSCH_T	DATUM	DATS	8	0	IS-M: Publication Date
12	ERSCH_T_TXT	☐	LANGT	TEXT20	CHAR	20	0	Day
13	PREIS_AVM1	☐	PREIS_AVM1	WERTV8	CURR	15	2	IS-M: Price Field 1 in the Order
14	PREIS_AVM2	☐	PREIS_AVM2	WERTV8	CURR	15	2	IS-M: Price Field 2 in the Order
15	WAEHRG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
16	WAEHRG_TXT	☐	LTEXT	TEXT40	CHAR	40	0	Long Text
17	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
18	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
19	AMPEL	☐	ISP_AMPEL	CHAR004	CHAR	4	0	IS-M: Light for representing the status visually
20	CCINS	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	*
21	CCINS_TXT	☐	VTEXT	TEXT20	CHAR	20	0	Description
22	CCNUM	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
23	DATBI	☐	DATBI_CC	DATUM	DATS	8	0	Payment Cards: Valid To
24	DATBI_TXT	☐	DATBI_CC_TXT	CHAR7	CHAR	7	0	IS-M: Payment Cards: Valid To as Month/Year
25	ZLSCH	☐	JZLSCH	ZLSCH	CHAR	1	0	IS-M: Payment Method	*
26	ZLSCH_TXT	☐	TEXT1_042Z	TEXT30	CHAR	30	0	Name of Payment Method in Language of the Country
27	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	*
28	BANKS_TXT	☐	LANDX	TEXT15	CHAR	15	0	Country Name
29	BANKL	☐	BANKL	BANKL	CHAR	15	0	Bank number
30	BANKL_TXT	☐	BANKA	TEXT60	CHAR	60	0	Name of bank
31	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
32	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
33	XEZER	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
34	ZUS_MENGE	☐	BER_MENGE	GROESSE	QUAN	7	3	IS-M: Number of Additional Ad Spec Calculation Units
35	ZUS_BERECH	☐	MEINH_ZUS	ISPEINHEIT	UNIT	3	0	IS-M: Additional Unit of Measure for Settlement	*
36	ZUS_BERECH_TXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
37	HOEHE_I	☐	HOEHE_I	GROESSE	QUAN	7	3	IS-M: Actual height of the ad spec
38	HOEHE_I_EH	☐	ISPEINH_H	ISPEINH_H	UNIT	3	0	IS-M: Unit of Measure for Height	*
39	HOEHE_I_EH_TXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
40	BREITE_I	☐	BREITE_I	GROESSE	QUAN	7	3	IS-M: Actual Ad Spec Width
41	BREITE_IEH	☐	BREITE_SEH	ISPEINHEIT	UNIT	3	0	IS-M/AM: Unit of Measure for Width	*
42	BREITE_IEH_TXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
43	CHIFFRE_NR	☐	CHIFFRE_WITHOUT_SEARCHHELP	CHIFFRE_NR	CHAR	10	0	IS-M: Box Number
44	CHIFFRE_KZ	☐	CHIFFRE_KZ	CHIFFRE_KZ	CHAR	1	0	IS-M: Box Number Indicator	*
45	CHIFFRE_OR	☐	CHIFFRE_OR	VKBUR	CHAR	4	0	IS-M: Box Number Location	*
46	CHIFFRE_OR_TXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
47	TEC_AVM_NR	☐	TEC_AVM_NR	CHAR10	CHAR	10	0	IS-M: Order number in technical system
48	MOTIV	☐	MOTIV_NR	PAM_MOTIV	NUMC	6	0	IS-M: Ad Spec Number (Ad)	*
49	MOTIVID	☐	MOTIVID	MOTIVID	CHAR	12	0	IS-M: Assigned ad spec/ad spec file in technical system
50	AZART_GEST	☐	AZART_GEST	AZART_GEST	CHAR	4	0	IS-M: Design Ad Type	TJJ19
51	AZFARB_IST	☐	AZFARB_IST	AZART_FARB	CHAR	4	0	IS-M: Actual Color Scheme Ad Type	TJJ11
52	GRUNFARBEI	☐	FARBNAME	FARBNAME	CHAR	8	0	IS-M: Color Name	TJH33
53	FARBNAME1I	☐	FARBNAME	FARBNAME	CHAR	8	0	IS-M: Color Name	TJH33
54	FARBNAME2I	☐	FARBNAME	FARBNAME	CHAR	8	0	IS-M: Color Name	TJH33
55	FARBNAME3I	☐	FARBNAME	FARBNAME	CHAR	8	0	IS-M: Color Name	TJH33
56	SEITE_FSP	☐	SEITE_FSP	SEITE_FSP	CHAR	4	0	IS-M: Page/column format	TJJ47
57	XANSCHNITT	☐	XANSCHNITT	XFELD	CHAR	1	0	IS-M: Bled Ad Spec Indicator
58	XUEBERBUND	☐	XUEBERBUND	XFELD	CHAR	1	0	IS-M: Indicates That The Ad Spec Overlaps Gutter Margin
59	TYPO_NR_IS	☐	TYPO_NR	TYPONR	CHAR	8	0	IS-M: Typography Number
60	RAHMENTYPI	☐	RAHMENTYP	RAHMENTYP	CHAR	8	0	IS-M: Border Type	TJH35
61	RAHMENSTAI	☐	RAHMENSTAE	NUM2	NUMC	2	0	IS-M: Border Width
62	RAHMENEINH	☐	RAHMENEINH	MEINS	UNIT	3	0	IS-M: Unit of measurement for border width	T006
63	TEXTSPITZE	☐	TEXTSPITZE	TEXT25	CHAR	25	0	IS-M: Ad Text Header
64	INVERSKNZI	☐	INVERSKNZ	XFELD	CHAR	1	0	IS-M: Reversed Indicator
65	RASTER_IST	☐	RASTERUNG	RASTERUNG	CHAR	2	0	IS-M: Grid Spacing	TJH37
66	MOTIV_URL	☐	MOTIV_URL	TEXT255	CHAR	255	0	IS-M/AM: URL for Ad Spec

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJHAW170	AZART_GEST	TJJ19	AZART_GEST	REF	1	CN
2	RJHAW170	AZFARB_IST	TJJ11	AZART_FARB	REF	1	CN
3	RJHAW170	FARBNAME1I	TJH33	FARBNAME	REF	1	CN
4	RJHAW170	FARBNAME2I	TJH33	FARBNAME	REF	1	CN
5	RJHAW170	FARBNAME3I	TJH33	FARBNAME		1	CN
6	RJHAW170	GRUNFARBEI	TJH33	FARBNAME	REF	1	CN
7	RJHAW170	RAHMENEINH	T006	MSEHI	REF	1	CN
8	RJHAW170	RAHMENTYPI	TJH35	RAHMENTYP	REF	1	CN
9	RJHAW170	RASTER_IST	TJH37	RASTER	REF	1	CN
10	RJHAW170	SEITE_FSP	TJJ47	SEITE_FSP	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	462