User Tools
Add this page to your book 
Remove this page from your book 
Manage book (
Help Table of Contents
SPR - System Pending Release
Module SPR
Datafields
| Name | Helptext Description | Data Type | Len | Codetable |
|---|---|---|---|---|
| INR | Internal Unique ID | Text | 8 | |
| SPTINR | INR of the Associated SPT | Text | 8 | |
| OBJTYP | Object Type | Text | 6 | |
| OBJINR | Object INR | Text | 8 | |
| CREDAT | Date Created | Date | 12 | |
| CRETIM | Time of Creation | Numeric | 6 | |
| CREUSR | Creating User ID | Text | 8 | |
| CRESSNINR | INR of Creating Session | Text | 8 | |
| RELLEV | Release Level | Text | 1 | |
| RELDAT | Date of Release | Date | 12 | |
| RELTIM | Time of Release | Numeric | 6 | |
| RELUSR | Releasing User ID | Text | 8 | |
| RELSSNINR | INR of Releasing Session | Text | 8 | |
| RELSTA | Release Status | Text | 1 | Embedded |
| PUPSTA | Processing Status | Text | 1 | Embedded |
Datafield Description and Properties
Datafield INR Internal Unique ID
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter of this table. The field INR is used to enable links from other tables to this table.
For contractdata the INR also links the two tables xxD and xxT as associated entries hold the same INR.
Datafield SPTINR INR of the Associated SPT
Unique ID of the pending transaction entry holding the relevant pending PUR or PUP.
Datafield OBJTYP Object Type
Type of object the pending entry refers to. Usually this is the table the object is associated to.
Datafield OBJINR Object INR
Unique ID of the object within the table, defined in the Object Type field.
Datafield CREDAT Date Created
This date field identifies the date the entry was physically added to the database.
Datafield CRETIM Time of Creation
This field defines the time when this pending transaction was initially created. The date field holds the corresponding date.
Datafield CREUSR Creating User ID
This identifies the user who created this entry.
Datafield CRESSNINR INR of Creating Session
This field holds the ID of the session that created the pending transaction.
Datafield RELLEV Release Level
This field contains the results of running the globally accessible routine GetSprRelLev, that controls the 4-eye principle in the application.
Datafield RELDAT Date of Release
This date defines the date when this pending transaction was released (or sent to correction/deletion). The time field holds the corresponding time.
Datafield RELTIM Time of Release
This field defines the time when this pending transaction was released (or sent to correction/deletion). The date field holds the corresponding date.
Datafield RELUSR Releasing User ID
The field identifies the user who released this entry (or sent it to correction/deletion).
Datafield RELSSNINR INR of Releasing Session
This field holds the unique ID of the session that released (or sent to correction/deletion) this pending transaction.
Datafield RELSTA Release Status
Codetable
| Code | Text |
|---|---|
| Waiting | |
| R | Released |
| C | Sent to Correction |
| D | Sent to Deletion |
Datafield PUPSTA Processing Status
Any non-empty content indicates that this masterfile modification has been processed and is no longer pending.
Codetable
| Code | Text |
|---|---|
| Waiting | |
| P | Finally Processed |
| E | Update Canceled |
| N | Not Released |
