| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVKO | VKORG | Allow NULL? |
| 3 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVTW | VTWEG | Allow NULL? |
| 4 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | No | TSPA | SPART | Allow NULL? |
| 5 | VANR | IS-M: Extra commission/exclusion | nvarchar | 5 | 0 | CHAR | (N' ') | No | | JVANR | Allow NULL? |
| 6 | GUELTIGAB | IS-M: "Valid From" Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATEVALFRM | Allow NULL? |
| 7 | GUELTIGBIS | IS-M: "Valid To" Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATEVALTO | Allow NULL? |
| 8 | XLOESCHVM | Deletion Flag for Master Data in Media Sales & Distribution | char | 1 | 0 | CHAR | (N' ') | Yes | | LOEVM_ISP | Allow NULL? |
| 9 | XLOESCHKZ | Deletion Indicator for Master Data in Media Sales & Dist. | char | 1 | 0 | CHAR | (N' ') | Yes | | LOEKZ_ISP | Allow NULL? |
| 10 | BEDART | IS-M: Requirement Type for Extra Commission Entitlement | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJ73 | JJBEDARTZP | Allow NULL? |
| 11 | BEDGR | IS-M: Media Sales Agent Requirement Group | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJ77 | BEDGR | Allow NULL? |
| 12 | PROSL | IS-M/AM: Commission Key for Media Sales Agent | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | TJH23 | JPROVSCHL | Allow NULL? |
| 13 | KURZTEXT | IS-M: Short Text | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | BEZEICHN15 | Allow NULL? |
| 14 | LANGTEXT | IS-M: Long Text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | BEZEICHN50 | Allow NULL? |
| 15 | ZUOFUNKT | IS-M: Assignment Function (Inclusive, Exclusive) | char | 1 | 0 | CHAR | (N' ') | Yes | | JZFKT | Allow NULL? |
| 16 | BELEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JJTBE | BELEGEINH | Allow NULL? |
| 17 | INHK_TECH2 | IS-M: Special Publication Content Component | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | JJTIKO | INHK_SOVER | Allow NULL? |
| 18 | INHK_KFM | IS-M: Business Content Component | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | JJTIKO | INHK_KFM | Allow NULL? |
| 19 | AVMPOS_ART | IS-M: Order-Publishing-Media - Item Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJH17 | AVMPOS_ART | Allow NULL? |
| 20 | BRAN1 | IS-M: Industry Sector for Advertiser | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TBRC | BRAN_PAM | Allow NULL? |
| 21 | KUKARR | IS-M: Customer Profile | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJ95 | JKUKARR | Allow NULL? |
| 22 | IN_GPNR | IS-M: Advertiser | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JJVDB_MK_FK | INSERENT | Allow NULL? |
| 23 | AR_GPNR | IS-M: Agency | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JGTGPNR | AGENTUR | Allow NULL? |
| 24 | BEZIRK_AG | IS-M: Sales Agent Zone of the Agency | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JVTBEZIRK | VERMBEZ_AG | Allow NULL? |
| 25 | BEZIRK_IS | IS-M: Sales Agent Zone of Advertiser | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JVTBEZIRK | VERMBEZ_IS | Allow NULL? |
| 26 | PRDHA | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | JJT179 | J_PRODH | Allow NULL? |
| 27 | VTNR | IS-M: Contract Number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | JHTVKO | ABS_VTNR | Allow NULL? |
| 28 | MATNR | IS-M: Service material number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | JJTDIEN | MATNR_DIEN | Allow NULL? |
| 29 | DIENTYP | IS-M: Service Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJH71 | DIENTYP | Allow NULL? |
| 30 | FATBB1 | IS-M: Free Attribute 1 Requirement Element | char | 1 | 0 | CHAR | (N' ') | Yes | TJJFA | JJFATBB1 | Allow NULL? |
| 31 | FATBB2 | IS-M: Free Attribute 2 Requirement Element | char | 1 | 0 | CHAR | (N' ') | Yes | TJJFC | JJFATBB2 | Allow NULL? |
| 32 | FATBB3 | IS-M: Free Attribute 3 Requirement Element | char | 1 | 0 | CHAR | (N' ') | Yes | TJJFE | JJFATBB3 | Allow NULL? |
| 33 | FATBB4 | IS-M: Free Attribute 4 Requirement Element | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJFG | JJFATBB4 | Allow NULL? |
| 34 | FATBB5 | IS-M: Free Attribute 5 Requirement Element | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJFI | JJFATBB5 | Allow NULL? |
| 35 | FATBB6 | IS-M: Free Attribute 6 Requirement Element | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJJFK | JJFATBB6 | Allow NULL? |
| 36 | FATBB7 | IS-M: Free Attribute 7 Requirement Element | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TJJFM | JJFATBB7 | Allow NULL? |
| 37 | ERFUSER | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERFUSER | Allow NULL? |
| 38 | ERFDATE | Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERFDATE | Allow NULL? |
| 39 | ERFTIME | Time Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERFTIME | Allow NULL? |
| 40 | AENUSER | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENUSER | Allow NULL? |
| 41 | AENDATE | Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AENDATE | Allow NULL? |
| 42 | AENTIME | Time of Last Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AENTIME | Allow NULL? |
