How to retrieve this data?

Former Member — Mon, 14 May 2007 10:37:50 GMT

Hi,

I would like to retrive the "product", and "Industry" under ITEM, but have no idea how to code it.

It seems to be a very complicated structures and table as below:

ZXML_SECTION is a structure, it contains NEW_PRODUCT (table), OLD_PRODUCT (table), MILESTONE (table).

NEW_PRODUCT is table "ZXML_NEW_PRODUCT_BP_TT",

OLD_PRODUCT is table "ZXML_OLD_PRODUCT_BP_TT",

MILESTONE is table "ZXML_MILESTONE_BP_TT".

When I double click the "ZXML_NEW_PRODUCT_BP_TT", it shows "ZXML_NEW_PRODUCT_BP", when i clicked into it,

it contains Items (structure) and Description (String).

Items is structure "ZXML_ITEM" that contains Product and Industry that defined as Char.


				 --> NEW_PRODUCT                      --> "ZXML_NEW_PRODUCT_BP" --> ITEM (Structure)	--> Product (char)
		    		     (TABLE "ZXML_NEW_PRODUCT_BP_TT")			  				--> Industry (char)
										 	        --> Description (String)
  ZTAB_SECTION --> ZXML_SECTION  --> OLD_PRODUCT
   (TABLE)	   (Structure)       (TABLE "ZXML_OLD_PRODUCT_BP_TT")

				 --> MILESTONE 
		   		     (TABLE "ZXML_MILESTONE_BP_TT")

Above is how the structure looks like.

If I wish to retrieve the "product" and "Industry", can I loop the ZTAB_SECTION since is an internal table? How should I declare a variable or data.

Please advise. Thanks a lot!

br,

Re: How to retrieve this data?

Former Member — Mon, 14 May 2007 11:27:36 GMT

hii

which fields you want to select?if product then from which table?and industry from which table?and according to naming i dont think that ZTAB_SECTION is an internal table,please explain in detail

vikass

Re: How to retrieve this data?

Former Member — Thu, 17 May 2007 03:43:18 GMT

Hi!

problem solved.

thanks for all help!

br,

topic How to retrieve this data? in Application Development and Automation Discussions

How to retrieve this data?

Re: How to retrieve this data?

Re: How to retrieve this data?