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