on 08-26-2009 2:14 PM
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?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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,
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
>
> 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
Hi,
if sy-subrc = 0 it's working correctly.
What's going wrong?
Regards,
Frisoni
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.