|
|
SQL Finance / Posting Templates
API OTRT
OTRT - Posting Templates Table
OTRT SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | TrtCode KEY UNIQUE | Template Code | nVarChar | 8 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Dscription | Template Description | nVarChar | 60 | |||||
| FrgnMode | FC Template | VarChar | Y) Yes N) No | 1 | Y | |||
| Memo | Details | nVarChar | 50 | |||||
| TransCode | Transaction Code | nVarChar | 4 | |||||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| StampTax | Stamp Tax | VarChar | Y) Yes N) No | 1 | N | |||
| AutoVat | Automatic VAT | VarChar | Y) Yes N) No | 1 | N | |||
| ManageWTax | Manage WTax | VarChar | Y) Yes N) No | 1 | N | |||
| DeferedTax | Deferred Tax | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
OTRT.TrtCode AS 'Template Code',
OTRT.Dscription AS 'Template Description',
OTRT.FrgnMode AS 'FC Template',
OTRT.Memo AS 'Details',
OTRT.TransCode AS 'Transaction Code',
OTRT.DataSource AS 'Data Source',
OTRT.UserSign AS 'User Signature',
OTRT.StampTax AS 'Stamp Tax',
OTRT.AutoVat AS 'Automatic VAT',
OTRT.ManageWTax AS 'Manage WTax',
OTRT.DeferedTax AS 'Deferred Tax'
FROM OTRT AS OTRT
Related information
OTRT SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
