2018 Aug 31 12:30 PM
Hi,
I have a field ATWRT in table AUSP which has the below records for the object 11A1.

Now my requirement is that I have to create a report where the field ATWRT has to be divided into the following 3 fields as shown:
Purchasing doc - ZOAP
Purchasing grp - C19
Channel - 1301,1302,1304,1305,1306
So how can I divide this ATWRT into 3 separate fields in my report ?
Regards,
Manish
Hi,
I have a field ATWRT in table AUSP which has the below records for the object 11A1.

Now my requirement is that I have to create a report where the field ATWRT has to be divided into the following 3 fields as shown:
Purchasing doc - ZOAP
Purchasing grp - C19
Channel - 1301,1302,1304,1305,1306
So how can I divide this ATWRT into 3 separate fields in my report ?
Regards,
Manish
2018 Aug 31 12:45 PM
You don't want to divide a field, but you want concatenate values of a field for a group of records?
(Look in online Abap documentation for loop at internal table, sort, group, 'at', and statements for concatenation of string)
Note that if would be more funny to generate a dynamic table such as
" Purchasing doc | Purchasing grp | Channel 1 | Channel 2 | Channel 3 | Channel 4
" ZOAP | C19 | 1301 | 1302 | 1304 | 1305
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |