|
|
API OGTM
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| CreateDate | Create Date | Date | 8 | |||||
| GtsMapNum | GTS Mapping No. | nVarChar | 20 | |||||
| InvMapEnty | Link to Invoice Mapping ID | Int | 11 | OIVM GTS Invoice Mapping Object | ||||
| GtsInvNum | Link to GTS Invoice Object | Int | 11 | OGTI GTS Invoice | ||||
| BpCode | BP Code | nVarChar | 15 | OCRD Business Partner | ||||
| BpName | BP Name | nVarChar | 100 | |||||
| BpTaxRegNo | BP Tax Registration No. | nVarChar | 20 | |||||
| BpAddrTel | BP Address and Telephone | nVarChar | 80 | |||||
| BpBankNum | BP Bank Number | nVarChar | 80 | |||||
| Remark | Remarks | nVarChar | 127 | |||||
| Checker | Checker | nVarChar | 80 | |||||
| Payee | Payee | nVarChar | 80 | |||||
| DocAmount | Document Net Amount | Num | 20 | |||||
| AmtAftDsct | Amount After Discount | Num | 20 | |||||
| TaxAmount | Tax Amount | Num | 20 | |||||
| GtsStatus | GTS Status | VarChar | 1) Exported 2) Voided 3) Imported | 1 | 1 | |||
| ExportDate | Export Date | Date | 8 | |||||
| VoidDate | Void Date | Date | 8 | |||||
| ImportDate | Import Date | Date | 8 |
Table relationship map
SELECT statement
SELECT
OGTM.AbsEntry AS 'Internal Number',
OGTM.CreateDate AS 'Create Date',
OGTM.GtsMapNum AS 'GTS Mapping No.',
OGTM.InvMapEnty AS 'Link to Invoice Mapping ID',
OGTM.GtsInvNum AS 'Link to GTS Invoice Object',
OGTM.BpCode AS 'BP Code',
OGTM.BpName AS 'BP Name',
OGTM.BpTaxRegNo AS 'BP Tax Registration No.',
OGTM.BpAddrTel AS 'BP Address and Telephone',
OGTM.BpBankNum AS 'BP Bank Number',
OGTM.Remark AS 'Remarks',
OGTM.Checker AS 'Checker',
OGTM.Payee AS 'Payee',
OGTM.DocAmount AS 'Document Net Amount',
OGTM.AmtAftDsct AS 'Amount After Discount',
OGTM.TaxAmount AS 'Tax Amount',
OGTM.GtsStatus AS 'GTS Status',
OGTM.ExportDate AS 'Export Date',
OGTM.VoidDate AS 'Void Date',
OGTM.ImportDate AS 'Import Date'
FROM OGTM AS OGTM
Related information
OGTM SQL Table
Business Partner OCRD SQL Table
GTS Invoice OGTI SQL Table
GTS Invoice Mapping Object OIVM SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates