Extract Master Data from GTS to perform V_Lookups via Excel
Hello GTS/SAP Gurus -
My company is a exporter/seller of highly regulated chemicals. As such, we have fields in GTS which flag our products for various regulations. I was not with the company when all of the data was initially uploaded to GTS. Since then, many updates have taken place to add new materials, delete old or discontinued products, etc.
Can you tell me if there is an easy way to extract data from a Table categorized as Struct.? I'm looking to extract data which is housed on the Legal Control Tab of the Material. I can view the entire list on screen, but there does not appear to be a way to send it to Excel. I can only see the individual data when I double click the Product Number we have assigned the information to. I'm looking to create the search which selects all of our assigned Product Numbers and the associated Regulator Flags we have linked to them. All appear to be related as follows:
PROGRAM NAME: /SAPSLL/SAPLPRODUCT_IFACE
TABLE NAME: /SAPSLL/PROD_LEG_CONTRL_DYNP_S
The reason for the extract is to satisfy requests from distributors/re-sellers who are requesting Export Compliance details based on the items which they purchase. The one-two item requests I can do by hand. However, some requests are over 200-300 items, which cannot be completed by hand. Any help/guidance you can provide is greatly appreciated.
(by the way, I am a GTS User, not programmer, so please try to simplify any instructions so that I can relay to our programmers. Thank you, in advance, for anything you can provide to assist me.