cancel
Showing results for 
Search instead for 
Did you mean: 

crm table

Former Member
0 Kudos

HI all

Does anybody have idea the table inCRM to find orders with respect to net value with in specified dates.

thanks

rajesh

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Rajesh,

Check the table

CRMD_PRICING_I

it gives Total value and net value

Please check

Regards

Apoorva Asthana

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

check these tables.

CRMM_PR_SALESA

CNCCRMPRSAP00090

Regards

Srinu

Former Member
0 Kudos

Hi Sreeni,

I am afraid these tables does not have net value for sales order.

To be clear on my question I am looking for a table where if I input date range say 10th to 25th, should get all orders with net value.

thanks-rajesh

Former Member
0 Kudos

None of these info is stored in a single table. So, even if you are reading a table, you will have to first get the Orders the particular date range (probably from CRMD_ORDERADM_H) and then try to get Net value for those Orders. Again to get the Net vlaue, you might have to pass through the link table (CRMD_LINK).

It would be easier to use FM - CRM_ORDER_READ

Regards,

Alin

Former Member
0 Kudos

hi,

CRMD_ORDERADM_H and CRMD_ORDERADM_i

are the main table for transaction related detials.

CRMD_ORDERADM_I related to the item details here the product will store.

So take that product and pass into COMM_PRODUCT it will fetch all the product related data.

Take product guid and pass into COMM_PR_FRG_ROD here you will get the FRG_GUID and pass these guid in the CRMM_PR_SALES,BBPM_PRGENERAL and CNCC* related tables.

Regards

Srinu