Material Document for Accounting Document

[Former Member]

Dear Gurus

I need one report like following

materialdocumentno accountingdocumentno gl amount

Selection parameter: Material Document No and Year

any standared report available ? or which table available those fields

Thanks and Regards

Suresh

Edited by: suresh kumar on Apr 24, 2009 7:56 AM

[GauthamV]

Plz SEARCH in SCN before posting.

Use these tables.

MKPF,MSEG,BKPF,MSEG.

[Former Member]

check these tables

SKB1,SKA1,BKPF,BSEG

[Former Member]

HI,

Check table

Accounting documents

BKPF Accounting document header

BSEG Accounting document segment

BSET Tax data document segment

BSEC One-time account data document segment

Material document

MKPF Header: Material Document

MSEG Document Segment: Material

BSIM Secondary Index, Documents for Material

General ledger accounts

SKA1 G/L accounts master (chart of accounts)

SKAS G/L account master (chart of accounts: key word list)

SKAT G/L account master record (chart of accounts: description)

SKB1 G/L account master (company code)

SKM1 Sample G/L accounts

SKPF Header Data: Inventory Sampling

Regards,

Mansi.

[Former Member]

Hi Suresh,

Select the data from MKPF & MSEG and follow to BKPF & BSEG tables...

and always use joins in these cse than For all entries for a better performance....

As i faced the same problem once,,,

Thanks & regards,

Dileep .C

[Former Member]

Dear All

Thanks For All Replys

BKPF-AWKEY this field stored material document and year but this field is not a key field so we are facing performence issue what can i do?

Thanks and Regards

Suresh

[Former Member]

Dear All

Still my problem not solved

Thanks and regards

Suresh

[SuhaSaha]

>

> Dear All
> 
> 
>  Thanks For All Replys
> 
> 
>  BKPF-AWKEY this field stored material document and year but this field is not a key field so we are facing performence issue what can i do?
> 
> 
> 
> Thanks and Regards
> Suresh

Hello Suresh,

What are the input parameters to the report? May be you can add some fields to the selection-screen like Company Code, Fiscal Year etc.

Hope this helps.

BR,

Suhas

[Former Member]

Hi Suhas

Thanks For your Reply

Any other Table available ( Material Doc and Accounting Document)

Thanks and Regards

Suresh

[SuhaSaha]

Hello Suresh,

AFAIK the tables to be used are MKPF & BKPF. I donot know if there are any tables which have a consolidated data from these 2 tables.

BR,

Suhas