on 04-15-2015 5:28 AM
Hello,
I am using custom ABAP transform within an ABAP dataflow to fetch the data from the customer group 5 table TVV5 from SAP ECC. There are only two fields in that table ( Supply chain centre , Description ). However, its resulting in a validation error saying Column Named <Supply Chain Centre > has an Embedded blank. ( BODI-1111203). Below is the screenshot...... Any idea what is this about ?
Column names that contain blanks must be embedded in double quotes: "SUPPLY CHAIN CENTRE".
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dirk,
It was already in double quotes, Still ending up with the same error, Screenshot below..
Also to just to add to my above point,the reason why i am using a custom ABAP transform and not pulling the table directly within ABAP dataflow is because one of the other fields ( Description ) in the table TVV5 is not visible in BODS, even though its visible in ECC system. Not sure why though...
I am assuming the error message is referring to the target schema in your query transform, not to the source. Try and embed the target name in double quotes.
DS does not show column names of data types it does not support, that might be the reason why. What's the exact source datatype of TVV5.DESCRIPTION?
It worked Dirk...Thank you....
Why can't the column names in target schema ( with input from the Custom ABAP custom transfer ) have spaces ?
Observation : The column names with spaces in target schema will result in validation error.
The column names with spaces in input schema ( Custom ABAP transform ) results in runtime error.
Both needs to be corrected...
Thank you....
I suggest changing the target schema name to Supply_Chain_Centre should solve the purpose.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Karthik,
Can you please check what does the column Supply Chain Center contains. Check the data type of this column in SAP ECC Tables...
Regards
Arun Sasi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
72 | |
11 | |
10 | |
7 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.