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

How to fetch values from PROJ table

Hi friends,

i have range with internal numbers with type NUMC 8.

PROJ table - field PSPNR(key field) is of type NUMC 8.

But internally it is maintained as 24 char in PROJ table.

How should i use this range to select records from PROJ table as it does not accept the range and sy-subrc always fails.

Give us some example

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 03, 2007 at 08:58 AM

    Hi

    DATA: PROJECT LIKE PROJ-PSPNR,

    NEW_START LIKE RCWBS-SEL01 VALUE ' ',

    VSNMR LIKE VSKOPF-VSNMR VALUE SPACE,

    ARNMR LIKE ADMI_RUN-DOCUMENT VALUE '000000'.

    data: begin of int_prhi occurs 1. "work table for

    include structure prhi. "PRHI

    data: end of int_prhi.

    CALL FUNCTION 'GET_PROJECT_HIERARCHY'

    EXPORTING

    i_pronr = project

    no_buffer = new_start

    vsnmr = vsnmr

    arnmr = arnmr

    TABLES

    t_prhi = int_prhi

    EXCEPTIONS

    not_found = 01.

    Also, can refer this thread

    Very urgent- find parent-child relationship for wbs element

    Regards

    Raj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 03, 2007 at 08:52 AM

    HEllo,

    Do like this.

    select * from proj into table itab where pspnr in s_pspnr.
    

    Regards,

    VAsanth

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 03, 2007 at 08:56 AM

    Hi

    Use the PSPID field in the where condition for PROJ table data fetching

    If you have NUMC number field then try using the PSPNR field

    Reward points for useful Answers

    Regards

    Anji

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 03, 2007 at 08:58 AM

    Hi,

    First convert the value to table format by using the conversion exit and store that value in an internal table and use that internal table field for fetching the records from PROJ table.

    Reward points if useful.

    Regards,

    Suman

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 03, 2007 at 09:02 AM

    Hi,

    Before select statement try using the conversions CONVERSION_EXIT_KONPD_INPUT

    CONVERSION_EXIT_KONPD_OUTPUT

    for converting select-options according to the data in table.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 03, 2007 at 09:02 AM

    RANGES: r_paspnr LIKE proj-pspnr.

    r_pspnr-sign = 'I'.

    r_pspnr-options = 'EQ'

    LOOP AT t_proj.

    r_pspnr-low = t_proj-paspnr.

    APPEND r_pspnr.

    ENDLOOP.

    SELECT * FROM WHERE pspnr IN r_pspnr.

    Regards,

    A.Singh

    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.