|
|
API GTI1
GTI1 - GTS Invoice Details Table
GTS Invoice OGTI SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | OGTI GTS Invoice | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Line Number | Int | 11 | |||||
| DisctLine | Discount Flag | VarChar | 0 1) Discount Line | 1 | 0 | |||
| ItemName | Item Name | nVarChar | 60 | |||||
| ItemSpec | Item Specification | nVarChar | 30 | |||||
| Uom | Unit of Measurement | nVarChar | 16 | |||||
| Quantity | Quantity | Num | 20 | |||||
| NetAmount | Net Amount | Num | 20 | |||||
| VatPercent | VAT Percent | Num | 20 | |||||
| VatAmount | VAT Amount | Num | 20 | |||||
| UnitPrice | Unit Price | Num | 20 | |||||
| UnitPricTp | Unit Price Type | VarChar | 0 1) Gross | 1 | 0 | |||
| ItemTaxCat | Item Tax Category | nVarChar | 4 |
SELECT statement
SELECT
GTI1.AbsEntry AS 'Internal Number',
GTI1.LineNum AS 'Line Number',
GTI1.DisctLine AS 'Discount Flag',
GTI1.ItemName AS 'Item Name',
GTI1.ItemSpec AS 'Item Specification',
GTI1.Uom AS 'Unit of Measurement',
GTI1.Quantity AS 'Quantity',
GTI1.NetAmount AS 'Net Amount',
GTI1.VatPercent AS 'VAT Percent',
GTI1.VatAmount AS 'VAT Amount',
GTI1.UnitPrice AS 'Unit Price',
GTI1.UnitPricTp AS 'Unit Price Type',
GTI1.ItemTaxCat AS 'Item Tax Category'
FROM GTI1 AS GTI1
Related information
GTS Invoice OGTI SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
