| 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 | BELEGEINHO | IS-M/AM: Higher-Level Booking Unit | nvarchar | 10 | 0 | CHAR | (N' ') | No | JJTBE | BELEGEINHO | Allow NULL? |
| 3 | TERMINSPEZ | IS-M/AM: Specify Dates for Date Combinations | nvarchar | 6 | 0 | CHAR | (N' ') | No | TJJ71 | TERMINSPEZ | Allow NULL? |
| 4 | BELEGEINHU | IS-M/AM: Lower-Level Booking Unit | nvarchar | 10 | 0 | CHAR | (N' ') | No | JJTBE | BELEGEINHU | Allow NULL? |
| 5 | NR_ZAEHLER | IS-M: Counter to distinguish entries with the same number | nvarchar | 2 | 0 | NUMC | (N'00') | No | | NR_ZAEHLER | Allow NULL? |
| 6 | BEO_OPTION | IS-M: Options for Range Table | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ISP_OPTION | Allow NULL? |
| 7 | BEO_SIGN | IS-M: SIGN Parameters of a Range Table | char | 1 | 0 | CHAR | (N' ') | Yes | | ISP_SESIGN | Allow NULL? |
| 8 | BEU_OPTION | IS-M: Options for Range Table | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ISP_OPTION | Allow NULL? |
| 9 | BEU_SIGN | IS-M: SIGN Parameters of a Range Table | char | 1 | 0 | CHAR | (N' ') | Yes | | ISP_SESIGN | Allow NULL? |
| 10 | XREFERENZ | IS-M: Reference entry for relative specifications | char | 1 | 0 | CHAR | (N' ') | Yes | | XREFERENZ | Allow NULL? |
| 11 | BE_ANTEIL | IS-M: Share of Sales Volume of Lower-Level BU (in Percent) | decimal | 5 | 2 | DEC | ((0)) | Yes | | BE_ANTEIL | |
| 12 | TAG_IN_PER | IS-M: Date Specification: Day in Period | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | TAG_IN_WO | Allow NULL? |
| 13 | WO_IN_PER | IS-M/AM: Date Spec.: Week Relative to "Reference Date" | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | WO_IN_PER | Allow NULL? |
| 14 | MO_IN_PER | IS-M: Date-specific month relative to "reference date" | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | MO_IN_PER | Allow NULL? |
| 15 | KOMBI_VATY | IS-M: Date Specification: Issue Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJD05 | KOMBI_VATY | Allow NULL? |
| 16 | X_EQWEEK | IS-M: Same Week As Reference Entry Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | X_EQWEEK | Allow NULL? |
| 17 | XEQ_MONTH | IS-M: Same month as reference entry indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | XEQ_MONTH | Allow NULL? |
| 18 | KOMBI_DAT | IS-M: Date specification - Time combination: Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | KOMBI_DAT | Allow NULL? |
| 19 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | char | 1 | 0 | CHAR | (N' ') | Yes | | LOEVM_ISP | Allow NULL? |
| 20 | XLOEKZ | Deletion Indicator for Master Data in Media Sales & Dist. | char | 1 | 0 | CHAR | (N' ') | Yes | | LOEKZ_ISP | Allow NULL? |
| 21 | ERFUSER | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERFUSER | Allow NULL? |
| 22 | ERFDATE | Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERFDATE | Allow NULL? |
| 23 | ERFTIME | Time Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERFTIME | Allow NULL? |
| 24 | AENUSER | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENUSER | Allow NULL? |
| 25 | AENDATE | Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AENDATE | Allow NULL? |
| 26 | AENTIME | Time of Last Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AENTIME | Allow NULL? |
