Exclude freight charges from Net value

[Former Member]

For reporting purpose, is there a way, where freight charge could be excluded from
net value of sales, net value of sales is being pulled from VBRP - NETWR {not sure, from which table/structure is freight charge is being stored}

We are using Z condition type(ZF00) for freight

[former_member657193]

As suggested, Since you are already have the Net Value captured in the report, I hope this report is a customized report. so better to copy the same value into another column and subtract the Freight condition value from the net value. This seems to be the easiest way. With the help of ABAPer you can simply put in the calculation.

Thanks

RB

[reazuddin_md]

Hi,

Assign Subtotal against frieght cond type in your pricing procedure & While developing sales report, introuduce another column "Netvalue excl:Freight" & add piece of coding eg: Netvalue - frieght. Refer this new column for your reporting.

eg: VBRP-KZWI* - amount will store in VBRP table based on subtotals used in pricing procedure.

Regards,

Reazuddin MD