| 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 | * | MANDT | Allow NULL? |
| 2 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | VKORG | Allow NULL? |
| 3 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | VTWEG | Allow NULL? |
| 4 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | SPART | Allow NULL? |
| 5 | ANWBER | Application Area | nvarchar | 10 | 0 | CHAR | (N' ') | No | | /BEV1/TSABER___D | Allow NULL? |
| 6 | KUNNR | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | KUNNR | Allow NULL? |
| 7 | SPNRD | Maintenance Number for Columns/Dynamic Part/Statistics Area | nvarchar | 3 | 0 | NUMC | (N'000') | No | | /BEV1/TSSPNRD | Allow NULL? |
| 8 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ERDAT | Allow NULL? |
| 9 | ERZET | Entry time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERZET | Allow NULL? |
| 10 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 11 | FACCALID | Factory Calendar | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | WFCID | Allow NULL? |
| 12 | FELDNAME | Column Reference Field in Main Statistics Table TS | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | /BEV1/TSSRFELD | Allow NULL? |
| 13 | VBELN | Sales and Distribution Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | VBELN | Allow NULL? |
| 14 | VBTYP | SD document category | char | 1 | 0 | CHAR | (N' ') | No | | VBTYP | Allow NULL? |
| 15 | STYP | Column Type Statistics Telephone Sales | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/TSSSTYP | Allow NULL? |
| 16 | SPBREITE | Default Column Width in Statistics Column Telephone Sales | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | /BEV1/TSSSPBR | Allow NULL? |
| 17 | SPUEB | Heading | nvarchar | 55 | 0 | CHAR | (N' ') | Yes | | REPTEXT | Allow NULL? |
| 18 | F2ANZ | Routine for F2 Action in Mode 'Display statistics TS' | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | /BEV1/TSSF2ANZ | Allow NULL? |
| 19 | F2UEB | Routing for F2 Action in Mode 'Data Transfer Statistics TS' | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | /BEV1/TSSF2UEB | Allow NULL? |
| 20 | DUEBSPERL | Data Transfer Allowed on Column Level | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/TSDUESPER | Allow NULL? |
| 21 | DUEBEZERL | Data Transfer Allowed on an Individual Entry Level | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/TSDUEEZER | Allow NULL? |
| 22 | DUEBSPNMA | Data Transfer Columns Only Material Number | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/TSDUESPNM | Allow NULL? |
