|
|
DTW Inventory / Item Master Data / Item - UoM Prices
API Items Prices / Uo M Prices
ITM9 - Item - UoM Prices Table
Uo M Prices UoMPrices Object· Table: ITM9
Parent: Items Prices Items_Prices Object· Table: ITM1
Currency Codes OCRN SQL Table
Items OITM SQL Table
Object Settings - History ADP1 SQL Table
Price Lists OPLN SQL Table
UoM Master Data OUOM 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 | Price List No. | Int | 6 | OPLN Price Lists | ||||
| UomEntry | UoM Entry | Int | 11 | OUOM UoM Master Data | ||||
| Factor | Reduced By % | Num | 20 | |||||
| Price | UoM Price | Num | 20 | |||||
| Currency | Currency for UoM Price | nVarChar | 3 | OCRN Currency Codes | ||||
| AutoUpdate | Automatic Update | VarChar | Y) Yes N) No | 1 | Y | |||
| 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 | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object | nVarChar | 20 | ADP1 Object Settings - History | 4 | |||
| Factor1 | Reduced By % | Num | 20 | |||||
| Factor2 | Reduced By % | Num | 20 | |||||
| UpdateDate | Date of Update | Date | 8 |
Table relationship map
SELECT statement
SELECT
ITM9.ItemCode AS 'Item No.',
ITM9.PriceList AS 'Price List No.',
ITM9.UomEntry AS 'UoM Entry',
ITM9.Factor AS 'Reduced By %',
ITM9.Price AS 'UoM Price',
ITM9.Currency AS 'Currency for UoM Price',
ITM9.AutoUpdate AS 'Automatic Update',
ITM9.AddPrice1 AS 'Additional Price (1)',
ITM9.Currency1 AS 'Currency for Add. Price 1',
ITM9.AddPrice2 AS 'Additional Price (2)',
ITM9.Currency2 AS 'Currency for Add. Price 2',
ITM9.LogInstanc AS 'Log Instance',
ITM9.ObjType AS 'Object',
ITM9.Factor1 AS 'Reduced By %',
ITM9.Factor2 AS 'Reduced By %',
ITM9.UpdateDate AS 'Date of Update'
FROM ITM9 AS ITM9
Related information
Uo M Prices UoMPrices Object· Table: ITM9
UoMPrices Class
Parent: Items Prices Items_Prices Object· Table: ITM1 Currency Codes OCRN SQL Table
Items OITM SQL Table
Object Settings - History ADP1 SQL Table
Price Lists OPLN SQL Table
UoM Master Data OUOM SQL Table
Items_Prices
Object
UoMPrices
Method
Property
AdditionalCurrency1
DTW DB
AdditionalCurrency2
DTW DB
AdditionalPrice1
DTW DB
AdditionalPrice2
DTW DB
AdditionalReduceBy1
DTW DB
AdditionalReduceBy2
DTW DB
Auto
DTW DB
Currency
DTW DB
Price
DTW DB
PriceList
DTW DB
ReduceBy
DTW DB
UoMEntry
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
