Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Issue with fetching a record from IHPA table with PARNR value as condition

Hi All,

I am trying to fetch a particular record from IHPA table where i am giving the OBJNR number, PARVW and PARNR as customer no. , But I am not getting any record but if i will give OBJNR and PARVW it will generate a record with having same PARNR value.

Example :

case 1st :-

when i am passing following values in IHPA table,

OBJNR = IE000000000010070910

PRAVW = BP

PARNR = 620000562

it is not generating any record

-


case 2nd:-

But if i will pass

OBJNR = IE000000000010070910

PRAVW = BP

it will generate a record?(one row) which will include PARNR as same 620000562 along with other value.

Q1 - Why it's not generating in case 1st,

Q2 - How I will resolve this issue ? as i have to link some table as EQUI -


IHPA -


VCKUN

-


VCNUM ?

I have written a code for this to join :

SELECT A~EQUNR

B~PARVW

C~CCNUM

D~CCNUM

FROM EQUI AS A JOIN IHPA AS B ON AOBJNR = BOBJNR

INNER JOIN VCKUN AS C ON BPARNR = CKUNNR

INNER JOIN VCNUM AS D ON CCCNUM = DCCNUM

APPENDING CORRESPONDING FIELDS OF TABLE IT_OBSO

WHERE A~EQUNR IN S_EQN.

AND PARVW = 'BP'.

But it is not generating any record but when i am commenting the PARVW i am getting the mixed record of PARVW as (BP,SP,SH)

Let me know if any more clarification required.

Highly appreciate your help

Thanks & Regards

Shaw

Former Member
Not what you were looking for? View more on this topic or Ask a question