topic Re: BAPI_SALESORDER_CREATEFROMDAT2 in Application Development and Automation Discussions

BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Mon, 14 Apr 2008 14:23:48 GMT

Hi together,

we use method SALESORDER.CREATEFROMDAT2 with BAPI 'BAPI_SALESORDER_CREATEFROMDAT2' to create customer sales orders.

Now we want to add customer own field vbak-zzactcode to BUS 'ZBUS2032'.

Following the online docu I´ve copied method ZSALES.CREATEFROMDAT2 (referring to BAPI

'BAPI_SALESORDER_CREATEFROMDAT2' and added parameter 'zsales_deal" (linked to field vbak-zzactcode).

Due to the online docu we now 'have to adjust the coding of the BAPI'.

Unfortunately SAP doesn´t tell us anythin about 'what' coding.

Thanks for any help

Gerd

Re: BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Mon, 14 Apr 2008 15:09:10 GMT

Hi Gerd,

I think you havent studied the documentation correctly.

See the clear explanation from sap.

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

Please let me know if u need further info.

No need to copy into Z...

Instead we can make use of Extension in to populate these additional fields.

Regards,

sasi

Re: BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Mon, 14 Apr 2008 15:26:12 GMT

Hi sasi,

Well, I´ve already tried different approaches - note #143580 you mention here is just one of those.

My problem is that don´t understand points 8. and 9. of this note. (143580)

How do I fill parameter EXTENSIONIN within BAPI CreateFromDat2?

And how do I make sure, that:

1. my additional field appears in BD87

2. my additional field vbak-zz...is being filled?

Thanks in advance

Gerd

Re: BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Mon, 14 Apr 2008 16:45:13 GMT

Hi,

First you need to create a structure with your own fields.

If you have completed up to 7 th step,

In the 8th step add the same structure in VBAKKOM too.

Other than this nothign needs to be done.

For 9th step,

we have to fill the extensionin of structure BAPIPAREX .

STRUCTURE Specify the structure that you included in the standard table in above steps

VALUEPART1 so fill this parts with your additonal fields data, it can take upto max of 240 characters

This wil populate the data into the corresponding table if you maintian the above entries correctly.

Regards,

sasi

Edited by: sasidhar yalamanchili on Apr 14, 2008 6:55 PM

Re: BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Tue, 15 Apr 2008 05:34:11 GMT

Hi sasi,

I still have problems with step 9.

We want to use the BAPI for incoming sales orders (via IDOC/ALE interface). Thus I think it doesn´t make much sense to 'pre-fill' any table here.

best regards

Gerd

Re: BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Tue, 15 Apr 2008 08:43:19 GMT

Hi,

Supose the data is coming from an external system, adn you want to create sales orders in SAP using the FM 'BAPI_SALESORDER_CREATEFROMDAT2'.

For this you will all the structures and tables to pass to FM 'BAPI_SALESORDER_CREATEFROMDAT2' right.

So similary you have to send these additional data too.

If the external system is sednign these data then you can see it in BD87.If they are not sednign then you have to build ur own logic to fill these fields in the extensionin.

so what ever data you want to see in these Z..fileds needs to be filled in the extensionin, then only after the sales order got created these additional data will go and store in VBAK table.

Please let me know if you need further help.

Regards,

sasi

Edited by: sasidhar yalamanchili on Apr 15, 2008 10:44 AM

Re: BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Tue, 15 Apr 2008 11:17:09 GMT

Hi sasi,

yes, I need help.

We have an interface to an external system which creates simple flat files (*.txt).

The interface is based on IDOC technology; the sales orders are created with function module 'SD_SALESORDER_CREATE'.

The interface uses IDOC type SALESORDER_CREATEFROMDAT202 and message type SALESORDER_CREATEFROMDAT2 which is generated by BAPI CreateFormDat2.

In order to send the additional data we need to expand IDOC type SALESORDER_CREATEFROMDAT202.

And thus we have to plow through all the BAPI stuff... (trx. we30/31 would be so easy! - bummer)

I don´t have a clue, how/were to fill extensionin then. And I even don´t know if this helps at all.

best regards

Gerd

Re: BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Tue, 15 Apr 2008 12:12:52 GMT

Hi,

I suppose the data is coming from external system, and by using this data you yre creating sales orders in sap system.

Is this correct.

Regards,

sasi.

Re: BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Tue, 15 Apr 2008 12:26:02 GMT

Hi,

yep, that´s correct.

We import the data, create segments and post the IDOCs.

Therefore we use basic type SALESORDER_CREATEFROMDAT202 and message typ SALESORDER_CREATEFROMDAT2.

Best regards

Gerd

Re: BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Tue, 15 Apr 2008 13:14:18 GMT

Hi,

Then you already have data in the idocs.

And the idoc posting Function module is IDOC_INPUT_SALESORDER_CREATEFR,

So the idoc needs to have E1BPPAREX filled.

With the corresponding details, the structure name and the value part1.

So if the idoc is already filled in with these data in E1BPPAREX then automatically it will populate in the database, iF you completed all the steps mentioned above.

Please let me know if you need further help.

Reward points if useful.

Regards,

sasi

Re: BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Tue, 15 Apr 2008 15:12:19 GMT

Hi sasi,

That sounds great at first.

But one thing... The extension table (STRUCTURE; VALUEPART1;...) has to be filled for table VBAK. (structure E1BPPAREX)

That means,

1.) we have to add two lines - for structure BAPE-VBAK and BAPE_VBAKX and

2.) we have to put the document number (and other information) for VALUEPART1.

But the document number is not yet available at that time, since we use internal document numbers.

Do you have any idea?

Best regards

Gerd

Re: BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Tue, 15 Apr 2008 15:29:49 GMT

Hi,

No need to put the document number,

Just give the values in the same way as of your structure,

If ur structure contians one filed,

give the value of this field in valuepart1.

And you have to follow all the above steps that are present in the note.

for example:

Adjust the following structures for customer enhancements to table VBAK:

a) VBAKKOZ

b) VBAKKOZX

c) BAPE_VBAK

d) BAPE_VBAKX

Reward points if useful.

Regards,

sasi

Re: BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Wed, 16 Apr 2008 12:58:48 GMT

Hi sasi,

DONE!

Many thanks for your help! It works perfect with structure E1BPPAREX

Best regards

Gerd

Re: BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Wed, 16 Apr 2008 13:16:33 GMT

Hi,

Good to know that it helped you a lot.

Regards,

sasi

Edited by: sasidhar yalamanchili on Apr 16, 2008 3:23 PM