How to get details Whenever an order has been blocked .

[Former Member]

Dear friends,

Please provide me a functional spec for the below requirement. I dont have proper functional input So depending on SDN .

Need to write a program and schedule it so that ............

- Whenever an order has been blocked due to the following reasons

u2022 Credit limit

u2022 Outstanding balance

u2022 Order due

u2022 Balance credit limit

A output should be published with following details

u2022 Customer name

u2022 SAP order

u2022 Credit limit

u2022 Outstanding

u2022 Order due

u2022 Balance credit limit

Please help me with the table fields and the logic need to implement.

Your support is highly requested and rewards.

Thanks.

[Former Member · Accepted solution]

Hi,

I believe VKM1 and VKM4 transations solves your purpose. If not, Please let me know.

Regards,

Sai

[Former Member · Accepted solution]

Hai Rajeshwar,

I gone through all these tables but really failed to draw a conclusion on how to approach this.

My clinet has given me exactly he same data that i have posted here.

Basically i am planning in this way:-

1. Betweena date range need to pick up all the salesorders that are blocked due to the given reasons .

2.From these sales orders getting customer name and other credit and over due details.

Sdn Please extend your helping hand..................

Regards,

simraan.

[Former Member · Accepted solution]

Hi,

In Sale order , you have delivery /Billing block.

LIFSK

FAKSK are the respective fields in VBAK table.

On the input screen ( Selection -screen)

Give date range and the sales area, Credit control area as input parameter.

Pick up all the sales orders (VBAK-Document Category should be ( VBTYP) should be 'C' and the delivery/ Billing block should be the required ones.

You will only find the code of the block in VBAK table. The description of the block will be in the table TVLS/TVLST.

You can get the sold to party also in VBAK table.

From the KUNAG in VBAK table, get the customer details ( Name Etc..) From KNA1.

The credit details of the customer( KUNAG) will be in the table KNKK and KNKA.

This program needs to be scheduled on daily basis and the output needs to be sent via E-mail to the concerned users.

( Use the FM SO_NEW_DOCUMENT_SEND_API to geneare the e-mail.).

Regards,

Sai

[Former Member · Accepted solution]

Thanks Sai,

This will be solving my problem. Kudos...

regards,

simraan.

[Former Member]

Hi ,

use thiese tables .

LIKP

LIPS

VBUK

TVAG

T024B

PLease let me know if oyu still need any more help.

Thanks and regards,

Rajeshwar.

[former_member1249468]

Hi ,

As suggested use the above tables and create ABAP Query to get your requirement.Also you can refer the below link to create the query.

http://www.thespot4sap.com/articles/sap_abap_queries_create_the_query.asp

Hope it helps.

Regards,

Pasapula.

[Former Member]

Hai rajeshwar,

Thanks for the details....working with that...

regards,

simraan.

[Former Member]

Hai Rajeshwar,

I gone through all these tables but really failed to draw a conclusion on how to approach this.

My clinet has given me exactly he same data that i have posted here.

Basically i am planning in this way:-

1. Betweena date range need to pick up all the salesorders that are blocked due to the given reasons .

2.From these sales orders getting customer name and other credit and over due details.

Sdn Please extend your helping hand..................

Regards,

simraan.

[Former Member]

Hi,

Try T-Code VKM3. The output of the VKM3 transaction contains the customer(Sold to Party ), Sales oredr number, open order credit, open delivery credit, Total receivables, credit limit. Hope this helps.

[Former Member]

Dear Friends,

Thanks for your replies.....hope it would help..

working on ur suggestion...will get back to you very soon...

thanks.......................

[former_member315051]

Check T Code : F.31- Credit mangement Over view , this might helps for your requirement

Regards,

Ramesh