biuan SAP® BUSINESS ONE SDK
API ASP1
ASP1 - Special Prices - Data Areas Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCodeItem No.nVarChar
20OSPP
Special Prices
CardCode KEY UNIQUEBP CodenVarChar
15OSPP
Special Prices
PRIMARYYes
LINENUMRow NumberInt
6
PriceSpecial PriceNum
20
CurrencyPrice CurrencynVarChar
3
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 ASP1.ItemCode AS 'Item No.', ASP1.CardCode AS 'BP Code', ASP1.LINENUM AS 'Row Number', ASP1.Price AS 'Special Price', ASP1.Currency AS 'Price Currency', ASP1.Discount AS 'Discount %', ASP1.ListNum AS 'Price List No.', ASP1.FromDate AS 'Date From', ASP1.ToDate AS 'Date To', ASP1.AutoUpdt AS 'Auto Update', ASP1.Expand AS 'Item Details', ASP1.LogInstanc AS 'Log Instance' FROM ASP1 AS ASP1

Related information


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