topic Re: BAPI for Sales Order Creation. in Application Development and Automation Discussions

BAPI for Sales Order Creation.

Former Member — Wed, 14 Feb 2007 09:28:11 GMT

Hello gurus,

I want to create a sales order using BAPI.

I have tried some BAPI's like BAPI_SALESORDER_CREATEFROMDAT1, BAPI_SALESORDER_CREATEFROMDAT2, BAPI_SALESORDER_CREATEFROMDATA, BAPI_SALESDOCU_CREATEWITHDIA.

But I am not able to update the Miscellaneous Information like Mode of transport(VBAP-OIC_MOT), Forwarding Agent(VBAP-OIC_LIFNR), Base Location(VBAP-OIA_BASELO), Truck Number(VBAP-OIC_TRUCKN), Pipeline trip No.(VBAP-OIC_PTRIP), Pipeline operator´s external batch number(VBAP-OIC_PBATCH).

Is there any other BAPI thru which i can update these fields while creation of Sales Order.

The Fields which I can provide to BAPI as import parameter is:

Order Type(VBAK-AUART),

Contract(VBAK_VGBEL),

SALES Org (VBAK-VGORT),

Dist Channel(VBAK-VTWEG),

Division (VBAK-SPART),

Open Quantity (VBAK-KWMENG)

Plant(VBAP-WERKS)

Storage Location (VBAP-LGORT)

Mode of transport(VBAP-OIC_MOT), Forwarding Agent(VBAP-OIC_LIFNR), Base Location(VBAP-OIA_BASELO), Truck Number(VBAP-OIC_TRUCKN), Pipeline trip No.(VBAP-OIC_PTRIP), Pipeline operator´s external batch number(VBAP-OIC_PBATCH).

Thanks In Advance,

Points will be rewarded for Best Solution......

Yogesh Sharma

Re: BAPI for Sales Order Creation.

Former Member — Wed, 14 Feb 2007 09:37:25 GMT

Hi,

Try with this bapi..if it works out..BAPI_SALESDOCU_CREATEFROMDATA.

Regards,

Jayaram...

Re: BAPI for Sales Order Creation.

Former Member — Wed, 14 Feb 2007 09:39:36 GMT

Hi,

Otherwise try with the following bapis..

BAPI_SALESORDER_CREATEFROMDAT2

BAPI_SALESORDER_CREATEFROMDAT3.

Regards,

Jayaram...

Re: BAPI for Sales Order Creation.

Former Member — Wed, 14 Feb 2007 09:55:24 GMT

Hi Jayaram....

Thanks for the reply......

I am able to create the sales order using the BAPI's which u have mentioned but these BAPI"s doesn't update the Miscellaneous Information like Mode of transport(VBAP-OIC_MOT), Forwarding Agent(VBAP-OIC_LIFNR), Base Location(VBAP-OIA_BASELO), Truck Number(VBAP-OIC_TRUCKN), Pipeline trip No.(VBAP-OIC_PTRIP), Pipeline operator´s external batch number(VBAP-OIC_PBATCH).

For all the fields mentioned above there is no import parameter or structure available in these BAPI.

So Question is still open for the answer.......

Re: BAPI for Sales Order Creation.

Former Member — Wed, 14 Feb 2007 14:58:57 GMT

hi,

I can give u a suggestion .. try it ..

its a quite a long process....

in BAPI_SALESORDER_CREATEFROMDAT2

there is a table EXTENSIONIN...

here u can add append structure and carry on ur sales order creation

Follow the process

Customer Enhancement for VBAK, VBAP, VBEP

Description

You can use this parameter to transfer user-specific enhancments to a BAPI. The customer has to complete the EXTENSION structure and the system automatically continues processing it. If you have not defined any user-specific fields, then you can transfer a blank EXTENSIONIN structure.

Technical information about Customer Enhancements

The following description uses an example to explain how to proceed with customer enhancements to the SD tables VBAK, VBKD, VBAP and VBEP.

