biuan SAP® BUSINESS ONE SDK
API ASPP
ASPP - Special Prices Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCodeItem No.nVarChar
20OITM
Items
CardCode KEY UNIQUEBP CodenVarChar
15OCRD
Business Partner
PRIMARYYes
PriceSpecial PriceNum
20
CurrencyPrice CurrencynVarChar
3
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. Crcy 1
2) Unit Price - Add. Crcy 2
6
0
LogInstancLog InstanceInt
11
0
UserSign2Updating UserInt
6OUSR
Users
CreateDateCreation DateDate
8
UpdateDateUpdate DateDate
8

Table relationship map

SELECT statement

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

Related information


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