Schedule line

[Former Member]

Hi All,

While writing an ABAP report which requires to identify the OPEN SALES ORDER SCHEDULE LINES.

The requirement is to identify the Open Sales Order Schedule Lines for a particular month (user Processing month in the selection screen). Here the Schedules line item could have been delivered already. If it is not Billed then it is OPEN schedule line.

Can anyone help me to understand the logic which I need to apply to identify only the Open sales order schedule lines.

I am using the following tables:

VBAK,VBAP,VBUK,VBUP,VBEP. Is there any other table which I need to use? I am trying to avoid using table VBFA due to performance issues.

Any suggestions.

Thanks

Sadhu Kishore

[Former Member]

Hi All,

While writing an ABAP report which requires to identify the OPEN SALES ORDER SCHEDULE LINES.

The requirement is to identify the Open Sales Order Schedule Lines for a particular month (user Processing month in the selection screen). Here the Schedules line item could have been delivered already. If it is not Billed then it is OPEN schedule line.

Can anyone help me to understand the logic which I need to apply to identify only the Open sales order schedule lines.

I am using the following tables:

VBAK,VBAP,VBUK,VBUP,VBEP. Is there any other table which I need to use? I am trying to avoid using table VBFA due to performance issues.

Any suggestions.

Thanks

Sadhu Kishore

[Former Member]

u need to do for open billing items then

make use of this sequence

give the input of sales orders in table VBUK

at header level

join of VBAK and VBUK

and check the fields GBSTK ne "C" and FKSTK ne "C" implies open .

FKSTK is for billing status..

all the open orders with open billing status can be fetched .

taking these Open Orders now fetch the entries at item level

Now for these do the same at item level from VBAP and VBUP .

In order to check the open items in schedule line fetch from VBEP for the same line items .

regards,

vijay