Skip to Content
Author's profile photo Juan-Carlos Garcia-Garavito

SAP SolMan Transaction Type – Table Storage Diagram

Greetings.

This is an update in old blog https://blogs.sap.com/2014/01/20/sap-charm-basic-business-transaction-table-storage-diagram/#comment-396043

The account is deactivated and the diagram was removed when that happened.  Somebody asked for the diagram again, so here is goes.


Hi there:

We created a small basic diagram that shows the main tables related to ChaRM where the Business Transaction data gets stored.

Two main component sets are part of the diagram:

  1. Business Partner, where you find the tables with data related to the BP, identification, HR related information, etc.
  2. Transaction, where you find the tables that store most of the Business Transaction related data, including our own customer developments.

It is important to mention that within each box, we placed the main table fields that server as connectors between tables, following the arrows.    Kind of foreign keys.

There is still an extra resource you may already know.  The report CRM_ORDER_READ.  In that report, you provide a Business Transaction and you will obtain the list of tables that contain records that pertain to that BT in particular.    Unfortunately, the report does not give you a connection between an RfC (ZMCR) and its own Change Objects (ZMMJs), or between either of them and their date field values.  At that moment is when the provided diagram gives you the complementary assistance to hook up the pieces together.

We hope the diagram becomes beneficial for you and any feedback to make it better is very much appreciated.

If you need a better resolution, please let me know and I will try to do my best to get it for you.

Regards,

 

Juan-Carlos Garcia-Garavito

 

 

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo GSMSUPPORT GSMSUPPORT
      GSMSUPPORT GSMSUPPORT

      Above Image is not clear. please upload a clear picture/image.

      Author's profile photo Juan-Carlos Garcia-Garavito
      Juan-Carlos Garcia-Garavito
      Blog Post Author

      Hi:

      I wish it were possible. I do not know what happened with the new SCN or SDN or whatever is the name this tool has by the time you read this message.  There use to be a way to click over the object and the PNG would become bigger and more readable.

      This is frustrating. I also have a huge diagram in Vision about SolMan 7.2 and may never be able to post it, because the new features do not allow good resolution.

      If you know a way, please share it.  I will do my best to follow.

      Regards,

      Juan

       

      Author's profile photo Jaime Rodriguez
      Jaime Rodriguez

      Very helpful information, thanks for sharing the diagram.

       

      I was able to view it in full size by using right-click and option ‘Open image in new tab’.

       

      Regards