Dispalying billing address in PO smartform

[Former Member]

HI,

I made Z smart form from standard PO form /SMB40/MMPO_L.

I have following instructions:

based on the compnay code.. u goto T001 , get the Address number...

then go to ADRC table.. to get the address

in tables ADR12 & ADR5.. u will get the FAX & WEB address

in ADR6 Email address is maintained

Can anybody give steps to retrive information from thess

tables into billing address window.

I mean what variables I need to define and interfaces and program

code.ANY similar available sample code steps will do

Appreciatenyour assistance with points.

Viswanath

[Former Member · Accepted solution]

Hi,

1.First select bukrs adrnr from t001 into (lw_bukrs,lw_adrnr) where bukrs EQ s_bukrs(you have this already).

2.Select name1 city1 city_code po_box street

from ADRC into (lw_name1,

lw_city1,

lw_city_code,lw_po_box,lw_street)

where ADDRNUMBER EQ lw_adrnr.

3.Select TLX_NUMBER from adr5

intolw_TLX_NUMBER

where ADDRNUMBER = lw_adrnr.

4.select uri from adr12 into lw_url

where addrnumber = lw_adrnr.

5.declare all these in globally.and display these.

Regards,

SHiva.

[Former Member · Accepted solution]

HI Shiva and Prashant

Thanks for replies

Can you please eloberate more

what option shall I select,IS IT orgsnization

if so what will be my address number

Do I need to pass person number

what are the input parms and output parms

i need to pass

What are the global data and interfaces I need to define

and do i need to define anyother things?

How can I test this layout if it is working fine or not?

Thanks,

Visu

[Former Member · Accepted solution]

I feel siva's reply is more relevent for me

[former_member184657 · Accepted solution]

werks - plant code

name1 - plant name

adrnr - address number

use this address number from t001w and link up with adrc table using the field addrnumber.

if a match is found then it wud display the selected records from adrc table.

u need to select the required fields from adrc acc to ur requirement.

this wud give u the address u are looking for.

pk

[Former Member]

answered.Thanks Prashant and Shiva

[former_member184657]

this is one sample code ive done for my project. change it to ur requirments:

select single werks

name1

adrnr

from t001w into wa_t001w

where werks = 'BEL1'.

select single ADDRNUMBER

NAME1

NAME2

city1

POST_CODE1

street

house_num1

STR_SUPPL3

location

country

TEL_NUMBER

FAX_NUMBER

from adrc into wa_adrc

where ADDRNUMBER = wa_t001w-adrnr.

after this in the billing window drag and drop the values of adrc work area.

revert back if u have any qureies.

pk