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
Table files for BAPI
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 385
- Joined: Tue Oct 07, 2003 4:55 am
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
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
-
- Premium Member
- Posts: 385
- Joined: Tue Oct 07, 2003 4:55 am
-
- Premium Member
- Posts: 385
- Joined: Tue Oct 07, 2003 4:55 am
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
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
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.
- 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.