Creating Extract Dataset

Former Member — Sun, 09 Mar 2008 06:01:26 GMT

hi,

Sample code for Creating Extract Dataset

thnks.

Re: Creating Extract Dataset

Former Member — Sun, 09 Mar 2008 08:43:02 GMT

HI,

a program that lists the Vendors and their Accounting documents. Create extract dataset from KDF logical database. Loop through the dataset to create the required report. Don't list those vendors which has no documents

See the code:

report zfwr0001 no standard page heading.

tables: lfa1, bsik.

field-groups: header, item1, item2.

insert lfa1-lifnr bsik-belnr into header.

insert lfa1-land1 lfa1-name1 into item1.

insert bsik-belnr bsik-budat into item2.

start-of-selection.

get lfa1.

....extract item1.

get bsik.

....extract item2.

end-of-selection.

loop.

....at item1 with item2.

........skip.

........write:/ 'Vendor number:', 28 'Name:', 56 'City:'.

........write: 16 lfa1-lifnr, 33(20) lfa1-name1, 62(20) lfa1-ort01.

........write:/ 'Document no.', 15 'Date'.

....endat.

....at item2.

........write:/ bsik-belnr, 13 bsik-budat.

....endat.

endloop.

Cheers,

Chandra Sekhar.

topic Re: Creating Extract Dataset in Application Development and Automation Discussions

Creating Extract Dataset

Re: Creating Extract Dataset