cancel
Showing results for 
Search instead for 
Did you mean: 

For all entries

Former Member
0 Kudos

the below given coding is given sy-subrc = 0 .

here T_ZISUBPTOPREMISE1 is an internal table of type database table ZISUBPTOPREMISE , having structure

BPEXT BU_BPEXT --- Primary Key

PARTNER BU_PARTNER

VKONT VKONT_KK

TPLNR TPLNR

VSTELLE VSTELLE

BPKIND BU_BPKIND

TITLE_MEDI AD_TITLETX

NAME_FIRST BU_NAMEP_F

NAME_LAST BU_NAMEP_L

BU_SORT1 BU_SORT1

BU_SORT2 BU_SORT2

STR_SUPPL1 AD_STRSPP1

STR_SUPPL2 AD_STRSPP2

STREET AD_STREET

HOUSE_NUM1 AD_HSNM1

HOUSE_NUM2 AD_HSNM2

SELECT

PARTNER " Business Partner Number

BPKIND " Business Partner Type

BPEXT " Business partner number in external system

BU_SORT1 " Search term 1 for business partner

BU_SORT2 " Search term 2 for business partner

TITLE " Form-of-Address Key

NAME_FIRST " First name of business partner (person)

NAME_LAST " Last name of business partner (person)

FROM BUT000 INTO TABLE T_BUT000

FOR ALL ENTRIES IN T_ZISUBPTOPREMISE1

WHERE BPEXT = T_ZISUBPTOPREMISE1-BPEXT .

What should be the reason behind it?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Only for the entries available in table T_ZISUBPTOPREMISE1 with the field matching BPEXT in this table with the field BPEXT in the table BUT000.

Here SY-SUBRC = 0. means, it found some entries.

Former Member
0 Kudos

Entries are there in Data Base table BUT000 but its not fetching the value

I have also used the conversion_exit_alpha_input but not fetching value..........

Former Member
0 Kudos

Hi,

How have you declared the internal table T_BUT000?

Regards,

Vik

Former Member
0 Kudos

TYPES : BEGIN OF TY_BUT000 ,

PARTNER TYPE BU_PARTNER , " Business Partner Number

BPKIND TYPE BU_BPKIND , " Business Partner Type

BPEXT TYPE BU_BPEXT , " Business partner number in external system

BU_SORT1 TYPE BU_SORT1 , " Search term 1 for business partner

BU_SORT2 TYPE BU_SORT2 , " Search term 2 for business partner

TITLE TYPE AD_TITLE , " Form-of-Address Key

NAME_FIRST TYPE BU_NAMEP_F , " First name of business partner (person)

NAME_LAST TYPE BU_NAMEP_L , " Last name of business partner (person)

END OF TY_BUT000.

DATA : T_BUT000 TYPE STANDARD TABLE OF TY_BUT000 INITIAL SIZE 0.

jaideepsharma
Active Contributor
0 Kudos

Hi,

Try declaring the table types as below:

TYPES : BEGIN OF TY_BUT000 ,

PARTNER TYPE BUT00-PARTNER , " Business Partner Number
BPKIND TYPE BUT00-BPKIND , " Business Partner Type
BPEXT TYPE BUT00-BPEXT , " Business partner number in external system
BU_SORT1 TYPE BUT00-SORT1 , " Search term 1 for business partner
BU_SORT2 TYPE BUT00-SORT2 , " Search term 2 for business partner
TITLE TYPE BUT00-TITLE , " Form-of-Address Key
NAME_FIRST TYPE BUT00-NAME_FIRST , " First name of business partner (person)
NAME_LAST TYPE BUT00-NAME_LAST , " Last name of business partner (person)
END OF TY_BUT000.

.

I don't think it should make much difference but still try using it.

KR Jaideep,

Former Member
0 Kudos

Not working

Former Member
0 Kudos

Where are you populating T_ZISUBPTOPREMISE1?

Former Member
0 Kudos

Hi Manish,

1.Debug the program, and change the content on internal table T_ZISUBPTOPREMISE1-BPEXT to make it same as one of the entries in in your database table BUT000 .

2. Check if you are able to get results . If this is succesfull then there are no no issues with your declaration .If not check the declaration for any type mismatch.

3. If succesfull and still no data during noraml run ,could be due to conversion issue,check BPEXT data residing in Internal table with that of the same field in BUT000 for any issues.

Regards,

Abhilash

SuhaSaha
Advisor
Advisor
0 Kudos

>

> Entries are there in Data Base table BUT000 but its not fetching the value

> I have also used the conversion_exit_alpha_input but not fetching value..........

Hello Manish,

The field BUT000-BPEXT has a domain CHAR20 which has got no conversion exit attached. So u need not use any conv. exit.

Are there data in BUT000 corresponding to the values in the internal table you have used in FAE i.e., T_ZISUBPTOPREMISE1-BPEXT ?

Please check & let us know.

BR,

Suhas

guilherme_frisoni
Contributor
0 Kudos

Hi,

if sy-subrc = 0 it's working correctly.

What's going wrong?

Regards,

Frisoni

Former Member
0 Kudos

But entries are there in table BUT000 .

and giving sy-subrc = 4 .

What are the possible reason for giving sy-subrc = 4.