cancel
Showing results for 
Search instead for 
Did you mean: 

CRM -> BI Status Extraction

Former Member
0 Kudos

Hi, users decided to use in transaction BP folder Status and use Status scheme BUP (Business Partner).

Unfortunatelly I can't find any table, where to find it or how to Extract it.

When I load data from 0CRM_STSMA and 0CRM_USSTAT, I Got the text to the statuses, but I cannot any datasource or way how to do an generic extractor, to obtain relation Business partner - Schema/Status.

Can You help me please?

Thank You a lot.

Accepted Solutions (1)

Accepted Solutions (1)

ravikanth_indurthi
Active Contributor
0 Kudos

Hi,

Check CRMD_ORDERADM_H, CRM_ORDER_INDEX and JCDS tables for linking User status and Business partner with GUID as key.You can create a view based on these and do a generic extraction.

Hope this helps............

Rgs,

Ravikanth.

Former Member
0 Kudos

I have fouond it just 10 minutes ago, then check the Forum

Thabx a lot.

Answers (1)

Answers (1)

Former Member
0 Kudos

go to the BI customizing (transaction SBIW) in your source system (in your case CRM I suppose)

then go to Settings for Application-Specific DataSources (PI Basis) (or something similiar... this is an example from ECC 6.0)

open Status Concept for BP/Product/CRM Objects

read the documents for each transaction... that should enable you to determine what to do