topic Re: Material Document for Accounting Document in Application Development and Automation Discussions

Material Document for Accounting Document

Former Member — Fri, 24 Apr 2009 05:52:54 GMT

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

Re: Material Document for Accounting Document

GauthamV — Fri, 24 Apr 2009 06:03:11 GMT

Plz SEARCH in SCN before posting.

Use these tables.

MKPF,MSEG,BKPF,MSEG.

Re: Material Document for Accounting Document

Former Member — Fri, 24 Apr 2009 06:03:31 GMT

check these tables

SKB1,SKA1,BKPF,BSEG

Re: Material Document for Accounting Document

Former Member — Fri, 24 Apr 2009 06:06:35 GMT

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.

Re: Material Document for Accounting Document

Former Member — Fri, 24 Apr 2009 06:07:10 GMT

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

Re: Material Document for Accounting Document

Former Member — Fri, 24 Apr 2009 06:19:05 GMT

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

Re: Material Document for Accounting Document

Former Member — Fri, 24 Apr 2009 09:37:26 GMT

Dear All

Still my problem not solved

Thanks and regards

Suresh

Re: Material Document for Accounting Document

SuhaSaha — Fri, 24 Apr 2009 09:50:19 GMT


> 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

Re: Material Document for Accounting Document

Former Member — Fri, 24 Apr 2009 09:54:50 GMT

Hi Suhas

Thanks For your Reply

Any other Table available ( Material Doc and Accounting Document)

Thanks and Regards

Suresh

Re: Material Document for Accounting Document

SuhaSaha — Fri, 24 Apr 2009 10:23:16 GMT

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