Skip to Content

LMDB: Extract list of logical components in spreadsheet

In LMDB of Solution Manager 7.1, I want to get an overview of all existing logical components in the system and to extract a spreadheet from that. Is there a way to do this?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Mar 01, 2017 at 02:59 PM

    SMUD work Certer can be an option.

    https://host:port/sap/bc/webdynpro/sap/slan_work_frame#

    Thanks

    Yogesh

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 02, 2017 at 06:06 AM

    Hi

    You can list all of them using below path (no export functionality there though):

    Transaction SOLMAN_WORKCENTER - SAP Solution Manager Administration - Landscape - Logical Components

    From there you can jump to "maintenance" of such a logical component which goes to LMDB (depending on your SolMan 7.1 version).

    Out of curiosity, why do you want to report on this? Logical component concept changes in SAP Solution Manager 7.2 in a way that you normally would not need that many logical components anymore but that you can re-use existing logical components once you're managed SAP systems are assigned to a logical component group. So that should get rid of the double or triple (or whatever number of logical components you have that include the same system).

    Best regards

    Tom

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 02, 2017 at 12:21 PM

    Hello,

    SMUD doesn't exist in 7.1.

    If you are looking only for Logical componants name, you can find the information in the view V_LOGCOMP in SE16.

    If you are trying to have the SID per logical componants, SAP doesn't provided a easy way to extract this information.
    (Z_LOG : DEV QUA PRD)

    You have to extract for each SID, the logical componant and use a macro in Excel to merge that:
    DEV Z_LOG
    QUA Z_LOG
    PRD Z_LOG

    is becoming :

    Z_LOG DEV QUA PRD

    ( see an exemple here : https://forum.excel-pratique.com/excel/macro-qui-transpose-et-regroupe-ligne-vers-colonne-t27550.html)

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 18, 2017 at 08:06 AM

    Hi,

    Did you found a way to get an overview of all existing logical components on Solution Manger,

    We need the same overview?

    Thanks for any help.

    BR

    Ejersbo

    Add comment
    10|10000 characters needed characters exceeded