Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Vendors list based on Purchasing Block Date.

Former Member

‎2008 Aug 04 7:13 PM

0 Likes
515

Hi All,

How to list out all blocked vendors(LFA1-SPERM = 'X' ) based on Block date. I know the date is stored in CDHDR table. But is it advisable to write queries on those tables ? Or is there any other ways to get that blocking date( LFA1-SPERM field checked date ) ??

Thanks in Advance !

Hi All,

How to list out all blocked vendors(LFA1-SPERM = 'X' ) based on Block date. I know the date is stored in CDHDR table. But is it advisable to write queries on those tables ? Or is there any other ways to get that blocking date( LFA1-SPERM field checked date ) ??

Thanks in Advance !

Reply
1 REPLY 1
Read only

Jelena_Perfiljeva
Active Contributor

‎2008 Aug 04 10:27 PM

0 Likes
357

To my knowledge, CDHDR is the only table where this date could be found - you are correct.

It would be rather inefficient to query the table CDHDR, especially in an ad-hoc report, so you are right again. The possible ways to avoid this:

a) tell the customers that there is no such date and it's not feasible

b) add a custom (Z) field to EKKO, which will have to be filled in when blocking the vendor

c) run a program in background and gather information from CDHDR into a Z table and then in the report use Z table instead

None of the solutions is perfect, unfortunately. 'A' is my personal favorite.

Good luck!