Example: Generating an Outbound Shipping Notice
The purpose of this example is to illustrate the structure of a typical Shipping Notice document.
The first hierarchical level is shipment, the second is order number, and the third is item number. Each of these level breaks occurs in the F47037 table. The value placed next to a level is the value that is placed in the hierarchical level field (SZHL03) in the F47036 table.
This table is an example of shipment data for which you could send an Advanced Shipping Notice:
Shipment ID |
Order Number |
Item Number |
Quantity |
|---|---|---|---|
MF123 |
724 Sales Order (SO) |
1001 |
5 |
1002 |
7 |
||
850 SO |
8787 |
4 |
|
5454 |
3 |
||
MF789 |
548 SO |
1001 |
6 |
1002 |
17 |
||
653 SO |
8787 |
8 |
|
5454 |
3 |
In this example hierarchical setup, the highest level break, is shipment. The F47036 table contains the highest level break, or Shipment ID. The EDI Ship Notice/Manifest Header table would contain these two records:
Type |
Sequence |
EDI Document Number |
Shipment ID |
|---|---|---|---|
H |
01 |
1 |
MF123 |
H |
01 |
2 |
MF789 |
The outbound F47037 table contains the records listed in this table. This table displays three level breaks for the data. The highest level break is Shipment ID, the next break is Order Number, and the third break is Item Number. The quantity (QTY) column reflects the total amount for that level break. For example, Shipment ID MF123 contains a total of 19 items. Order Number 724 and Shipment ID MF123 contain a total of 12 items. Item Number 1001, Order Number 724, and Shipment MF123 contain a total of five items.
Type |
Seq. |
EDI Doc # |
EDI Line # |
Hier. Lvl |
Hier. Code |
Shipment ID |
Order # |
Item # |
Qty |
|---|---|---|---|---|---|---|---|---|---|
D |
01 |
1 |
1 |
1 |
S |
MF123 |
724 SO |
1001 |
19 |
D |
01 |
1 |
2 |
2 |
O |
MF123 |
724 SO |
1001 |
12 |
D |
01 |
1 |
3 |
3 |
I |
MF123 |
724 SO |
1001 |
5 |
D |
01 |
1 |
4 |
3 |
I |
MF123 |
724 SO |
1002 |
7 |
D |
01 |
1 |
5 |
2 |
O |
MF123 |
850 SO |
8787 |
7 |
D |
01 |
1 |
6 |
3 |
I |
MF123 |
850 SO |
8787 |
4 |
D |
01 |
1 |
7 |
3 |
I |
MF123 |
850 SO |
5454 |
3 |
D |
01 |
2 |
1 |
1 |
S |
MF789 |
548 SO |
1001 |
34 |
D |
01 |
2 |
2 |
2 |
O |
MF789 |
548 SO |
1001 |
23 |
D |
01 |
2 |
3 |
3 |
I |
MF789 |
548 SO |
1001 |
6 |
D |
01 |
2 |
4 |
3 |
I |
MF789 |
548 SO |
1002 |
17 |
D |
01 |
2 |
5 |
2 |
O |
MF789 |
653 SO |
8787 |
11 |
D |
01 |
2 |
6 |
3 |
I |
MF789 |
653 SO |
8787 |
8 |
D |
01 |
2 |
7 |
3 |
I |
MF789 |
653 SO |
5454 |
3 |
The key to creating the various hierarchy levels is the data sequencing. This table is an example of data sequencing used to produce the Advanced Shipping Notice:
Field |
Sequence |
|---|---|
Shipment ID (Order Number, Container ID, Delivery Note, Invoice, Shipment Number, or Job Number) |
1 |
Order Number |
2 |
Item Number |
3 |