Table SERREQUEST
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| SERREQUEST | SRE | Service requests | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SRE0 | SRENUM | No | |
| SRE1 | CREDAT | Yes | |
| SRE2 | CREDAT+SRENUM | No | |
| SRE3 | SREBPC | Yes | |
| SRE4 | SRECCN | Yes | |
| SRE5 | SREBPC+SRENUMBPC | Yes | |
| SRE6 | SOLNUM | Yes | |
| SRE7 | SREORI+SREORIVCR+SREORIVCRL | Yes | |
| SRE8 | SRERESDAT+SRERESHOU+SREASS+SRENUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
| CONSPT | Support contract | CON | [CON]CON0=[SRE]CONSPT | Block | ||||
| CONSPTFLG | Support contract flg | C | 1 | |||||
| CONSPTTYP | Contract type | AOB | [AOB]ABREV=[SRE]CONSPTTYP | Block | ||||
| COVAUSCLA | Covered by | A | 30 | |||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREHOU | Creation time | HM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CTIMSPGDAY | Cumul (days) | L | 8 | |||||
| CTIMSPGHOU | Cumul (hours) | L | 8 | |||||
| CTIMSPGMNT | Cumul (minutes) | L | 8 | |||||
| DIE | Dimension type code | DIE | [DIE]DIE0=[SRE]DIE | Block | ANA | |||
| ENTCOD | Stock auto journal | GAU | [GAU]GAU0=[SRE]ENTCOD | Block | ||||
| INVDTA | Invoicing element | SFI | [SFI]SFI0=[SRE]INVDTA | Other | SFI | |||
| INVDTAAMT | % or amt inv el | DCB | 11.4 | SFI | ||||
| INVDTATYP | Value type | M | 6 | 2227 | SFI | |||
| MACFLT | Base filter | MAC | [MAC]MAC0=[SRE]MACFLT | Block | ||||
| MACFLTINT | Customer filter | M | 4 | 1 | ||||
| MANUPD | Modify resolution | M | 4 | 1 | ||||
| NBRMANUPD | No. manual modifs | L | 8 | |||||
| NUMFULDES | Description chrono | CLC | ||||||
| OVRCOV | Global coverage | M | 15 | 3003 | ||||
| OVRCOVREN | Non-coverage reason | C | 4 | |||||
| OVRCOVTYP | Contract type | AOB | [AOB]ABREV=[SRE]OVRCOVTYP | Block | ||||
| REP | Sales rep | A | 5 | |||||
| SALFCY | Site | FCY | [FCY]FCY0=[SRE]SALFCY | Block | ||||
| SFISSTCOD | SST tax code | ADI | [ADI]CODE=203;SFISSTCOD | Block | SFI | |||
| SOLNUM | Solution code | SOL | [SOL]SOL0=[SRE]SOLNUM | Block | ||||
| SREASS | Assignment | M | 15 | 975 | ||||
| SREBPAADD | Address | ADR | ||||||
| SREBPC | Customer | BPR | [BPR]BPR0=[SRE]SREBPC | Block | ||||
| SREBPCGRU | Group customer | BPR | [BPR]BPR0=[SRE]SREBPCGRU | Block | ||||
| SREBPCINV | Bill-to customer | BPR | [BPR]BPR0=[SRE]SREBPCINV | Block | ||||
| SREBPCPYR | Pay-by | BPR | [BPR]BPR0=[SRE]SREBPCPYR | Block | ||||
| SRECCN | Contact (relationship) | AIN | [AIN]AIN0=[SRE]SRECCN | Block | ||||
| SRECHGTYP | Rate type | M | 15 | 202 | ||||
| SRECOV | Covered | M | 4 | 1 | ||||
| SRECOVAUS | Covered by | A | 5 | |||||
| SRECOVAUT | Auto cover | C | 4 | |||||
| SRECOVCTL | To control by | A | 5 | |||||
| SRECOVNUM | Coverage reference | VCR | ||||||
| SRECUR | Currency | CUR | [TCU]TCU0=[SRE]SRECUR | Block | ||||
| SREDATASS | Assignment date | D | ||||||
| SREDEP | Settlement discount | TDA | [TDA]TDA0=SREDEP;[V]GSUPCLE | Block | ||||
| SREDES | Overview | CLX | ||||||
| SREDESFLG | Overview written | C | 2 | |||||
| SREDET | Assignment detail | VCR | ||||||
| SREDOO | Service caller | BPR | [BPR]BPR0=[SRE]SREDOO | Block | ||||
| SREESC | No. of escalations | C | 4 | |||||
| SREESC2 | Historized escalation | C | 4 | |||||
| SREESC3 | Incremental escaln | C | 4 | |||||
| SREGRALEV | Severity level | ADI | [ADI]CODE=428;SREGRALEV | Block | ||||
| SREHOUASS | Time | HM | ||||||
| SREINUMBPC | Customer no. chrono | L | 8 | |||||
| SREINVFLG | Invoicing flag | M | 15 | 3004 | ||||
| SRELOK | Blocking gravity | M | 4 | 1 | ||||
| SREMAC | Base by default | MAC | [MAC]MAC0=[SRE]SREMAC | Block | ||||
| SREMACPBL | Skills base/default | PBL | [PBL]PBL0=[SRE]SREMACPBL | Block | ||||
| SRENUM | Sequence no. | VCR | ||||||
| SRENUMBPC | Customer request | VCR | ||||||
| SREORI | Source | M | 20 | 2982 | ||||
| SREORIVCR | Original document no. | VCR | ||||||
| SREORIVCRL | Source document line | L | 8 | |||||
| SREPBLGRP | Skill | PBL | [PBL]PBL0=[SRE]SREPBLGRP | Block | ||||
| SREPIOLEV | Level of urgency | ADI | [ADI]CODE=405;SREPIOLEV | Block | ||||
| SREPJT | Project | PJT | [PIM]PIM0=[SRE]SREPJT | Block | ||||
| SREPRITYP | Price type | M | 6 | 243 | ||||
| SREPTE | Payment terms | PTE | [TPT]TPT0=SREPTE;[V]GCURLEG;1 | Block | ||||
| SREREP | Sales rep | REP | [REP]REP0=[SRE]SREREP | Block | REC | |||
| SRERESDAT | Desired resolution | D | ||||||
| SRERESHOU | Desired resolution | HM | ||||||
| SRERESREN | Reason | A | 80 | |||||
| SRESAT | Request status | ADI | [ADI]CODE=422;SRESAT | Block | ||||
| SRETIMSPG | Total time spent | C | 4 | |||||
| SRETPL | Request model | VCR | ||||||
| SRETTR | Title | A | 80 | |||||
| SRETYPCOV | Coverage type | M | 25 | 974 | ||||
| SREVACBPR | Tax rule | TVB | [TVB]TVB0=SREVACBPR;[V]GSUPCLE | RTZ | ||||
| SSTENTCOD | Entity/Use | ADI | [ADI]CODE=202;SSTENTCOD | Block | LTA | |||
| STOFCY | Storage site | FCY | [FCY]FCY0=[SRE]STOFCY | Block | ||||
| TIMSPGDAY | Time passed (days) | L | 8 | |||||
| TIMSPGHOU | Time spent (hours) | L | 8 | |||||
| TIMSPGMNT | Time passed (minute) | L | 8 | |||||
| TRSCOD | Movement code | ADI | [ADI]CODE=14;TRSCOD | Block | ||||
| TRSFAM | Transaction group | ADI | [ADI]CODE=9;TRSFAM | Block | ||||
| TSDCOD | Statistical group | ADI | [ADI]CODE=indice+445;TSDCOD(indice) | Block | STR | |||
| TSKREPCRE | Sales rep task created | M | 4 | 1 | ||||
| TYPFULDES | Description type | CLT | ||||||
| TYPMAC | Base type | M | 15 | 2983 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |