Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

hi it is related to Read statement , please any one can write the logic

Former Member
0 Kudos

• Read data in table BSIK

If data in table then

Create Control Header record when BSIK has data.

The Control Header Record is the first record in the interface file.

Only one Control Record is required in each file.

Maximum number of 8000 lines per interface file.

Several interface files will be created if there are more than 8000 lines,

however, no document should ever be split between 2 files, only whole

document processing.

Else

If no data in table then

Notification message send to IT Support and AP Account when BSIK is

empty. Then end the program.

Error Message

Empty File no FTP Transfer.

1 ACCEPTED SOLUTION

andreas_mann3
Active Contributor
0 Kudos

some brain storming...

use a counter and a strcucture save_key for saving keyfields bukrs belnr gjahr.

-select bsik to itab ; save sy-dbcnt into total

-loop itab

if counter = 8000.

1) check if document is complete

select *

where buzei > itab-buzei

if not complete

delete itab where save_key

clear counter

if counter = 0 and total > 1.

select bsik again with save_key

A.

2 REPLIES 2

andreas_mann3
Active Contributor
0 Kudos

some brain storming...

use a counter and a strcucture save_key for saving keyfields bukrs belnr gjahr.

-select bsik to itab ; save sy-dbcnt into total

-loop itab

if counter = 8000.

1) check if document is complete

select *

where buzei > itab-buzei

if not complete

delete itab where save_key

clear counter

if counter = 0 and total > 1.

select bsik again with save_key

A.

0 Kudos

Thanks for ur replay ......