2012 Sep 07 6:12 AM
Hi experts,
I want fetch the account no of bank ( in Master data creation in FI01) it is stored in ADDR1_DATA table( Field name is NAME2). But when i see in se11 . It is a structure . How can i fetch the data. Using BNKA table.
Screen shot attached for your reference.
Please help me friends.
Thanks and Regards,
Linganathan
2012 Sep 07 6:35 AM
Dear,
take ADRNR from table BNKA and pass it to ADRC table and you can get name2.
2012 Sep 07 6:16 AM
Hi,
Follow this step
1)
F1 on value> double click on data element in se11 >where used list>u will get the tables.
2)Otherwise directly refer to data element is good practice in abap,
Gourav.
2012 Sep 07 6:39 AM
Dear Kumar Gaurav,
The data element name is AD_NAME2 . What can i do next. And how can i fetch the data for bank name ( Input in selection screen, i.e BNKA-BANKA) .
Thanks and Regards,
Linganathan.K
2012 Sep 07 6:46 AM
2012 Sep 07 6:35 AM
Dear,
take ADRNR from table BNKA and pass it to ADRC table and you can get name2.
2012 Sep 07 6:37 AM
Hiii,
BNKA table contain field ADRNR pass this to table ADRC field ADDRNUMBER you will get name2.
2012 Sep 07 6:41 AM
Hi,Try like this
Select ..... adrnr.......from bnka
into ........it_bnka
where........
then
select ....addrnumber name2 from adrc "name 2 data element is ad_name2
into ....
for all entries in it_bnka
where addrnumber = it_bnka-adrnr.
Gourav.
2012 Sep 07 7:14 AM
HI,
Check ADRC Table with ADDRNUMBER.
ADDRNUMBER = BNKA-ADRNR.
You will get the required details in NAME2 field of ADRC Tabke.
Regards,
RAvi Singh
2012 Sep 07 7:33 AM
Dear Kumar Gourav, Bharath Rathod, Ashish Ahire . Thank you all. My problem was solved because of your valuable replies.
Once again thank you so much.
Regards,
Linganathan.K
2012 Sep 07 7:38 AM
Dear,
If you got ur solution then please close this theread by answer
2012 Sep 07 7:39 AM
2012 Sep 07 8:12 AM
2012 Sep 07 8:22 AM
2012 Sep 07 8:25 AM
Done, no further activity required.
One friendly reminder is enough, friends, as long as you don't mean "give me points" when you say "mark it as answered"
Thomas
2012 Sep 07 10:09 AM
Although this should have been closed already:
It is advisable and upgrade-safe to get required data using SAP standard BAPI functions, i.e. BAPI_BUPA_GET_DETAIL.
Regards
Clemens