How does SBO know which child items belong to which parent item ?

[kris_coppens]

How does SBO know which child items belong to which parent item of a SALES BOM in an ( f.i ) an sales order.

In other words : which fields of rdr1 play a role in this ?

I can't figure it out , the closest thing to an answer is the VisOrder field, which I guess would be a bit strange.

I need this info to do some reporting via a query.

Can anybody enlighten me ?

Kind Regards.

Kris

[Former Member]

Hi Kris,

I believe the original design of Sales BOM had not predicted you usage like this.

In common sense, one sales order should have only one Sales BOM.

Thanks,

Gordon

[Former Member]

We often have multiple Sales BOM items on the same Sales Order - i don't understand why it's common sense that Sales Orders should only have one.

We're running into an issue with having the SDK create Sales Orders with multiple BOMs (for our web orders). The SDK puts all the kit components (treeType='I') items as the last lines in RDR1. When you add a Sales Order with Sales BOMs through SAP Client, it places the kit component right after the father.

No big deal - Copy To > Delivery fixes it

BUT we're using the SDK to batch create delivery documents - and on these orders, it looses track of what Father goes with what child.

We're considering manually changing RDR1.LineNum values through SQL - shuffling the LineNums until the child is right after to parent - but i know that breaks SAP rules. I'm having trouble figuring out other options

[Former Member]

Hi Rob,

VisOrder is probably your best bet - the visual order of the lines. This is what we have used in Crystal Reports to determine which components go with which BOM...

[Former Member]

Hi Kris......

if you check ITT1 table the you get the Child and its Parent relationship which ultimately goes to OrderTable.

Check OITT and ITT1 tables and also its BOM type as its Sales/Production/Template.......

Hope this will help you.....

Regards,

Rahul

[kris_coppens]

Hi,

thx for your reply,

I'm with you but what if I append the same BOM serveral times to the same sales order and I change the quantity of the childitems in each case.

Kind regards

Kris

[Former Member]

Hi Kris......

You can have inner join of RDR1 with ITT1 where you get the proper result and if you want amendment history of BOM with updated Order then you have AITT and ATT1 with ADOC tables....

Build the proper relationship by using those tables......

Regards,

Rahul

[kris_coppens]

Hi,

Of course this would be good if a salesbom only appears once in a sales order but not if the salesbom is repeated (or do i miss something ? ).

Imagine a sales bom A ( a box of 12 B's )

In OITT : 1 A

in ITT1 : 12 B

Now I create an (1) order where I add this item A 3 times, changing in some cases the 12 to something else

In RDR1 I see this

LineNum ItemCode Quantity

0 A 1

1 B 12

2 A 1

3 B 10

4 A 1

5 B 15

Than I think joining with OITT en ITT1 would not help me. Imagine I even append a Sales BOM C ( a box of 100 B's ). THen I guess I cannot formally create the correct joins.

Moreover : apparently when using the DI-API to create this sales Order I get the next view in RDR1 :

LineNum ItemCode Quantity

0 A 1

1 A 1

2 A 1

3 B 12

4 B 10

5 B 15

( while in the User Interface all is very OK )

I can restore the above 'image' by using visorder instead of linenumber but somehow I think this is a very week link.

Kind regards.