Skip to Content
author's profile photo Former Member
Former Member

Fields required for report creation

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2010 at 09:50 AM

    Hi,

    1: thats SAP standard, BSEG cannot be table- joined.

    2. use LDB BRF, add table VBRK to table BKPF (not BSEG, VBRK and BKPF are header tables, BSEG is a line item table) in the infoset based on LDB BRF.

    I don't know which tables contain "invoice status and invoice type " but guess you can join this info to VBRK also.

    Best regards, Christian

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      As you suggested when i am creating query using tables bseg,bkpf and kna1(logical database BRF) and vbrk,i am getting error as "query Specifications cannot be used to generate list" in SQ01.I linked BRF logical database with vbrk by using condition vbrk-vbeln = bkpf-awkey.

      Is my condition is wrong in linking VBRK to BRF logical database.please guide me how to solve this.

      If my joining is wrong means why I didn't get error in SQ02.??

      Required fields are:Invoice number(vbrk),invoice category(vbrk),invoice date(vbrk),account document number(bkpf),company code(bkpf),G/L account(bseg),currency(bseg),state(kna1),invoice amount(vbrk).

      Do i picked fields from wrong tables?

      Regards,

      narasimha.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.