|
|
SQL Others / Resource Groups
API ORSB
ORSB - Resource Groups Table
ORSB SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ResGrpCod KEY UNIQUE | Number | Int | 6 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ResGrpNam KEY UNIQUE | Group Name | nVarChar | 20 | GROUP_NAME | Yes | |||
| Locked | Locked | VarChar | N) Changeable Y) Locked | 1 | N | |||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| Object | Object Type - History | nVarChar | 20 | 292 | ||||
| logInstanc | Log Instance - History | Int | 11 | |||||
| createDate | Creation Date - History | Date | 8 | |||||
| userSign2 | Updating User - History | Int | 6 | |||||
| updateDate | Date of Update - History | Date | 8 | |||||
| ResType | Resource Type | VarChar | M) Machine L) Labor O) Other | 1 | M | |||
| CostName1 | Resource Std Cost 1 | nVarChar | 127 | |||||
| CostVal1 | Resource Std Cost 1 | Num | 20 | |||||
| CostName2 | Resource Std Cost 2 | nVarChar | 127 | |||||
| CostVal2 | Resource Std Cost 2 | Num | 20 | |||||
| CostName3 | Resource Std Cost 3 | nVarChar | 127 | |||||
| CostVal3 | Resource Std Cost 3 | Num | 20 | |||||
| CostName4 | Resource Std Cost 4 | nVarChar | 127 | |||||
| CostVal4 | Resource Std Cost 4 | Num | 20 | |||||
| CostName5 | Resource Std Cost 5 | nVarChar | 127 | |||||
| CostVal5 | Resource Std Cost 5 | Num | 20 | |||||
| CostName6 | Resource Std Cost 2 | nVarChar | 127 | |||||
| CostVal6 | Resource Std Cost 6 | Num | 20 | |||||
| CostName7 | Resource Std Cost 7 | nVarChar | 127 | |||||
| CostVal7 | Resource Std Cost 7 | Num | 20 | |||||
| CostName8 | Resource Std Cost 8 | nVarChar | 127 | |||||
| CostVal8 | Resource Std Cost 8 | Num | 20 | |||||
| CostName9 | Resource Std Cost 9 | nVarChar | 127 | |||||
| CostVal9 | Resource Std Cost 9 | Num | 20 | |||||
| CostName10 | Resource Std Cost 10 | nVarChar | 127 | |||||
| CostVal10 | Resource Std Cost 10 | Num | 20 | |||||
| ResUoM | Resource Unit of Measurement | nVarChar | 20 |
Table relationship map
SELECT statement
SELECT
ORSB.ResGrpCod AS 'Number',
ORSB.ResGrpNam AS 'Group Name',
ORSB.Locked AS 'Locked',
ORSB.DataSource AS 'Data Source',
ORSB.UserSign AS 'User Signature',
ORSB.Object AS 'Object Type - History',
ORSB.logInstanc AS 'Log Instance - History',
ORSB.createDate AS 'Creation Date - History',
ORSB.userSign2 AS 'Updating User - History',
ORSB.updateDate AS 'Date of Update - History',
ORSB.ResType AS 'Resource Type',
ORSB.CostName1 AS 'Resource Std Cost 1',
ORSB.CostVal1 AS 'Resource Std Cost 1',
ORSB.CostName2 AS 'Resource Std Cost 2',
ORSB.CostVal2 AS 'Resource Std Cost 2',
ORSB.CostName3 AS 'Resource Std Cost 3',
ORSB.CostVal3 AS 'Resource Std Cost 3',
ORSB.CostName4 AS 'Resource Std Cost 4',
ORSB.CostVal4 AS 'Resource Std Cost 4',
ORSB.CostName5 AS 'Resource Std Cost 5',
ORSB.CostVal5 AS 'Resource Std Cost 5',
ORSB.CostName6 AS 'Resource Std Cost 2',
ORSB.CostVal6 AS 'Resource Std Cost 6',
ORSB.CostName7 AS 'Resource Std Cost 7',
ORSB.CostVal7 AS 'Resource Std Cost 7',
ORSB.CostName8 AS 'Resource Std Cost 8',
ORSB.CostVal8 AS 'Resource Std Cost 8',
ORSB.CostName9 AS 'Resource Std Cost 9',
ORSB.CostVal9 AS 'Resource Std Cost 9',
ORSB.CostName10 AS 'Resource Std Cost 10',
ORSB.CostVal10 AS 'Resource Std Cost 10',
ORSB.ResUoM AS 'Resource Unit of Measurement'
FROM ORSB AS ORSB
Related information
ORSB SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
