SAP Reports / Programs | Cross-Application Components | European Monetary Union: Euro(CA-EUR) SAP CA

DMC_CLEANUP_USAGE SAP ABAP Report - deletes MWB table entries that are not referenced







DMC_CLEANUP_USAGE is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This report checks relationships between tables of the migration workbench...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.

If you would like to execute this report or see the full code listing simply enter DMC_CLEANUP_USAGE into the relevant SAP transactions such as SE38 or SE80


ABAP code to call this SAP report using the submit statement

This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.






SUBMIT DMC_CLEANUP_USAGE. "Basic submit
SUBMIT DMC_CLEANUP_USAGE AND RETURN. "Return to original report after report execution complete
SUBMIT DMC_CLEANUP_USAGE VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Selection Text: D_ACTP = delete actual parameters
Selection Text: D_ALL = delete all kinds of zombies
Selection Text: D_CNTN = delete container
Selection Text: D_COBJ = delete conversion objects
Selection Text: D_COPY = control of rule copies
Selection Text: D_CWBINC = delete CWB includes
Selection Text: D_DOCU = delete documentation
Selection Text: D_FIELD = delete fields
Selection Text: D_FORKEY = delete foreign keys
Selection Text: D_PREC = del. precalc / acc.pl / runInf
Selection Text: D_RCALL = delete rule call
Selection Text: D_RFC = delete rfc settings
Selection Text: D_RSDAT = delete RSDAT / SSDAT
Selection Text: D_RSREL = delete structure relationships
Selection Text: D_RULCDE = delete rule coding
Selection Text: D_RULE = delete rules
Selection Text: D_STREE = delete container node
Selection Text: D_STRUCT = delete structure
Selection Text: D_SUBPR = delete subprojects
Selection Text: D_WSTEP = delete worksteps
Selection Text: SO_SUBPR = delete subproject(s)
Title: deletes MWB table entries that are not referenced
Text Symbol: RFC = rfc settings
Text Symbol: RL1 = structure relationships
Text Symbol: RL2 = structure relationsh.
Text Symbol: RS1 = RSDAT entries refer to non-existing containers and would be deleted
Text Symbol: RS2 = RSDAT entries refer to non-existing containers and are deleted
Text Symbol: RU1 = rule calls
Text Symbol: RU2 = rule call
Text Symbol: SB1 = subprojects
Text Symbol: SP1 = refers to a non-existing subproject and would be deleted!
Text Symbol: SP2 = refers to a to-be-deleted subproject and would be deleted!
Text Symbol: SPR = refers to a non-existing subproject and is deleted!
Text Symbol: SS1 = SSDAT entries refer to non-existing containers and are deleted
Text Symbol: SS2 = SSDAT entries refer to non-existing containers and would be deleted
Text Symbol: ST1 = container node
Text Symbol: ST2 = structures
Text Symbol: ST3 = structure





Text Symbol: ST4 = refers to a non-existing container node and is deleted!
Text Symbol: ST5 = refers to a non-existing container node and would be deleted!
Text Symbol: ST6 = refers to a to-be-deleted container node and would be deleted!
Text Symbol: SUB = subproject
Text Symbol: WS1 = worksteps
Text Symbol: WS2 = worksteps refer to non-existing objects and would be deleted!
Text Symbol: WS3 = worksteps refer to non-existing objects and were deleted!
Text Symbol: DEL = were deleted
Text Symbol: CW1 = CWB include entries
Text Symbol: COB = migration object
Text Symbol: CO2 = migration objects
Text Symbol: CNT = container
Text Symbol: CHK = check
Text Symbol: CB3 = refers to a to-be-deleted container and would also be deleted!
Text Symbol: CB2 = refers to a non-existing container and is deleted!
Text Symbol: CB1 = refers to a non-existing container and is deleted!
Text Symbol: CA2 = collective access plans refer to non-existing migration objects and are deleted!
Text Symbol: CA1 = collective access plans
Text Symbol: AP2 = access plans refer to a non-existing object and are deleted!
Text Symbol: AP1 = access plans
Text Symbol: AC6 = refers to a rule call that itself should be deleted
Text Symbol: AC5 = refers to a non-existing rule call and would be deleted!
Text Symbol: AC4 = refers to a non-existing formal parameter and would be deleted!
Text Symbol: AC3 = refers to a non-existing rule call and is deleted!
Text Symbol: AC1 = actual parameter
Text Symbol: 011 = No inconsistent documents and owner objects found
Text Symbol: 010 = Inconsistent documents and owner objects
Text Symbol: 002 = delete specific objects with missing reference
Text Symbol: 001 = delete ALL objects with missing reference
Text Symbol: FI1 = fields
Text Symbol: RF1 = do not refer to an existing (sub)project and are deleted
Text Symbol: R07 = refers to a non-existing rule and would be deleted!
Text Symbol: R06 = refers to a non-existing rule and is deleted!
Text Symbol: R05 = would also be deleted, because the reference object is deleted!
Text Symbol: R04 = refers to a non-existing object and would be deleted!
Text Symbol: R03 = refers to a non-existing object and is deleted!
Text Symbol: R02 = rule
Text Symbol: R01 = rules
Text Symbol: PRO = refers to a non-existing project and is deleted!





Text Symbol: PR1 = refers to a non-existing project and would be deleted!
Text Symbol: PC2 = precalculations refer to non-existing migration objects and are deleted!
Text Symbol: PC1 = precalculations
Text Symbol: OP5 = rule relationships
Text Symbol: OP4 = refers to a to-be-deleted rule and would be deleted!
Text Symbol: OP3 = does not refer to an existing rule and would be deleted!
Text Symbol: OP2 = refers to a non-existing rule and is deleted!
Text Symbol: OP1 = rule relationship
Text Symbol: FK1 = foreign key
Text Symbol: FI5 = refers to a to-be-deleted structure and would be deleted!
Text Symbol: FI4 = refers to a non-existing structure and would be deleted!
Text Symbol: FI3 = refers to a non-existing structure and is deleted!
Text Symbol: FI2 = field


INCLUDES used within this REPORT DMC_CLEANUP_USAGE

No INCLUDES are used within this REPORT code!


TABLES used within REPORT and the associated SELECT statement:

No SAP DATABASE tables are accessed within this REPORT code!


Function Modules used within report and the associated call statement:

DB_COMMIT CALL FUNCTION 'DB_COMMIT'.



Contribute (Add Comments)

Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.

The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.

This will then be available for everyone to easily find by simply searching on the report name DMC_CLEANUP_USAGE or its description.