on ‎2024 Dec 14 1:06 PM
Hi Team,
We require Fragmented-based Adobe forms to change the layout and make some calculations as below.
Requirement Explanation in detail.
1. Table 1(Raw Data) shows the possible cases of materials packed in handling units. There is a chance of mixed cases as shown(ie., Multiple materials can be packed in a single pallet).
2. Table 2 - Format provided by Standard output type(DELIVERY_PACKING_LIST). Handling units followed by Materials packed.
3. Table 3 - Format required for our client to transpose the data and display it in the form.
| Existing format provided in SAP Public cloud | ||||
| Handling Units | Material | Qty | Gross Weight | Gross Volume |
| HU1 | 50 | 100 | ||
| 330000184 | 10 | |||
| HU2 | 50 | 100 | ||
| 330000184 | 20 | |||
| HU3 | 50 | 100 | ||
| 330000185 | 10 | |||
| HU4 | 50 | 100 | ||
| 330000186 | 10 | |||
| HU5 | 50 | 100 | ||
| 330000187 | 10 | |||
| 330000188 | 15 | |||
| HU6 | 50 | 100 | ||
| 330000189 | 20 | |||
| HU7 | 50 | 100 | ||
| 330000189 | 10 | |||
| HU8 | 50 | 100 | ||
| 330000189 | 10 | |||
| HU9 | 50 | 100 | ||
| 330000189 | 10 | |||
| HU10 | 50 | 100 | ||
| 330000190 330000191 | 10 15 |
The required format for our client is as follows.
Kindly suggest.
Thanks in Advance.
Request clarification before answering.
| User | Count |
|---|---|
| 15 | |
| 9 | |
| 6 | |
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.