FK02..hELP again..

[Former Member]

Masters..

Im using FK02 for my bdc particularly in communication section ONLY. In the telephone fields you may click the arrow besides it and there will be a new window for telephone.It has an Id which is generated by the system automatically.

Now Im currently uploading my flat file one vendor code can have 1-10 tel numbers..meaning its Id will also have 1 id per telephone so the total would be 10.

it was successfully uploaded , my PROBLEM now is during its edit mode.If in case the Id in my flat file is alreadt existing in vendor master(fk02) It will just overwrite that particular line item.

I noticed that the order/sort of the Id's becomes UNSORTED.

Im asking for help to anybody to please advise me on how would I manage these scenario.I need to have those system generated ID's to be sorted or at least help me with my logic to properly overwrite those Id's that are existing already.

You may ask question to me to may it clear.

Please help me this is an urgent task help me SAPers!!!!

[naimesh_patel]

Before passing the ID from your fiel, try to check wheather the id is already exits for that vendor.

1. Go to LFA1 .. get the ADRNR

2. Go to ADR2. put ADRNR and get the maximum CONSNUMBER field. This is internally generated ID. Say you got value as 5.

3. So, change your data into your internal table so it can start form 6.

ITAB-ID = ITAB-ID + CONSNUMBER.

Regards,

Naimesh Patel

[Former Member]

Actually I was able to link in my internal table and in table adr2 those existing Id's.My problem is how would I do that in bdc..In table adr2 consnumber are sorted properly so I just insert a counter to my internal table to specify as its line item number..for example if theres 4 line items in table adr2 for a given address number I numbered those line items 1-4. If at line item number 2 meets my condition (meaning Id existing) my indicator in my bdc would be in line number 2.

Problem is the Id's during recording in BDC BECOMES UNSORTED. I was wondering why does those Id's becomes unsorted...

Please help me..what should I need to do..

[naimesh_patel]

I don't have any idea why it not going in sorted manner in BDC.

Try to sort before going to BDC.

Do one thing:

Get all records from ADR2 into your internal table.

Now, update this internal table with corresponding entry, if cirteria meets, from your file.

Now you can delete all the telephones which are there in the popup by pressing "minus" (delete entry) button in the BDC. YOu need to press this button for all the records.

After this put your records by pressing the "Plus" add entry button.

Regards,

Naimesh Patel

Regards,

Naimesh Patel