Skip to Content
author's profile photo Former Member
Former Member

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

• 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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Nov 23, 2007 at 12:10 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.