code problem

[former_member630092]

Hi all

i am using bsak, bsik, bseg tables, reguh .

{select * from bseg into table ibseg

where belnr = REGUH-VBLNR

and SHKZG = 'S'.}

for one reguh-belnr record it should pick one corresponding record from bseg.

it is picking multiple records from bseg.

{select * from bsik into table ibsik

for all entries in ibseg

where belnr = ibseg-REBZG.}

no data is coming in table ibsik. because bsik table nas no belnr record corresponding to

bseg-rebzg.

Thanks

[sridhar_meesala]

HI,

If you want single record to be fetched then you can use

SELECT SINGLE *

Thanks,

Sri.

[Former Member]

Hai,

Please explain what is your exact requirement, What do you want to do?

[former_member630092]

Thanks sir.

I want to display the amount entries and total . so picked the data from bseg into ibsik

{select * from bsik into table ibsik

for all entries in ibseg

where belnr = ibseg-REBZG.}

please give me some hint or sol

[Former Member]

Hello,

How you can compare bseg-REBZG with bsik-belnr.

REBZG = Number of the Invoice the Transaction Belongs to.

BELNR = Accounting Document Number

You Can do like this:

Select * from bsik into corresponding fields of table ibsik
                                        where belnr = ibseg-belnr
                                          and buzei = ibseg-buzei.

I hope it will solve your Problem.

[former_member630092]

Thanks for info.

Using f-58, when document is posted . bseg table is got updated immedietly.

But bsik table is not getting updated immediately. This condition is also not working

Select * from bsik into corresponding fields of table ibsik

where belnr = ibseg-belnr.

[Former Member]

Hi Ravi kumar,

You are comparing Invoice number with Accounting document number to get records from BSIK. Use BELNR and Fiscal year to Compare.

Regards,

Rajitha.

[SuhaSaha]

Hello Ravi,

If you are making a payment for a particular vendor using F-58. Then i think that the entry will move from BSIK (open vendor items) to BSAK (closed vendor items).

I think BSIK is not the right table to search.

BR,

Suhas

[former_member630092]

This message was moderated.