topic Re: Need to include Structures in SAP Query in Application Development and Automation Discussions

Need to include Structures in SAP Query

Former Member — Wed, 10 Oct 2007 10:51:12 GMT

Hi,

I need to extract data of material master from a 3.1 System, where there is a Structure which contains my required information.

How can i include the fields of the Strucutre into my query?

thanks,

Chintan

Re: Need to include Structures in SAP Query

Former Member — Wed, 10 Oct 2007 11:15:43 GMT

whether it is 3.1 or 4.0B or 4.6C

material master data will be in Material master transparent tables like MARA,MARC,MARD,MARM etc

so you have to fetch the data from those tables only, structures are not helpful to fetch the data

where from you wants to get that data

within 3.1 G itself ? or from

from some other systems?

if it is from other systems use RFC fun module ad fetch the data

Regards

ANJI

Re: Need to include Structures in SAP Query

Former Member — Wed, 10 Oct 2007 11:26:01 GMT

I need to pull the data within 3.1 system itself..

I agree that the data has to be fetched only thru the transparent tables, but since i am trying to develop a query, there are some fields that are being called from a Structure (SMEINH in my case). These are the additional units of measure. and the data for these are calculated after some manipulations it seems, so i cannot use the fields in the other tables where they exist already.

nor do i know how are they being manipulated.

so is there any other way to go about it?

thanks,

chintan.

Re: Need to include Structures in SAP Query

Former Member — Wed, 10 Oct 2007 12:29:56 GMT

My first step would normally be to turn SQL Trace on (ST05) and run the transaction where you see the structure filled... then look at the tables the trace shows you, and you can also drill down in there to look at the code that undertook the relevant selects.

Jonathan