SAP Table JDTVAUSGB
IS-M/SD: Issues
JDTVAUSGB (IS-M/SD: Issues) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link JDTVAUSGB to other SAP tables.
JDTVAUSGB table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| VAUSGB | Issue | VAUSGB | CHAR | 10 | 0 | |||||||
| DRERZ | Publication | DRERZ | JDTDRER | CHAR | 8 | 0 | ||||||
| PVA | Edition | PVA | JDTPVA | CHAR | 8 | 0 | ||||||
| ERSCHDAT | Publication Date | ERSCHDAT | DATS | 8 | 0 | |||||||
| ERSTVERDAT | IS-M: First Shipping Date | ERSTVERDAT | DATS | 8 | 0 | |||||||
| EPERDATUM | IS-M: Starting Date of Individual Period | EPERDATUM | DATS | 8 | 0 | |||||||
| JAHRGANG | Year number of issue | JAHRGANG | NUMC | 4 | 0 | |||||||
| NRIMJAHR | Issue number (in year) | NRIMJAHR | CHAR | 4 | 0 | |||||||
| HEFTNUMMER | Copy Number of Issue | HEFTNUM_VA | CHAR | 9 | 0 | |||||||
| EANVA | European Article Number of issue | JEANVA | CHAR | 18 | 0 | |||||||
| VAVARTYPPL | Standard issue variant type (planned) | VAVARTYPPL | TJD05 | CHAR | 2 | 0 | ||||||
| VAVARTYPTA | Actual issue variant type | VAVARTYPTA | TJD05 | CHAR | 2 | 0 | ||||||
| ANZSEITEN | Number of Pages in Issue | ANZSEITEN | NUMC | 8 | 0 | |||||||
| GESAMTAUFL | Total Circulation Produced (Issue) | GESAMTAUFL | NUMC | 8 | 0 | |||||||
| BISBEZDAT | Issue Availability Bar | BISBEZDAT | DATS | 8 | 0 | |||||||
| MAXBEILAGE | Guideline: Maximum number of inserts | MAXBEILAGE | NUMC | 3 | 0 | |||||||
| ANZVORDR | Number of Forms | ANZVORDR | NUMC | 3 | 0 | |||||||
| XEDATKORR | Indicator: Publication Date Corrected Automatically | XEDATKORR | CHAR | 1 | 0 |
Possible values
|
||||||
| XVAVTYKORR | Issue type corrected automatically | XVAVTYKORR | CHAR | 1 | 0 |
Possible values
|
||||||
| XSONDAUSG | Special issue | XSONDAUSG | CHAR | 1 | 0 |
Possible values
|
||||||
| XINDIVANG | Contains individual specifications (for postal settlement) | XINDIVANG | CHAR | 1 | 0 |
Possible values
|
||||||
| XVERGRIFF | Issue sold out | XVERGRIFF | CHAR | 1 | 0 |
Possible values
|
||||||
| XOHNEIVW | Exclusion from audit report | XOHNEIVW | CHAR | 1 | 0 |
Possible values
|
||||||
| XGENMASCH | Indicator: Object generated automatically | XGENMASCH | CHAR | 1 | 0 |
Possible values
|
||||||
| XPLZUS | Issue combination from production unit as planned | JXPLZUS_VA | CHAR | 1 | 0 |
Possible values
|
||||||
| FORMATBR | Page Width | FORMATBR | QUAN | 9 | 3 | |||||||
| MEINHBREIT | IS-M: Unit of measure for page width | MEINHBREIT | T006 | UNIT | 3 | 0 | ||||||
| FORMATHOE | Page Length | FORMATHOE | QUAN | 9 | 3 | |||||||
| MEINHHOE | IS-M: Unit of measurement for page length | MEINHHOE | T006 | UNIT | 3 | 0 | ||||||
| VAGEWICHT | Calculated Issue Weight | VAGEWICHT | QUAN | 9 | 3 | |||||||
| MEINHGEW | Unit of weight for issue (calculated weight) | MEINHVAGEW | T006 | UNIT | 3 | 0 | ||||||
| VAGEWPLAN | Planned Issue Weight | VAGEWPLAN | QUAN | 9 | 3 | |||||||
| MEINHGEWP | Unit of weight for planned issue weight | MEINHVAGEP | T006 | UNIT | 3 | 0 | ||||||
| XPGMANUELL | Indicator: Planned Weight was Changed Manually | XPGMANUELL | CHAR | 1 | 0 |
Possible values
|
||||||
| VAGEWIST | Actual Issue Weight | VAGEWIST | QUAN | 9 | 3 | |||||||
| MEINHGEWI | Unit of weight for actual issue weight | MEINHVAGEI | T006 | UNIT | 3 | 0 | ||||||
| STAERKE | Thickness of Issue (Usually mm/100 Units) | VASTAERKE | QUAN | 9 | 3 | |||||||
| MEINHSTRK | Unit of measurement for thickness | MEINHSTRK | T006 | UNIT | 3 | 0 | ||||||
| PAPIERGEW | Weight of Paper | PAPIERGEW | QUAN | 9 | 3 | |||||||
| MEINHPAGEW | Unit of measure for weight of paper | MEINHPAGEW | T006 | UNIT | 3 | 0 | ||||||
| PAGEWMANTL | Weight of Paper for Common Part (Actual) | PAGEWMANTL | QUAN | 9 | 3 | |||||||
| MEINHPAGMT | Unit of measure for weight of paper | MEINHPAGEW | T006 | UNIT | 3 | 0 | ||||||
| BLATTGEW | Leaf Weight | BLATTGEW | QUAN | 9 | 3 | |||||||
| MEINHBLGEW | Unit of weight for page weight | MEINHBLGEW | T006 | UNIT | 3 | 0 | ||||||
| BLATTGWMA | Leaf Weight of Common Part | BLATTGWMA | QUAN | 9 | 3 | |||||||
| MEINHBGWMA | Unit of weight for page weight | MEINHBLGEW | T006 | UNIT | 3 | 0 | ||||||
| XMUSTERL | Indicator: Pass on sample to Production (ad pre-print) | XMUSTERL | CHAR | 1 | 0 |
Possible values
|
||||||
| MUSTERLDAT | Date sample passed on to Production (ad pre-print) | MUSTERLDAT | DATS | 8 | 0 | |||||||
| RK_AUFNR | Order Number of RK Order for Account Assignment | J_RK_AUFNR | CHAR | 8 | 0 | |||||||
| RK_POSNR | Item Number of RK Order for Account Assignment | J_RK_POSNR | NUMC | 2 | 0 | |||||||
| CO_AUFNR | Order number of internal CO order for account assignment | J_CO_AUFNR | AUFK | CHAR | 12 | 0 | ||||||
| LOEVM | Deletion Flag for Master Data in Media Sales & Distribution | LOEVM_ISP | CHAR | 1 | 0 |
Possible values
|
||||||
| LOEKZ | Deletion Indicator for Master Data in Media Sales & Dist. | LOEKZ_ISP | CHAR | 1 | 0 |
Possible values
|
||||||
| ERFUSER | Created By | ERFUSER | CHAR | 12 | 0 | |||||||
| ERFDATE | Created On | ERFDATE | DATS | 8 | 0 | |||||||
| ERFTIME | Time Created | ERFTIME | TIMS | 6 | 0 | |||||||
| ERFPROG | Program Used to Create Object | ERFPROG | CHAR | 40 | 0 | |||||||
| AENUSER | Last Changed By | AENUSER | CHAR | 12 | 0 | |||||||
| AENDATE | Date of Last Change | AENDATE | DATS | 8 | 0 | |||||||
| AENTIME | Time of Last Change | AENTIME | TIMS | 6 | 0 | |||||||
| AENPROG | Program that Made Last Change | AENPROG | CHAR | 40 | 0 | |||||||
| MATNR | Material Number | MATNR | CHAR | 18 | 0 | |||||||
| XANZSEITAE | Number of pages in issue changed after shipping function | XANZSEITAE | CHAR | 1 | 0 |
Possible values
|
||||||
| NRZUSATZ | Issue number affix for double issues | NRIMJAHR2 | CHAR | 4 | 0 | |||||||
| JGZUSATZ | Year number affix of issue for double issues | JAHRGANG2 | NUMC | 4 | 0 | |||||||
| XHRKNFTPAM | IS-M: Ad pre-print origin indicator | XHRKNFTPAM | CHAR | 1 | 0 |
Possible values
|
||||||
| REMIBEGINN | Alternative Start of Returns: Earliest Return Date | REMIBEGINN | DATS | 8 | 0 | |||||||
| SI_NUMMER | IS-M: Ad Insert Number | ISM_SI_NUMMER | CHAR | 10 | 0 | |||||||
| SI_BEARB | IS-M: Ad Insert Processing Type | SINSBEARB | TJH03 | CHAR | 2 | 0 | ||||||
| SI_TYP | IS-M: Ad Insert Type | SITYP | TJH29 | CHAR | 2 | 0 | ||||||
| SI_INSERNT | IS-M: Advertiser | INSERENT | JJVDB_MK_FK | CHAR | 10 | 0 | ||||||
| SI_STICHW | IS-M: Keyword | STICHW | CHAR | 40 | 0 | |||||||
| SI_ENTSPFL | IS-M: Waste Disposal Required Indicator | ISM_SI_ENTSPFL | CHAR | 1 | 0 |
Possible values
|
||||||
| SI_VERBWER | IS-M: Tie-In Ads Indicator | ISM_SI_VERBWER | CHAR | 1 | 0 |
Possible values
|
||||||
| SI_KENNZIF | IS-M: Identification Number | PAM_KENNZI | CHAR | 10 | 0 | |||||||
JDTVAUSGB foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| JDTVAUSGB | CO_AUFNR | JDTVAUSGB | MANDT | AUFK | Order master data | MANDT |
| JDTVAUSGB | CO_AUFNR | JDTVAUSGB | CO_AUFNR | AUFK | Order master data | AUFNR |
| JDTVAUSGB | DRERZ | JDTVAUSGB | MANDT | JDTDRER | IS-M/SD: Publications | MANDT |
| JDTVAUSGB | DRERZ | JDTVAUSGB | DRERZ | JDTDRER | IS-M/SD: Publications | DRERZ |
| JDTVAUSGB | MANDT | JDTVAUSGB | MANDT | T000 | Clients | MANDT |
| JDTVAUSGB | MEINHBGWMA | JDTVAUSGB | MEINHBGWMA | T006 | Units of Measurement | MSEHI |
| JDTVAUSGB | MEINHBGWMA | JDTVAUSGB | MANDT | T006 | Units of Measurement | MANDT |
| JDTVAUSGB | MEINHBLGEW | JDTVAUSGB | MANDT | T006 | Units of Measurement | MANDT |
| JDTVAUSGB | MEINHBLGEW | JDTVAUSGB | MEINHBLGEW | T006 | Units of Measurement | MSEHI |
| JDTVAUSGB | MEINHBREIT | JDTVAUSGB | MANDT | T006 | Units of Measurement | MANDT |
| JDTVAUSGB | MEINHBREIT | JDTVAUSGB | MEINHBREIT | T006 | Units of Measurement | MSEHI |
| JDTVAUSGB | MEINHGEW | JDTVAUSGB | MANDT | T006 | Units of Measurement | MANDT |
| JDTVAUSGB | MEINHGEW | JDTVAUSGB | MEINHGEW | T006 | Units of Measurement | MSEHI |
| JDTVAUSGB | MEINHGEWI | JDTVAUSGB | MANDT | T006 | Units of Measurement | MANDT |
| JDTVAUSGB | MEINHGEWI | JDTVAUSGB | MEINHGEWI | T006 | Units of Measurement | MSEHI |
| JDTVAUSGB | MEINHGEWP | JDTVAUSGB | MANDT | T006 | Units of Measurement | MANDT |
| JDTVAUSGB | MEINHGEWP | JDTVAUSGB | MEINHGEWP | T006 | Units of Measurement | MSEHI |
| JDTVAUSGB | MEINHHOE | JDTVAUSGB | MANDT | T006 | Units of Measurement | MANDT |
| JDTVAUSGB | MEINHHOE | JDTVAUSGB | MEINHHOE | T006 | Units of Measurement | MSEHI |
| JDTVAUSGB | MEINHPAGEW | JDTVAUSGB | MANDT | T006 | Units of Measurement | MANDT |
| JDTVAUSGB | MEINHPAGEW | JDTVAUSGB | MEINHPAGEW | T006 | Units of Measurement | MSEHI |
| JDTVAUSGB | MEINHPAGMT | JDTVAUSGB | MEINHPAGMT | T006 | Units of Measurement | MSEHI |
| JDTVAUSGB | MEINHPAGMT | JDTVAUSGB | MANDT | T006 | Units of Measurement | MANDT |
| JDTVAUSGB | MEINHSTRK | JDTVAUSGB | MANDT | T006 | Units of Measurement | MANDT |
| JDTVAUSGB | MEINHSTRK | JDTVAUSGB | MEINHSTRK | T006 | Units of Measurement | MSEHI |
| JDTVAUSGB | PVA | JDTVAUSGB | PVA | JDTPVA | IS-M/SD: Editions | PVA |
| JDTVAUSGB | PVA | JDTVAUSGB | MANDT | JDTPVA | IS-M/SD: Editions | MANDT |
| JDTVAUSGB | PVA | JDTVAUSGB | DRERZ | JDTPVA | IS-M/SD: Editions | DRERZ |
| JDTVAUSGB | SI_BEARB | JDTVAUSGB | MANDT | TJH03 | IS-M/AM: Ad Insert Processing Types | MANDT |
| JDTVAUSGB | SI_BEARB | JDTVAUSGB | SI_BEARB | TJH03 | IS-M/AM: Ad Insert Processing Types | BEARB |
| JDTVAUSGB | SI_INSERNT | JDTVAUSG | MANDT | JJVDB_MK_FK | Generierte Tabelle zu einem View | MANDT |
| JDTVAUSGB | SI_INSERNT | JDTVAUSGB | SI_INSERNT | JJVDB_MK_FK | Generierte Tabelle zu einem View | GPNR |
| JDTVAUSGB | SI_TYP | JDTVAUSGB | MANDT | TJH29 | IS-M/AM: Ad Insert Type | MANDT |
| JDTVAUSGB | SI_TYP | JDTVAUSGB | SI_TYP | TJH29 | IS-M/AM: Ad Insert Type | SI_TYP |
| JDTVAUSGB | VAVARTYPPL | JDTVAUSGB | MANDT | TJD05 | IS-M/SD: Issue Variant Types | MANDT |
| JDTVAUSGB | VAVARTYPPL | JDTVAUSGB | VAVARTYPPL | TJD05 | IS-M/SD: Issue Variant Types | VAVARTYP |
| JDTVAUSGB | VAVARTYPTA | JDTVAUSGB | MANDT | TJD05 | IS-M/SD: Issue Variant Types | MANDT |
| JDTVAUSGB | VAVARTYPTA | JDTVAUSGB | VAVARTYPTA | TJD05 | IS-M/SD: Issue Variant Types | VAVARTYP |
