topic Re: code problem in Application Development and Automation Discussions

code problem

former_member630092 — Fri, 21 Aug 2009 05:44:08 GMT

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

Re: code problem

sridhar_meesala — Fri, 21 Aug 2009 05:48:10 GMT

HI,

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

SELECT SINGLE *

Thanks,

Sri.

Re: code problem

Former Member — Fri, 21 Aug 2009 05:58:39 GMT

Hai,

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

Re: code problem

former_member630092 — Fri, 21 Aug 2009 07:04:52 GMT

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

Re: code problem

Former Member — Fri, 21 Aug 2009 07:25:27 GMT

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.

Re: code problem

Former Member — Fri, 21 Aug 2009 07:39:55 GMT

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.

Re: code problem

former_member630092 — Fri, 21 Aug 2009 07:59:43 GMT

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.

Re: code problem

SuhaSaha — Fri, 21 Aug 2009 08:13:15 GMT

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

Re: code problem

former_member630092 — Thu, 27 Aug 2009 04:37:41 GMT

This message was moderated.