SAP ABAP Table JSBW_C_P_MAM_ATTR (IS-M/AM: Contact Person for M/AM BW)

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	JSBW_C_P_MAM_ATTR	Table Relationship Diagram
Short Description	IS-M/AM: Contact Person for M/AM BW

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	PARNR	☐	ISM_CNTCT_PRSN	BU_PARTNER	CHAR	10	0	IS-M: Contact Person	*
2	GPNR	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*
3	ADRND	☐	ISPADRND	JADRNR	CHAR	10	0	IS-M/AM: Address Number for Business Number	*
4	ADRNP	☐	ISPADRNP	JADRNR	CHAR	10	0	IS-M/AM: Address number for private address	*
5	LOEVM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
6	LOEKZ	☐	LOEKZ_ISP	XFELD	CHAR	1	0	Deletion Indicator for Master Data in Media Sales & Dist.
7	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
8	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
9	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
10	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
11	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
12	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
13	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
14	REF_GPNR	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*
15	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	*
16	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	*
17	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	*
18	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	*
19	PARLA	☐	PARLA	SPRAS	LANG	1	0	Partner language	*
20	PAVIP	☐	PAVIP	PAVIP	CHAR	1	0	VIP Partner	*
21	PARGE	☐	JGESCHL	JGESCHL	CHAR	1	0	IS-M: Gender Key
22	GBDAT	☐	JGEBDAT	DATUM	DATS	8	0	IS-M: Date of Birth of a Business Partner
23	SPNAM	☐	SPNAM	TEXT10	CHAR	10	0	Nickname
24	ISPTELVW	☐	ISPTELVW	ISPTELVW	CHAR	10	0	IS-M: Telephone Area Code
25	ISPTEL	☐	ISPTEL	ISPTEL	CHAR	20	0	IS-M: Telephone Number
26	BUERO	☐	JBUERO	TEXT8	CHAR	8	0	IS-M: Office Number
27	ABTPA	☐	ABTEI_PA	ABTEI	CHAR	12	0	Contact person's department at customer
28	ABTNR	☐	ABTNR_PA	ABTNR	CHAR	4	0	Contact person department	*
29	PAFKT	☐	PAFKT	PAFKT	CHAR	2	0	Contact person function	*
30	PARVO	☐	PARVO	PARVO	CHAR	1	0	Partner's power of attorney	*
31	BRYTH	☐	BRYTH	BRYTH	CHAR	4	0	Call frequency	*
32	AKVER	☐	AKVER	AKVER	CHAR	2	0	Buying habits	*
33	NMAIL	☐	NMAIL	XFELD	CHAR	1	0	Advertising material indicator
34	KONTGRP	☐	KONTGRP	KONTGRP	CHAR	2	0	IS-M: Sales activity group	*
35	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	*
36	TITEL_AMTL	☐	TITEL_AMTL	TITELAMT	CHAR	2	0	IS-M: Official title	*
37	PAPOS	☐	PAPOS	PAPOS	CHAR	2	0	IS-M: Position of Contact Person	*
38	POS_FTEXT	☐	POS_FTEXT	TEXT60	CHAR	60	0	IS-M: Freely Definable Text for Position of Contact Person
39	SPERRVM	☐	SPERRVM	SPERRVM	CHAR	1	0	IS-M: Block Flag	*
40	NAME1_MACO	☐	NAME1_ISPM	NAME_MACO	CHAR	35	0	IS-M: Business Partner Name (Upper Case for Matchcode)
41	NAME2_MACO	☐	NAME2_ISPM	NAME_MACO	CHAR	35	0	IS-M: Bus.Partner's First Name (Upper Case for Matchcode)
42	NAME1_D	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
43	HAUSN_D	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
44	STRAS_D	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
45	ORT01_D	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
46	PSTLZ_D	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
47	HERK_D	☐	HERK	HERK	CHAR	1	0	IS-M: Use of Address
48	NAME2_D	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
49	POSTEINORT_D	☐	ALORT2	ALORT	CHAR	8	0	IS-M: Postal Unit of City for PO Box	*
50	LOCCO_D	☐	LOCCO	LOCCO	CHAR	10	0	City Coordinates
51	NIELS_D	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	*
52	COUNC_D	☐	COUNC	COUNC	CHAR	3	0	County Code	*
53	CITYC_D	☐	CITYC	CITYC	CHAR	4	0	City Code	*
54	RPMKR_D	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
55	SORTL_D	☐	SORTL	CHAR10	CHAR	10	0	Sort field
56	SORT2_D	☐	SORT2	SORT2	CHAR	2	0	Sort indicator 02
57	REGIO_D	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
58	TELFP_D	☐	TELFP	TEXT16	CHAR	16	0	IS-M: Home Phone Number
59	TELFD_D	☐	TELFD	TEXT16	CHAR	16	0	IS-M: Telephone Number at Work
60	TXJCD_D	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
61	LAND1_D	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
62	STREET2_D	☐	STREET2_ISM	TEXT35	CHAR	35	0	IS-M: Second street line
63	PSTLZ_ADDON_D	☐	PSTLZ_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code
64	NAME3_D	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
65	NAME4_D	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
66	ORT02_D	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
67	NAME1_P	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
68	HAUSN_P	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
69	STRAS_P	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
70	ORT01_P	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
71	PSTLZ_P	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
72	HERK_P	☐	HERK	HERK	CHAR	1	0	IS-M: Use of Address
73	NAME2_P	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
74	POSTEINORT_P	☐	ALORT2	ALORT	CHAR	8	0	IS-M: Postal Unit of City for PO Box	*
75	LOCCO_P	☐	LOCCO	LOCCO	CHAR	10	0	City Coordinates
76	NIELS_P	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	*
77	COUNC_P	☐	COUNC	COUNC	CHAR	3	0	County Code	*
78	CITYC_P	☐	CITYC	CITYC	CHAR	4	0	City Code	*
79	RPMKR_P	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
80	SORTL_P	☐	SORTL	CHAR10	CHAR	10	0	Sort field
81	SORT2_P	☐	SORT2	SORT2	CHAR	2	0	Sort indicator 02
82	REGIO_P	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
83	TELFP_P	☐	TELFP	TEXT16	CHAR	16	0	IS-M: Home Phone Number
84	TELFD_P	☐	TELFD	TEXT16	CHAR	16	0	IS-M: Telephone Number at Work
85	TXJCD_P	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
86	LAND1_P	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
87	STREET2_P	☐	STREET2_ISM	TEXT35	CHAR	35	0	IS-M: Second street line
88	PSTLZ_ADDON_P	☐	PSTLZ_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code
89	NAME3_P	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
90	NAME4_P	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
91	ORT02_P	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District

History

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