|
|
SQL Others / Resource Capacity Log
API ORCJ
ORCJ - Resource Capacity Log Table
Resources ORSC SQL Table
Warehouses OWHS SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Id KEY UNIQUE | Primary Key | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ResCode KEY | Internal Resource ID | nVarChar | 20 | ORSC Resources | RWDT | No | ||
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS Warehouses | ||||
| CapDate | Capacity Date | Date | 8 | |||||
| CapType | Type of Capacity Entry | VarChar | I) Internal O) Ordered C) Committed U) Consumed | 1 | ||||
| Capacity | Capacity | Num | 20 | |||||
| SrcObjType | Source Object Type | Int | 202) Production Order 60) Issue for Production 59) Receipt from Production | 11 | ||||
| SrcAbsEnt | Source Absolute Entry | Int | 11 | |||||
| SrcLine | Source Line Number | Int | 11 | |||||
| BaseObjTyp KEY | Base Object Type | Int | 202) Production Order | 11 | BASE_DOC | No | ||
| BaseAbsEnt | Base Absolute Entry | Int | 11 | |||||
| BaseLine | Base Line Number | Int | 11 | |||||
| ActionType | Action Type | Int | 1) Production Order - Create 2) Production Order - Close 3) Production Order - Reschedule 4) Production Order - Add Line 5) Production Order - Delete Line 6) Production Order - Update Line 7) Issue for Production - Create 8) Receipt from Production - Create | 6 | ||||
| OwnObjTyp KEY | Owning Doc. Object Type | Int | 202) Production Order 60) Issue for Production 59) Receipt from Production | 11 | OWNING_DOC | No | ||
| OwnAbsEnt | Owning Doc. Absolute Entry | Int | 11 | |||||
| OwnLine | Owning Doc. Line Number | Int | 11 | |||||
| RevdObjTyp | Reverted Object Type | Int | 60) Issue for Production | 11 | ||||
| RevdAbsEnt | Reverted Absolute Entry | Int | 11 | |||||
| RevdLine | Reverted Line Number | Int | 11 | |||||
| MemoSrc | Memo Source | VarChar | C) Resource Capacity Form S) Set Daily Internal Capacities Form | 1 | ||||
| Memo | Memo | Text | 16 |
Table relationship map
SELECT statement
SELECT
ORCJ.Id AS 'Primary Key',
ORCJ.ResCode AS 'Internal Resource ID',
ORCJ.WhsCode AS 'Warehouse Code',
ORCJ.CapDate AS 'Capacity Date',
ORCJ.CapType AS 'Type of Capacity Entry',
ORCJ.Capacity AS 'Capacity',
ORCJ.SrcObjType AS 'Source Object Type',
ORCJ.SrcAbsEnt AS 'Source Absolute Entry',
ORCJ.SrcLine AS 'Source Line Number',
ORCJ.BaseObjTyp AS 'Base Object Type',
ORCJ.BaseAbsEnt AS 'Base Absolute Entry',
ORCJ.BaseLine AS 'Base Line Number',
ORCJ.ActionType AS 'Action Type',
ORCJ.OwnObjTyp AS 'Owning Doc. Object Type',
ORCJ.OwnAbsEnt AS 'Owning Doc. Absolute Entry',
ORCJ.OwnLine AS 'Owning Doc. Line Number',
ORCJ.RevdObjTyp AS 'Reverted Object Type',
ORCJ.RevdAbsEnt AS 'Reverted Absolute Entry',
ORCJ.RevdLine AS 'Reverted Line Number',
ORCJ.MemoSrc AS 'Memo Source',
ORCJ.Memo AS 'Memo'
FROM ORCJ AS ORCJ
Related information
Resources ORSC SQL Table
Warehouses OWHS SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
