|
|
DTW Opportunities
API MDC1
MDC1 - Master Data Cleanup - Log Table
Master Data Cleanup OMDC SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Key | Int | 11 | OMDC Master Data Cleanup | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineID | Line ID | Int | 11 | |||||
| ObjectType | Object Type | nVarChar | 20 | |||||
| ObjectKey | Object Key | nVarChar | 20 | |||||
| Name | Name | nVarChar | 100 | |||||
| LastDate | Last Transaction Date | Date | 8 | |||||
| Action | Action | VarChar | R) Remove D) Deactivate | 1 | ||||
| ObjectCode | Object Code | nVarChar | 100 | |||||
| ActFailed | Action Failed | VarChar | Y) Yes N) No | 1 | N | |||
| OrigAction | Original Action | VarChar | R) Remove D) Deactivate | 1 | ||||
| SubObjType | Subobject Type | nVarChar | 20 | |||||
| SubObjKey | Subobject Key | nVarChar | 50 | |||||
| SubObjNam1 | Subobject Name 1 | nVarChar | 50 | |||||
| SubObjNam2 | Subobject Name 2 | nVarChar | 50 | |||||
| SubObjNam3 | Subobject Name 3 | nVarChar | 50 |
SELECT statement
SELECT
MDC1.AbsEntry AS 'Internal Key',
MDC1.LineID AS 'Line ID',
MDC1.ObjectType AS 'Object Type',
MDC1.ObjectKey AS 'Object Key',
MDC1.Name AS 'Name',
MDC1.LastDate AS 'Last Transaction Date',
MDC1.Action AS 'Action',
MDC1.ObjectCode AS 'Object Code',
MDC1.ActFailed AS 'Action Failed',
MDC1.OrigAction AS 'Original Action',
MDC1.SubObjType AS 'Subobject Type',
MDC1.SubObjKey AS 'Subobject Key',
MDC1.SubObjNam1 AS 'Subobject Name 1',
MDC1.SubObjNam2 AS 'Subobject Name 2',
MDC1.SubObjNam3 AS 'Subobject Name 3'
FROM MDC1 AS MDC1
Related information
Master Data Cleanup OMDC SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
