|
|
SQL Reports / Thresholds
API OTHL
OTHL - Thresholds Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| RecType | Report Type | VarChar | A) Annual Invoice Declaration B) Blacklist Country | 1 | A | |||
| EffecFrom | Effective From | Date | 8 | |||||
| Company | Company | nVarChar | 20 | |||||
| PrivInv | Private - Invoice | nVarChar | 20 | |||||
| PrivJE | Private - Journal Entry | nVarChar | 20 | |||||
| LogInstanc | Log Instance | Int | 11 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| CreateDate | Creation Date | Date | 8 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| Tourism | Tourism | nVarChar | 20 |
SELECT statement
SELECT
OTHL.AbsEntry AS 'Internal Number',
OTHL.RecType AS 'Report Type',
OTHL.EffecFrom AS 'Effective From',
OTHL.Company AS 'Company',
OTHL.PrivInv AS 'Private - Invoice',
OTHL.PrivJE AS 'Private - Journal Entry',
OTHL.LogInstanc AS 'Log Instance',
OTHL.UserSign AS 'User Signature',
OTHL.CreateDate AS 'Creation Date',
OTHL.UserSign2 AS 'Updating User',
OTHL.UpdateDate AS 'Date of Update',
OTHL.Tourism AS 'Tourism'
FROM OTHL AS OTHL
Related information
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
