Skip to Content
0
Former Member
Oct 18, 2010 at 09:08 AM

Fields required for report creation

79 Views

Hi Experts,

In My report(Invoice distribution report for company wise) I need to add fields

invoice number,

invoice status,

invoice type,

invoice date,

invoice period,

customer number

account document number,

company code,amount in local,

g/l amount

currency,

customer name ,

city,

state.

I have taken tables VBRK,BSEG and KNA1.I fetch fields from these tables as follows

VBRK-invoicenumber,invoice status,invoice type,invoice date,invoice period,customer number.

BSEG-Account document number,company code,amount in local,G/L amount,currency.

I planned to join VBRK-vbeln = BSEG-Vbeln,

KNA1-customer name,city,state

I planed to join VBRK-KUNAG = KNA1-KUNNR.

In order to test whether the values are populating as expected I tried to create Quick viewer report.

When I create report using data source;table join when I add table bseg I am getting error as bseg is not used in join condition.

So I checked logical data base for these 3 tables but only for bseg and kna1 two ldb are common:BRF,DDF

My Question are:

1.How can I include BSEG in table join as data source in creating Quick viewer report.

2.If I use LDB BRF or DDF I can fetch all fields except invoice status and invoice type where other fields mentioned in VBRK can also fetch in BSEG.How can I get invoice status and invoice type in report.

3.Please let me know whether my field or table selection is wrong in creating report.

Please let me know how to get above fields in convenient way. I am waiting for your reply.

Thanks&Regards,

narasimha.