Fields required for report creation

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi ,

In BKPG I can get account document number,compnay code but again where i can fetch g/L account number,amount in local .

Regards,

narasimha.

[Former Member]

Hi,

using logical database allows you to get the BSEG-entries (account number, amount in local currency,...)

best regards, Christian

[Former Member]

Hi ,

But how to include fields from vbrk ite invoice number,invoice category,billing date,net amount(netwr),

Regards,

narasimha.

[Former Member]

Hi,

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.?????

Is it possible to add Vbrk to brf logical data base??

Please tell me how to do it if possible??

Regards,

narasimha.

[Former Member]

HI,

it works like that (you can add fields, tables,...) to logical databases).

1: create an infoset (SQ02) based on LDB BRF, tick "Extras"

2: in "Additional information on node" select BKPF

3: tick the "create" icon and add additional table VBRK, define the join condition from BKPF to VBRK (as discussed above)

best regards, Christian

[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.