Application Development 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: 

Regarding blocked customer table information

Former Member

‎05-24-2008 6:34 AM

0 Kudos

Hello,

I blocked some customers using xd05 tcode. Now i want to get the information the blocked customer information. Actually all the screen feilds are in one structure RF02D. So now from which table i could fetch data. based on that i need develop the collection report.

Thank you

2 REPLIES 2

Former Member

‎05-24-2008 12:36 PM

0 Kudos

Hi,

check table KNA1 and search for block.

Cheers.

...Reward if useful.

vinod_vemuru2
Active Contributor

‎05-24-2008 1:19 PM

0 Kudos

Hi Ravi,

U can block the customer at various levels eg: Only for creating/changing Orders, Delivery, Billing etc.

Go to table KNA1. Here u have various fields for various reasons. Select the data based on ur requirement. If it is vendor then u can check in table LFA1.

Have a look at fields AUFSD,FAKSD, LIFSD, SPERR, SPERZ,CASSD, NODEL, J_3GBLSPER in KNA1 table.

If u want to display customer who is blocked for any one of the above reasons then u can write a select on kna1 with where clause having all the above fields NE space(Or condition).

Thanks,

Vinod.