How to load data from MS Excel sheet to SAP by using BDC method ?

SAP, SD, BDC, Human Resource questions and answers

(Continued from previous question...)

How to load data from MS Excel sheet to SAP by using BDC method ?

KCD_EXCEL_OLE_TO_INT_CONVERT even takes care of blank cells and is available in older versions of SAP

* Add values to internal table
SORT t_cells BY row col.
LOOP AT t_cells INTO wa_cells.
MOVE : wa_cells-col TO l_index.
ASSIGN COMPONENT l_index OF STRUCTURE itab TO <f_value>.
MOVE : wa_cells-value TO <f_value>.
AT END OF row.
APPEND itab
CLEAR itab.
ENDAT.
ENDLOOP.

(Continued on next question...)

Other Interview Questions

• What is the purpose of text determination, account determination, partner determination, output determination,storagelocation determination
• What are the five imp fields to be maintained in account determination
• How to create excise invoice and what is it
• What is meant by transfer of data from legacy code to sap Legacy Code ?
• What do you do really in pricing determination, and what are the main deifferences between pricing procedures?
• What type of reports generally a support consultant maintain and report
• What are interfaces used generally an indian organisation which is in retail business and and which is in banking business and oil business.
• What is the purpose of shipping point determination not menu path
• What and where types of copy controls we change
• How to and where to maintain copy controls
• What is purpose of maintaining common distribution channels and common divisions
• What is the difference between the Avaialbility check 01 (Daily requirement) and 02 (Individual Requirement) in material master?
• We are in the service industry and have employees working in multiple cities on the same day ....
• We use clocking machine for recording employee clock-in/out ...
• We want to make a copy of an organizational structure from one plan variant to another ...
• What is the best way to handle this?
• We plan to use Personnel Development( PD). What is that we have to consider in this case?
• How can we configure the options for the Assgn Form ....
• Should RFFOUS_C produce an accounting entry to debit the payroll payable account and credit the cash account ?
• Which is the best way to configure basing eligibility for HMO's on zip codes?
• Why the value is not displayed after modification?
• Difference between /N and /BEND ?
• SM35 transaction . How to automate BDC ?
• Update types in Call transaction method. What is the difference ?
• What are the table controls in BDC ? What is the difference between bdc and lsmw ? What is the difference between bdc and rfc ?
• Data conversion experience?
• Open datasets, Read datasets ( Reading and writing data to files)?
• How to do back ground processing in BDC Session method ?
• Call transaction method, how to capture the errors ?
• How to load data from MS Excel sheet to SAP by using BDC method ?
• What is the difference between call transaction and session method?
• SM35 transaction . How to automate BDC ?
• What is the difference between Upload and WS_Upload ?
• If I want to excute a program only in background not in forground is there any option for this?
• What kind of BDC programs are written ?
• How to read files and process BDCs automatically?
• In session method sy-subrc is not returned whereas in call transaction method sy-subrc is returned . what does it mean?
• Recording Function
• BDC vs Direct Loads( have you used direct loads on SAP tables )
• Have you set up a back ground job ? How to create a background job without a variant ?