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

History

Last changed by/on	SAP	20110901
SAP Release Created in	464