|
|
DTW Business Partners / Business Partner Master Data / Special Prices for Groups
API Business Partners / Discount Groups
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | CardCode KEY UNIQUE | BP Code | nVarChar | 15 | OCRD Business Partner | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ObjType | Object Type | nVarChar | 52) Item Group 8) Item Properties 43) Companies | 20 | ||||
| ObjKey | Object Key | nVarChar | 20 | |||||
| Discount | Discount | Num | 20 | |||||
| DataSource | Data Source | VarChar | 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 | |||
| UserSign | User Form | Int | 6 | OUSR 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
BusinessPartners
Object
DiscountGroups
Enumeration
Method
Property
DiscountPercentage
DTW DB
ObjectEntry
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates