Sales Report for One Time Customer

[Former Member]

Hi everyone,

I'm just new user of SAP FICO.

Please help me on how to display a Sales Report with One-Time Customer Details ( Name and Tax No.).

The current report I'm using is displaying the regular customer name but for One-Time customer have no details.

Thanks in advance for your reply.

Thanks,

Jeffrey

[moazzam_ali]

Hi Jeffrey Lopez

You have to check whether it is ABAP report or query report. If ABAP then seek the help of ABAPER and if query then create your own. In you current report data is coming from KNA1 table. You need to fetch it from ADRC table. For sales order take ADRNR from VBPA table and pass it to ADRC table in ADDRNUMBER field. You would see name and city details which you have entered for onetime customer in pop up screen.

Thank$

[siva_vasireddy2]

Hi,

you need to take the Data from the transaction instead Master data,as the One -time customer name is changed in the sales order during creation

you can do the report by yourself in SQVI by taking the Logical Database-VAV