09-10-2014 10:21 PM
Though a BW extractor, we save AUSP data to a flat file daily. I need to build an external lookup table to link ATINN to the internal characteristic. Where can I go in SAP SE16N to extract the relationship between AUSP.ATINN and the Internal Characteristic number?
Ex: material abc
AUSP.ATINN=0000000006
Internal Characteristic: Z_GENERIC_ARTICLE
From SE16n, I would like to extract to an external table the ATINN number and the internal characteristic, like this:
Internal_Char_No Internal_Char_Value Char_Desc
0000000001 Z_COLOR_2 Color
0000000002 Z_HEIGHT_2 Height
0000000003 Z_COMB_SIZE_2 Size
0000000004 Z_TYPE_2 Type
0000000005 Z_MATERIAL_CATEGORY Material Category
0000000006 Z_GENERIC_ARTICLE Generic Article Number
0000000007 Z_FLAVOR_2 Flavor
If I search CABN from SE16n, on the screen, the ATINN displays the internal characteristic description vs. the actual ATINN number, so I get something like: ATINN, ATNAM
Z_COLOR_2 Z_COLOR_2
Z_HEIGHT_2 Z_HEIGHT_2
When I export it, it exports in the same format. See attached for screenshot.
Thank you!
09-10-2014 10:40 PM
In SE16N selection screen You should choose from menu Extras -> Change Settings (or Ctrl-F12) and mark option "Output without Conversion Exit".
Regards,
Jarek
09-10-2014 10:40 PM
In SE16N selection screen You should choose from menu Extras -> Change Settings (or Ctrl-F12) and mark option "Output without Conversion Exit".
Regards,
Jarek
09-11-2014 3:18 PM