|
|
API ECM2
ECM2 - Electronic Transactions Table
ECM2 SQL Table
Brazil Numeric Indexer OBNI SQL 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 | AbsEntry | Internal ID | Int | 11 |
|---|---|---|---|---|---|---|---|---|
| Code | Code | VarChar | 1 | OECM Electronic Communication Types or Protocols | ||||
| ActType | Action Type | VarChar | S) Setup R) Report D) Document A/R P) Document A/P F) Draft O) Other K) Skip C) Contingency B) BP Check | 1 | ||||
| ActDesc | Action Description | nVarChar | 100 | |||||
| ActStatus | Action Status | VarChar | N) New P) Pending E) Error O) OK S) Sent R) Document Error W) Waiting A) Authorized I) In Process J) Rejected D) Denied C) Canceled B) Aborted Q) Queued | 1 | N | |||
| ActEnv | Action Environment Type | Int | 11 | OBNI Brazil Numeric Indexer | -1 | |||
| ActMessage | Action Message | nVarChar | 127 | |||||
| ActData | Action Data | Text | 16 | |||||
| ObjectID | Object ID | nVarChar | 50 | |||||
| ReportID | Report ID | nVarChar | 50 | |||||
| BPLId | Branch ID | Int | 11 | OBPL Business Place | -1 | |||
| SrcObjType KEY | Source Object Type | nVarChar | 20 | DOCREF | No | |||
| SrcObjAbs | Source Object Internal ID | Int | 11 | |||||
| PeriodType | Report Period Type | VarChar | Y) Year Q) Quarter M) Month P) Period | 1 | ||||
| PeriodNum | Report Period Number | Int | 11 | |||||
| Year | Report Year | Int | 6 | |||||
| DateFrom | Report - Date From | Date | 8 | |||||
| DateTo | Report - Date To | Date | 8 | |||||
| Submits | Report - Number of Submissions | Int | 6 | |||||
| DocBtch | Document Batch | nVarChar | 50 | |||||
| DocBtchLn | Document Batch Line | Int | 6 | |||||
| AssignedID | Assigned ID | nVarChar | 50 | |||||
| SendDate | Send Date | Date | 8 | |||||
| ReceivDate | Received Date | Date | 8 | |||||
| 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 | |||||
| ActData2 | Action Data 2 | Text | 16 | |||||
| IsRemoved | Is Removed | VarChar | Y) Yes N) No | 1 | N | |||
| Cancel | Cancelation | VarChar | Y) Yes N) No | 1 | N | |||
| CreateTS | Creatn Time - Incl. Secs | Int | 11 | |||||
| UpdateTS | Update Full Time | Int | 11 | |||||
| SendTS | Send Time - Incl. Secs | Int | 11 |
Table relationship map
SELECT statement
SELECT
ECM2.AbsEntry AS 'Internal ID',
ECM2.Code AS 'Code',
ECM2.ActType AS 'Action Type',
ECM2.ActDesc AS 'Action Description',
ECM2.ActStatus AS 'Action Status',
ECM2.ActEnv AS 'Action Environment Type',
ECM2.ActMessage AS 'Action Message',
ECM2.ActData AS 'Action Data',
ECM2.ObjectID AS 'Object ID',
ECM2.ReportID AS 'Report ID',
ECM2.BPLId AS 'Branch ID',
ECM2.SrcObjType AS 'Source Object Type',
ECM2.SrcObjAbs AS 'Source Object Internal ID',
ECM2.PeriodType AS 'Report Period Type',
ECM2.PeriodNum AS 'Report Period Number',
ECM2.Year AS 'Report Year',
ECM2.DateFrom AS 'Report - Date From',
ECM2.DateTo AS 'Report - Date To',
ECM2.Submits AS 'Report - Number of Submissions',
ECM2.DocBtch AS 'Document Batch',
ECM2.DocBtchLn AS 'Document Batch Line',
ECM2.AssignedID AS 'Assigned ID',
ECM2.SendDate AS 'Send Date',
ECM2.ReceivDate AS 'Received Date',
ECM2.UserSign AS 'User Signature',
ECM2.CreateDate AS 'Creation Date',
ECM2.UserSign2 AS 'Updating User',
ECM2.UpdateDate AS 'Update Date',
ECM2.LogInstanc AS 'Log Instance',
ECM2.ActData2 AS 'Action Data 2',
ECM2.IsRemoved AS 'Is Removed',
ECM2.Cancel AS 'Cancelation',
ECM2.CreateTS AS 'Creatn Time - Incl. Secs',
ECM2.UpdateTS AS 'Update Full Time',
ECM2.SendTS AS 'Send Time - Incl. Secs'
FROM ECM2 AS ECM2
Related information
ECM2 SQL Table
Brazil Numeric Indexer OBNI SQL Table
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
