BSIS and BSIK table Fields

[former_member355168]

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

[former_member355168]

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

[SuhaSaha]

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

[Former Member]

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

[former_member355168]

thanks for ur reply.

I hv checked, the document is open.

Regards,

Jaspal

[Former Member]

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

[SuhaSaha]

>

> 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.

[Former Member]

>

> 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

[Former Member]

You can fetch from FAGLFLEXA table.

Regards,

Sai Prasad

[former_member355168]

FaglFlexa get almost resolved the issue.