*SAP Query on Vendor Master*

[Former Member]

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.

[paul_shrewsbury2]

Make the "Remark" field a part of your selection screen and run it for this field as >= "Blank". This should give you the 5 that have data but also the 15 where this field is empty.

Regards

[former_member182673]

When you linking multiple tables, all common fields need to be linked, then only the query will work perfectly. So link all the fields and then look for the result

[Former Member]

Hi Ramesh,

Thanks for your immediate response.

I have linked all the common fields. But still it is not working.

Any idea why this is happening.

Regards,

Narayan.