Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

*SAP Query on Vendor Master*

Hello SAP Gurus,

I have created a SAP query joining SAP tables LFM1, LFA1 & ADRCT.

The join condition is LIFNR for LFM1 & LFA1.

The join condition for LFA1 & ADRCT is ADDRNUMBER.

The query is intended to pick the following fields

Vendor, POrg, ABC indicator & Remark(field in ADRCT table)


I have 20 records created for LFM1/LFA1, but the query retrieves only 5 records which has value in remark field. Balance 15 records which had null value in remark field is not getting displayed.


Is there a way to retrieve all the 20 records, so that users can know what are the missing vendors(15) which did not have remark field updated. If I remove the join condition between LFA1 & ADRCT all the 20 records are displayed. User wants to execute the query for all the vendors for a particular PORG.

Thanks in advance for your inputs.



Former Member
Not what you were looking for? View more on this topic or Ask a question