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

[Former Member]

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 A_{OBJNR = B}OBJNR

INNER JOIN VCKUN AS C ON B_{PARNR = C}KUNNR

INNER JOIN VCNUM AS D ON C_{CCNUM = D}CCNUM

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

[SantoshKallem]

problem is with leading zeros.

regards,

santosh

[Former Member]

Hi Santosh,

Thanks for your quick response.

But I am Sorry, I already checked with putting Zero before PARNR.

The issue is still as it is.

Thanks

Shaw

[former_member338769]

Hi Kumar,

Did you manage to find a solution to your issue? I am having the same problem when trying to extract records for a particular partner. I noticed that if a partner is a number, it doesn't work. But if I use partner = user id, I can see the records.

Thanks,

E