cancel
Showing results for 
Search instead for 
Did you mean: 

SAP QUERY report for vendor line items

former_member565100
Active Participant
0 Kudos

Hi

I have created a SAP QUERY report for vendor line items with fields vendor no.,vendor name,amount,company code and period.But there is one line item i donot know from wher system is getting it picked with is not in that vedor account,when i compare with fbl1n.I checked the document number too...the same doc number is twice in my query report.One with correct amount and another with wrong one.How do i chk.Where did i go wrong in creating query.I used logical database KDF.

Please advise.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member565100
Active Participant
0 Kudos

resolved

Former Member
0 Kudos

hi

please check your table join (inner or outer Join) used in your query

former_member565100
Active Participant
0 Kudos

i chked...how do we get the amount displayed in query...it just displays amount no debit credit symbol... i have selected BSEG-DMBTR field but no -/+ sign,how is it done in query,please suggest.