How to link Invoice Quantity and Confirmed quantity in schedule line

[Former Member]

Hello,

I'm working for a report in BW. The user want to compare the invoice quantity to the confirmed quantity in schedule line for a sales order.

I can't find any table linking these two fields.

Could you help?

Thanks a lot

Jeannie

[Lakshmipathi · Accepted solution]

Dear jeannie

Use query SQVI and Table Join VBEP (Field BMENG) for confirmed quantity in sale order and VBRP (Field FKIMG) for despatched quantity.

Thanks

G. Lakshmipathi

[Former Member · Accepted solution]

Hello,

Thanks for your answer.

I knew these tables and fields.

But how can I despatach billed quantity to confirmed quantity?

Best regards,

Juan

[former_member183879 · Accepted solution]

Jeannie,

You really cannot link the confirmed quantity in schedule line to the invoice quantity. At the most, you can try to link the delivery quantity to invoiced quantity if your process is delivery related billing. In this case, tables LIPS and VBRP should help you.

Else, try to link VBFA and VBUP of the items and then arrive at items levels which are billed. You cannot relate schedule lines to invoices. You can at the most related s.lines to deliveries.

[Former Member · Accepted solution]

The table that links Order to Bill is VBFA.

Also the billing (item level) table VBRP has AUBEL fiield which is nothing but the sales order no (VBAP-VBELN).

Also you have to link VBRP-AUPOS with VBAP-POSNR.

Linking VBRP-AIBEL = VBAP-VBELN

VBRP-AUPOS = VBAP-POSNR

then link

VBAP-VBELN = VBEP-VBELN

VBAP-POSNR = VBEP-POSNR

[Former Member · Accepted solution]

Hi Navaneetha,

Yes, that is what I thought.

I'd just like to have SD expert's suggestion to make sure.

In the case, I'll use routine in BW in order to despatch invoice quantity to confirmed quantity of schedule line.

Thanks for your help.

Jeannie

PS: the status in VBUP may not be input in our process.

[Former Member · Accepted solution]

You can link Invoice quantity to confirmed quantity.

Linking VBRP-AIBEL = VBAP-VBELN

VBRP-AUPOS = VBAP-POSNR

then link

VBAP-VBELN = VBEP-VBELN

VBAP-POSNR = VBEP-POSNR

[Former Member · Accepted solution]

Hi Ashish,

Yes, I tried it.

But the problem is the invoiced quanity will not despatched to confirmed quantity.

Any other idea?

Regards,

Jeannie

[Former Member · Accepted solution]

In VBRP table invoiced quantity and VBEP confirmed quantity are there. You want to compare these two figures. The link between the two table is there. So what is the problem.

[Former Member · Accepted solution]

Ashish,

When we link these two tables by Sales Order Number / Item, we would take following result:

Sales Order / Itme / Schedule line / confirmed quantity / actual billed quantity

1 / 10 / 1 / 3 / 5

1 / 10 / 2 / 2 / 5

But in fact, for Sales order/itm 1/10, we have only 5 PC billed, not 10.

When billed 5 PC, I want to despatch it to the Schedule line as 3, 2.

Regards,

Jeannie

[Former Member]

Hi Jeannie,

Right now i am facing the same problem with scheduling lines and invoiced quantitites in BI.

As this post is already quite old, i guess that you might have an solution by now ?

How did you figure it our resp. which routines did you use in BI ?

Thanks in advance for any information !

Bye,

Markus

[Former Member]

yes, As above said, u can use SQV1 (quickviewer) to merge the respective tables.