topic Re: problem regarding BSAD and BSID table in Application Development and Automation Discussions

problem regarding BSAD and BSID table

Former Member — Thu, 19 Nov 2009 18:05:12 GMT

Hi friends,

I have a some invoice numbers say 100 invoice numbers. now my requirement is i should find weather the invoices has entry in BSAD or BSID tables.

what are the fields i need to use..

can any one let me know..

Regards

kUMAR

Re: problem regarding BSAD and BSID table

Former Member — Thu, 19 Nov 2009 18:10:52 GMT

BELNR is your required field...

Re: problem regarding BSAD and BSID table

Former Member — Thu, 19 Nov 2009 18:17:55 GMT

Hi,

can you be clear..

actaully i have vbrk -vbeln which is my invoice number..

now how should i make a check.... in bsid or bsad table

what will be the invoice field in those table bsad and bsid.

Regards

kumar

Re: problem regarding BSAD and BSID table

Former Member — Thu, 19 Nov 2009 18:22:28 GMT

No need to go to BSID and BSAD. You can get the data you need directly from BKPF and BSEG using AWTYPE and AWKEY.

Rob

Re: problem regarding BSAD and BSID table

Former Member — Thu, 19 Nov 2009 18:25:22 GMT

The check iam doing is because i have to find out what are the invoice numbers which have been flowed to financial accounting.

regards

kumar

Re: problem regarding BSAD and BSID table

Former Member — Thu, 19 Nov 2009 18:25:42 GMT

vbrk-vbeln is mapped with BELNR in BSID/BSAD...

both are invoice number..

Re: problem regarding BSAD and BSID table

brad_bohn — Thu, 19 Nov 2009 18:38:02 GMT


BELNR is your required field...

That's not necessarily true. That's a configuration dependent setting which varies by company. Many companies pass through the invoice number as the accounting document number but many do not. AWTYP and AWKEY (from BKPF) are the more correct fields, unless of course the poster knows how to verify this and can make the assumption.

As for the question, why do you need to check BSID or BSAD? The customer line item on BSEG (found after using BKPF) will identify whether the item is cleared or not.

Re: problem regarding BSAD and BSID table

brad_bohn — Thu, 19 Nov 2009 18:39:34 GMT


vbrk-vbeln is mapped with BELNR in BSID/BSAD...
both are invoice number..

How do you know that? Do you work for the same company?

Re: problem regarding BSAD and BSID table

Former Member — Thu, 19 Nov 2009 18:42:30 GMT

let him check with his system.. and let him respond please.. i am posting my view.

thank you.

Re: problem regarding BSAD and BSID table

Former Member — Thu, 19 Nov 2009 18:42:48 GMT

Just Rob said u need to start from BKPF and BSEG.

If the FI invoice is posted for the billing:

A) U need to find the FI invoice selecting the record of BKPF where AWTYP = 'VBRK' and AWKEY = VBRK-VBELN

B) U need to select the customer items from BSEG where BUKRS = BKPF-BUKRS, BELNR = BKPF-BELNR, GJAHR = BKPF-GJAHR and KOART = 'D'

C) U need to check if the item is open or cleared:

IF BSEG-AUGBL IS INITIAL.

> The item is open => the item will be in BSID

ELSE.

> The item is cleared => the item will be in BSAD

ENDIF

Max

Re: problem regarding BSAD and BSID table

brad_bohn — Thu, 19 Nov 2009 18:56:11 GMT


let him check with his system.. and let him respond please.. i am posting my view.

But again, your answer is not the correct one. As a 14 year veteran of SAP, I can tell you that I've worked with several companies that don't follow that rule. Think of not only this poster but also the person who will search for the same answer and find that your answer doesn't work for him/her. If it were me, I would have the courage to admit when I didn't give the right answer instead of 'this is my view'...

Re: problem regarding BSAD and BSID table

Former Member — Sat, 21 Nov 2009 00:25:13 GMT

> Total Questions: 16 (9 unresolved)

There is a 56,25% chance of clarifying what the context is, so I think Kumar is the problem here...

Cheers,

Julius

Re: problem regarding BSAD and BSID table

Former Member — Mon, 23 Nov 2009 12:48:47 GMT

Have patience Julius... Things cant be achieved in a day...

I Guess u havent learned SAP in a single day...!!!\

Kumar

Re: problem regarding BSAD and BSID table

Former Member — Mon, 23 Nov 2009 13:01:59 GMT

> I Guess u havent learned SAP in a single day...!!!\

Hey, Brad learnt SAP in 14 years but that is also no reason to leave questions unanswered forever (like many often are).

> Total Questions: 16 (2 unresolved)

Thank you for following up...

Cheers,

Julius

Re: problem regarding BSAD and BSID table

Former Member — Mon, 23 Nov 2009 15:21:51 GMT

Thanks for your answer MAX...

Julius questions are Resolved FOREVER.....!!!!!! Happy....

Kumar...!!!!