Skip to Content
0
Former Member
Jan 23, 2013 at 06:52 AM

Upload excel sheet

21 Views

Hello Experts,

I need to upload excel sheet as below.

Excel Sheet

S910 table

Month

SPMON

Sales Organization

VKORG

Distribution Channel

VTWEG

Area

VKBUR

Territory

VKGRP

Customer Group

KDGRP

Route

PZONE

Product Group

PRODH1

Package Group

PRODH2

Size Group

PRODH3

From the excel sheet read Area, Territory, Product Group, Package Group, UOM and refer the respective tables for values based on the description and map it to table.

Initially the upload should work on simulation mode where it should validate any mismatch in any of the data in excel with the data in their respective tables and should an error report with row and field details where there is mismatch.and also program should not upload the file to table. Program should check the excel sheet data with existing data in that period and should give an error report if the data already exists in table for that period.

The program should not allow the data to be uploaded in the past periods and it should only take data in current and future periods.

How can be able to achieve this. it ll be help full if u can provide with some piece of code.

Moderator message: We do not consider it good style to ask questions before trying to find the solution yourself.Please refer in your text also to what you have done already to solve the problem and what resources you have searched or used. Please try to avoid the impression of spec dumping.

Message was edited by: Kesavadas Thekkillath