crm table

[Former Member]

HI all

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

thanks

rajesh

[Former Member · Accepted solution]

Hi Rajesh,

Check the table

CRMD_PRICING_I

it gives Total value and net value

Please check

Regards

Apoorva Asthana

[Former Member]

Hi,

check these tables.

CRMM_PR_SALESA

CNCCRMPRSAP00090

Regards

Srinu

[Former Member]

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]

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]

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