|
|
DTW Inventory / Item Master Data / Items - Prices
API Items / Items Prices
ITM1 - Items - Prices Table
Items Prices Items_Prices Object· Table: ITM1
Parent: Items Items Object· Table: OITM
Price Lists OPLN SQL Table
Currency Codes OCRN SQL Table
Items OITM SQL Table
Object Settings - History ADP1 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 |
|---|---|---|---|---|---|---|---|---|
| PriceList KEY | Price List No. | Int | 6 | OPLN Price Lists | PRICE_LIST | No | ||
| Price | List Price | Num | 20 | |||||
| Currency KEY | Currency for List Price | nVarChar | 3 | OCRN Currency Codes | CURRENCY | No | ||
| Ovrwritten KEY | Manual Price Entry | VarChar | Y) Yes N) No | 1 | N | MANUAL | No | |
| Factor | Factor | Num | 20 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object | nVarChar | 20 | ADP1 Object Settings - History | 4 | |||
| AddPrice1 | Additional Price (1) | Num | 20 | |||||
| Currency1 | Currency for Add. Price 1 | nVarChar | 3 | OCRN Currency Codes | ||||
| AddPrice2 | Additional Price (2) | Num | 20 | |||||
| Currency2 | Currency for Add. Price 2 | nVarChar | 3 | OCRN Currency Codes | ||||
| Ovrwrite1 | Manual Price Entry (1) | VarChar | Y) Yes N) No | 1 | N | |||
| Ovrwrite2 | Manual Price Entry (2) | VarChar | Y) Yes N) No | 1 | N | |||
| BasePLNum | Base Price List No. | Int | 6 | OPLN Price Lists |
Table relationship map
SELECT statement
SELECT
ITM1.ItemCode AS 'Item No.',
ITM1.PriceList AS 'Price List No.',
ITM1.Price AS 'List Price',
ITM1.Currency AS 'Currency for List Price',
ITM1.Ovrwritten AS 'Manual Price Entry',
ITM1.Factor AS 'Factor',
ITM1.LogInstanc AS 'Log Instance',
ITM1.ObjType AS 'Object',
ITM1.AddPrice1 AS 'Additional Price (1)',
ITM1.Currency1 AS 'Currency for Add. Price 1',
ITM1.AddPrice2 AS 'Additional Price (2)',
ITM1.Currency2 AS 'Currency for Add. Price 2',
ITM1.Ovrwrite1 AS 'Manual Price Entry (1)',
ITM1.Ovrwrite2 AS 'Manual Price Entry (2)',
ITM1.BasePLNum AS 'Base Price List No.'
FROM ITM1 AS ITM1
Related information
Items Prices Items_Prices Object· Table: ITM1
Items_Prices is a child object of the Items object that represents the items' prices in the Inventory and Production module. This object enables you to specify prices for various price lists.
Source table: ITM1
Parent: Items Items Object· Table: OITM Price Lists OPLN SQL Table
Currency Codes OCRN SQL Table
Items OITM SQL Table
Object Settings - History ADP1 SQL Table
Items
Object
Items_Prices
Method
Object
UoMPrices ITM9
Property
Currency
DTW DB
Price
DTW DB
PriceList
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
