query for Credit Memo

[Former Member]

Hi,

I was working to a query in order to collect all the information related to credit memo request and credit memo.

Can you please advise to me which tables is better to join?

many thanks for your help

[Former Member · Accepted solution]

Credit memo Request is a kind of Sales Order - so all sales order relevant tables are applicable depending on requirement.

As mentioned in the post above - credit memo is a kind of billing doc. - so all billing tables are applicable.

In both the above cases the Order Type and Billing Type would be the differentiating factor. For the tables refer -

http://www.sap-img.com/sap-sd/important-tables-for-sap-sd.htm

Thanks

[Lakshmipathi]

Please search the forum before posting.

For Credit Memo Request, consider VBAK for header data and VBAP for item data

For Credit Note, consider VBRK for header data and VBRP for item data

thanks

G. Lakshmipathi

[Former Member]

THANKS FOR YOUR HELP

After I selected tableVBAK for header data and VBAP,VBRK,VBRP how I have to join it.

I can't understand how from VBak (that is both for sales document and credit memo request) I can choose only credit memo request.

can you please advise me?

[Lakshmipathi]

how I have to join it

Through SQVI, you can join the said tables.

I can choose only credit memo request

Maintain Document Category as "K" in VBAK and execute SQVI

thanks

G. Lakshmipathi

[Former Member]

sorry,

I get an error.

thanks

[Former Member]

Hi,

VBAP table has to be joined with VBAK table. Also VBRK should be joined with VBAK table only. and the VBRP table should be joined with VBRK table. In the selection screen u need to pass the document category and the creditmemo request number. In a way VBAK table is ur main table.

This should work.

Regards,

Deepak

[Former Member]

Hi,

Credit memo is nothing but a billing document, so all the billing documents created and saved are stored in table VBRK and VBRP

so you can take data from this table

When you writing querry then on selection screen there should be selection for billing document type.

So user can select billing document as CREDIT Memo and execute.

Kapil

Edited by: Kapildev Farakte on Mar 8, 2011 2:54 PM