02-13-2008 7:26 AM
Hi. We're trying to find out what are the demographics of our students. For this, we wanted to use the postal code or the state field (found within standard address details tab in the student master data.)
If we use an infoset query, we believe it should be possible to get this information. However, what are the tables and fields to query is not known to us.
Can somebody help us with this information?
Best Wishes,
Ashish
03-10-2008 7:43 PM
Ashish,
The address data for a student is actually stored with the Business Partner. There would be multiple tables to join to get this information. You would be better off using the function module BAPI_BUPA_ADDRESSES_GET to discover the GUID for the standard address, and then calling BAPI_BUPA_ADDRESS_GETDETAIL to get the details.
Michael