|
|
API EJD1
EJD1 - ERV-JAb Signing Persons List Table
EJD1 SQL Table
Company Details for ERV-JAb OEJD SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | OEJD Company Details for ERV-JAb | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| Title | Title | nVarChar | 20 | |||||
| FirstName | First Name | nVarChar | 38 | |||||
| Surname | Surname | nVarChar | 38 | |||||
| CommID | Commercial ID | nVarChar | 3 | |||||
| DateOfBrth | Date of Birth | Date | 8 | |||||
| Active | Active | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
EJD1.AbsEntry AS 'Internal Number',
EJD1.LineNum AS 'Row Number',
EJD1.Title AS 'Title',
EJD1.FirstName AS 'First Name',
EJD1.Surname AS 'Surname',
EJD1.CommID AS 'Commercial ID',
EJD1.DateOfBrth AS 'Date of Birth',
EJD1.Active AS 'Active'
FROM EJD1 AS EJD1
Related information
EJD1 SQL Table
Company Details for ERV-JAb OEJD SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
