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

History

Last changed by/on	SAP	20110901
SAP Release Created in	46C