| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DRERZ | Publication | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | PVA | Edition | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | PVAART | Content Category | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | POVERKZ | IS-M: Postal distribution indicator | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | ERSCHWWO | Indicator for Publication Frequency Relative to Week | char | 1 | 0 | | | | Allow NULL? |
| 7 | POTAEULAND | Postal charges for Europe/land (reduced charge packages) | char | 1 | 0 | | | | Allow NULL? |
| 8 | POTAEULUFT | Postal charges for Europe/airmail (reduced charge packages) | char | 1 | 0 | | | | Allow NULL? |
| 9 | POTAWELAND | Postal charges for world/land (reduced charge packages) | char | 1 | 0 | | | | Allow NULL? |
| 10 | POTAWELUFT | Postal charge for airmail/world (for reduced charge package) | char | 1 | 0 | | | | Allow NULL? |
| 11 | BEZEI10 | Short text for edition | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | LBEZEIINT | Internal long text | nvarchar | 50 | 0 | | | | Allow NULL? |
| 13 | LBEZEIEXT | External long text | nvarchar | 50 | 0 | | | | Allow NULL? |
| 14 | PERREGEL | Frequency rule | nvarchar | 5 | 0 | | | | Allow NULL? |
| 15 | FKALENDID | Factory Calendar for Production | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | XNUMPVA | Automatic numbering for individual editions | char | 1 | 0 | | | | Allow NULL? |
| 17 | SFORMATBR | Standard page width | decimal | 9 | 3 | | | | |
| 18 | MEINHBREIT | IS-M: Unit of measure for page width | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | SFORMATHOE | Standard page length | decimal | 9 | 3 | | | | |
| 20 | MEINHHOE | IS-M: Unit of measurement for page length | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | SPAPIERGEW | Standard weight of paper (inside pages) | decimal | 9 | 3 | | | | |
| 22 | MEINHPAGEW | Unit of measure for weight of paper | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | STDBLTTGEW | Standard page weight (inside) | decimal | 9 | 3 | | | | |
| 24 | MEINHSBLGW | Unit of weight for page weight | nvarchar | 3 | 0 | | | | Allow NULL? |
| 25 | SPAGEWMANT | Standard weight of paper for cover | decimal | 9 | 3 | | | | |
| 26 | MEINHPAGEM | Unit of measure for weight of paper | nvarchar | 3 | 0 | | | | Allow NULL? |
| 27 | STDBLGEWMA | Standard page weight (cover) | decimal | 9 | 3 | | | | |
| 28 | MEINHSBGMA | Unit of weight for page weight | nvarchar | 3 | 0 | | | | Allow NULL? |
| 29 | ISPCNROB | ISPC Number of Object | nvarchar | 6 | 0 | | | | Allow NULL? |
| 30 | ISPCNRTO | ISPC Number of Sub-Object | nvarchar | 2 | 0 | | | | Allow NULL? |
| 31 | ISSNNR | ISSN Number of Edition | nvarchar | 9 | 0 | | | | Allow NULL? |
| 32 | VDZVERTRKZ | IS-M: WBZ, VDZ Sales Code (Num. Share Postal Sales Code) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 33 | IVWNR | Circulation Audit Report ID for Edition | nvarchar | 10 | 0 | | | | Allow NULL? |
| 34 | AUFMELDART | Audit Report Type for Edition | nvarchar | 2 | 0 | | | | Allow NULL? |
| 35 | GNGRP | Edition generation grouping | nvarchar | 6 | 0 | | | | Allow NULL? |
| 36 | PVASTAGRP | Statistics grouping for edition | char | 1 | 0 | | | | Allow NULL? |
| 37 | BERGRP1 | Report group 1 - edition | nvarchar | 10 | 0 | | | | Allow NULL? |
| 38 | BERGRP2 | Report group 2 - edition | nvarchar | 10 | 0 | | | | Allow NULL? |
| 39 | BZBKDAU | Availability Period for Edition in Days | nvarchar | 5 | 0 | | | | Allow NULL? |
| 40 | BASJAHR | Base Year for Determining Year Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 41 | MANZBEIL | Guideline: Maximum number of inserts | nvarchar | 3 | 0 | | | | Allow NULL? |
| 42 | VERSVLEVS | Shipping lead time in days for first shipment | decimal | 3 | 0 | | | | |
| 43 | REM_NACHLF | Return Follow-Up Time in Days for Alternative Return Start | decimal | 3 | 0 | | | | |
| 44 | RK_AUFNR | Order Number of RK Order for Account Assignment | nvarchar | 8 | 0 | | | | Allow NULL? |
| 45 | RK_POSNR | Item Number of RK Order for Account Assignment | nvarchar | 2 | 0 | | | | Allow NULL? |
| 46 | CO_AUFNR | Order number of internal CO order for account assignment | nvarchar | 12 | 0 | | | | Allow NULL? |
| 47 | LOEVM | Deletion Flag for Master Data in Media Sales & Distribution | char | 1 | 0 | | | | Allow NULL? |
| 48 | LOEKZ | Deletion Indicator for Master Data in Media Sales & Dist. | char | 1 | 0 | | | | Allow NULL? |
| 49 | KOSTL | Cost Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 50 | KOSTL_R2 | Cost center in R/2 | nvarchar | 8 | 0 | | | | Allow NULL? |
| 51 | ERFUSER | Created By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 52 | ERFDATE | Created On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 53 | ERFTIME | Time Created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 54 | AENUSER | Last Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 55 | AENDATE | Date of Last Change | nvarchar | 8 | 0 | | | | Allow NULL? |
| 56 | AENTIME | Time of Last Change | nvarchar | 6 | 0 | | | | Allow NULL? |
| 57 | KZEIGFRE | External Delivery Order | char | 1 | 0 | | | | Allow NULL? |
| 58 | GPNR | IS-M: Business Partner Publisher | nvarchar | 10 | 0 | | | | Allow NULL? |
| 59 | ISMTMCPRODTYPE | Market Coverage Product Type | char | 1 | 0 | | | | Allow NULL? |
| 60 | BOTENART | IS-M: Courier type for Swiss postal service PTT (CH) | char | 1 | 0 | | | | Allow NULL? |
