Table files for BAPI

[Amos.Rosmarin]

Hi,

I want to pass tables activated as input into a BAPI output link.
I see the expected columns in the LOG tab.

What is the file format expected by the stage (fixed, delimited...)
What it the charset of this file (unicode, none or project default)



Thanks,
Amos

[tomato]

depends on BusinessObject / FunctionModule setting in SAP side. Normally is "|" delimetered...

[Amos.Rosmarin]

Hi

many thanks

Can you give some instructions for howto determine the file format ?

The problem is that I the BAPI stage does not even look at the files
it looks only at the content of the input.txt
if the input.txt is empty the job finishes without doing anything and ignores the files I prepared.

If it will help, I try to load master recipe reference (S) data.

Thank
Amos

[tomato]

i am not quite getting what u mean here....

is the BAPI stage as Source or Target?....can roughly draw out ur job structure?

Regards.

[Amos.Rosmarin]

The job looks like this:
bapi stage ---> return file

I expect the bapi to read the source data from files in the TABLE stracture
There are no input parameters
I marked the RETURN table for output

I'll leave you a message, can you please look at it ?

Thanks
Amos

[Amos.Rosmarin]

Maybe i'll try to elaborate:

The BAPI stage as output link.
The BAPI I want to use as 4 tables,
2 tables marked for input :
(I) SELECTION
(I) SELECTIONFIELDS

And 2 tables marked for output :
(E) RESULTDATA
(E) RETURN

My question is on the input tables data:
1.) How does the BAPI stage accepts the data for SELECTION, SELECTIONFIELDS ?
2.) I assume it expects files with the names SELECTION.txt and SELECTIONFIELDS.txt am I right?
3.) Where should I put those files ?
4.) What is the file format (delimiter, quote char, NLS, header row ...)


Thanks,
Amos

[tomato]

can try the follows:

- put the value for CURRENCYTYPE, MAXRECORD, OPERATINGCONCERN in Input.txt

- place the SELECTION.txt and SELECTEDFIELDS.txt in "C:\Ascential\DataStage\DSSAPConnections\BRIT_POC\BAPIs\Extracts\COPAQuery.GetCostingBasedActualData\" directory

- example of SELECTION.txt
VRGAR |I |EQ |F |
PERIO |I |BT |1999001 |1999012
SPART |I |EQ |01 |

- example of SELECTEDFIELDS.txt
VRGAR
PERIO
SPART
ARTNR
ABSMG
ABSMG_ME
ERLOS


Hope this will return you with some rows in the result.

Regards.