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

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEYItem No.nVarChar
20OITM
Items		ITEMNo
CardCode KEYBP CodenVarChar
15OCRD
Business Partner		CARDNo
SPP1LNumDates Row NumberInt
6
SPP2LNumRow NumberInt
6
AmountQuantityNum
20
PriceSpecial PriceNum
20
Currency KEYPrice CurrencynVarChar
3
CURRENCYNo
DiscountDiscount in %Num
20
UomEntryUoM EntryInt
6OUOM
UoM Master Data
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

SELECT SPP2.ItemCode AS 'Item No.', SPP2.CardCode AS 'BP Code', SPP2.SPP1LNum AS 'Dates Row Number', SPP2.SPP2LNum AS 'Row Number', SPP2.Amount AS 'Quantity', SPP2.Price AS 'Special Price', SPP2.Currency AS 'Price Currency', SPP2.Discount AS 'Discount in %', SPP2.UomEntry AS 'UoM Entry', SPP2.LogInstanc AS 'Log Instance' FROM SPP2 AS SPP2

Related information


Special Prices Quantity Areas SpecialPricesQuantityAreas Object· Table: SPP2
SpecialPricesQuantityAreas is a child object of SpecialPricesDataAreas object and represents special prices that are valid only for specified quantities and above. Source table: SPP2.
   Parent: Special Prices Data Areas SpecialPricesDataAreas Object· Table: SPP1
Business Partner OCRD SQL Table

Items OITM SQL Table

UoM Master Data OUOM 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