Tuesday, 3 October 2017

CRM status management important table

I record down my self study notes here in order to be used in the future.

TJ01: Business Transactions definition

TJ02: System status definition. For some of entries in this table, the corresponding constants are defined in include CRM_STATUS_CON

SAP CRM, SAP Certifications, SAP Learning, SAP Tutorial, Material and Certification, SAP Live Access
SAP CRM, SAP Certifications, SAP Learning, SAP Tutorial, Material and Certification, SAP Live Access

TJ03: status object type definition. Storage table for tcode BS12, see screenshot below:

SAP CRM, SAP Certifications, SAP Learning, SAP Tutorial, Material and Certification, SAP Live Access

TJ04: define initial status for system object. For example, I1002 ( open ) is defined as initial status for status object COH ( CRM Order Header ). Due to this setting, every time you create an order, it always has open as initial status.

SAP CRM, SAP Certifications, SAP Learning, SAP Tutorial, Material and Certification, SAP Live Access

TJ05: Permitted transactions per object type

For example, status object COH has totally 369 permitted business transactions. The system status bound with a unpermitted business transaction will not appear in status drop down list in WebUI.

SAP CRM, SAP Certifications, SAP Learning, SAP Tutorial, Material and Certification, SAP Live Access

TJ06: System statuses set/deleted by process

For example, the following report checks whether a given user status is actually mapped to Completed system status I1005 or not.

REPORT order_is_status_completed.
PARAMETERS: t_type   TYPE crmd_orderadm_h-process_type OBLIGATORY DEFAULT 'OPPT',
            i_status TYPE crm_j_status OBLIGATORY DEFAULT 'I1001'.
DATA lt_sys_stat          TYPE TABLE OF tj06.
DATA lv_status_profile      TYPE j_stsma.

SELECT SINGLE user_stat_proc FROM crmc_proc_type INTO lv_status_profile
  WHERE process_type = t_type.
CALL FUNCTION 'CRM_WAP_GET_OPP_POSSIBLE_STAT'
  EXPORTING
    iv_stat           = i_status
    iv_user_stat_proc = lv_status_profile
  TABLES
    et_06             = lt_sys_stat.
READ TABLE  lt_sys_stat WITH KEY istat = 'I1005' inact = abap_false TRANSPORTING NO FIELDS. "check system status is complete
IF sy-subrc = 0.
  WRITE:/ 'This status is Completed Status'.
ELSE.
  WRITE:/ 'This status is NOT Completed Status'.
ENDIF.

Can you tell the answer that for status profile CRMOPPOR below, which user status is actually mapped to system status I1005?

The answer is COMP ( Completed – Jerry ), since it is assigned with business transaction CCOR,

SAP CRM, SAP Certifications, SAP Learning, SAP Tutorial, Material and Certification, SAP Live Access

And there is one entry for CCOR and I1005 in this TJ06 table.

SAP CRM, SAP Certifications, SAP Learning, SAP Tutorial, Material and Certification, SAP Live Access

TJ07: Influence of system status on transactions

For example, this entry below means it is not allowed to perform transaction ARCH ( Archive ) if order has status I1002 – Open.

SAP CRM, SAP Certifications, SAP Learning, SAP Tutorial, Material and Certification, SAP Live Access

This table is part of storage table for tcode BS22 – maintain system status

SAP CRM, SAP Certifications, SAP Learning, SAP Tutorial, Material and Certification, SAP Live Access

TJ21: Permitted object types for status profile
For example, status profile is only allowed for status object type COH.

SAP CRM, SAP Certifications, SAP Learning, SAP Tutorial, Material and Certification, SAP Live Access

TJ30: storage table for tcode BS02 – Maintain status profiles
Compare the content of this table with tcode BS02:

SAP CRM, SAP Certifications, SAP Learning, SAP Tutorial, Material and Certification, SAP Live Access

SAP CRM, SAP Certifications, SAP Learning, SAP Tutorial, Material and Certification, SAP Live Access

CRM_JSTO: assignment of object with its status object type

If you would like to get a statistics for example which combination of status object and status profile has been used most of the time in your system.

For example, the screenshot belows show in my system there are totally 69436 objects which has used object type MPL and empty status profile for status management.

SAP CRM, SAP Certifications, SAP Learning, SAP Tutorial, Material and Certification, SAP Live Access

CRM_JEST: object guid and all of its status value
SAP Online Guides, Tutorials, Materials and Certifications.

Related Posts

11 comments:

  1. Good Post. I like your blog. Thanks for Sharing
    SAP CRM Training in Noida

    ReplyDelete
    Replies
    1. Looking for the best SAP Ariba Training in Bangalore, then don't delay join IntelliMindz SAP Ariba Training in Bangalore. Join our SAP Ariba training to get hands-on training and practice in SAP Ariba Software. Any Queries call @ 9655877677. IntelliMindz is the best IT Training Institute in Bangalore with placement, offering 200 and more software courses with 100% Placement Assistance.
      SAP Ariba in Bangalore
      SAP Ariba in Chennai
      SAP Ariba Online Course

      Delete
  2. I truly appreciate this post. I’ve been looking all over for this! Thank goodness I found it on Bing. You have made my day! Thanks again! Keep update more excellent posts..
    CRM Software in Dubai
    CRM Software in UAE
    CRM Software
    Best CRM Software
    Customer Relationship Management Software
    CRM Software for Small Business

    ReplyDelete
  3. Thank you for the sharing ....I saw your post its fine We at WebCRS Travel are always willing to provide our expertise in assisting you with our crm for travel with inbuilt TravelCRM that can help you immensely in survival during lockdown and quick recovery afterwards. Go to our website for more details:http://www.webcrstravel.com/

    ReplyDelete
  4. This post is extremely radiant. I extremely like this post. It is outstanding amongst other posts that I’ve read in quite a while. Much obliged for this better than average post. I truly value it! sap institutes in hyderabad with placements

    ReplyDelete
  5. Thanks so much for sharing this awesome info! I am looking forward to see more postsby you! singapore best management training

    ReplyDelete
  6. This article is an appealing wealth of informative data that is interesting and well-written. I commend your hard work on this and thank you for this information. You’ve got what it takes to get attention. check more info about management training

    ReplyDelete
  7. Very nice article, I enjoyed reading your post, very nice share, I want to twit this to my followers. Thanks!. best singapore management training

    ReplyDelete
  8. Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It’s always nice when you can not only be informed, but also entertained! management training course

    ReplyDelete
  9. They ought to not be manufactured usage of When you are Expecting or nursing. management training in Singapore

    ReplyDelete