biuan SAP® BUSINESS ONE SDK
DTW Inventory / Item Master Data / Items - Prices
API Items / Items Prices
ITM1 - Items - Prices Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEY UNIQUEItem No.nVarChar
20OITM
Items
PRIMARYYes
PriceList KEYPrice List No.Int
6OPLN
Price Lists
PRICE_LISTNo
PriceList PriceNum
20
Currency KEYCurrency for List PricenVarChar
3OCRN
Currency Codes
CURRENCYNo
Ovrwritten KEYManual Price EntryVarChar
Y) Yes
N) No
1
NMANUALNo
FactorFactorNum
20
LogInstancLog InstanceInt
11
0
ObjTypeObjectnVarChar
20ADP1
Object Settings - History
4
AddPrice1Additional Price (1)Num
20
Currency1Currency for Add. Price 1nVarChar
3OCRN
Currency Codes
AddPrice2Additional Price (2)Num
20
Currency2Currency for Add. Price 2nVarChar
3OCRN
Currency Codes
Ovrwrite1Manual Price Entry (1)VarChar
Y) Yes
N) No
1
N
Ovrwrite2Manual Price Entry (2)VarChar
Y) Yes
N) No
1
N
BasePLNumBase Price List No.Int
6OPLN
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates