SAP ABAP Table JDTVAUSGB (IS-M/SD: Issues)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JDTVAUSGB	Table Relationship Diagram
Short Description	IS-M/SD: Issues

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	VAUSGB	☑	VAUSGB	VAUSGB	CHAR	10	0	Issue
3	DRERZ	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
4	PVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
5	ERSCHDAT	☐	ERSCHDAT	DATUM	DATS	8	0	Publication Date
6	ERSTVERDAT	☐	ERSTVERDAT	DATUM	DATS	8	0	IS-M: First Shipping Date
7	EPERDATUM	☐	EPERDATUM	DATUM	DATS	8	0	IS-M: Starting Date of Individual Period
8	JAHRGANG	☐	JAHRGANG	JAHRGANG	NUMC	4	0	Year number of issue
9	NRIMJAHR	☐	NRIMJAHR	JNRIMJAHR	CHAR	4	0	Issue number (in year)
10	HEFTNUMMER	☐	HEFTNUM_VA	HEFTNUMMER	CHAR	9	0	Copy Number of Issue
11	EANVA	☐	JEANVA	EAN11	CHAR	18	0	European Article Number of issue
12	VAVARTYPPL	☐	VAVARTYPPL	VAVARTYP	CHAR	2	0	Standard issue variant type (planned)	TJD05
13	VAVARTYPTA	☐	VAVARTYPTA	VAVARTYP	CHAR	2	0	Actual issue variant type	TJD05
14	ANZSEITEN	☐	ANZSEITEN	NUM8	NUMC	8	0	Number of Pages in Issue
15	GESAMTAUFL	☐	GESAMTAUFL	NUM8	NUMC	8	0	Total Circulation Produced (Issue)
16	BISBEZDAT	☐	BISBEZDAT	DATUM	DATS	8	0	Issue Availability Bar
17	MAXBEILAGE	☐	MAXBEILAGE	ANZBEILAGE	NUMC	3	0	Guideline: Maximum number of inserts
18	ANZVORDR	☐	ANZVORDR	ANZVORDRCK	NUMC	3	0	Number of Forms
19	XEDATKORR	☐	XEDATKORR	XFELD	CHAR	1	0	Indicator: Publication Date Corrected Automatically
20	XVAVTYKORR	☐	XVAVTYKORR	XFELD	CHAR	1	0	Issue type corrected automatically
21	XSONDAUSG	☐	XSONDAUSG	XFELD	CHAR	1	0	Special issue
22	XINDIVANG	☐	XINDIVANG	XFELD	CHAR	1	0	Contains individual specifications (for postal settlement)
23	XVERGRIFF	☐	XVERGRIFF	XFELD	CHAR	1	0	Issue sold out
24	XOHNEIVW	☐	XOHNEIVW	XFELD	CHAR	1	0	Exclusion from audit report
25	XGENMASCH	☐	XGENMASCH	XFELD	CHAR	1	0	Indicator: Object generated automatically
26	XPLZUS	☐	JXPLZUS_VA	XFELD	CHAR	1	0	Issue combination from production unit as planned
27	FORMATBR	☐	FORMATBR	ISPMNG9	QUAN	9	3	Page Width
28	MEINHBREIT	☐	MEINHBREIT	MEINS	UNIT	3	0	IS-M: Unit of measure for page width	T006
29	FORMATHOE	☐	FORMATHOE	ISPMNG9	QUAN	9	3	Page Length
30	MEINHHOE	☐	MEINHHOE	MEINS	UNIT	3	0	IS-M: Unit of measurement for page length	T006
31	VAGEWICHT	☐	VAGEWICHT	ISPMNG9	QUAN	9	3	Calculated Issue Weight
32	MEINHGEW	☐	MEINHVAGEW	MEINS	UNIT	3	0	Unit of weight for issue (calculated weight)	T006
33	VAGEWPLAN	☐	VAGEWPLAN	ISPMNG9	QUAN	9	3	Planned Issue Weight
34	MEINHGEWP	☐	MEINHVAGEP	MEINS	UNIT	3	0	Unit of weight for planned issue weight	T006
35	XPGMANUELL	☐	XPGMANUELL	XFELD	CHAR	1	0	Indicator: Planned Weight was Changed Manually
36	VAGEWIST	☐	VAGEWIST	ISPMNG9	QUAN	9	3	Actual Issue Weight
37	MEINHGEWI	☐	MEINHVAGEI	MEINS	UNIT	3	0	Unit of weight for actual issue weight	T006
38	STAERKE	☐	VASTAERKE	ISPMNG9	QUAN	9	3	Thickness of Issue (Usually mm/100 Units)
39	MEINHSTRK	☐	MEINHSTRK	MEINS	UNIT	3	0	Unit of measurement for thickness	T006
40	PAPIERGEW	☐	PAPIERGEW	PAPIERGEW	QUAN	9	3	Weight of Paper
41	MEINHPAGEW	☐	MEINHPAGEW	MEINS	UNIT	3	0	Unit of measure for weight of paper	T006
42	PAGEWMANTL	☐	PAGEWMANTL	PAPIERGEW	QUAN	9	3	Weight of Paper for Common Part (Actual)
43	MEINHPAGMT	☐	MEINHPAGEW	MEINS	UNIT	3	0	Unit of measure for weight of paper	T006
44	BLATTGEW	☐	BLATTGEW	ISPMNG9	QUAN	9	3	Leaf Weight
45	MEINHBLGEW	☐	MEINHBLGEW	MEINS	UNIT	3	0	Unit of weight for page weight	T006
46	BLATTGWMA	☐	BLATTGWMA	ISPMNG9	QUAN	9	3	Leaf Weight of Common Part
47	MEINHBGWMA	☐	MEINHBLGEW	MEINS	UNIT	3	0	Unit of weight for page weight	T006
48	XMUSTERL	☐	XMUSTERL	XFELD	CHAR	1	0	Indicator: Pass on sample to Production (ad pre-print)
49	MUSTERLDAT	☐	MUSTERLDAT	DATUM	DATS	8	0	Date sample passed on to Production (ad pre-print)
50	RK_AUFNR	☐	J_RK_AUFNR	J_RK_AUFNR	CHAR	8	0	Order Number of RK Order for Account Assignment
51	RK_POSNR	☐	J_RK_POSNR	J_RK_POSNR	NUMC	2	0	Item Number of RK Order for Account Assignment
52	CO_AUFNR	☐	J_CO_AUFNR	AUFNR	CHAR	12	0	Order number of internal CO order for account assignment	AUFK
53	LOEVM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
54	LOEKZ	☐	LOEKZ_ISP	XFELD	CHAR	1	0	Deletion Indicator for Master Data in Media Sales & Dist.
55	.INCLUDE	☐				0	0	Created-by data (maximum version)
56	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
57	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
58	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
59	ERFPROG	☐	ERFPROG	PROGRAMM	CHAR	40	0	Program Used to Create Object	*
60	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
61	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
62	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
63	AENPROG	☐	AENPROG	PROGRAMM	CHAR	40	0	Program that Made Last Change	*
64	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
65	XANZSEITAE	☐	XANZSEITAE	XFELD	CHAR	1	0	Number of pages in issue changed after shipping function
66	NRZUSATZ	☐	NRIMJAHR2	JNRIMJAHR	CHAR	4	0	Issue number affix for double issues
67	JGZUSATZ	☐	JAHRGANG2	JAHRGANG	NUMC	4	0	Year number affix of issue for double issues
68	XHRKNFTPAM	☐	XHRKNFTPAM	XFELD	CHAR	1	0	IS-M: Ad pre-print origin indicator
69	REMIBEGINN	☐	REMIBEGINN	DATUM	DATS	8	0	Alternative Start of Returns: Earliest Return Date
70	.INCLU--AP	☐				0	0	IS-M/AM: Create/Change/Display Ad Insert
71	SI_NUMMER	☐	ISM_SI_NUMMER	SI_NUMMER	CHAR	10	0	IS-M: Ad Insert Number
72	SI_BEARB	☐	SINSBEARB	SIBEAR_ART	CHAR	2	0	IS-M: Ad Insert Processing Type	TJH03
73	SI_TYP	☐	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	TJH29
74	SI_INSERNT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JJVDB_MK_FK
75	SI_STICHW	☐	STICHW	TEXT40	CHAR	40	0	IS-M: Keyword
76	SI_ENTSPFL	☐	ISM_SI_ENTSPFL	XFELD	CHAR	1	0	IS-M: Waste Disposal Required Indicator
77	SI_VERBWER	☐	ISM_SI_VERBWER	XFELD	CHAR	1	0	IS-M: Tie-In Ads Indicator
78	SI_KENNZIF	☐	PAM_KENNZI	PAM_KENNZI	CHAR	10	0	IS-M: Identification Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JDTVAUSGB	CO_AUFNR	AUFK	AUFNR
2	JDTVAUSGB	DRERZ	JDTDRER	DRERZ	KEY	1	CN
3	JDTVAUSGB	MANDT	T000	MANDT	KEY	1	CN
4	JDTVAUSGB	MEINHBGWMA	T006	MSEHI	REF	C	CN
5	JDTVAUSGB	MEINHBLGEW	T006	MSEHI	REF	C	CN
6	JDTVAUSGB	MEINHBREIT	T006	MSEHI	REF	C	CN
7	JDTVAUSGB	MEINHGEW	T006	MSEHI	REF	C	CN
8	JDTVAUSGB	MEINHGEWI	T006	MSEHI	REF	C	CN
9	JDTVAUSGB	MEINHGEWP	T006	MSEHI	REF	C	CN
10	JDTVAUSGB	MEINHHOE	T006	MSEHI	REF	C	CN
11	JDTVAUSGB	MEINHPAGEW	T006	MSEHI	REF	C	CN
12	JDTVAUSGB	MEINHPAGMT	T006	MSEHI	REF	C	CN
13	JDTVAUSGB	MEINHSTRK	T006	MSEHI	REF	C	CN
14	JDTVAUSGB	PVA	JDTPVA	PVA	REF	1	CN
15	JDTVAUSGB	SI_BEARB	TJH03	BEARB		1	CN
16	JDTVAUSGB	SI_INSERNT	JJVDB_MK_FK	GPNR	REF	1	CN
17	JDTVAUSGB	SI_TYP	TJH29	SI_TYP		1	CN
18	JDTVAUSGB	VAVARTYPPL	TJD05	VAVARTYP	REF	1	CN
19	JDTVAUSGB	VAVARTYPTA	TJD05	VAVARTYP	REF	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in