SAP ABAP Table RJHA6206 (IS-PAM: Scrn struct.for cent.access - overview of all items)

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	RJHA6206	Table Relationship Diagram
Short Description	IS-PAM: Scrn struct.for cent.access - overview of all items

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	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	*
2	POS_NR	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	*
3	TEC_AVM_NR	☐	TEC_AVM_NR	CHAR10	CHAR	10	0	IS-M: Order number in technical system
4	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
5	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
6	PREIS_AVM1	☐	PREIS_AVM1	WERTV8	CURR	15	2	IS-M: Price Field 1 in the Order
7	PREIS_AVM2	☐	PREIS_AVM2	WERTV8	CURR	15	2	IS-M: Price Field 2 in the Order
8	WAEHRG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
9	MWST_BETR	☐	GRMWSTBETR	WERTV7	CURR	13	2	IS-M: Value-Added Tax Amount
10	STICHW	☐	STICHW	TEXT40	CHAR	40	0	IS-M: Keyword
11	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	*
12	NOTIZKNZ	☐	NOTIZKNZ	XFELD	CHAR	1	0	IS-M: Indicates Whether Notes are Available for an OPM Objct
13	ALTINSGPNR	☐	ALTINSGPNR	CHAR15	CHAR	15	0	IS-M: Alternative Customer Number for Advertiser
14	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	*
15	INS_NAME	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
16	INS_ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
17	INSERKNZ	☐	INSERKNZ	XFELD	CHAR	1	0	IS-M: Advertiser Indicator
18	BELEGEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	*
19	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	*
20	BE_KURZ	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
21	BEKENNZ	☐	BEKENNZ	XFELD	CHAR	1	0	IS-M: Booking Unit Indicator
22	XINSBLANK	☐	XINSBLANK	XFELD	CHAR	1	0	IS-M: Agency Order Without Advertiser Indicator
23	AMPEL	☐	ISP_AMPEL	CHAR004	CHAR	4	0	IS-M: Light for representing the status visually
24	STAT_AMPEL	☐	STAT_AMPEL	SYCHAR132	CHAR	132	0	IS-M: Status visualization
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	TEXTSPITZE	☐	TEXTSPITZE	TEXT25	CHAR	25	0	IS-M: Ad Text Header
28	NOTIZ	☐	MOTIVNOTIZ	TEXT50	CHAR	50	0	IS-M: Note for Ad Spec Design
29	.INCLUDE	☐				0	0	IS-M/AM: Include for Pure Item Attributes
30	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
31	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
32	VBTYP	☐	ISPVBTYP	ISPVBTYP	CHAR	1	0	IS-M/AM: Sales Document Category
33	WERBK_TYP	☐	WKOMBI_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Combination Sale Type	TJH91
34	WERBK_KNZ	☐	WERBK_KNZ	WERBEKKNZ	NUMC	4	0	IS-M: Combination Sale Indicator
35	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
36	XEINTEILG	☐	XEINTEILG	XFELD	CHAR	1	0	IS-M: Indicator for modification at subordinate ord. level
37	BRAN_PAM	☐	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	TBRC
38	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
39	.INCLUDE	☐				0	0	IS-PAM: Agent attributes outside agent assignment
40	VERMITTLER	☐	VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID Code for Screen	*
41	VNR	☐	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	JJTVV
42	BEDNR	☐	VM_BEDNR	VM_BEDNR	NUMC	6	0	IS-M: Number of Media Sales Agent Contract Requirement	JJTVB
43	PROSL	☐	JPROVSCHL	PRSCHL	CHAR	5	0	IS-M/AM: Commission Key for Media Sales Agent	TJH23
44	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	TJJKAMP
45	WERBK_POS	☐	WERBK_POS	AVM_PNR	NUMC	3	0	IS-M: Combination Sale Grouping Item Number	JHAP
46	WERBK_UPOS	☐	WERBK_UPOS	AVM_UPNR	NUMC	4	0	IS-M: Combination Sale Grouping Sub-Item
47	WERBK_EINT	☐	WERBK_EINT	AVMENR	NUMC	6	0	IS-M: Combination Sale Grouping for Schedule Line Number	JHAE
48	REF_AVM_NR	☐	REF_AVM_NR	AVM_NR	CHAR	10	0	IS-M: Reference Order Number of Preceding Order	JHAK
49	REF_POS_NR	☐	REF_POS_NR	AVM_PNR	NUMC	3	0	IS-M: Reference Item Number of Preceding Item	JHAP
50	SUC_AVM_NR	☐	SUC_AVM_NR	AVM_NR	CHAR	10	0	IS-M: Order Number of Subsequent Document	JHAK
51	SUC_POS_NR	☐	SUC_POS_NR	AVM_PNR	NUMC	3	0	IS-M: Item Number of Subsequent Item	JHAP
52	VORL_AVMNR	☐	VORL_AVMNR	AVM_NR	CHAR	10	0	IS-M: Order Number of the Preceding Document	JHAK
53	VORL_POSNR	☐	VORL_POSNR	AVM_PNR	NUMC	3	0	IS-M: Item number of the Preceding Item	JHAP
54	CAMPAIGN	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign
55	.INCLUDE	☐				0	0	IS-PAM: INCLUDE for bank data
56	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
57	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys	BNKA
58	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
59	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
60	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
61	XEINZUG	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
62	.INCLUDE	☐				0	0	IS-M/AM: Include for IBAN
63	IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
64	.INCLUDE	☐				0	0	IS-PAM: Include for Business Data
65	WAERG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
66	FAKSPP	☐	PAM_FAKSP	FAKSP	CHAR	2	0	IS-M: Billing Block	TVFS
67	XSEPFKKOPF	☐	XSEPFKKOPF	XFELD	CHAR	1	0	Separate billing document for sales order
68	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
69	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
70	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
71	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
72	FAKDATUM	☐	JHFKTER	DATUM	DATS	8	0	IS-M: Planned Billing/Settlement Date
73	VORAUSKNZ	☐	VORAUSKNZ	XFELD	CHAR	1	0	IS-M: Indicates Whether Advance Billing Required
74	VORAUSRCH	☐	VORAUSRCH	XFELD	CHAR	1	0	IS-M: "Advance billing required" indicator
75	XRECHN	☐	XRECHN	XFELD	CHAR	1	0	IS-M: Invoice Requested Indicator
76	XKFMAEND	☐	XKFMAEND	XFELD	CHAR	1	0	IS-M: Business Data was Changed Manually Indicator
77	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
78	XORTSPREIS	☐	XORTSPREIS	XFELD	CHAR	1	0	IS-M/AM: Local Customer Indicator
79	KALKS	☐	KALKS	KALKS	CHAR	1	0	Pricing procedure assigned to this customer	TVKD
80	KUKARR_K	☐	JKUKARR	JKUKARR	CHAR	2	0	IS-M: Customer Profile	TJJ95
81	KARENZ	☐	JKARENZ	JKARENZ	NUMC	4	0	IS-M: Grace Period for Price Changes
82	KARENZ_ME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
83	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
84	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
85	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
86	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	T042Z
87	AE	☐	AGEN_AE	AGEN_AE	CHAR	1	0	IS-M: Agency Commission Entitlement
88	STORNOGRND	☐	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	TJHSTOG
89	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
90	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
91	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
92	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
93	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
94	MARK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
95	AVM_HRKNFT	☐	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
96	XZEILFARB	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
97	PRODH_TEXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJHA6206	BANKL	BNKA	BANKL
2	RJHA6206	BANKS	T005	LAND1	REF	C	CN
3	RJHA6206	BEDNR	JJTVB	BEDNR	KEY	1	CN
4	RJHA6206	BRAN_PAM	TBRC	BRACO		C	CN
5	RJHA6206	FAKSPP	TVFS	FAKSP	KEY	1	CN
6	RJHA6206	GPAG	JGTGPNR	GPNR
7	RJHA6206	KALKS	TVKD	KALKS	KEY	1	CN
8	RJHA6206	KAMPAGNE	TJJKAMP	KAMPAGNE	REF	1	CN
9	RJHA6206	KARENZ_ME	T006	MSEHI	KEY	1	CN
10	RJHA6206	KDGRP	T151	KDGRP	REF	1	CN
11	RJHA6206	KONDA	T188	KONDA	KEY	1	CN
12	RJHA6206	KUKARR_K	TJJ95	KUKARR	KEY	1	CN
13	RJHA6206	KURST	TCURV	KURST	REF	1	CN
14	RJHA6206	PERFK	TFACD	IDENT	KEY	1	CN
15	RJHA6206	PLTYP	T189	PLTYP	REF	1	CN
16	RJHA6206	POS_ART	TJH17	AVMPOS_ART	REF	1	CN
17	RJHA6206	PROSL	TJH23	PRSCHL	KEY	1	CN
18	RJHA6206	PSTYV	TJHAP	PSTYV	REF	1	CN
19	RJHA6206	REF_AVM_NR	JHAK	AVM_NR	REF	1	CN
20	RJHA6206	REF_POS_NR	JHAP	POS_NR	REF	1	CN
21	RJHA6206	STORNOGRND	TJHSTOG	STORNOGRD
22	RJHA6206	SUC_AVM_NR	JHAK	AVM_NR	REF	1	CN
23	RJHA6206	SUC_POS_NR	JHAP	POS_NR	REF	1	CN
24	RJHA6206	VNR	JJTVV	VNR	KEY	1	CN
25	RJHA6206	VORL_AVMNR	JHAK	AVM_NR	REF	1	CN
26	RJHA6206	VORL_POSNR	JHAP	POS_NR	KEY	1	CN
27	RJHA6206	WAERG	TCURC	WAERS	KEY	1	CN
28	RJHA6206	WERBK_EINT	JHAE	EIN_NR		1	CN
29	RJHA6206	WERBK_POS	JHAP	POS_NR		1	CN
30	RJHA6206	WERBK_TYP	TJH91	WKOMBI_TYP		1	CN
31	RJHA6206	ZLSCH	T042Z	ZLSCH	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in