The customer has added their own fields to table VBAP using the INCLUDE structure CUTEST. This structure contains 2 fields:

CFIELD1, CHAR 10

CFIELD2, CHAR 3.

The customer also requires that these two fields can be maintained with the BAPI.

1. Maintain structure CUTEST in table VBAP

2. Because the BAPIs work with checkboxes, you must also define a CUTESTX checkbox for the customer structure. It should be structured like this:

Field name Data element

CFIELD1 CHAR1

CFIELD2 CHAR1

3. Define these customer structures in the structures VBAPKOZ und VBAPKOZX using INCLUDE or APPEND.

4. Add the customer structures to the BAPE_VBAP and BAPE_VBAPX BAPI structures using the APPEND technique.

5. Adjust the following structures for customer enhancements to table VBAK:

a) VBAKKOZ

b) VBAKKOZX

c) BAPE_VBAK

d) BAPE_VBAKX

6. Adjust the following structures for customer enhancements to table VBEK:

a) VBEPKOZ

b) VBEPKOZX

c) BAPE_VBEP

d) BAPE_VBEPX

7. Generally, the data should be added to the BAPI interface in the internal communication structures (VBAKKOM, and so on). There, you can process the data in the SD tables (VBAK, and so on).

8. If the EXTENSIONIN parameter contains customer data, you must complete at least the key fields in the relevant standard parameters.

For example:

You want to change customer field VBAP-CFIELD2 for item 20 to "XYZ" in order 4711.

The following entries are expected:

Import: BAPIVBELN-VBELN = '0000004711' Document number

BAPISDHD1X-UPDATEFLAG = 'U' UPDKZ for doc header

Tables: BAPISDITM-ITM_NUMBER = '000020' Item number

BAPISDITMX-ITM_NUMBER = '000020' Item number

+ BAPISDITMX-UPDATEFLAG = 'U' UPDKZ for item

You must complete the EXTENSION table as follows:

STRUCTURE VALUEPART1 1234561234567890123

BAPE_VBAP 0000004711000020 XYZ

BAPE_VBAPX 0000004711000020 X

Further Information

You can find more information in the BAPI programming guide in the chapter for enhancements to BAPIs.

Notes

You must complete the STRUCTURE field with the name of the relevant enhancement structure (BAPE_VBAK, BAPE_VBAP, BAPE_VBEP). You can complete the remaining fields with the append structures from the enhancement structures.

At the moment, you can use the BAPI to store enhancements in the following structures:

VBAK : An enhancement to header data requires an append structure to BAPE_VBAK and an enhancement to structure VBAKKOZ.

VBAP : An enhancement to item data requires an append structure to BAPE_VBAP and an enhancment to structure VBAPKOZ.

VBEP : An enhancement to schedule line data requires an append structure to BAPE_VBEP and an enhancement to structure VBEPKOZ.

VBKD : If you are using an enhancement for header data, you must add an append structure to BAPE_VBAK. You also need to enhance structure VBAKKOZ. If it is for item data, you need to add an append structure to BAPE_VBAP. You must also enhance structure VBAPKOZ.

If you also want to work with checkboxes, each X-structure must also contain an append structure.

For example:

A customer has created an order and wants to include the material long text (50 digits long).

The EXTENSIONIN structure must be completed with BAPE_VBAP. Two fields have fixed definitions in this structure. These are in the VBAP host key (VBELN, POSNR). The customer sets up an append structure that contains field ZMAT50.

Because the VBELN is normally blank when you create an order, the data can look like this:

STRUCTURE |BAPE_VBAP

VALUEPART1 | 000010Customermateriallongtext50

VBELN POSNR ZMAT50

Re: BAPI for Sales Order Creation.

Former Member — Wed, 14 Feb 2007 15:02:37 GMT

Hi ratandip,

Thanks for the reply....

This solution works perfect......

Points Rewarded........

Thanks again...

Yogesh