|
|
API TRS1
TRS1 - Tax Report Saving Object - Approved Documents Table
Tax Report Saving Object OTRS SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | OTRS Tax Report Saving Object | SECONDARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ObjType | Object Type | nVarChar | 20 | |||||
| LineID | Internal Row Number | Int | 11 | |||||
| ApDocType | Approved Document Type | nVarChar | 20 | |||||
| ApDocEntry | Approved Document Key | Int | 11 | |||||
| ApDocOrdNo | Appr. Doc. Ordinal Number | Int | 11 | -1 | ||||
| ApDocAdRef | Appr. Doc. Additional Reference | Int | 11 | -1 | ||||
| MeansType | Payment Means Type | Int | 11 | -1 | ||||
| PayLineID | Payment Means Line ID | Int | 11 | -1 | ||||
| PayDocType | Payment Document Type | Int | 11 | -1 | ||||
| PayDocEntr | Payment Document Entry | Int | 11 | -1 |
SELECT statement
SELECT
TRS1.AbsEntry AS 'Internal Number',
TRS1.ObjType AS 'Object Type',
TRS1.LineID AS 'Internal Row Number',
TRS1.ApDocType AS 'Approved Document Type',
TRS1.ApDocEntry AS 'Approved Document Key',
TRS1.ApDocOrdNo AS 'Appr. Doc. Ordinal Number',
TRS1.ApDocAdRef AS 'Appr. Doc. Additional Reference',
TRS1.MeansType AS 'Payment Means Type',
TRS1.PayLineID AS 'Payment Means Line ID',
TRS1.PayDocType AS 'Payment Document Type',
TRS1.PayDocEntr AS 'Payment Document Entry'
FROM TRS1 AS TRS1
Related information
Tax Report Saving Object OTRS SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
