topic Re: BSIS and BSIK table Fields in Application Development and Automation Discussions

BSIS and BSIK table Fields

former_member355168 — Fri, 04 Jun 2010 06:26:50 GMT

Dear Experts,

I m coding a Vendor GL report and using bsik and bsis table.

problem is when i check for a document ( say 1100000290 open document), i dont get any entry of prctr, bupla or secco in bsis and bsik tables. but when i chek same document in BSEG (which i don't want to use, because its a cluster table) , I get bupla, prctr and secco fields value.

Do i need to use some other tables also ?????????

Any suggestions.

Regards,

Maverick

Re: BSIS and BSIK table Fields

SuhaSaha — Fri, 04 Jun 2010 06:40:43 GMT

After selecting data from BSIS & BSIK you must be having the fields BUKRS, GJAHR, BELNR, BUZEI. Correct ?

These fields are key fields of BSEG. You can select data from BSEG using FOR ALL ENTRIES and in the WHERE condition pass the fields BUKRS, GJAHR, BELNR, BUZEI. I don't think selecting data based on key fields from cluster tables will give any performance issues.

Cheers,

Suhas

Re: BSIS and BSIK table Fields

Former Member — Fri, 04 Jun 2010 07:04:17 GMT

Check if the document is cleared, as when the document is cleared the record will not be avaliable in the tables you have mentioned.

Re: BSIS and BSIK table Fields

former_member355168 — Fri, 04 Jun 2010 07:29:35 GMT

thanks for ur reply.

I hv checked, the document is open.

Regards,

Jaspal

Re: BSIS and BSIK table Fields

Former Member — Fri, 04 Jun 2010 08:59:39 GMT

Use Substitution to insert the value in the BSIK table , also look at OSS note 112312 .

Re: BSIS and BSIK table Fields

Former Member — Fri, 04 Jun 2010 09:16:29 GMT

You can fetch from FAGLFLEXA table.

Regards,

Sai Prasad

Re: BSIS and BSIK table Fields

SuhaSaha — Fri, 04 Jun 2010 10:29:25 GMT


> Use Substitution to insert the value in the BSIK table , also look at OSS note 112312 .

Wow !!! I wonder if the OP pays heed to this post & tries implementing this solution.

Re: BSIS and BSIK table Fields

Former Member — Fri, 04 Jun 2010 13:48:18 GMT


> Wow !!! I wonder if the OP pays heed to this post & tries implementing this solution.

I've said it before and I'll say it again. This is the internet. You get what you pay for.

Rob

Re: BSIS and BSIK table Fields

former_member355168 — Sat, 05 Jun 2010 05:08:52 GMT

FaglFlexa get almost resolved the issue.