SAP ABAP Table JJTAM (IS-M/AM: Media Contact Person)

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	TRANSP	Transparent table
Transparent table	JJTAM	Table Relationship Diagram
Short Description	IS-M/AM: Media Contact Person

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	GPNR	☑	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	JGTGPNR
3	PARNR	☑	ISM_CNTCT_PRSN	BU_PARTNER	CHAR	10	0	IS-M: Contact Person	*
4	LOEVM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
5	LOEKZ	☐	LOEKZ_ISP	XFELD	CHAR	1	0	Deletion Indicator for Master Data in Media Sales & Dist.
6	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
7	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
8	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
9	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
10	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
11	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
12	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
13	REF_GPNR	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	JGTGPNR
14	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	TJG43
15	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
16	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
17	ADRND	☐	ISPADRND	JADRNR	CHAR	10	0	IS-M/AM: Address Number for Business Number	JGTSADR
18	ADRNP	☐	ISPADRNP	JADRNR	CHAR	10	0	IS-M/AM: Address number for private address	JGTSADR
19	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	T535N
20	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	T535N
21	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	T535N
22	PARLA	☐	PARLA	SPRAS	LANG	1	0	Partner language	T002
23	PAVIP	☐	PAVIP	PAVIP	CHAR	1	0	VIP Partner	TVIP
24	PARGE	☐	JGESCHL	JGESCHL	CHAR	1	0	IS-M: Gender Key
25	GBDAT	☐	JGEBDAT	DATUM	DATS	8	0	IS-M: Date of Birth of a Business Partner
26	SPNAM	☐	SPNAM	TEXT10	CHAR	10	0	Nickname
27	ISPTELVW	☐	ISPTELVW	ISPTELVW	CHAR	10	0	IS-M: Telephone Area Code
28	ISPTEL	☐	ISPTEL	ISPTEL	CHAR	20	0	IS-M: Telephone Number
29	BUERO	☐	JBUERO	TEXT8	CHAR	8	0	IS-M: Office Number
30	ABTPA	☐	ABTEI_PA	ABTEI	CHAR	12	0	Contact person's department at customer
31	ABTNR	☐	ABTNR_PA	ABTNR	CHAR	4	0	Contact person department	TSAB
32	PAFKT	☐	PAFKT	PAFKT	CHAR	2	0	Contact person function	TPFK
33	PARVO	☐	PARVO	PARVO	CHAR	1	0	Partner's power of attorney	TVPV
34	BRYTH	☐	BRYTH	BRYTH	CHAR	4	0	Call frequency	TVBR
35	AKVER	☐	AKVER	AKVER	CHAR	2	0	Buying habits	TVAV
36	NMAIL	☐	NMAIL	XFELD	CHAR	1	0	Advertising material indicator
37	KONTGRP	☐	KONTGRP	KONTGRP	CHAR	2	0	IS-M: Sales activity group	TJJKGRP
38	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	TJJKAMP
39	TITEL_AMTL	☐	TITEL_AMTL	TITELAMT	CHAR	2	0	IS-M: Official title	TJJAMTL
40	PAPOS	☐	PAPOS	PAPOS	CHAR	2	0	IS-M: Position of Contact Person	TJJPOS
41	POS_FTEXT	☐	POS_FTEXT	TEXT60	CHAR	60	0	IS-M: Freely Definable Text for Position of Contact Person
42	SPERRVM	☐	SPERRVM	SPERRVM	CHAR	1	0	IS-M: Block Flag	TJJSPVM
43	PAVERT1	☐	PAVERT	PAVERT	CHAR	2	0	IS-M: Distribution List for Contact Person	TJJVERT
44	PAVERT2	☐	PAVERT2	PAVERT	CHAR	2	0	IS-M: Distribution List for Contact Person	TJJVERT
45	PAVERT3	☐	PAVERT3	PAVERT	CHAR	2	0	IS-M: Distribution List for Contact Person	TJJVERT
46	PAVERT4	☐	PAVERT4	PAVERT	CHAR	2	0	IS-M: Distribution List for Contact Person	TJJVERT
47	PAVERT5	☐	PAVERT5	PAVERT	CHAR	2	0	IS-M: Distribution List for Contact Person	TJJVERT
48	PAVERT6	☐	PAVERT6	PAVERT	CHAR	2	0	IS-M: Distribution List for Contact Person	TJJVERT
49	PAVERT7	☐	PAVERT7	PAVERT	CHAR	2	0	IS-M: Distribution List for Contact Person	TJJVERT
50	PAVERT8	☐	PAVERT8	PAVERT	CHAR	2	0	IS-M: Distribution List for Contact Person	TJJVERT
51	PAVERT9	☐	PAVERT9	PAVERT	CHAR	2	0	IS-M: Distribution List for Contact Person	TJJVERT
52	PAVERT10	☐	PAVERT10	PAVERT	CHAR	2	0	IS-M: Distribution List for Contact Person	TJJVERT
53	MOAB1	☐	BEMOAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Monday morning from ...
54	MOBI1	☐	BEMOBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Monday morning until ...
55	MOAB2	☐	BEMOAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Monday afternoon from ...
56	MOBI2	☐	BEMOBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Monday afternoon until ...
57	DIAB1	☐	BEDIAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Tuesday morning from...
58	DIBI1	☐	BEDIBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Tuesday morning until ...
59	DIAB2	☐	BEDIAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Tuesday afternoon from..
60	DIBI2	☐	BEDIBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Tuesday afternoon until ...
61	MIAB1	☐	BEMIAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Wednesday morning from...
62	MIBI1	☐	BEMIBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Wednesday morning until ...
63	MIAB2	☐	BEMIAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Wednesday afternoon from ..
64	MIBI2	☐	BEMIBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Wednesday afternoon until..
65	DOAB1	☐	BEDOAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Thursday morning from ....
66	DOBI1	☐	BEDOBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Thursday morning until ....
67	DOAB2	☐	BEDOAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Thursday afternoon from...
68	DOBI2	☐	BEDOBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Thursday afternoon until ..
69	FRAB1	☐	BEFRAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Friday morning from ...
70	FRBI1	☐	BEFRBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Friday morning until ...
71	FRAB2	☐	BEFRAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Friday afternoon from ...
72	FRBI2	☐	BEFRBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Friday afternoon until ...
73	SAAB1	☐	BESAAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Saturday morning from ...
74	SABI1	☐	BESABI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Saturday morning until ...
75	SAAB2	☐	BESAAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Saturday afternoon from ...
76	SABI2	☐	BESABI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Saturday afternoon until ..
77	SOAB1	☐	BESOAB1	UHRZT	TIMS	6	0	Contact person's visiting hours: Sunday morning from ...
78	SOBI1	☐	BESOBI1	UHRZT	TIMS	6	0	Contact person's visiting hours: Sunday morning until ...
79	SOAB2	☐	BESOAB2	UHRZT	TIMS	6	0	Contact person's visiting hours: Sunday afternoon from ...
80	SOBI2	☐	BESOBI2	UHRZT	TIMS	6	0	Contact person's visiting hours: Sunday afternoon until ...
81	PARH1	☐	PAAT1	PARHO	CHAR	2	0	Contact Partner: Attribute 1	TVPH
82	PARH2	☐	PAAT2	PAAT2	CHAR	2	0	Contact person: Attribute 2	TVP2
83	PARH3	☐	PAAT3	PAAT3	CHAR	2	0	Contact person: Attribute 3	TVP3
84	PARH4	☐	PAAT4	PAAT4	CHAR	2	0	Contact person: Attribute 4	TVP4
85	PARH5	☐	PAAT5	PAAT5	CHAR	2	0	Contact person: Attribute 5	TVP5
86	PAKN1	☐	PAAT6	PAAT6	CHAR	3	0	Contact person: Attribute 6	TVP6
87	PAKN2	☐	PAAT7	PAAT7	CHAR	3	0	Contact person: Attribute 7	TVP7
88	PAKN3	☐	PAAT8	PAAT8	CHAR	3	0	Contact person: Attribute 8	TVP8
89	PAKN4	☐	PAAT9	PAAT9	CHAR	3	0	Contact person: Attribute 9	TVP9
90	PAKN5	☐	PAAT0	PAAT0	CHAR	3	0	Contact person: Attribute 10	TVP0
91	NAME1_MACO	☐	NAME1_ISPM	NAME_MACO	CHAR	35	0	IS-M: Business Partner Name (Upper Case for Matchcode)
92	NAME2_MACO	☐	NAME2_ISPM	NAME_MACO	CHAR	35	0	IS-M: Bus.Partner's First Name (Upper Case for Matchcode)
93	.INCLUDE	☐				0	0	IS-M/AM: Structure Used During Media Contact Migration
94	SAPBP_REF	☐	ISM_SAPBP_REF	BU_PARTNER	CHAR	10	0	Reference to SAP BP That Corresponds to the Media Cont.Pers.	BUT000
95	CONV_STATUS	☐	ISM_CONV_STATUS	ISM_CONV_STATUS	NUMC	1	0	IS-M/AM: Status of Media Contact Person Conversion

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JJTAM	ABTNR	TSAB	ABTNR	REF	C	CN
2	JJTAM	ADRND	JGTSADR	ADRNR	REF	1	C
3	JJTAM	ADRNP	JGTSADR	ADRNR	REF	1	C
4	JJTAM	AKVER	TVAV	AKVER	REF	C	CN
5	JJTAM	ANRED	TJG43	JANRED	REF	C	CN
6	JJTAM	BRYTH	TVBR	BRYTH	REF	C	CN
7	JJTAM	GPNR	JGTGPNR	GPNR	KEY	1	CN
8	JJTAM	KAMPAGNE	TJJKAMP	KAMPAGNE	KEY
9	JJTAM	KONTGRP	TJJKGRP	KONTGRP	KEY	1	CN
10	JJTAM	MANDT	T000	MANDT	KEY	1	CN
11	JJTAM	NAMZU	T535N	TITEL
12	JJTAM	PAFKT	TPFK	PAFKT	REF	C	CN
13	JJTAM	PAKN1	TVP6	PAAT6	REF	C	CN
14	JJTAM	PAKN2	TVP7	PAAT7	REF	C	CN
15	JJTAM	PAKN3	TVP8	PAAT8	REF	C	CN
16	JJTAM	PAKN4	TVP9	PAAT9	REF	C	CN
17	JJTAM	PAKN5	TVP0	PAAT0	REF	C	CN
18	JJTAM	PAPOS	TJJPOS	PAPOS	KEY
19	JJTAM	PARH1	TVPH	PARHO	REF	C	CN
20	JJTAM	PARH2	TVP2	PAAT2	REF	C	CN
21	JJTAM	PARH3	TVP3	PAAT3	REF	C	CN
22	JJTAM	PARH4	TVP4	PAAT4	REF	C	CN
23	JJTAM	PARH5	TVP5	PAAT5	REF	C	CN
24	JJTAM	PARLA	T002	SPRAS	REF	C	CN
25	JJTAM	PARVO	TVPV	PARVO	REF	C	CN
26	JJTAM	PAVERT1	TJJVERT	PAVERT	KEY
27	JJTAM	PAVERT10	TJJVERT	PAVERT	KEY
28	JJTAM	PAVERT2	TJJVERT	PAVERT	KEY
29	JJTAM	PAVERT3	TJJVERT	PAVERT	KEY
30	JJTAM	PAVERT4	TJJVERT	PAVERT	KEY
31	JJTAM	PAVERT5	TJJVERT	PAVERT	KEY
32	JJTAM	PAVERT6	TJJVERT	PAVERT	KEY
33	JJTAM	PAVERT7	TJJVERT	PAVERT	KEY
34	JJTAM	PAVERT8	TJJVERT	PAVERT
35	JJTAM	PAVERT9	TJJVERT	PAVERT	KEY
36	JJTAM	PAVIP	TVIP	PAVIP	REF	C	CN
37	JJTAM	REF_GPNR	JGTGPNR	GPNR	REF	C	CN
38	JJTAM	SAPBP_REF	BUT000	PARTNER	REF	1	CN
39	JJTAM	SPERRVM	TJJSPVM	SPERRVM	KEY
40	JJTAM	TITEL	T535N	TITEL
41	JJTAM	TITEL_AMTL	TJJAMTL	TITEL	KEY
42	JJTAM	VORSW	T535N	TITEL

History

Last changed by/on	SAP	20110901
SAP Release Created in