SAP ABAP Table ISMAM_TXW_JHAISZ (DART IS-M/AM: Assignment Table: Advertisers for 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	ISMAM_TXW_JHAISZ	Table Relationship Diagram
Short Description	DART IS-M/AM: Assignment Table: Advertisers for 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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	AVM_NR	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
3	POS_NR	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
4	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JJVDB_MK_FK
5	XINSBLANK	☐	XINSBLANK	XFELD	CHAR	1	0	IS-M: Agency Order Without Advertiser Indicator
6	INSZ_NR	☐	INSZ_NR	NUMC4	NUMC	4	0	IS-M: Advertiser assignment number
7	INS_PROZ	☐	ISMAM_TXW_PAM_PROZ	CHAR15	CHAR	15	0	IS-M: Percentage Figure for Cost Distribution
8	AZGR_INS	☐	AZGR_INS	NUMC4	NUMC	4	0	Column MM of the Ad Which the Advertiser is Involved In
9	ALTINSGPNR	☐	ALTINSGPNR	CHAR15	CHAR	15	0	IS-M: Alternative Customer Number for Advertiser
10	REGULIERER	☐	REGULIERER	GPNR	CHAR	10	0	IS-M: Payer	JGTGPNR
11	TAXK1	☐	TAXK1	TAXKD	CHAR	1	0	Tax classification 1 for customer	*
12	TAXK2	☐	TAXK2	TAXKD	CHAR	1	0	Tax classification 2 for customer	*
13	TAXK3	☐	TAXK3	TAXKD	CHAR	1	0	Tax classification 3 for customer	*
14	TAXK4	☐	TAXK4	TAXKD	CHAR	1	0	Tax classification 4 for customer	*
15	TAXK5	☐	TAXK5	TAXKD	CHAR	1	0	Tax classification 5 for customer	*
16	TAXK6	☐	TAXK6	TAXKD	CHAR	1	0	Tax classification 6 for customer	*
17	TAXK7	☐	TAXK7	TAXKD	CHAR	1	0	Tax classification 7 for customer	*
18	TAXK8	☐	TAXK8	TAXKD	CHAR	1	0	Tax classification 8 for customer	*
19	TAXK9	☐	TAXK9	TAXKD	CHAR	1	0	Tax classification 9 for customer	*
20	GPNR_RECH	☐	GPNR_RECH	GPNR	CHAR	10	0	IS-M: Business Partner - Bill-To Party	JGTGPNR
21	RECH_ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
22	RECH_ADVAR	☐	ADRESSVAR	ERSTADR	CHAR	1	0	IS-M: Address Variant
23	RECH_ADHER	☐	HERK	HERK	CHAR	1	0	IS-M: Use of Address
24	WAERG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
25	FAKSPP	☐	PAM_FAKSP	FAKSP	CHAR	2	0	IS-M: Billing Block	TVFS
26	XSEPFKKOPF	☐	XSEPFKKOPF	XFELD	CHAR	1	0	Separate billing document for sales order
27	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
28	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
29	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
30	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
31	FAKDATUM	☐	JHFKTER	DATUM	DATS	8	0	IS-M: Planned Billing/Settlement Date
32	VORAUSKNZ	☐	VORAUSKNZ	XFELD	CHAR	1	0	IS-M: Indicates Whether Advance Billing Required
33	VORAUSRCH	☐	VORAUSRCH	XFELD	CHAR	1	0	IS-M: "Advance billing required" indicator
34	XRECHN	☐	XRECHN	XFELD	CHAR	1	0	IS-M: Invoice Requested Indicator
35	XKFMAEND	☐	XKFMAEND	XFELD	CHAR	1	0	IS-M: Business Data was Changed Manually Indicator
36	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
37	XORTSPREIS	☐	XORTSPREIS	XFELD	CHAR	1	0	IS-M/AM: Local Customer Indicator
38	KALKS	☐	KALKS	KALKS	CHAR	1	0	Pricing procedure assigned to this customer	TVKD
39	KUKARR_K	☐	JKUKARR	JKUKARR	CHAR	2	0	IS-M: Customer Profile	TJJ95
40	KARENZ	☐	JKARENZ	JKARENZ	NUMC	4	0	IS-M: Grace Period for Price Changes
41	KARENZ_ME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
42	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
43	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
44	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
45	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	T042Z
46	AE	☐	AGEN_AE	AGEN_AE	CHAR	1	0	IS-M: Agency Commission Entitlement
47	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
48	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys	BNKA
49	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
50	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
51	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
52	XEINZUG	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
53	XSPERR_BON	☐	XSPERR_BON	XFELD	CHAR	1	0	IS-M: "Blocked for reasons of creditworthiness" indicator
54	VKBUR_ZUST	☐	VKBURZUS	VKBUR	CHAR	4	0	Sales office responsible	*
55	CCINS	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	TVCIN
56	CCNUM	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	VCNUM
57	DATBI	☐	DATBI_CC	DATUM	DATS	8	0	Payment Cards: Valid To
58	CCNAME	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
59	CVVAL	☐	ISM_CVVAL	ISM_CVVAL	CHAR	6	0	Card Verification Value
60	CVVCT	☐	ISM_CVVCT	ISM_CVVCT	CHAR	1	0	Control Field for Card Verification Value
61	CVVST	☐	ISM_CVVST	ISM_CVVST	CHAR	1	0	Usage Status of Card Verification Value
62	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
63	BRAN1	☐	BRAN_PAM	BRACO	CHAR	10	0	IS-M: Industry Sector for Advertiser	*
64	ADV_AD_SIZE	☐	ISMAM_TXW_ADV_AD_SIZE	CHAR15	CHAR	15	0	Quantity
65	ENCTP	☐	CCSECA_ENCTYPE	CCSECA_ENCTYPE	CHAR	1	0	Type of Encryption
66	.INCLUDE	☐				0	0

Foreign Keys

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

History

Last changed by/on	SAP	20131127
SAP Release Created in	471