Excel sheet data going mismatch while uploding using bdc

[former_member612655]

Hi Experts,

I had an requirement to update zuonr and sgtxt fields from excel sheet to sap using bdc call transaction method. Apart from those two feilds my excel sheet containing remaining feilds as follows transaction type, utr number, payment date,

instrument amount,name of benificiary, bank account num,bank code, debit account num,maker id, first approver, second approver, document num, company code, and fisical year.

I declare all those fields in excel sheet order, but when i uploading excel file into sap the data is going mismatch that means in the place of document number ,company code and fisical year it takes another feild data in that excel sheet .

Can you please help me to resolve this problem.

Begards,

Bhavani

[former_member698447]

Hi Bhavani,

I have faced this type of issue earlier as well, Kindly check the fields that have missed out any in Flat File

I would more suggest check the recording if possible or try to create a new recording with the help of functional consultant.

Best Regards,

Repakula Manoj

[former_member612655]

Thank you for reply but my exact problem is given below. Can you please help me to resolve this.

I have to use only 5 fields(not in order) of an excel input file out of the 15 fields the file contains. Customer will not change the structure of the file. Moreover, I know the datatype of only the 5 fields that I intend to use and not the rest. Is there anyway I can upload the file and use it without knowing the datatype of the fields I dont wan to use ? Is there anyway I can upload only the fields I want and not the remaining without changing excel structure ?.How do I handle this ? Kindly let me know. I am trying to avoid going back to the customer asking the datatypes.

[former_member698447]

Hi Bhavani,

First of all don't change the file format, Use the same format how it has been recording.

Now the fields which you dont want to use leave it blank but make sure its not mandatory fields.

Now enter the data which you want to use.

Best Regards,

Repakula Manoj

[former_member612655]

Actually my excel sheet order is given below .I need to update sgtxt and zuonr fields in excel sheet into sap using fb09 t_code where belnr, bukrs,gjahr are madatory feilds. My bdc recording feilds order and excel sheet order is not same .As per my requirement i am not allowed to change the excel sheet order. Is there any way to find out this

Excel Sheet Order:

Transaction Type ,Status Of Transaction(sgtxt), CMS Bank ref no(zuonr), UTR Number ,Payment Date ,Instrument Amount ,Name of Beneficiery ,Beneficiery Bank Code, Beneficiery Bank Account No., Debit Account No,. Maker ID First Approver, Second Approver Unique reference number(belnr), Company Code(bukrs) ,Fisical Year(gjahr).

[RaymondGiuseppi]

Map the unknown fields to some dummy text fields, and don't use those fields in the BDC.

What's your exact problem?