|
|
API TGPA
TGPA - Gross Profit Adjustment - Log Table
Items OITM SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Key | Identity | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ItemCode | Item No. | nVarChar | 20 | OITM Items | ||||
| ItemName | Item Description | nVarChar | 100 | |||||
| LineID | Line ID | Int | 11 | |||||
| Selected | Selected | VarChar | 1 | N | ||||
| DocType | Document Type | nVarChar | 20 | |||||
| DocNum | Document Number | Int | 11 | |||||
| DocAbs | Document Abs. Entry | Int | 11 | |||||
| DocLineNum | Document Line Number | Int | 11 | |||||
| ManagedBy | Managed By | Int | 10000044) Batch Numbers 10000045) Serial Numbers | 11 | -1 | |||
| SysNumber | System Number | Int | 11 |
SELECT statement
SELECT
TGPA.AbsEntry AS 'Internal Key',
TGPA.ItemCode AS 'Item No.',
TGPA.ItemName AS 'Item Description',
TGPA.LineID AS 'Line ID',
TGPA.Selected AS 'Selected',
TGPA.DocType AS 'Document Type',
TGPA.DocNum AS 'Document Number',
TGPA.DocAbs AS 'Document Abs. Entry',
TGPA.DocLineNum AS 'Document Line Number',
TGPA.ManagedBy AS 'Managed By',
TGPA.SysNumber AS 'System Number'
FROM TGPA AS TGPA
Related information
Items OITM SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
