| 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 | PACKAGE_ID | Package | nvarchar | 10 | 0 | CHAR | (N' ') | No | JJTPC | ISM_PACKAGE_ID | Allow NULL? |
| 3 | PK_ELEMENT_ID | Package Element ID | nvarchar | 3 | 0 | NUMC | (N'000') | No | JJTPCE | ISM_PK_ELEMENT_ID | Allow NULL? |
| 4 | PSTYV | IS-M: Item Category for Sales Document | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJHAP | PSTYV_PAM | Allow NULL? |
| 5 | BOOKING_UNIT | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JJVBE_AZ | BELEGEINH | Allow NULL? |
| 6 | CONT_COMP_LEV1 | IS-M: Level 1 content component in the hierarchy | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | INHK_LEV1 | Allow NULL? |
| 7 | BUS_CONT_COMP | IS-M: Business Content Component | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | JJTIKO | INHK_KFM | Allow NULL? |
| 8 | TECH_COMP_LEV1 | IS-M: Level 1 content component in the hierarchy | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | INHK_LEV1 | Allow NULL? |
| 9 | TECH_CONT_COMP | IS-M: Technical Content Component (Positioning View) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | JJTIKO | INHK_TECH1 | Allow NULL? |
| 10 | SPEC_CONT_COMP | IS-M: Special Publication Content Component | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | JJTIKO | INHK_SOVER | Allow NULL? |
| 11 | AD_DESIGN_TYPE | IS-M: Design Ad Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJJ19 | AZART_GEST | Allow NULL? |
| 12 | AD_FIXED_FORMAT | IS-M/AM: Fixed Format Proposal /Ad Dimensions | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJJ13 | AZART_AREA | Allow NULL? |
| 13 | AD_COLOR_SCHEME | IS-M: Color Scheme Ad Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJJ11 | AZART_FARB | Allow NULL? |
| 14 | AD_SHAPE | IS-M: Shape Ad Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJJ17 | AZART_FORM | Allow NULL? |
| 15 | POS_INSTRUCTION | IS-M/AM: Positioning Instruction | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJ65 | PLAZIERANW | Allow NULL? |
| 16 | POS_AD_TYPE | IS-M: Ad Type with Regard to General Positioning | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJJ15 | AZART_PLAZ | Allow NULL? |
| 17 | AD_SPEC_HANDLING | IS-M: Ad Type - Special Handling Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJ49 | AZART_SOND | Allow NULL? |
| 18 | DATE_SPEC | IS-M/AM: Specify Dates for Date Combinations | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TJJ71 | TERMINSPEZ | Allow NULL? |
| 19 | DATE_CATEGORY | IS-M/AM: Date Category Copy Number/Publication Date | char | 1 | 0 | CHAR | (N' ') | Yes | TJH55 | TERMINTYP | Allow NULL? |
| 20 | PUBL_FREQUENCY | IS-M: Frequency for Ad Publication | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJJ57 | ANZ_ZYKLUS | Allow NULL? |
| 21 | WEB_PUBLICATION | IS-M/AM: Indicator - Booking Unit for Internet Publication | char | 1 | 0 | CHAR | (N' ') | Yes | | ISM_WEBPUBL_BU | Allow NULL? |
| 22 | MONDAY | IS-M: Date Field Indicator - Monday | char | 1 | 0 | CHAR | (N' ') | Yes | | JHT_MONTAG | Allow NULL? |
| 23 | TUESDAY | IS-M: Date Field Indicator - Tuesday | char | 1 | 0 | CHAR | (N' ') | Yes | | JHT_DIENSTAG | Allow NULL? |
| 24 | WEDNESDAY | IS-M: Date Field Indicator - Wednesday | char | 1 | 0 | CHAR | (N' ') | Yes | | JHT_MITTWOCH | Allow NULL? |
| 25 | THURSDAY | IS-M: Date Field Indicator - Thursday | char | 1 | 0 | CHAR | (N' ') | Yes | | JHT_DONNERST | Allow NULL? |
| 26 | FRIDAY | IS-M: Date Field Indicator - Friday | char | 1 | 0 | CHAR | (N' ') | Yes | | JHT_FREITAG | Allow NULL? |
| 27 | SATURDAY | IS-M: Date Field Indicator - Saturday | char | 1 | 0 | CHAR | (N' ') | Yes | | JHT_SAMSTAG | Allow NULL? |
| 28 | SUNDAY | IS-M: Date Field Indicator - Sunday | char | 1 | 0 | CHAR | (N' ') | Yes | | JHT_SONNTAG | Allow NULL? |
| 29 | PLAN_HEIGHT | IS-M: Planned Height of the Ad Spec | decimal | 7 | 3 | QUAN | ((0)) | Yes | | HOEHE_S | |
| 30 | HEIGHT_UOM | IS-M: Unit of Measure for Height | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | TJH61 | ISPEINH_H | Allow NULL? |
| 31 | PLAN_WIDTH | IS-M: Planned Ad Spec Width | decimal | 7 | 3 | QUAN | ((0)) | Yes | | BREITE_S | |
| 32 | WIDTH_UOM | IS-M/AM: Unit of Measure for Width | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | TJH57 | BREITE_SEH | Allow NULL? |
| 33 | NUM_OF_PUBL | IS-M: Number of Placements | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ISM_NUM_OF_PUBL | Allow NULL? |
| 34 | PUBL_DURATION | IS-M: Publication Duration | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ISM_PUBL_DURATION | Allow NULL? |
