Combining 2 different table into a single staging table

Mathan

Hi everyone,

I am looking for a way to combine Warehouse Shipment Header 7320 and Warehouse Shipment line 7321 table into a single staging table, I have tried it to create manually, but no success because of the repeating fields. Can someone help me on what should be done to make it into one single staging table?

Thanks in advance

HannesHolst

Hi,

Copy all fields from the Header-table into the Line-table.
The Line-table determines the Primary fields.

HannesHolst

Hi,

Copy all fields from the Header-table into the Line-table.
The Line-table determines the Primary fields.

Mathan

Thank you for the reply HannesHolst.
since the single shipment has multiple lines, This won't mess up anything right?

HannesHolst

Mathan,

When thinking in Table-relations, of course, you would have something like this:


The green columns are coming from the Lines and the blue from the Header.

Mathan

Thank you,

so there is no need to delete the repeating fields which are in sales header while adding it?
For example the No. field over there in your example.

HannesHolst

I would in either case create a new table from scratch. Modifying an existing table this way will lead to problems caused by errors in objects which are rely on. For example Pages, Codeunit and Reports.

Mathan

Thanks for the answer and heads up