|
|
API AEC1
AEC1 - Parameters for Various Types of Electronic Communication Table
Business Place OBPL SQL Table
Electronic Communication Types or Protocols OECM SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Code | VarChar | 1 | OECM Electronic Communication Types or Protocols | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| StrIndex | String Index | Int | 6 | |||||
| BPLId | Branch ID | Int | 11 | OBPL Business Place | -1 | |||
| ParamType | Parameter Type | nVarChar | TX) General Text TT) Title EM) E-Mail UR) URI Address SA) Server Address PT) Path FN) File Name LG) Logic Value - Yes/No NI) Number - Integer NR) Number - Real PW) Password OT) Other | 2 | TX | |||
| ParamVisib | Parameter is Visible | VarChar | Y) Yes N) No | 1 | Y | |||
| ParamName | Parameter Name | nVarChar | 100 | |||||
| ParamValue | Parameter Value | Text | 16 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| CreateDate | Creation Date | Date | 8 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Update Date | Date | 8 | |||||
| LogInstanc | Log Instance | Int | 6 |
Table relationship map
SELECT statement
SELECT
AEC1.Code AS 'Code',
AEC1.LineNum AS 'Row Number',
AEC1.StrIndex AS 'String Index',
AEC1.BPLId AS 'Branch ID',
AEC1.ParamType AS 'Parameter Type',
AEC1.ParamVisib AS 'Parameter is Visible',
AEC1.ParamName AS 'Parameter Name',
AEC1.ParamValue AS 'Parameter Value',
AEC1.UserSign AS 'User Signature',
AEC1.CreateDate AS 'Creation Date',
AEC1.UserSign2 AS 'Updating User',
AEC1.UpdateDate AS 'Update Date',
AEC1.LogInstanc AS 'Log Instance'
FROM AEC1 AS AEC1
Related information
Business Place OBPL SQL Table
Electronic Communication Types or Protocols OECM 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
