Details Of One TIme Customers

[Former Member]

i want to know the details of ONE TIME CUSTOMER such as SALES AREA,SALES ORG ETC. fROM WHICH TABLE I CAN GET IT

[Former Member]

Hi Dheeraj

Customer Details can be extracted from table KNA1. There is a field: XCPDK in this table which identifies whether ONE TIME customers.

For their sales data you can go with these customer to table KNVV.

Maybe below code can help you to understand:

  select a~kunnr a~name1 a~adrnr b~vkorg b~vtweg b~spart ...
         into table itab
         from kna1 as a
         inner join knvv as b
         on a~kunnr = b~kunnr
         where a~kunnr in s_kunnr
         and   a~xcpdk = 'X'. <b>-> One time Customer</b>

Kind Regards

Eswar

[former_member404244]

Hi Dheeraj,

check the below tables for one time customer/account..

KNA1,LFA1,VBPA,VFPA,VTPA.

Regards,

nagaraj

[Former Member]

One time accounts are handeled differently than normal customers. Go to table BSEC with the company code, FI document number, fiscal year, and line item number.

Rob

[Former Member]

hi dheeraj nadamwar,

A term for a collective master record used for the processing of transactions involving miscellaneous customers with whom you do not regularly do business.

When you record a transaction involving a one-time customer, you must enter the customer data manually.