|
|
API GTM1
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | OGTM GTS Mapping Object | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Line Number | Int | 11 | |||||
| ItemCode | Item Code | nVarChar | 20 | OITM Items | ||||
| ItemName | Item Name | nVarChar | 100 | |||||
| ItemUoM | Item UoM | nVarChar | 100 | |||||
| ItemSpec | Item Spec. | nVarChar | 30 | |||||
| ItemTaxCat | Item Tax Category | nVarChar | 4 | |||||
| Quantity | Quantity | Num | 20 | |||||
| Amount | Amount | Num | 20 | |||||
| VatPercent | VAT Percent | Num | 20 | |||||
| DiscRate | Discount Rate | Num | 20 | |||||
| DiscAmount | Discount Amount | Num | 20 | |||||
| VatAmount | VAT Amount | Num | 20 | |||||
| DiscVatAmt | Discount VAT Amount | Num | 20 | |||||
| UnitPrice | Unit Price | Num | 20 | |||||
| UPirceType | Unit Price Type | VarChar | 0 1) Gross | 1 | 0 |
Table relationship map
SELECT statement
SELECT
GTM1.AbsEntry AS 'Internal Number',
GTM1.LineNum AS 'Line Number',
GTM1.ItemCode AS 'Item Code',
GTM1.ItemName AS 'Item Name',
GTM1.ItemUoM AS 'Item UoM',
GTM1.ItemSpec AS 'Item Spec.',
GTM1.ItemTaxCat AS 'Item Tax Category',
GTM1.Quantity AS 'Quantity',
GTM1.Amount AS 'Amount',
GTM1.VatPercent AS 'VAT Percent',
GTM1.DiscRate AS 'Discount Rate',
GTM1.DiscAmount AS 'Discount Amount',
GTM1.VatAmount AS 'VAT Amount',
GTM1.DiscVatAmt AS 'Discount VAT Amount',
GTM1.UnitPrice AS 'Unit Price',
GTM1.UPirceType AS 'Unit Price Type'
FROM GTM1 AS GTM1
Related information
GTS Mapping Object OGTM SQL Table
Items OITM SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates