SAP ABAP Table RJY_MAM_ORDERLIST (IS-M/AM: CIC, Order Overview: Item/Schedule Line Data)

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	RJY_MAM_ORDERLIST	Table Relationship Diagram
Short Description	IS-M/AM: CIC, Order Overview: Item/Schedule Line Data

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	AVM_NR	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	*
3	POS_NR	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	*
4	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
5	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
6	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
7	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
8	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
9	AUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	*
10	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
11	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
12	BELEGEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	*
13	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
14	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
15	PREIS_AVM1	☐	PREIS_AVM1	WERTV8	CURR	15	2	IS-M: Price Field 1 in the Order
16	PREIS_AVM2	☐	PREIS_AVM2	WERTV8	CURR	15	2	IS-M: Price Field 2 in the Order
17	WAEHRG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
18	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	*
19	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	*
20	INSZ_NR	☐	INSZ_NR	NUMC4	NUMC	4	0	IS-M: Advertiser assignment number
21	ALTINSGPNR	☐	ALTINSGPNR	CHAR15	CHAR	15	0	IS-M: Alternative Customer Number for Advertiser
22	AG_NAME	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
23	INS_NAME	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
24	WERBK_TYP	☐	WKOMBI_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Combination Sale Type	*
25	SELDAT_VON	☐	SELDAT_VON	DATUM	DATS	8	0	IS-M: Start Date for Item
26	SELDAT_BIS	☐	SELDAT_BIS	DATUM	DATS	8	0	IS-M: End Date for Items
27	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
28	AMPEL	☐	ISP_AMPEL	CHAR004	CHAR	4	0	IS-M: Light for representing the status visually
29	STICHW	☐	STICHW	TEXT40	CHAR	40	0	IS-M: Keyword
30	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	JJT179
31	PRODHTEXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
32	STORNOGRND	☐	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	*
33	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
34	AVM_HRKNFT	☐	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
35	TEC_AVM_NR	☐	TEC_AVM_NR	CHAR10	CHAR	10	0	IS-M: Order number in technical system
36	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	*
37	BRAN_PAM	☐	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	*
38	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
39	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
40	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
41	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
42	CHIFFRE_NR	☐	CHIFFRE	CHIFFRE_NR	CHAR	10	0	IS-M/AM: Box Number
43	COPY_NO_START	☐	ISM_COPY_NO_START	PAM_PERIOD	CHAR	14	0	IS-M/AM: Start of Period for Copy
44	COPY_NO_END	☐	ISM_COPY_NO_END	PAM_PERIOD	CHAR	14	0	IS-M/AM: End of Period for Copy
45	NE_TERMIN	☐	NE_TERMIN	DATUM	DATS	8	0	IS-M: Next/Last Publication Date
46	NE_HEFT	☐	NE_HEFT	PAM_PERIOD	CHAR	14	0	IS-M: Copy Number for the Next/Last Publication
47	EIN_NR	☐	EIN_NR	AVMENR	NUMC	6	0	IS-M: Schedule Line	*
48	EINTL_ANZ	☐	EINTL_ANZ	NUMC6	NUMC	6	0	IS-M: Number of Schedule Lines in an Item
49	WS_TIMESLC	☐	WS_TIMESLC	WS_TIMESLC	CHAR	2	0	IS-M: Commercial Time Slice	*
50	WS_BLOCK	☐	WS_BLOCK	WS_BLOCK	CHAR	2	0	IS-M: Commercial Cluster	*
51	WS_STELLE	☐	WS_STELLE	NUMC3	NUMC	3	0	IS-M: Position (Sequence) Within a Commercial Cluster
52	GFK_CODE	☐	GFK_CODE	CHAR06	CHAR	6	0	IS-M: Society for Consumer Research Code

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJY_MAM_ORDERLIST	INHK_KFM	JJTIKO	INHALTSKOM
2	RJY_MAM_ORDERLIST	POS_ART	TJH17	AVMPOS_ART
3	RJY_MAM_ORDERLIST	PRODH	JJT179	PRODH
4	RJY_MAM_ORDERLIST	PSTYV	TJHAP	PSTYV

History

Last changed by/on	SAP	20110901
SAP Release Created in	463