cancel
Showing results for 
Search instead for 
Did you mean: 

SAP CRM - How can I find the database table for a generic condition record?

Is there a good way to find out which database table is behind the values of a certain generic condition record? I know the database table for the condition type, but I dont see the value entries..

michael_piesche
Active Contributor
0 Kudos

enyang.wang, please follow up on your open question.

  • comment answers or your question if there are still open issues.
  • otherwise mark an answer as accepted if it helped you solve your problem
  • or post an answer of yourself and accept it if you found another useful solution yourself
  • or redirect your question to another question that is related and was useful to solve your problem
  • in the end, close your question

Accepted Solutions (1)

Accepted Solutions (1)

michael_piesche
Active Contributor
0 Kudos

There are several ways to find out what you are looking for. It mainly depends on your starting point and the rights you were granted to access the system. And also, do you just want to know the "table" or actually find it in the database.

(A) Check the Pricing Analysis in Trx. CRMD_ORDER

  1. Switch to the position of the order and open the tab "Pricing"
  2. Select your step/condition and switch to display the "Condition Rec."
  3. Select "Details" and you find the "Condition Table" from which this condition has originated
  4. If you want to find out why the condition from this table was selected and not from another table in the access sequence, switch back to "Accesses" (you might have to recalculate in order to see the trace, make sure price tracing is activated for your user with parameters PRC_CALC_TRACE = X and PRC_TRACE = X)

(B) Check conditions for condition types with Trx. /SAPCND/GCM

  1. Depending on the customizing for Maintenance Groups for condition types, you might also be able to check for all existing conditions for a condition type with the Trx. /SAPCND/GCM
  2. Here it will also make you aware of the underlying condition table
  3. However, this transaction does not automatically work for all condition types and tables of the sequences, as these must also be customized before hand
    SPRO->CRM->Master Data->Pricing->Conditions and Condition Technique->Condition Technique: Basics->Create Maintenance Group

(C) Check the Customizing and look for the database table entries

  1. Check the settings of the condition in customizing and find out the access sequence
    SPRO->CRM->Master Data->Pricing->Conditions and Condition Technique->Condition Technique: Basics->Create Condition Types (Trx. PRC_CONDTYPE_CRM)
    e.g. the Condition Type PR00 has the access sequence PR00
  2. Check the settings of the access sequence and find out the assigned condition tables that will be accessed for this sequence
    SPRO->...->Create Access Sequences (Trx. ACCESS_SEQ_CRM_PR)
    e.g. the access sequence PR00 has the assigned condition tables SAP005, SAP006, SAP006, SAP004
  3. Standard CRM/ERP condition tables are in general defined as SAPxxx where xxx is smaller than 500 which typically originate in SAP ERP. Standard CRM condition tables which originate in the CRM system can also be defined as SAPxxxxx.
  4. Custom CRM/ERP condition tables are in general defined as CUSyyy where yyy is greater than 500, and if created in CRM system, the also can be defined as CUSyyyyy.
  5. => A condition for a condition type will therefore be in one of the assigned condition tables, and which condition is triggered also depends on the access sequence
  6. The database tables for condition records you are looking for are the following:
    CNCCRMPRSAPxxx in CRM and Axxx in ERP, if it is a SAP Standard condition table
    CNCCRMPRCUSyyy in CRM and Ayyy in ERP, if it is a Custom condition table
  7. If you are looking for possible scale conditions, you will need to check the following tables:
    CNSCRMPRSAPxxx
    CNSCRMPRCUSyyy

Answers (2)

Answers (2)

former_member87164
Active Contributor

HI,

The table name depends on the condition table you have chosen while adding a condition record. Like if it is SAP001, the database table will be CNCCRMPRSAP001.

Br,

Keshav

0 Kudos

Hi, thanks for the reply! May I ask, does it always start with CNCCRMPR?

former_member87164
Active Contributor
0 Kudos

Hi,

yes might be I don't have system to check please check it your end.

Br,

Keshav