Report with customer info for an Sales Order with batch details

[Former Member]

Hi

Can any one please tell me the SAP REPORT with contains data of customers were shipped a specific product (material number) by batch number. report with the name and address of the customer, the sales order number and the number of products that were shipped.

Thanks

Nick

[former_member575786]

Try MB5C

[Former Member]

Hi nick,

See if anybody has worked on SIS (sales information system) in your team.

He can help you out to create one info structure , by selecting desired characteristics, key figure with respective update rules. though its require lot of configuration but you can make it without abap development.

(I couldn"t make it in time to provide you detailed configuration but below given path will take you to the configuration area )

IMG - LG -Logistick information system -logistick data werhouse- data basis- field catalogue.

IMG - LG -Logistick information system -logistick data werhouse- data basis -

infostructure.

IMG - LG -Logistick information system -logistick data werhouse- data basis - updating - update defination & update rules.

( MC18, MC21, MC24,& MC30)this transaction help to create field catelogue, info system, update rule & generation log respectively.

karnesh

[Manoj_Mahajan78]

Hi...you will not get such std report..also all info is not there in one single table..

As Laxmipathi explained that is the quite easier way..If it doesnt work you will have to do ABAP development.

Regds

MM

[Former Member]

TRY SDO1 and BMBC.

[Lakshmipathi]

Dear Nick

Through <b>SQVI</b> by Table Join <b>KNA1</b> (for customer address) and <b>VBRP</b> (for material code, qty shipped) you can get the datas in brackets.

To get the sale order number of the respective billing document, once again you have to use <b>SE16</b> with table name <b>VBFA</b> where you need to give billing document references in "Follow on doc" and "<b>C</b>" in "Prec doc categ" field.

If this is going to be a regular practice, you need to develop a report capturing the above tables.

Thanks

G. Lakshmipathi

[Former Member]

Hi,

There is no such report available in standard, you may have to develope on your own.

Regards,

Murali