alternative for it!

[Former Member]

SELECT SINGLE posnv INTO v_posnv FROM vbfa WHERE vbeln = tvbdpl-vbeln AND

posnn = tvbdpl-posnr.

table:

MANDT

VBELV

POSNV

VBELN

POSNN

VBTYP_N

RFMNG

MEINS

RFWRT

WAERS

VBTYP_V

[Former Member]

SELECT SINGLE posnv INTO v_posnv FROM vbfa WHERE vbeln = tvbdpl-vbeln AND

posnn = tvbdpl-posnr.

table:

MANDT

VBELV

POSNV

VBELN

POSNN

VBTYP_N

RFMNG

MEINS

RFWRT

WAERS

VBTYP_V

[Former Member]

Hi,

what exactly is your question?

Regards,

Gianpietro

[Former Member]

usually select single means that you read one line because you specify a complete unique key. Sometimes it is used to read only one record of several fulfilling the where condition.

Is there a secondary key on on VBFA with VBELN and POSNN?

[Former Member]

no.

i wanted to create it..is it right thought?

[Former Member]

Hi

yes you had writen the code in correct way

select single *

from table

into table

where condition

[Former Member]

It's not incorrect, just slow. You are trying to get the preceding document from the subsequent document using document flow. VBFA is generally used the other way around. You may be able to get the preceding document number from the table you get tvbdpl-vbeln.

Rob