|
|
API AIT6
AIT6 - Asset Item Distribution Rules Table
Items OITM SQL Table
Object Settings - History ADP1 SQL Table
Distribution Rule OOCR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ItemCode KEY UNIQUE | Item No. | nVarChar | 20 | OITM Items | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Line Number | nVarChar | 11 | |||||
| ValidFrom | Valid From | Date | 8 | |||||
| ValidTo | Valid To | Date | 8 | |||||
| OcrCode | Distribution Rule | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode2 | Costing Code 2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode3 | Costing Code 3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode4 | Costing Code 4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode5 | Costing Code 5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object | nVarChar | 20 | ADP1 Object Settings - History | 4 |
Table relationship map
SELECT statement
SELECT
AIT6.ItemCode AS 'Item No.',
AIT6.LineNum AS 'Line Number',
AIT6.ValidFrom AS 'Valid From',
AIT6.ValidTo AS 'Valid To',
AIT6.OcrCode AS 'Distribution Rule',
AIT6.OcrCode2 AS 'Costing Code 2',
AIT6.OcrCode3 AS 'Costing Code 3',
AIT6.OcrCode4 AS 'Costing Code 4',
AIT6.OcrCode5 AS 'Costing Code 5',
AIT6.LogInstanc AS 'Log Instance',
AIT6.ObjType AS 'Object'
FROM AIT6 AS AIT6
Related information
Items OITM SQL Table
Object Settings - History ADP1 SQL Table
Distribution Rule OOCR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
