Sorry to ask such a basic question but please provide explanation of the difference and purpose of sequence number (srnb) for tables tdsls045 and tdpur045. when a line item is created it automatically gets both a sequence number 0 and 1. Why both. What do they do. I also seen a sequence number 2 if you care to elaborate on that also?

When you create a sales/purchase order line a record is automatically inserted in tdsls045/tdpur045 with a sequence no zero. When a delivery/receipt is done against the order then a sequence 1 record is created. If there are multiple deliveries/receipts then you will see multiple records in there tables for an order line. The exception I think is collect orders. There is usually only a sequence zero records created for these types of orders.

Thank you - when there are multiple deliveries and receipts is a unique srnb used for each? Or are all deviveries and receipts issued srnb = 1

Each delivery is a unique srnb

Hi,

there is a difference between deliveries and receipts. The first delivery starts with the sequnce number 0. The first receipt on the other hand is the sequence number 1. Sequece number 0 in tdpur045 is kind of a copy of the purchase order line used to generate new receipt lines.