problem regarding BSAD and BSID table

[Former Member]

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

[Former Member]

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

[Former Member]

BELNR is your required field...

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

both are invoice number..

[brad_bohn]

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.

[brad_bohn]

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?

[Former Member]

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

thank you.

[Former Member]

Hi

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

[brad_bohn]

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

[Former Member]

> 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

[Former Member]

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

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

Kumar

[Former Member]

> 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

[Former Member]

Thanks for your answer MAX...

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

Kumar...!!!!