Interface to uplode Header & LIne Item data

[Former Member]

HI All..

Any one can help me ASAP to upload Header & line Item data Using BDC. I am confusing, how to upload both header & Line item date. How i must write the BDC. It must accept Excel file only.

. A spool request should be created at the completion of the process showing the user the document numbers that were created in the upload process. An option of viewing this request on screen or printing it should be allowed for.

· The complete spreadsheet should be pre-validated before any documents are parked. Should there be errors on the spreadsheet, then detailed information should be provided to the processor for error correction.

· The posting periods should be checked to ensure that the relevant posting periods are opened. If the posting period is not opened, then the process should end and the journal processor notified.

· If possible, the file name and location, user ID and document numbers should be stored in custom table (ZFUPLOAD) for tracking purposes. This file should be updated at the completion of the process. A check should be done against the file name stored in this table to ensure that the same file name hasn’t been previously uploaded.

Regards

Raj

[Former Member]

Raj,

A lot of requirements for a project that needs "ASAP" response.

If your main req is to use Excel, then a BDC is not the answer. I would suggest that you build a script using CATT.

As far as your other reqs of updating a custom table/checking data validatity, etc... you must write a custom ABAP program for all of that.

BDCs and CATTs do not perform: custom table updates after a record has been processed, check pre-validation, etc

A custom program must be written to met all of these reqs OR the business must agree to reduce the reqs.

[Former Member]

I'm not entirely sure, but I think that standard SAP program RFBIBL00 can be used to park documents. If it can, then this will be your simplest option. It is well documented, so have a look and see if it meets your requirements.

Rob