|
|
DTW Distribution Rule
API Distribution Rules Service / Distribution Rule
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
OOCR.OcrCode AS 'Factor Code',
OOCR.OcrName AS 'Factor Description',
OOCR.OcrTotal AS 'Total Factor',
OOCR.Direct AS 'Direct',
OOCR.Locked AS 'Locked',
OOCR.DataSource AS 'Data Source',
OOCR.UserSign AS 'User Signature',
OOCR.DimCode AS 'In Which Dimension',
OOCR.AbsEntry AS 'Numerator',
OOCR.Active AS 'Active',
OOCR.logInstanc AS 'Log Instance',
OOCR.UserSign2 AS 'Updating User',
OOCR.updateDate AS 'Date of Update'
FROM OOCR AS OOCR
Related information
Distribution Rule DistributionRule Object· Table: OOCR
Represents a distribution rule for spreading a specific expense, account, journal entry, or other entity among profit centers.
Source table: OOCR
Mandatory properties: FactorCode, TotalFactor
Parent: Distribution Rules Service DistributionRulesService Service· Table: OOCR Distribution Rules Service DistributionRulesService Service· Table: OOCR
The DistributionRulesService service enables you to add, look up and remove distribution rules for spreading a specific expense, account, journal entry, or other entity among profit centers.
To see the list of distribution rules, select...
OOCR SQL Table
Cost Accounting Dimension ODIM SQL Table
Users OUSR SQL Table
DistributionRulesService
Object
DistributionRule
Collection
Method
Property
Active
DB
Direct
DB
FactorCode
DB
TotalFactor
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates