pricing report of material sold

[Former Member]

Dear Experts,

i have one requirement based on material pricing report,

the fields they were expected in reporting layout is,

produc description product family material number

the material information i founfd in the 0mat_attr

just guide me the where we can see the rest of the fields?

i searched in SDN i could not found the exact information.....plz help.

plz tell me the tables name and extractors ..

[Former Member]

Hi,

You can consult with you SD Consultants where they have maintained those information in SAP R/3 based on that you have to design your target..

Is this report based on masterdata ? Are you using Standard Material Price for calculation ? Is this report required any transaction data Involvement ?

-

---

Thanks

BVR

[Former Member]

hi ,

tanx for ur valuable reply,

this is the requirment of US sales report

actually the report also involved transaction data,

product family product descar net sales contract price

i jut want to see the table related to the fieldds and whether the data is prepopulated or not?

plz guide me how do i achieve tis?

[Former Member]

I FOUND THESE FIELDS ARE AVAILABLE IN 0PRODUCT_TEXT

BUT ITS NOT AVAILABLE IN RSA5 AND RSA6 ALSO,

PLZ GUIDE ME HOW TO FIND ?

Edited by: raazsap on Sep 26, 2011 12:14 PM

[Former Member]

Hi,

If it is sales report (Contract ) You can use cube 0SD_C05, Dso 0SD_O03 , Data Source 2LIS_11_VAITM.

-

---

Thanks

BVR

[Former Member]

wahtever the information required from data target which are all build ovet the multiprovider

but for the frond end calculation how to take contract price information?

any satandard extractor invloved?

[Former Member]

Hi,

So Sorry ... Didn't get your question !!!

What calculation you want to do in report ? What all are the KF you need to get for calculation ? If it is an attribute of a master data info object like material standard price etc. can achieve it by formula variable using processing type replacement path ...

-

---

Thanks

BVR

[Former Member]

contract price net sales qty rebate

rebate ,qty and net sales i can address through cube directly.

but contract price information how to calculate in fron end?

this field is not part of attribute to char infoobject.

regards