|
|
DTW Inventory / Item Master Data / Asset Item Projects
API Items / Items Projects
ITM5 - Asset Item Projects Table
Items Projects ItemsProjects Object· Table: ITM5
Parent: Items Items Object· Table: OITM
Items OITM SQL Table
Object Settings - History ADP1 SQL Table
Project Codes OPRJ 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 | Int | 11 | |||||
| ValidFrom | Valid From | Date | 8 | |||||
| ValidTo | Valid To | Date | 8 | |||||
| Project | Project | nVarChar | 20 | OPRJ Project Codes | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object | nVarChar | 20 | ADP1 Object Settings - History | 4 |
Table relationship map
SELECT statement
SELECT
ITM5.ItemCode AS 'Item No.',
ITM5.LineNum AS 'Line Number',
ITM5.ValidFrom AS 'Valid From',
ITM5.ValidTo AS 'Valid To',
ITM5.Project AS 'Project',
ITM5.LogInstanc AS 'Log Instance',
ITM5.ObjType AS 'Object'
FROM ITM5 AS ITM5
Related information
Items Projects ItemsProjects Object· Table: ITM5
ItemsProjects is a child object of the Items object.
You can assign projects to an asset to facilitate cost accounting.
Source table: ITM5.
Parent: Items Items Object· Table: OITM Items OITM SQL Table
Object Settings - History ADP1 SQL Table
Project Codes OPRJ SQL Table
Items
Object
ItemsProjects
Method
Property
LineNumber
DB
Project
DB
ValidFrom
DB
ValidTo
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
