Upload excel sheet

[Former Member]

HI

i need a help regarding a requirment like Upload excel sheet to SAP to create sales order, can it be done

regards

subhrangshu

[Former Member]

thanx guys

[Former Member]

Hi

Yes it is possible. Contact your ABAP consultant regarding this.

You can use BAPI or GUI UPLOAD functionality of SAP.

[Former Member]

hi,

yes, it is possibe.

===like this :

PARAMETERS: p_datei LIKE rlgrap-filename OBLIGATORY.

DATA: len(15) TYPE p,

rec(300).

OPEN DATASET p_datei FOR INPUT IN TEXT MODE ENCODING DEFAULT.

DO.

READ DATASET p_datei INTO rec LENGTH len.

IF sy-subrc NE 0.

EXIT.

ENDIF.

SPLIT rec AT ';' INTO

w_umst-team

w_umst-pstlz

........

ENDdo.

CLOSE DATASET p_datei.

====

The excel - sheet should be *.csv and within the text, there should be no ';' sign. otherwhise the split will not work correctly.

hans

[former_member315051]

you can use xl sheet to create sales orders through BDC Programs , check with your ABAPer for formates etc.

Regards,

Ramesh

[Former Member]

hi ramesh

thanx for the reply can u please provide me the formate it will realy help my problem

regards

subhrngshu

[former_member315051]

It is depends on the program, so check with your ABAPer , he only help you regarding the format.

Regards,

Ramesh

[Former Member]

Hi,

Please check the below program and FM with help of ABAPer, usefull for creating the sales order.

Program:

MWWMJF21_BAPI_SALESORDER_CREAT

FM:

BAPI_SALESORDER_CREATEBOS

SPP01_SALESORDER_CREATE Create Sales Order

ISIA_RLOEPM_SALES_ORDER_CREATE Create a sales order for a date and an account

BS01_SALESDOCUMENT_CREATE Creation of a Sales Document with BOS

BS01_SALESORDER_CREATE Sales Order: Create with BOS

ISP_SALES_HEADER_CREATE

ISP_SALES_ITEM_CREATE

ISP_SALES_SCHEDULE_CREATE

ISM_SALES_ORDER_CREATE

with regards

Vivek.