|
|
SQL Finance / Box Set Definition
API OBOS
OBOS - Box Set Definition Table
OBOS SQL Table
Legal List Format OLLF 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 |
|---|---|---|---|---|---|---|---|---|
| IsUsed | Is Set Used | VarChar | Y) Yes N) No | 1 | N | |||
| EffecDate KEY | Effective From | Date | 8 | EFFEC_DATE | No | |||
| FileFmtCo | File Format Code | Int | 11 | OLLF Legal List Format | ||||
| IsDeleted | Is Set Deleted | VarChar | Y) Yes N) No | 1 | N | |||
| ReportType | Report Type | VarChar | B) Box Declaration S) BAS Report | 1 | S |
Table relationship map
SELECT statement
SELECT
OBOS.AbsEntry AS 'Internal Number',
OBOS.IsUsed AS 'Is Set Used',
OBOS.EffecDate AS 'Effective From',
OBOS.FileFmtCo AS 'File Format Code',
OBOS.IsDeleted AS 'Is Set Deleted',
OBOS.ReportType AS 'Report Type'
FROM OBOS AS OBOS
Related information
OBOS SQL Table
Legal List Format OLLF SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates