Flat files to be loaded to SAP R/3

[pranay]

Hi All,
This is the first time i am working on SAP. I have to load the General ledger module data of SAP from flat files. What's the best way of doing it.
I in consultantion with SAP developers found there are 2 options.
1. Datastage can create the Flat files in the format as required by the SAP and land it in SAP application server. SAP developers will write the ABAP code to load the data and validate it.
2. Datastage can be connected to SAP using datastage pack for SAP r/3 and use a BAPI load stage to call a BAPI to load the data. I have'nt used this before. After reading about this in pdf it looks straight forward, but definaly i can sense a lot of issues. Does this approch handle data validation.
Has anyone worked on thsi scenarioa. if someone can share his/her experinences this would be of great help to me.
My questions here are
which approach i should follow ?
wchih one will give better performane, i have to load files with 200-300 k recs. the input file is having 200 columns.
Thanks in advanve for all ur inputs.

[sreddy]

Hi Pranay


At this phase collect the information from the Functional & Technical team.
The Function team like SAP FI + SD + MM + WM and SCM , SRM all these club with one complete Business Flow.

First you have collect information from them, then discuss with ABAP technical team. They will tell you what the tables you are going to extract or load. Then you get High level and low level of mapping document.

Ask your manager is there any standard template you guys are follow or i have to prepare.

Without knowing your Business flow how can I give my inputs.
I can also search for you related document.

[sreddy]

Hi

The code look like this.


DATA:
l_documentheader TYPE bapiache09,
lt_accountpayable TYPE TABLE OF bapiacap09,
l_accountpayable TYPE bapiacap09,
lt_currencyamount TYPE TABLE OF bapiaccr09,
l_currencyamount TYPE bapiaccr09.

* Header
l_documentheader-username = sy-uname.
l_documentheader-header_txt = 'test'.
l_documentheader-comp_code = '1000'.
l_documentheader-doc_date = sy-datum.
l_documentheader-pstng_date = sy-datum.
l_documentheader-fis_period = '06'.
l_documentheader-fisc_year = '2008'.
l_documentheader-doc_type = 'KA'.
l_documentheader-ref_doc_no = '4500000029'.

* Item
l_accountpayable-itemno_acc = '1'.
l_accountpayable-vendor_no = '0007000008'.
l_accountpayable-comp_code = '1000'.
l_accountpayable-sp_gl_ind = 'A'.
l_accountpayable-pymt_cur = 'USD'.
l_accountpayable-pymt_amt = '100'.
APPEND l_accountpayable TO lt_accountpayable.

l_currencyamount-itemno_acc = '1'.
l_currencyamount-curr_type = '00'.
l_currencyamount-currency = 'EUR'.
l_currencyamount-amt_base = '300.00'.
APPEND l_currencyamount TO lt_currencyamount.

CALL FUNCTION 'BAPI_ACC_DOCUMENT_CHECK'
EXPORTING
documentheader = l_documentheader
TABLES
accountpayable = lt_accountpayable
currencyamount = lt_currencyamount
return = return.

CALL FUNCTION 'BAPI_ACC_DOCUMENT_POST'
EXPORTING
documentheader = l_documentheader
TABLES
accountpayable = lt_accountpayable
currencyamount = lt_currencyamount
return = return.

CLEAR commit_ret.

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'
EXPORTING
wait = 'X'
IMPORTING
return = commit_ret.

[pranay]

we just have to load the FI data for GL not for FA, MM and etc..
and data needs to be loaded for just on BAPI.
Now my question is should i give flat files to SAP developer and they can load it using ABAP code or should i use datastage pack for sap r/3 and using bapi load stage to load data.
The code u have mentioned below, where can i put it or from where can i view it.

Thanks.

Hi

The code look like this.


DATA:
l_documentheader TYPE bapiache09,
lt_accountpayable TYPE TABLE OF bapiacap09,
l_accountpayable TYPE bapiacap09,
lt_currencyamount TYPE TABLE OF bapiaccr09,
l_currencyamount TYPE bapiaccr09.

* Header
l_documentheader-username = sy-uname.
l_documentheader-header_txt = 'test'.
l_documentheader-comp_code = '1000'.
l_documentheader-doc_date = sy-datum.
l_documentheader-pstng_date = sy-datum.
l_documentheader-fis_period = '06'.
l_documentheader-fisc_year = '2008'.
l_documentheader-doc_type = 'KA'.
l_documentheader-ref_doc_no = '4500000029'.

* Item
l_accountpayable-itemno_acc = '1'.
l_accountpayable-vendor_no = '0007000008'.
l_accountpayable-comp_code = '1000'.
l_accountpayable-sp_gl_ind = 'A'.
l_accountpayable-pymt_cur = 'USD'.
l_accountpayable-pymt_amt = '100'.
APPEND l_accountpayable TO lt_accountpayable.

l_currencyamount-itemno_acc = '1'.
l_currencyamount-curr_type = '00'.
l_currencyamount-currency = 'EUR'.
l_currencyamount-amt_base = '300.00'.
APPEND l_currencyamount TO lt_currencyamount.

CALL FUNCTION 'BAPI_ACC_DOCUMENT_CHECK'
EXPORTING
documentheader = l_documentheader
TABLES
accountpayable = lt_accountpayable
currencyamount = lt_currencyamount
return = return.

CALL FUNCTION 'BAPI_ACC_DOCUMENT_POST'
EXPORTING
documentheader = l_documentheader
TABLES
accountpayable = lt_accountpayable
currencyamount = lt_currencyamount
return = return.

CLEAR commit_ret.

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'
EXPORTING
wait = 'X'
IMPORTING
return = commit_ret.

[sreddy]

Hi

You can use aither of the approach

1. Provide Flatfile to SAP R/3 Developer he can load in to SAP environment by developing ABAP code.

2. You can also load data using BAPI Plug-in.


IDOC is a data container ( Inter change Document )
BAPI is a RFC Functional module.


ALE is using with in one organisation.
EDI is using when they are dealing with other vendors.

BAPI is used to update Master / transactional data in R/3

[pranay]

Which of these approcahes is better and would give good performance.
And also would be as per the standards.
Any experts who has worked on such a type of project please provide ur inputs. Eagerly waiting for your inputs.

Thanks,
pranay

Hi

You can use aither of the approach

1. Provide Flatfile to SAP R/3 Developer he can load in to SAP environment by developing ABAP code.

2. You can also load data using BAPI Plug-in.


IDOC is a data container ( Inter change Document )
BAPI is a RFC Functional module.


ALE is using with in one organisation.
EDI is using when they are dealing with other vendors.

BAPI is used to update Master / transactional data in R/3

[sreddy]

Hi Pranay

1. If you work with ABAP Team give them data in FlatFile .
Or else work with Functional people you have to update the data using BAPI Load plug-in

2. I am not sure about performance.

I can check with FI/CO consultant.

[tomato]

in my project which also involved interfacing to SAP with files, i will avoid using any stage from SAP PACK.

What i will do is, get datastage to prepare the file, and FTP the file over to SAP server and let ABAP program to handle the rest.