Sales order create

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi Alex,

         Can you please mention exact table name and field name.

Thanks & Regards,

Hemanth.

[Former Member]

Hi

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

[Former Member]

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,

1. Hemanth.

[Former Member]

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.

[Former Member]

Hi Alex,

           There is no standard way for this.

Thanks & Regards,

Hemanth.

[Former Member]

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

[RaymondGiuseppi]

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

[Former Member]

Hi Raymond,

                 I did not check standard report in Financial Accounting

Thanks & Regards,

Hemanth.

[Former Member]

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.

[Former Member]

Hi All,

      Is there  any use of CMGST field in VBUK table?

Thanks &Regards

Hemanth.