topic Re: Sales order create in Application Development and Automation Discussions

Sales order create

Former Member — Fri, 20 Sep 2013 05:29:33 GMT

Hi All,

I have created one sales order for X customer,but this customer has no creadit limit. But The order has created successfully.

my question is " How to identify these sales order in tables"?

Thanks & Regards,

Hemanth.

Re: Sales order create

Former Member — Fri, 20 Sep 2013 09:13:27 GMT

http://wiki.scn.sap.com/wiki/display/ERPLO/SD+related+tables+and+structures

Re: Sales order create

Former Member — Mon, 23 Sep 2013 05:02:23 GMT

Hi Alex,

Can you please mention exact table name and field name.

Thanks & Regards,

Hemanth.

Re: Sales order create

Former Member — Mon, 23 Sep 2013 05:08:50 GMT

Pass your customer number(KUNNR) in VBAK and get the Sales order Number(VBELN).

Tcode: SE11

Table name: VBAK

Field Name : KUNNR

Sales Order Field: VBELN

To find customer cretit control data,

pass Customer number(KUNNR), Credit control area(VBAK-KKBER) to KNKK database table

Re: Sales order create

Former Member — Mon, 23 Sep 2013 05:29:09 GMT

Hi Hemanth,

VBAK---Table for Sales order Header.

VBAP---Table for Sales order Item details.

In VBAK-KUNNR pass the customer number get the sales order header details like Sales order number(VBELN).

Pass this sales order number to VBAP-POSNR and get the item details.

Thanks

Pavan.N

Re: Sales order create

Former Member — Mon, 23 Sep 2013 05:33:51 GMT

Hi Alex,

For above scenario, the total sales orders created by that customer are displaying.

I don't want to display all sales orders. I want to display the sales orders that does not have creadit limit.

For example: the credit limit for customer X is 20k.

I have created one sales order for X customer with net value is 15k,the order is created successfully with order no 14984.

Now the available credit limit is 20k-15k= 5k.

Once again I have created one sales order for the same customer with net value 20k the order is created

Successfully with order no 14985 .Now I want to display the 14985 only not both orders.

Thanks & Regards,

Hemanth.

Re: Sales order create

Former Member — Mon, 23 Sep 2013 05:55:21 GMT

Hi for this you need to create an ABAP program.

You can proceed like:

1. Find open sales orders for the customer

2. Find the customers credit limit

3. Process the open orders(check whether the order value exceeded the credit limit) to get the desired result.

For each of these steps, please search the forum if you require more information.

Re: Sales order create

Former Member — Mon, 23 Sep 2013 07:03:40 GMT

Hi Alex,

There is no standard way for this.

Thanks & Regards,

Hemanth.

Re: Sales order create

RaymondGiuseppi — Mon, 23 Sep 2013 08:15:10 GMT

You have to match entries from some tables

from VBAK and VBAP to VBRK and VBRP to VBFA to BSID - to identify "open orders" and get credit used
KNKK to get credit limit (and current balance)

Remember used credit is decreased of the payments of the customer.

But did you check standard reports available in Financial Accounting, Accounts Receivable, Credit Management, Credit management info system ?

Regards,

Raymond

Re: Sales order create

Former Member — Mon, 23 Sep 2013 08:29:22 GMT

Hi Raymond,

I did not check standard report in Financial Accounting

Thanks & Regards,

Hemanth.

Re: Sales order create

Former Member — Mon, 23 Sep 2013 08:58:10 GMT

check the link http://help.sap.com/saphelp_46c/helpdata/en/93/743861546011d1a7020000e829fd11/content.htm

RVKRED06

Checking blocked credit documents

The report checks all blocked documents from credit view.

RVKRED08

Checking sales documents which reach the credit horizon

The report checks all sales documents, which reach the dynamic credit check horizon, as new.

Your functional consultant could help u finding more reports if any.

Re: Sales order create

Former Member — Tue, 24 Sep 2013 04:35:23 GMT

Hi All,

Is there any use of CMGST field in VBUK table?

Thanks &Regards

Hemanth.