|
|
API AOCR
AOCR - Distribution Rule Table
Cost Accounting Dimension ODIM SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | OcrCode KEY UNIQUE | Factor Code | nVarChar | 8 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| OcrName | Factor Description | nVarChar | 30 | |||||
| OcrTotal | Total Factor | Num | 20 | |||||
| Direct | Direct | VarChar | Y) Yes N) No | 1 | N | |||
| Locked | Locked | VarChar | Y) Yes N) No | 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 | ||||
| DimCode | In Which Dimension | Int | 6 | ODIM Cost Accounting Dimension | 1 | |||
| AbsEntry | Numerator | Int | 11 | |||||
| Active | Active | VarChar | Y) Yes N) No | 1 | Y | |||
| logInstanc | Log Instance | Int | 11 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| updateDate | Date of Update | Date | 8 |
Table relationship map
SELECT statement
SELECT
AOCR.OcrCode AS 'Factor Code',
AOCR.OcrName AS 'Factor Description',
AOCR.OcrTotal AS 'Total Factor',
AOCR.Direct AS 'Direct',
AOCR.Locked AS 'Locked',
AOCR.DataSource AS 'Data Source',
AOCR.UserSign AS 'User Signature',
AOCR.DimCode AS 'In Which Dimension',
AOCR.AbsEntry AS 'Numerator',
AOCR.Active AS 'Active',
AOCR.logInstanc AS 'Log Instance',
AOCR.UserSign2 AS 'Updating User',
AOCR.updateDate AS 'Date of Update'
FROM AOCR AS AOCR
Related information
Cost Accounting Dimension ODIM 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
