|
|
API ASP1
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ItemCode | Item No. | nVarChar | 20 | OSPP Special Prices |
|---|---|---|---|---|---|---|---|---|
| CardCode KEY UNIQUE | BP Code | nVarChar | 15 | OSPP Special Prices | PRIMARY | Yes | ||
| LINENUM | Row Number | Int | 6 | |||||
| Price | Special Price | Num | 20 | |||||
| Currency | Price Currency | nVarChar | 3 | |||||
| Discount | Discount % | Num | 20 | |||||
| ListNum | Price List No. | Int | 6 | OPLN Price Lists | 0 | |||
| FromDate | Date From | Date | 8 | |||||
| ToDate | Date To | Date | 8 | |||||
| AutoUpdt | Auto Update | VarChar | Y) Yes N) No | 1 | Y | |||
| Expand | Item Details | VarChar | Y) Yes N) No | 1 | N | |||
| LogInstanc | Log Instance | Int | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates