on 2021 Jun 09 1:45 PM
I am trying to do an inner join between two sap ztables in a single abap dataflow.
I am getting the below error
abap program</tmp/ztest> syntax error:< the name "ztb_dsc_e_039_zz_post_date_for_dsc" is long> .
looks like while joining two ztables , it also considers the length of column names, the length of the column name is long (which is 20). I have tried reducing the column name in the ztable to 19, 18, and 17 till "zz_post_date_for_" and the join worked without any issue.
It also dosen't give any issue while extracting the data from two ztables independently in two different abap dataflows. I tried extracting the data from these ztables( using two different abap datsflows) to two different staging tables and tried joining them, the join worked. But the staging table's data grows as the ztables data grow which is not a preferred approach.
Please help me if there is any way to resolve this issue by joining the two tables in single abap dataflow.
Appreciate your help.
User | Count |
---|---|
79 | |
11 | |
10 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.