help needed

[Former Member]

hi friends,

plz help to write code for below given description.

Customer Name:

1. Perform these steps only where address code = ‘BT’.

2. Select from VBPA the address number (VBPA_ADDRNUMER) for the Ship-to (VBPA-KUNNR) for the billing document (VBRK-VBELN) where partner function (VBPA-PARVW) is equal to ‘WE.

3. Select from ADRC the name (ADRC-NAME1) where the address number in step 1 (VBPA-ADDRNUMBER) is equal to the address number in ADRC (ADRC-ADDRNUMBER)

SYS_ADDRESS

1.Perform these steps only where address code = ‘BT’.

2. Identify the address number as described to get customer name above.

3. Select from ADRC the street 1 (ADRC-STREET) where the address number in step 1 (VBPA-ADDRNUMBER) is equal to the address number in ADRC (ADRC-ADDRNUMBER)

regards,

siri.

[Former Member]

hi

what's BT?

A)

SELECT SINGLE * FROM VBPA WHERE VBELN = VBRK-VBELN

AND PARVW = 'WE'

AND POSNR = '000000'.

*--->Address number:

VBPA-ADRNR

SELECT * FROM ADRC WHERE ADDRNUMBER = VBPA-ADRNR.

WRITE: ADRC-NAME1.

EXIT.

ENDSELECT.

B)

SELECT SINGLE * FROM VBPA WHERE VBELN = VBRK-VBELN

AND PARVW = 'WE'

AND POSNR = '000000'.

*--->Address number:

VBPA-ADRNR

SELECT * FROM ADRC WHERE ADDRNUMBER = VBPA-ADRNR.

WRITE: ADRC-STREET.

EXIT.

ENDSELECT.

Max

[Former Member]

'BT' IS THE VALUE FOR FIELD IN TARGET SYSTEM.

ACTUALLY I NEED TO DOWNLOAD DATA FROM SAP TO FLAT FILE.

REGARDS,

SIRI.