biuan SAP® BUSINESS ONE SDK
DTW Opportunities
API MDC1
MDC1 - Master Data Cleanup - Log Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal KeyInt
11OMDC
Master Data Cleanup
PRIMARYYes
LineIDLine IDInt
11
ObjectTypeObject TypenVarChar
20
ObjectKeyObject KeynVarChar
20
NameNamenVarChar
100
LastDateLast Transaction DateDate
8
ActionActionVarChar
R) Remove
D) Deactivate
1
ObjectCodeObject CodenVarChar
100
ActFailedAction FailedVarChar
Y) Yes
N) No
1
N
OrigActionOriginal ActionVarChar
R) Remove
D) Deactivate
1
SubObjTypeSubobject TypenVarChar
20
SubObjKeySubobject KeynVarChar
50
SubObjNam1Subobject Name 1nVarChar
50
SubObjNam2Subobject Name 2nVarChar
50
SubObjNam3Subobject Name 3nVarChar
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates