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)

Problem:

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.

Request:

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.

Regards,

Narayan.

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