biuan SAP® BUSINESS ONE SDK
API ASP2
ASP2 - Special Prices - Quantity Areas Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCodeItem No.nVarChar
20OITM
Items
CardCode KEY UNIQUEBP CodenVarChar
15OCRD
Business Partner
PRIMARYYes
SPP1LNumDates Row NumberInt
6
SPP2LNumRow NumberInt
6
AmountQuantityNum
20
PriceSpecial PriceNum
20
CurrencyPrice CurrencynVarChar
3
DiscountDiscount in %Num
20
UomEntryUoM EntryInt
6OUOM
UoM Master Data
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

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

Related information


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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates