|
|
API GPA9
GPA9 - Applied Gross Profit Adjustments Table
Gross Profit Adjustment OGPA SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Key | Int | 11 | OGPA Gross Profit Adjustment | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineId | Row No. | Int | 11 | |||||
| DocAbs | Document Abs. Entry | Int | 11 | |||||
| DocType | Document Type | nVarChar | 20 | |||||
| DocLineNum | Document Line Number | Int | 11 | |||||
| SnBAbs | SnB Abs. Entry | Int | 11 | |||||
| ManagedBy | Managed By | Int | 10000044) Batch Numbers 10000045) Serial Numbers -1) | 11 | -1 | |||
| Applied | Applied Adjustment | Num | 20 |
SELECT statement
SELECT
GPA9.AbsEntry AS 'Internal Key',
GPA9.LineId AS 'Row No.',
GPA9.DocAbs AS 'Document Abs. Entry',
GPA9.DocType AS 'Document Type',
GPA9.DocLineNum AS 'Document Line Number',
GPA9.SnBAbs AS 'SnB Abs. Entry',
GPA9.ManagedBy AS 'Managed By',
GPA9.Applied AS 'Applied Adjustment'
FROM GPA9 AS GPA9
Related information
Gross Profit Adjustment OGPA SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
