|
|
SQL Finance / Tax Report Type
API OKRT
OKRT - Tax Report Type Table
OKRT SQL Table
Define Summary VAT Report Type OSVT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Tax Report Type ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| TaxRepType KEY UNIQUE | Tax Report Type Name | nVarChar | 127 | TAX_REP_TY | Yes | |||
| Descrip | Tax Report Type Description | nVarChar | 127 | |||||
| SumRepType | Summary VAT Report Type | Int | 11 | OSVT Define Summary VAT Report Type | ||||
| NameDesc | Tax Report Type Name + Desc | nVarChar | 127 |
Table relationship map
SELECT statement
SELECT
OKRT.AbsEntry AS 'Tax Report Type ID',
OKRT.TaxRepType AS 'Tax Report Type Name',
OKRT.Descrip AS 'Tax Report Type Description',
OKRT.SumRepType AS 'Summary VAT Report Type',
OKRT.NameDesc AS 'Tax Report Type Name + Desc'
FROM OKRT AS OKRT
Related information
OKRT SQL Table
Define Summary VAT Report Type OSVT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
