Need vendor report for district/county

[Former Member]

I am looking to pull a report for a vendor by district/county.

If possible, jurisdiction code would be nice.

I was looking at a range of reports around S_ALR_87012087 but none include district. Even vendor search doesn't have this function.

Thanks!

[Former Member · Accepted solution]

Dear Michelle Lansky

In the same t-code S_ALR_87012087, go to dynamic selection (Shift + F4) and select the required fileds like country etc.

Thanks & Regards,

VB

[Former Member · Accepted solution]

Thanks for your response.

However, these are US addresses and County isn't listed. In SAP, the field is listed in XK03 as District (City2 is technical field name).

I only need County.

[Former Member · Accepted solution]

You can create a query in SQ01 or do a direct table read using SE16 on table LFA1. District is field LFA1-ORT02. That is where the county should be populated.

Regards,

Tara