Skip to Content
author's profile photo Former Member
Former Member

How get records with constraint on hierarchical fileds

I have table <i>T1</i> with fields <i>F1, F2</i>. <i>F2</i> has reference to the hierarchical table <i>T2</i>. Data in <i>T2</i> organized as:

Parent1

|-Child1

|-Child2

Parent2

|-Child3

I want to get all records from <i>T1</i> which has <i>F2</i> values in Parent1 group.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 10:48 AM

    Hi Dymtro,

    U declare <i>T1</i> as your main table and <i>F2</i> as a lookup table inside it ie.[lookup hierarchy] inside it.

    Now the importing have to be decided depending on the source format.

    The source may have the parent and child relationship maintained in a single field or in seperate field.

    <b>Type1:</b>

    If maintained in a single field(values are maintained separeately by a delimiter) then the field declaration inside f1 is not required.just Split in to Hierarchy.follow" target="_blank">http://help.sap.com/saphelp_mdm550/helpdata/en/43/12036df94c3e92e10000000a1553f6/frameset.htm">follow this url.

    <b>Type2:</b>

    if maintained in separate fields then they have to be constituted in to a hierarchy

    follow" target="_blank">http://help.sap.com/saphelp_mdm550/helpdata/en/43/12036df94c3e92e10000000a1553f6/frameset.htm">follow this URL

    hope this will help u .

    please reward me if u find this blog helpful.

    Thanks & Regards

    Deepankar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 10:54 AM

    Thank you for attention, but I forgot to indicate that I need Java API solution.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.