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

TABLE-FIELD

HELLO EVERYONE,

I HAVE A QUERY NEEDED TOBE SOLVED.

I WANT TO CREATE A Z REPORT WHICH WILL SHOW THE MATERIAL DOCUMENT NUMBER (MIGO),ACCOUNTING DOCUMENT NUMBER (MIRO),AMOUNT IN LOCAL CURRENCY (MIRO).

CAN ANYONE PLS HELP ME???

REGARDS,

INDRANIL

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 05:32 AM

    Hi

    Check in BSEG table

    XREF3 - Reference key 3 (Material document)

    BELNR - Document Number (Accounting document)

    DMBTR -Amount in Local currency (Amount)

    Vishal...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 05:29 AM

    Hi,

    You need not devlop Z report for getting this as standard document will display the settings you are looking for.

    When you open the MIRO document in the display mode, it will show the accounting document is foreign currency and go further in options and select the option of other than foreign currency the same document will be displayed in local currency.

    Please revert if any question further.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 05:39 AM

    RBKP u will get invoice dioc number

    BKPF u will get header details u will get Accounting doc no

    Invoice Document No.RBKP-BELNR

    Fiscal Year RBKP-GJAHR

    that we have got from RBKP

    Put in

    Reference Key 51000021462007 BKPF-AWKEY

    u will get Accounting doc no

    Curr u will get in RBKP-WAERS

    hope this helps

    Reward accordingly

    Add a comment
    10|10000 characters needed characters exceeded

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.