Reporting SAP

[Former Member]

Dear all, I would greatly appreciate any help in regards to obtaining "better reporting"

I am running a ZSD_ATS report which shows me every item, the historical sales consolidated per year and reported for the past three years, as well as current in-house qty. 

I am now looking for a report which will allow me to have the same information however also include current open vendor purchase orders, current client open orders and even vendor information

Does anyone know if this is a report that SAP offers (or something similar)?

Thank you and regards - Simpson

[marianoc]

Dear Simpson,

Try with FBL1N to see vendor open items.

You said:

I am now looking for a report which will allow me to have the same information however also include current open vendor purchase orders, current client open orders and even vendor information

It is not possible for us to know what do you mean when you said "same information than your non standard report ZSD_ATP.

Please elaborate your question if you want to get a response.

Kind Regards,

Mariano

[Former Member]

Mariano

Thank you for your reply and suggestion of FBL1N

The ZSD_ATS report that I had mentioned (shown below)

What I am looking for is MORE information to include:

On Order (open vendor PO’s) and possibly

Open order (open client orders) and also possibly

Vendor information (Which vendor we are currently purchasing from)

		Billings - PY-(2011)	Billings - PY-(2012)	Billings - PY- (2013)	Billings - PY YTD# (2013)	Billings - YTD# (2014)	Inventory Quantity
40515	knife	5	10	5	1,000	1,200	1,000
40600	knife	5	10	5	1,000	1,200	1,000
40601	knife	5	10	5	1,000	1,200	1,000
40509	knife	5	10	5	1,000	1,200	1,000
40612	knife	5	10	5	1,000	1,200	1,000
40502	knife	5	10	5	1,000	1,200	1,000

Any suggestions are greatly welcomed

Thank you - Simpson

[marianoc]

Hi Simpson,

I don't think there is a report in SAP with all this info. You will need to make a custom report or enhanced your actual report with the vendor information and open orders.

To see open purchase orders you can use ME2L, ME2N, ME2N, ME80FN. All these reports only show purchase orders.

Kind Regards,

Mariano