biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Special Prices / Special Prices - Data Areas
DTW Special Prices - Data Areas
API Special Prices / Special Prices Data Areas
SPP1 - Special Prices - Data Areas Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEYItem No.nVarChar
20OSPP
Special Prices		ITEMNo
CardCode KEYBP CodenVarChar
15OSPP
Special Prices		CARDNo
LINENUMRow NumberInt
6
PriceSpecial PriceNum
20
Currency KEYPrice CurrencynVarChar
3
CURRENCYNo
DiscountDiscount %Num
20
ListNumPrice List No.Int
6OPLN
Price Lists		0
FromDateDate FromDate
8
ToDateDate ToDate
8
AutoUpdtAuto UpdateVarChar
Y) Yes
N) No
1
Y
ExpandItem DetailsVarChar
Y) Yes
N) No
1
N
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

SELECT SPP1.ItemCode AS 'Item No.', SPP1.CardCode AS 'BP Code', SPP1.LINENUM AS 'Row Number', SPP1.Price AS 'Special Price', SPP1.Currency AS 'Price Currency', SPP1.Discount AS 'Discount %', SPP1.ListNum AS 'Price List No.', SPP1.FromDate AS 'Date From', SPP1.ToDate AS 'Date To', SPP1.AutoUpdt AS 'Auto Update', SPP1.Expand AS 'Item Details', SPP1.LogInstanc AS 'Log Instance' FROM SPP1 AS SPP1

Related information


Special Prices Data Areas SpecialPricesDataAreas Object· Table: SPP1
SpecialPricesDataAreas is a child object of SpecialPrices object and represents special prices that are valid only for specified periods such as, holidays and season sales. Source table: SPP1.
   Parent: Special Prices SpecialPrices Object· Table: OSPP
Special Prices OSPP SQL Table

Price Lists OPLN 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