address not in kna1

[former_member229304]

We have typical case where we have integrated our 3 PL logistics, Invoices from them are processed in background by ABAP programs to replicate sales

In one case we are unable tor replicate the sales, error is customer not found but the customer is actually created.

The logic of program is

Search for 3 PL customer code in ADRC table based on field Search term 1

Then search the ADDR.no: in KNA1 table to find customer code and make invoice

In this case we have 2 records with search term 1 ,in ADRC table

System picks up 1st record, of ADDR.no: and searches in KNA1 but no customer record found.

Can anyone please tell me why ADDRno: will not be in KNA1.

[Jelena]

Table ADRC is used not just by Customer Master but in many other places (Sales Org address, Vendor address, etc.).

The logic described is not very reliable, I'd recommend to use the fields that are located directly in KNA1 (e.g. SORTL, MCOD1..3, etc.). If you stick with the extsing design, read all the records in ADRC with matching SORT1 and check each one of them against KNA1 (might need to create a secondary index for better performance). Don't stop after checking just one record.

[Former Member]

Hi,

Instead of passing just SORT1 value into ADRC table pass another value also along with search term 1(SORT1) and get ADdRNUMBER Address No. You can pass this value in KNA1 table into ADRNR field to get customer number.

Please revert in case of clarifications.

Regards,

Sharan

Edited by: SharanKumar.S on Nov 2, 2011 10:48 AM

[former_member209761]

Dear BhaveshGN,

Please input the customer code you said you have created in KNA1 as KUNNR and check whether there is any entry.

if yes, then fetch ADDRNO from KNA1 and put in ADRC and check whether there is any entry.

Also check in xd03 whether the address is maintained for the customer code.

Thanks & Regards,

Hegal K Charles