|
|
API ASPP
ASPP - Special Prices Table
Business Partner OCRD SQL Table
Items OITM SQL Table
Price Lists OPLN SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ItemCode | Item No. | nVarChar | 20 | OITM Items |
|---|---|---|---|---|---|---|---|---|
| CardCode KEY UNIQUE | BP Code | nVarChar | 15 | OCRD Business Partner | PRIMARY | Yes | ||
| Price | Special Price | Num | 20 | |||||
| Currency | Price Currency | nVarChar | 3 | |||||
| Discount | Discount in % | Num | 20 | |||||
| ListNum | Price List No. | Int | 6 | OPLN Price Lists | 0 | |||
| AutoUpdt | Auto Update | VarChar | Y) Yes N) No | 1 | Y | |||
| EXPAND | Item Details | VarChar | Y) Yes N) No | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| SrcPrice | Source Price | Int | 0 1) Unit Price - Add. Crcy 1 2) Unit Price - Add. Crcy 2 | 6 | 0 | |||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| CreateDate | Creation Date | Date | 8 | |||||
| UpdateDate | Update Date | Date | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
