‎2009 Feb 13 7:41 AM
Hi,
Im new to this group,and new to ABAP
plz hep me out by solving ABAP Query...
i want to generate a report for getting Vendor Details
like Vendor address,Ph num and Email
input fields are Company code,country key and Account Group.
im Using Smart Forms for this..
but im not getting the Exact Function module to get All Required Details..
regards
Smitha
‎2009 Feb 13 7:45 AM
Hi,
Use Function Module:
ISIDE_CE_MRPCONTROLLER_READ
ISIDE_CE_VENDOR_READ
Regards,
Gurpreet
‎2009 Feb 13 7:45 AM
Hi,
just get the ADRNR from LFA1 and create address window in u r smartform and pass this number to that window.
It will give all the address details.
Or using this address number u can get whole address from ADRC table by passing ADRNR.
Hope this helps.
Thanks & Regards,
Rock.
‎2009 Feb 14 7:30 AM
Hi
i did as u said...
that is i passed the ADRNR into Address number...
if i do like this i wil get the adress of single Vendor...
i want the address of all the vendors which satisfies the input....
can i loop it?
if possible plz tell me how to do...
Regards
Smitha
‎2009 Feb 13 7:45 AM
‎2009 Feb 13 8:53 AM
thanks for ur quick reply...
SELECT SINGLE LIFNR
FROM LFB1
INTO V_LIFNR
WHERE BUKRS EQ V_BUKRS.
CALL FUNCTION 'VENDOR_READ'
EXPORTING
i_bukrs = V_BUKRS
i_lifnr = V_LIFNR
EXCEPTIONS
NOT_FOUND = 1
OTHERS = 2
.
IF sy-subrc <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
this is the code i have written...
but my problem is there no table in the Function module....
for Example...
CALL FUNCTION 'QPAX_PLMKB_READ_FROM_PLKO'
EXPORTING
i_plnty = 'Q'
i_plnnr = V_PLNNR
I_PLNAL = V_PLNAL
i_sttag = V_DATUV
TABLES
T_PLMKB_TAB = IT_TAB
i want the function modules with tables and proper input...
‎2009 Feb 13 9:19 AM
Hi,
Try using this FM BAPI_VENDOR_GETDETAIL / "GET_VENDOR_DETAILS".
Regards,
NAveen
‎2009 Feb 13 10:32 AM
Hi Nagaraj,
Is there any other way to get Vendor Details?
my input is Account Group : YDSP (Domesyic Vendor)
Country Key : IN
Company Code : 1000
if i give the above fields as input i have to get all the vendors which matches the above criteria and
there Address Details....
Regards
Smitha
‎2009 Feb 13 7:59 AM
Hi Smitha,
You can use FM 'LFA1_READ_SINGLE' to get Vendor Address detials. I am not sure if requirement will be fully satisfied because this FM gives all data stored in LFA1 table.
You can use following FM as per your data requirement.
LFA1_READ_SINGLE
LFB1_READ_SINGLE
For customer,
KNA1_READ_SINGLE
KNB1_READ_SINGLE
‎2009 Feb 13 8:14 AM
Hi,
Try BAPI_CREDITOR_GETDETAIL Funtional module to get the vendor details
Hope it helps u.....
‎2009 Feb 13 8:23 AM
Hi,
Try this FM -- WS_LM_VENDOR_ADDRESS_DISPLAY .
Regards
Pinaki
‎2009 Feb 13 8:30 AM
‎2009 Feb 13 9:33 AM
Hi Smitha,
Try using this function module,
BAPI_VENDOR_GETDETAIL
It will fetch you the required address details.
Hope it helps
Regrds
Mansi
‎2009 Feb 17 4:37 AM
‎2009 Feb 17 4:40 AM
Hi,
Im generating a report Using smartforms
I want Current Date to be Printed on that Report...
Can anybody help me on this?
Regards
Smitha
‎2009 Feb 17 4:54 AM
Helo,
you can print current date using Sy-datum system field.
write: /sy-datum.
Explore yourself before posting.
regards,
naveen
‎2014 Jun 11 12:16 PM
Hi
From Lfa1 get ADRNR and pass to this
FM ADDR_GET. for getting Address.
Regards,
Venkat.