topic Re: BAPI SALESORDER CREATE/CHANGE in Application Development and Automation Discussions

BAPI SALESORDER CREATE/CHANGE

Former Member — Tue, 08 Aug 2006 15:32:11 GMT

hi guys,

does anyone know how to use the INT_NUMBER_ASSIGNMENT field on the Sales Order create/Change BAPI's. I am having a problem as i am trying to add BOM Materials to the sales order.if i add 2 BOM's each explode and its messing up the schedule lines.we are proposing the line item number in the schedule lines tables.

Please let me know if anyone has ever used this...

Thanks

Re: BAPI SALESORDER CREATE/CHANGE

Former Member — Thu, 10 Aug 2006 05:23:34 GMT

I have used the internal assignment number and it works fine for multiple BOM Materials and multiple schedule lines, you have to set 'X' for internal assignment and the rest will be taken care internally.

Revert back if you need more info.

Thanks

Eswar

Note: Reward for helpful answers.

Re: BAPI SALESORDER CREATE/CHANGE

Former Member — Thu, 10 Aug 2006 15:26:09 GMT

hi eswar,

can u tell me if you still proposed the line item numbers in the schedule lines...can u tell me what all you filled in the ORDER_ITEMS_IN and SCHEDULE_LINES_IN tables...

i have tried various combinations and somehow nothing works....the order always gets created with either 0 quantity or runs schedule lines twice for one line item which overlaps...

Thanks

Re: BAPI SALESORDER CREATE/CHANGE

Former Member — Fri, 11 Aug 2006 09:50:01 GMT

I have tried for multiple BOM's and individual materials passing an item number for ORDER_ITEMS_IN, ORDER_ITEMS_INX. The same Item Number will be used in ORDER_SCHEDULES_IN, ORDER_SCHEDULES_INX.


   Suppose my order has: Item1 000010 BOM1
                         Item2 000020 MAT1
                         Item3 000030 BOM2
                         Item4 000040 MAT2
   These same item numbers i have used as reference while passing the values for schedule lines. I have even tried passing multiple schedules for the same item and it still works.
    Schedule Lines: Item1 000010 DATE1 QTY
                    ITEM1 000010 DATE2 QTY
                    ITEM2 000020 DATE1 QTY
                    ITEM2 000020 DATE2 QTY
                    ITEM3 000030 DATE1 QTY
                    ITEM4 000040 DATE2 QTY

    Update Flag will be I for both ITEMSX and SCHEDULESX.

    Apart from the above you have to pass 'X' for INT_NUMBER_ASSIGNMENT in the export parameters.

    Do try as above and revert back if you are still facing the problem.

Kind Regards

Eswar

Note: Reward for helpful answers

Re: BAPI SALESORDER CREATE/CHANGE

Former Member — Fri, 11 Aug 2006 10:34:00 GMT

Hello,

Set the INT_NUMBER_ASSIGNMENT as 'X'.

You need not assign any item numbers for the Line Item, if the system is internally calculating those.

However, you need to propose correct line item number in the schedule lines. The quantities will get assigned correctly.

So your structures will look like this :

INT_NUMBER_ASSIGNMENT = 'X'.

SALES_ITEMS_IN

Item1 000000 BOM1

Item2 000000 MAT1

Item3 000000 BOM2

Item4 000000 MAT2

Schedule Lines:

ITEM1 000010 QTY (for BOM1)

ITEM2 000040 QTY (for MAT1 assuming BOM1 has 2 items)

ITEM3 000050 QTY (for BOM2 assuming BOM2 has 3 items)

ITEM4 000090 QTY (for MAT2)

How are you proposing the line item numbers in schedule lines?

Re: BAPI SALESORDER CREATE/CHANGE

Former Member — Fri, 11 Aug 2006 10:43:38 GMT

Dear Vaishali

If we have to derive the number of components to determine the item number in schedule lines, i guess it will be troublesome and be an impact on the performance if we have like 10 BOMS in the Order or when we have nested BOM's. I guess starting with with 000010 and incrementing 10 for each item and giving the same for schedule lines will be easy to code and have a better performance.

Kindly correct me if i am wrong or missed anything.

Kind Regards

Eswar

Re: BAPI SALESORDER CREATE/CHANGE

Former Member — Fri, 11 Aug 2006 11:03:57 GMT

yes you are right.

Set INT_NUMBER_ASSIGNMENT = 'x' and assign line items and schedule lines in increasing order of 10 and the order is created correctly.

thanks!