Sales order

[Former Member]

Hai

I am creating a crystal reports from the below fields

Sold to party

Sales org

Delivery date

sales doc

item

material

order qty

netvalue

doc date

po num

Please tell which standard cube or DSo or Infoset or Mutiprovider having these fields.

Points willl be assigned for good answers

[anshu_lilhori]

Hi,

Please make use of datasources like

2LIS_11_VAITM---

2LIS_11_VAHDR--

These two datasources will give you al the relevant information.

Make a ZDSO for both the flows.

Either you can make a infoset to get the data of fields which is not available at item level or else you can do a look up as well.

Hope it helps.

Regards,

AL

[Former Member]

all above is there a standard mutiprovider?

[anshu_lilhori]

Hi,

As far as i remember there is no standard multiporivder for sales data,but i believe you can make your one based on the combination of characterstic and data you have.

ALso check this link for your refernce

http://help.sap.com/saphelp_tm80/helpdata/en/f0/3baf6718d2427a94ced005f298be06/frameset.htm

Regards,

AL

Edited by: AL1112 on Sep 15, 2011 9:11 AM

[Former Member]

Hi,

0SD_C15 - Condition Value

0SD_C04 - Delivery service

0SD_C03 - Sales: Overview

-

---

Thanks

BVR