Net condition value checking without sales order

[former_member377333]

Dear All,

I'm having more condition value for a single material.

Like MRP, Dealer Margin, Freight value. [ 100(MRP)- 5 (Dealer Margin)+15(Freight) = 80 (Net)]

We need to verify the condition value for a customer (not through  Sales Order booking)

how to get this in SD, pl guide me.

Regards,

Sarran

[former_member211556 · Accepted solution]

Hi Saran,

Try using the t-code V_NL. This will help you to find net price for a given customer and material combination based on your pricing procedure.

Regards

[former_member209761]

Dear Sarran,

Can you explain your requirement a little further.

Maybe post the screenshot of your condition tab and explain whats the requirement.

Thanks & Regards,

Hegal K Charles

[former_member377333]

Hi,

See the Sales Order Item data condition value.

Having many condition values, we need to see the Net condition value.

but not in Sales Order screen.

Regards,

Sarran

[former_member209761]

Dear Saran,

Having many condition values, we need to see the Net condition value.
but not in Sales Order screen.

You mean you need some report to see the Condition values coming against the different condition types like ZMRP,ZTRD,ZBPT etc?? or the summation of all the condition values??

I am not able to understand your requirement.

Thanks & Regards,

Hegal K Charles

[Former Member]

hi,

check the pricing procedure because Yellow sign means condition can not pick the value and which are  green that conditio value is picked

[Shiva_Ram]

Try with function module PRICING in SE37.

Regards,

[former_member377333]

Dear Hegal K Charles,.

Yes, I need a report as the summation of all the condition values.

Regards,

Sarran

[former_member377333]

Hegal . K . Charles wrote:
Dear Saran,
Having many condition values, we need to see the Net condition value.
but not in Sales Order screen.
You mean you need some report to see the Condition values coming against the different condition types like ZMRP,ZTRD,ZBPT etc?? or the summation of all the condition values??
I am not able to understand your requirement.
Thanks & Regards,
Hegal K Charles

Dear Hegal K Charles,.

Yes, I need a report as the summation of all the condition values.

Regards,

Sarran

[former_member209761]

Dear Sarran,

You can create a Zreport for the requirement.

Logic : You have to decide on the selection parameter like date or billing types etc.

System will fetch all the billing documents from table VBRK based on the above selection.

Now in VBRK, you will get a condition record No KNUMV.

Put this condition record No in Table KONV .

You will get the list of all the condition types and their respective condition values.

You can ask the abaper to do the summation on each record (KNUMV)  basis.

Check and revert back.

Thanks & Regards,

Hegal K Charles

Message was edited by: Hegal . K . Charles