|
|
API OSCM
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | RuleID KEY UNIQUE | Rule Identification Number | Int | 6 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| RuleType | Rule Type Number | Int | 6 | 2 | ||||
| ParentID | Parent Rule ID | Int | 6 | OSCM Special Ledger - Analytical Accounting Configuration Rules: Material | ||||
| Status | Rule Status | VarChar | 1 | |||||
| Priority | Rule Priority | Int | 6 | 100 | ||||
| Name | Rule Name | nVarChar | 100 | |||||
| CreateDate | Date of Rule Generation | Date | 8 | |||||
| UpdateDate | Date of Rule Change | Date | 8 | |||||
| UserSign | Rule Created By | Int | 6 | OUSR Users | ||||
| UserSign2 | Rule Changed By | Int | 6 | OUSR Users | ||||
| ExtCond | Extended Special Data | nVarChar | 127 |
Table relationship map
SELECT statement
SELECT
OSCM.RuleID AS 'Rule Identification Number',
OSCM.RuleType AS 'Rule Type Number',
OSCM.ParentID AS 'Parent Rule ID',
OSCM.Status AS 'Rule Status',
OSCM.Priority AS 'Rule Priority',
OSCM.Name AS 'Rule Name',
OSCM.CreateDate AS 'Date of Rule Generation',
OSCM.UpdateDate AS 'Date of Rule Change',
OSCM.UserSign AS 'Rule Created By',
OSCM.UserSign2 AS 'Rule Changed By',
OSCM.ExtCond AS 'Extended Special Data'
FROM OSCM AS OSCM
Related information
Special Ledger - Analytical Accounting Configuration Rules: Material OSCM 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