SAP ABAP Table JJTVB (IS-M/AM: Requirement in Media Sales Agent Contract)

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	JJTVB	Table Relationship Diagram
Short Description	IS-M/AM: Requirement in Media Sales Agent Contract

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	VNR	☑	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	JJTVV
3	BEDNR	☑	VM_BEDNR	VM_BEDNR	NUMC	6	0	IS-M: Number of Media Sales Agent Contract Requirement
4	.INCLUDE	☐				0	0	IS-PAM: Media agent contract requirement (data part)
5	GUELTIGAB	☐	DATEVALFRM	DATUM	DATS	8	0	IS-M: "Valid From" Date
6	GUELTIGBIS	☐	DATEVALTO	DATUM	DATS	8	0	IS-M: "Valid To" Date
7	BEDART	☐	VMBEDART	JVMBEDART	CHAR	2	0	IS-M/AM: Requirement Type in Media Sales Agent Contract	TJJ73
8	BEDGR	☐	BEDGR	BEDGR	CHAR	2	0	IS-M: Media Sales Agent Requirement Group	TJJ77
9	XSTDBED	☐	JSTDBED	XFELD	CHAR	1	0	IS-M: Standard Requirement
10	PROSL	☐	JPROVSCHL	PRSCHL	CHAR	5	0	IS-M/AM: Commission Key for Media Sales Agent	TJH23
11	XPROV	☐	XJPROVI	XFELD	CHAR	1	0	IS-M: Qualifies for Commission Indicator
12	XBONUS	☐	XBONUS1	XFELD	CHAR	1	0	IS-M: Indicator: Qualifies for Bonus 1
13	XBONUS2	☐	XBONUS2	XFELD	CHAR	1	0	IS-M: Indicates: Qualifies for Bonus 2
14	XSTEIG	☐	XJSTEIG	XFELD	CHAR	1	0	IS-M: Can be Incremented Indicator
15	XBERICHT	☐	XBESBERICH	ISM_XBESBERICH	CHAR	1	0	IS-M/AM: Report Required, Reference to Partner (Role)
16	XVORAUS	☐	XJVORAUS	XFELD	CHAR	1	0	IS-M: Payment Granted in Advance
17	JVERMART	☐	JVERMART	JVERMART	CHAR	2	0	IS-M: Media Sales Agent Type: General/City/Special Agent	TJJ09
18	XLOEVM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
19	XLOEKZ	☐	LOEKZ_ISP	XFELD	CHAR	1	0	Deletion Indicator for Master Data in Media Sales & Dist.
20	VOR_VNR	☐	VOR_VNR	JVMVVNR	CHAR	10	0	IS-M: Sales Agnt Contract: Contract No.of Preliminary Req.	JJTVV
21	VOR_BEDNR	☐	VOR_BEDNR	VM_BEDNR	NUMC	6	0	Sales Agent Contract: Number of the Preliminary Requirement	JJTVB
22	XNOGVZ	☐	XNOGVZ	XFELD	CHAR	1	0	IS-M: Do Not Create Sales Agent Assignment Indicator
23	.INCLUDE	☐				0	0	IS-M: Short and Long Texts
24	KURZTEXT	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
25	LANGTEXT	☐	BEZEICHN50	TEXT50	CHAR	50	0	IS-M: Long Text
26	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
27	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
28	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
29	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
30	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
31	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
32	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
33	LAST_BESNR	☐	JBESTNR_EX	JBESTNR_EX	NUMC	6	0	IS-M: Element Number in Media Agent Contract

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JJTVB	BEDART	TJJ73	BEDART	REF	1	CN
2	JJTVB	BEDGR	TJJ77	BEDGR	REF	1	CN
3	JJTVB	JVERMART	TJJ09	JVERMART	REF	1	CN
4	JJTVB	MANDT	T000	MANDT	KEY	1	CN
5	JJTVB	PROSL	TJH23	PRSCHL
6	JJTVB	VNR	JJTVV	VNR	KEY	1	CN
7	JJTVB	VOR_BEDNR	JJTVB	BEDNR	REF	C	CN
8	JJTVB	VOR_VNR	JJTVV	VNR	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in