Recursive Program - Read Structure Query

Former Member — Thu, 31 Oct 2013 09:36:21 GMT

Hi expert,

I want to create a program that read query structure (Query Bex).

Parameter of program : Structure ID of query.

Output Program : table with several informations :

=> line description

=> line type : formula, infoobject, Restricted key figure,etc.

=> formula : ratio1+ratio2

Example, first line :

ID : FEFE794FECAE94CA94CA

Type : Formula

Formule : D45QWBAI0ZTXWXT + D45QWBAI0ZTX548 =>> I dont want this,

i want this : D45QWBAI0ZTXWXT = 897RERRFERBAI0ZTXWXT + D45ZEDEFEZ81CEXWXT

897RERRFERBAI0ZTXWXT = keyfigure1 + keyfigure 2

D45ZEDEFEZ81CEXWXT = Restricted Key Figure4

D45QWBAI0ZTX548 = keyfigure8

Conclusion :

Insertion output table formule = keyfigure1 + keyfigure 2 + Restricted Key Figure4 + keyfigure8

My problem is recursive, i lose the beginning stages when i have several formula.

My program is in attachements.

Have you got an ideas ?

Thank you for your help.

Goulwen

Re: Recursive Program - Read Structure Query

MariaJooRocha — Thu, 31 Oct 2013 10:02:09 GMT

Hi,

Try to use the type statics for your declaration variable.

Regards,

Maria João Rocha

Former Member — Thu, 31 Oct 2013 11:46:01 GMT

Hi Maria,

It's not possible, beaucause i use one perform on recursive,

i dont know how many stages i have when i begin the perform

The problem is resume by this picture.