SAP ABAP Table RJHAISZ (IS-M/AM: Structure Table for Advertiser Assign.in OPM Order)

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	RJHAISZ	Table Relationship Diagram
Short Description	IS-M/AM: Structure Table for Advertiser Assign.in OPM Order

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: Flat Part of Structure RJHAISZ
2	.INCLUDE	☐				0	0	IS-M/AM: Flat Part of Structure RJHAISZ
3	.INCLUDE	☐				0	0	IS-M/AM: Assignment Table of Advertisers for OPM Order
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	AVM_NR	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
6	POS_NR	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
7	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JJVDB_MK_FK
8	XINSBLANK	☐	XINSBLANK	XFELD	CHAR	1	0	IS-M: Agency Order Without Advertiser Indicator
9	INSZ_NR	☐	INSZ_NR	NUMC4	NUMC	4	0	IS-M: Advertiser assignment number
10	INS_PROZ	☐	PAM_PROZ	JHPROZ33	DEC	6	3	IS-M: Percentage Figure for Cost Distribution
11	AZGR_INS	☐	AZGR_INS	NUMC4	NUMC	4	0	Column MM of the Ad Which the Advertiser is Involved In
12	ALTINSGPNR	☐	ALTINSGPNR	CHAR15	CHAR	15	0	IS-M: Alternative Customer Number for Advertiser
13	REGULIERER	☐	REGULIERER	GPNR	CHAR	10	0	IS-M: Payer	JGTGPNR
14	.INCLUDE	☐				0	0	IS-PAM: Include for Customer Tax Classification
15	TAXK1	☐	TAXK1	TAXKD	CHAR	1	0	Tax classification 1 for customer	*
16	TAXK2	☐	TAXK2	TAXKD	CHAR	1	0	Tax classification 2 for customer	*
17	TAXK3	☐	TAXK3	TAXKD	CHAR	1	0	Tax classification 3 for customer	*
18	TAXK4	☐	TAXK4	TAXKD	CHAR	1	0	Tax classification 4 for customer	*
19	TAXK5	☐	TAXK5	TAXKD	CHAR	1	0	Tax classification 5 for customer	*
20	TAXK6	☐	TAXK6	TAXKD	CHAR	1	0	Tax classification 6 for customer	*
21	TAXK7	☐	TAXK7	TAXKD	CHAR	1	0	Tax classification 7 for customer	*
22	TAXK8	☐	TAXK8	TAXKD	CHAR	1	0	Tax classification 8 for customer	*
23	TAXK9	☐	TAXK9	TAXKD	CHAR	1	0	Tax classification 9 for customer	*
24	GPNR_RECH	☐	GPNR_RECH	GPNR	CHAR	10	0	IS-M: Business Partner - Bill-To Party	JGTGPNR
25	RECH_ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
26	RECH_ADVAR	☐	ADRESSVAR	ERSTADR	CHAR	1	0	IS-M: Address Variant
27	RECH_ADHER	☐	HERK	HERK	CHAR	1	0	IS-M: Use of Address
28	.INCLUDE	☐				0	0	IS-PAM: Include for Business Data
29	WAERG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
30	FAKSPP	☐	PAM_FAKSP	FAKSP	CHAR	2	0	IS-M: Billing Block	TVFS
31	XSEPFKKOPF	☐	XSEPFKKOPF	XFELD	CHAR	1	0	Separate billing document for sales order
32	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
33	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
34	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
35	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
36	FAKDATUM	☐	JHFKTER	DATUM	DATS	8	0	IS-M: Planned Billing/Settlement Date
37	VORAUSKNZ	☐	VORAUSKNZ	XFELD	CHAR	1	0	IS-M: Indicates Whether Advance Billing Required
38	VORAUSRCH	☐	VORAUSRCH	XFELD	CHAR	1	0	IS-M: "Advance billing required" indicator
39	XRECHN	☐	XRECHN	XFELD	CHAR	1	0	IS-M: Invoice Requested Indicator
40	XKFMAEND	☐	XKFMAEND	XFELD	CHAR	1	0	IS-M: Business Data was Changed Manually Indicator
41	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
42	XORTSPREIS	☐	XORTSPREIS	XFELD	CHAR	1	0	IS-M/AM: Local Customer Indicator
43	KALKS	☐	KALKS	KALKS	CHAR	1	0	Pricing procedure assigned to this customer	TVKD
44	KUKARR_K	☐	JKUKARR	JKUKARR	CHAR	2	0	IS-M: Customer Profile	TJJ95
45	KARENZ	☐	JKARENZ	JKARENZ	NUMC	4	0	IS-M: Grace Period for Price Changes
46	KARENZ_ME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
47	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
48	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
49	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
50	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	T042Z
51	AE	☐	AGEN_AE	AGEN_AE	CHAR	1	0	IS-M: Agency Commission Entitlement
52	.INCLUDE	☐				0	0	IS-PAM: INCLUDE for bank data
53	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
54	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys	BNKA
55	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
56	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
57	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
58	XEINZUG	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
59	.INCLUDE	☐				0	0	IS-M/AM: Include for IBAN
60	IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
61	XSPERR_BON	☐	XSPERR_BON	XFELD	CHAR	1	0	IS-M: "Blocked for reasons of creditworthiness" indicator
62	VKBUR_ZUST	☐	VKBURZUS	VKBUR	CHAR	4	0	Sales office responsible	*
63	.INCLUDE	☐				0	0	IS-M/AM: Payment cards: Projection of RJH_CCDATA
64	CCINS	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	TVCIN
65	CCNUM	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	VCNUM
66	DATBI	☐	DATBI_CC	DATUM	DATS	8	0	Payment Cards: Valid To
67	CCNAME	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
68	.INCLUDE	☐				0	0	IS-M/AM: Card Verification Value
69	CVVAL	☐	ISM_CVVAL	ISM_CVVAL	CHAR	6	0	Card Verification Value
70	CVVCT	☐	ISM_CVVCT	ISM_CVVCT	CHAR	1	0	Control Field for Card Verification Value
71	CVVST	☐	ISM_CVVST	ISM_CVVST	CHAR	1	0	Usage Status of Card Verification Value
72	DATE_GEN_RULE_BI	☐	ISM_DATE_GEN_RULE_BI	ISM_DATE_GEN_RULE_BI	CHAR	2	0	IS-M: Date Rule for Generating Billing Dataset	TJHGENBI
73	BRAN1	☐	BRAN_PAM	BRACO	CHAR	10	0	IS-M: Industry Sector for Advertiser	TBRC
74	ADV_AD_SIZE	☐	ISM_ADV_AD_SIZE	MENGE13	QUAN	13	3	Share of Ad Size Belonging to the Advertiser
75	.INCLUDE	☐				0	0	Credit Card Encryption
76	CGUID	☐	CARD_GUID	SYSUUID	RAW	16	0	GUID of a Payment Card
77	ENCTP	☐	CCSECA_ENCTYPE	CCSECA_ENCTYPE	CHAR	1	0	Type of Encryption
78	.INCLUDE	☐				0	0	IS-M/AM: Include for SEPA Mandates
79	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
80	.INCLUDE	☐				0	0	IS-M/AM: Include for extra data for bank details
81	.INCLUDE	☐				0	0	IS-PAM: Bank Data Include: BNKA Without JHIBANK
82	BANKA	☐	BANKA	TEXT60	CHAR	60	0	Name of bank
83	PROVZ	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
84	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
85	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
86	SWIFT	☐	SWIFT	SWIFT	CHAR	11	0	SWIFT/BIC for International Payments
87	BGRUP	☐	BGRUP	BGRUP	CHAR	2	0	Bank group (bank network)
88	XPGRO	☐	XPGRO	XFELD	CHAR	1	0	Post Office Bank Current Account
89	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
90	BNKLZ	☐	BANKL	BANKL	CHAR	15	0	Bank number
91	PSKTO	☐	PSKTO_CH	PSKTO	CHAR	16	0	Post office bank current account number
92	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
93	BRNCH	☐	BRNCH	TEXT40	CHAR	40	0	Bank Branch
94	.INCLUDE	☐				0	0	IS-M/AM: Include for Created by data and new bank dets ind.
95	XBVNEU	☐	XBVNEU	XFELD	CHAR	1	0	IS-M/AM: Indicator: New Bank Details
96	XBVNEUVERTBER	☐	XBVNEUVERTBER	XFELD	CHAR	1	0	IS-M/AM: Indicator 'Bank Details are New in Sales Area
97	XGENERNEU	☐	XGENERNEU	XFELD	CHAR	1	0	IS-M/AM: Indicator: Billing Dataset Must Be Generated Again
98	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
99	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
100	.INCLUDE	☐				0	0	IS-M/AM: Extra data for collection authorization include
101	ERTEILT_AM	☐	ISPEZWANN	DATUM	DATS	8	0	IS-M: Date on Which Collection Authorization Issued
102	BIS_DATUM	☐	ISPEZBIS	DATUM	DATS	8	0	IS-M: Date to Which Collection Authorization Is Valid
103	ERTEILT_VON	☐	ISPEZWEM	TEXT35	CHAR	35	0	IS-M: Collection Authorization Issued By
104	KONTOINH	☐	ISPEZKTOIN	TEXT35	CHAR	35	0	IS-M: Account Holder for Collection Authorization
105	BETRAG	☐	ISPEZBTR	ISPWV072	CURR	9	2	IS-M: Collection Authorization up to Amount of:
106	WAEHRUNG	☐	ISPEZWAERS	WAERS	CUKY	5	0	IS-M: Currency for Collection Authorization	*
107	INS_NAME	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
108	INS_ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
109	REG_NAME	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
110	RECH_NAME	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
111	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
112	RECH_LOGAD	☐	JLOGADR	JLOGADR	NUMC	4	0	IS-M: Logical Address Number
113	.INCLUDE	☐				0	0	IS-M/AM: Payment cards: Projection of RJH_CCDATA
114	DATAB	☐	DATAB_CC	DATUM	DATS	8	0	Payment cards: Valid from
115	AUSGDAT	☐	CC_AUSGDAT	DATUM	DATS	8	0	Payment Cards: Date of Issue
116	CCTYP	☐	CCTYP	CCTYP	CHAR	2	0	Payment cards: Card category	TVCTY
117	CCARD_ID	☐	BU_CCID	CHAR6	CHAR	6	0	Payment Card ID
118	ISSBANK	☐	CC_ISSBANK	TEXT40	CHAR	40	0	Payment cards: Issuing bank
119	CSOUR	☐	CSOUR	CSOUR	CHAR	1	0	Payment cards: Entry mode
120	CCFOL	☐	CCFOL	CHAR10	CHAR	10	0	Payment cards: Payment card suffix
121	CCARD_OWNER	☐	ISM_CCARD_OWNER	BU_PARTNER	CHAR	10	0	IS-M/AM: Payment Card Holder	*
122	CVVSTTEXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
123	ZLSCH_TEXT	☐	TEXT1_042Z	TEXT30	CHAR	30	0	Name of Payment Method in Language of the Country
124	KONDA_TEXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
125	RJHAVZW_ITAB	☐	RJHAVZW_TAB		TTYP	0	0
126	ADV_DESCRIPTION	☐	BU_DESCRIP_LONG	CHAR80	CHAR	80	0	Description of a Business Partner
127	PAYER_DESCRIPTION	☐	BU_DESCRIP_LONG	CHAR80	CHAR	80	0	Description of a Business Partner
128	BTP_DESCRIPTION	☐	BU_DESCRIP_LONG	CHAR80	CHAR	80	0	Description of a Business Partner
129	XCCNUM_UPD	☐	ISM_XCCNUM_UPD	XFELD	CHAR	1	0	Indicator: Change Payment Card in Order Dialog
130	CCNUM_UNMASKED	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
131	MND_ITAB	☐	RJHAMND_TAB		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJHAISZ	AVM_NR	JHAK	AVM_NR	KEY	1	CN
2	RJHAISZ	BANKL	BNKA	BANKL
3	RJHAISZ	BANKS	T005	LAND1	REF	C	CN
4	RJHAISZ	BRAN1	TBRC	BRACO
5	RJHAISZ	CCINS	TVCIN	CCINS	REF	1	CN
6	RJHAISZ	CCNUM	VCNUM	CCNUM	REF	1	CN
7	RJHAISZ	CCTYP	TVCTY	CCTYP	REF	1	CN
8	RJHAISZ	DATE_GEN_RULE_BI	TJHGENBI	DATE_GEN_RULE_BI	REF	1	CN
9	RJHAISZ	FAKSPP	TVFS	FAKSP
10	RJHAISZ	GPNR_RECH	JGTGPNR	GPNR	REF	1	CN
11	RJHAISZ	INSERENT	JJVDB_MK_FK	GPNR	KEY	1	CN
12	RJHAISZ	KALKS	TVKD	KALKS
13	RJHAISZ	KARENZ_ME	T006	MSEHI	KEY	1	CN
14	RJHAISZ	KDGRP	T151	KDGRP	REF	1	CN
15	RJHAISZ	KONDA	T188	KONDA
16	RJHAISZ	KUKARR_K	TJJ95	KUKARR
17	RJHAISZ	KURST	TCURV	KURST	REF	1	CN
18	RJHAISZ	MANDT	T000	MANDT	KEY	1	CN
19	RJHAISZ	PERFK	TFACD	IDENT
20	RJHAISZ	PLTYP	T189	PLTYP	REF	1	CN
21	RJHAISZ	POS_NR	JHAP	POS_NR	KEY	1	CN
22	RJHAISZ	PROVZ	T005S	BLAND
23	RJHAISZ	REGULIERER	JGTGPNR	GPNR	REF	1	CN
24	RJHAISZ	WAERG	TCURC	WAERS		1	CN
25	RJHAISZ	ZLSCH	T042Z	ZLSCH	REF	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in