reg ADRNR

[Former Member]

hai to all,

In scripts on address window i am using the address / endaddress statements.

this form is for purchase order application.tcode is me21n

ADDRESS PARAGRAPH AS

ADDRESSNUMBER &EKKO-ADRNR(K)&

FROMCOUNTRY &T001-LAND1&

ENDADDRESS

can i know from which table this adrnr is been fetched.

becoz i checked in ekko / sadr i can't found any values on the corresponding tables , but i can find the output on the form. i want to know the exact table name / field .

please advise me

regards

vijay

[Former Member]

hai to all,

In scripts on address window i am using the address / endaddress statements.

this form is for purchase order application.tcode is me21n

ADDRESS PARAGRAPH AS

ADDRESSNUMBER &EKKO-ADRNR(K)&

FROMCOUNTRY &T001-LAND1&

ENDADDRESS

can i know from which table this adrnr is been fetched.

becoz i checked in ekko / sadr i can't found any values on the corresponding tables , but i can find the output on the form. i want to know the exact table name / field .

please advise me

regards

vijay

[Former Member]

First you need to get the ADRNR from USR21 table by giving USR21-BNAME = EKKO-ERNAM.

Then pass thes ADRNR to ADRC table and retreive the address of PO creator.

Hope it helps.

or

SELECT SINGLE * FROM USR21 WHERE BNAME = EKKO-ERNAME.

ADDR1_SEL-ADDRNUMBER = USR21-ADDRNUMBER

CALL FUNCTION 'ADDR_GET'

EXPORTING

ADDRESS_SELECTION = ADDR1_SEL

[Former Member]

Hi,

<b>ADRC</b> table and field is <b>ADDRNUMBER</b>

Regards

vijay

[Former Member]

Hi Vijay,

the program picks the address number from the Vendor Master Table LFA1, using the vendor number...

[Former Member]

ADDRESS PARAGRAPH AS
ADDRESSNUMBER &EKKO-ADRNR(K)&
FROMCOUNTRY &T001-LAND1&
ENDADDRESS

the above code triggers the FM <b>ADDRESS_INTO_PRINTFORM</b>. do you know this...?

run this FM in SE37 only pass the address number and see..from where it is picking the data.

the Fm no where calls LFA1 table .it calls only ADDress tables.

Regards

vijay

[Former Member]

Hi Vijay Babu,

I know that this code triggers the FM that u mentioned. Bu i guess Vijay was asking about the Address number rather than the address, in the FM u pass the address number, so in the PO program, first u get the address number n it gets it from the vendor master table..

it may also use the ADRC table, but then it has to have the address number first. so for a vendor, dont u think the address number is stored in LFA1??

[Former Member]

Jyoti

You can use NAST table, whereby you can pass OBJKY as PO number and you can get ADRNR as well as PARNR details. in case of PO, different vendors attched to output types.