biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Special Prices
API OSPP / / Special Prices
OSPP - Special Prices Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEYItem No.nVarChar
20OITM
Items		ITEMNo
CardCode KEYBP CodenVarChar
15OCRD
Business Partner		CARDNo
PriceSpecial PriceNum
20
Currency KEYPrice CurrencynVarChar
3
CURRENCYNo
DiscountDiscount in %Num
20
ListNumPrice List No.Int
6OPLN
Price Lists		0
AutoUpdtAuto UpdateVarChar
Y) Yes
N) No
1
Y
EXPANDItem DetailsVarChar
Y) Yes
N) No
1
N
UserSignUser SignatureInt
6OUSR
Users
SrcPriceSource PriceInt
0
1) Unit Price - Add. Curr. 1
2) Unit Price - Add. Curr. 2
6
0
LogInstancLog InstanceInt
11
0
UserSign2Updating UserInt
6OUSR
Users
CreateDateCreation DateDate
8
UpdateDateUpdate DateDate
8

Table relationship map

SELECT statement

SELECT OSPP.ItemCode AS 'Item No.', OSPP.CardCode AS 'BP Code', OSPP.Price AS 'Special Price', OSPP.Currency AS 'Price Currency', OSPP.Discount AS 'Discount in %', OSPP.ListNum AS 'Price List No.', OSPP.AutoUpdt AS 'Auto Update', OSPP.EXPAND AS 'Item Details', OSPP.UserSign AS 'User Signature', OSPP.SrcPrice AS 'Source Price', OSPP.LogInstanc AS 'Log Instance', OSPP.UserSign2 AS 'Updating User', OSPP.CreateDate AS 'Creation Date', OSPP.UpdateDate AS 'Update Date' FROM OSPP AS OSPP

Related information


Special Prices SpecialPrices Object· Table: OSPP
Represents a discount for a specific item in a specific price list. The discount can apply to a specific business partner or for all business partners. Specific Partners: To view discounts for specific business partners, select Inventory --
OSPP SQL Table

Business Partner OCRD SQL Table

Items OITM SQL Table

Price Lists OPLN SQL Table

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