biuan SAP® BUSINESS ONE SDK
DTW Business Partners / Business Partner Master Data / Special Prices for Groups
API Business Partners / Discount Groups
OSPG - Special Prices for Groups Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CardCode KEY UNIQUEBP CodenVarChar
15OCRD
Business Partner
PRIMARYYes
ObjTypeObject TypenVarChar
52) Item Group
8) Item Properties
43) Companies
20
ObjKeyObject KeynVarChar
20
DiscountDiscountNum
20
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser FormInt
6OUSR
Users

Table relationship map

SELECT statement

SELECT OSPG.CardCode AS 'BP Code', OSPG.ObjType AS 'Object Type', OSPG.ObjKey AS 'Object Key', OSPG.Discount AS 'Discount', OSPG.DataSource AS 'Data Source', OSPG.UserSign AS 'User Form' FROM OSPG AS OSPG

Related information


Discount Groups DiscountGroups Object· Table: OSPG
Represents a set of item discounts for a specific business partner. Each business partner can be assigned a set of discounts, and each discount is associated with an item group, property, or manufacturer. If the business partner purchases an...
   Parent: Business Partners BusinessPartners Object· Table: OCRD
Business Partner OCRD 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