Export Container Load Volume and Weight Planning Program
Short answer: A custom program that calculates the gross weight and volume of export deliveries ready for loading from carton, roll or pallet dimensions, distributes them to the selected container types (for example 20', 40', 40' HC), shows the fill rate of each container and creates one shipment document per container from the approved plan. Shipping teams know how many containers they need before loading and avoid sending half-empty containers.
- Estimated effort
- M · 8–10 working days
- System
- ECC and S/4HANA
- Tables
- 8
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
VT01N shows the total weight and volume of the deliveries added to a shipment, but it does not split deliveries automatically by container capacity or propose how many containers are needed. Three-dimensional load planning is possible in SAP Transportation Management, but that is a separate component that needs its own implementation. The custom program quickly builds the container plan from existing delivery, packaging and unit of measure data.
Who uses it? Export and shipping teams, logistics planning, customs and foreign trade operations.
Closest standard alternatives
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| LIKPDelivery Header | Delivery header: shipping point, goods issue date, ship-to party | Read | ECC + S/4 |
| LIPSDelivery Item Data | Delivery items: material, quantity, sales unit | Read | ECC + S/4 |
| KNA1Customer Master (General Section) | Name and country of the ship-to party | Read | ECC + S/4 |
| VEKPHandling Unit Header | Gross weight and volume of handling units | Read | ECC + S/4 |
| MARMUnits of Measure for Material | Weight, volume and dimensions of the sales unit | Read | ECC + S/4 |
| MARAGeneral Material Data | Allowed loading weight and volume of the container packaging material | Read | ECC + S/4 |
| VTTKShipment Header | Shipment header created per container | Write | ECC + S/4 |
| VTTPShipment Item | Shipment items: deliveries assigned to the container | Write | ECC + S/4 |
BAPIs and functions used
- BAPI_SHIPMENT_CREATECreate Shipment. Creates the shipment with its deliveries for each container
- BAPI_TRANSACTION_COMMITCommit a BAPI transaction. Commits each shipment separately
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_VSTEL | Shipping point | Range / multiple | LIKP-VSTEL | Yes | 1000 |
| S_WADAT | Planned goods issue date | Range / multiple | LIKP-WADAT | Yes | 18.11.2026 – 20.11.2026 |
| S_LAND1 | Destination country | Range / multiple | KNA1-LAND1 | No | DE |
| S_KUNNR | Ship-to party | Range / multiple | LIKP-KUNNR | No | — |
| S_CONT | Container types (packaging material) | Range / multiple | MARA-MATNR | Yes | CNT-20DC, CNT-40DC, CNT-40HC |
| P_FILL | Fill factor (%) | Single value | — | Yes | 90 |
| P_SPLIT | Allow a delivery to be split across containers | Checkbox | — | No | — |
| P_SHTYP | Shipment type | Single value | VTTK-SHTYP | No | 0001 |
| P_TPLST | Transportation planning point | Single value | VTTK-TPLST | No | 1000 |
| P_TEST | Test mode (plan only, no shipments created) | Checkbox | — | No | X |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Container no. | Calculated Sequence number of the container in the plan |
| 2 | Container type | MARA-MATNR |
| 3 | Delivery | LIKP-VBELN |
| 4 | Ship-to party | KNA1-NAME1 |
| 5 | Country | KNA1-LAND1 |
| 6 | Load units | Calculated Number of handling units or unpacked items |
| 7 | Gross weight (kg) | Calculated Σ VEKP-BRGEW or LIPS quantity × MARM-BRGEW |
| 8 | Volume (m³) | Calculated Σ VEKP-BTVOL or LIPS quantity × MARM-VOLUM |
| 9 | Weight fill % | Calculated Total weight in container / (MARA-ERGEW × fill factor) × 100 |
| 10 | Volume fill % | Calculated Total volume in container / (MARA-ERVOL × fill factor) × 100 |
| 11 | Shipment | VTTK-TKNUM |
| 12 | Message | Calculated Plan or BAPI return message |
Sample result list
| Container no. | Container type | Delivery | Ship-to party | Country | Load units | Gross weight (kg) | Volume (m³) | Weight fill % | Volume fill % | Shipment | Message |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | CNT-40HC | 80041301 | Nordic Apparel GmbH | DE | 118 | 9,850 | 41.60 | 37.50 | 59.30 | 0000041210 | Shipment created |
| 1 | CNT-40HC | 80041304 | Nordic Apparel GmbH | DE | 74 | 6,120 | 25.90 | 61.10 | 96.60 | 0000041210 | Shipment created |
| 2 | CNT-20DC | 80041309 | Demo Retail Ltd. | GB | 52 | 4,380 | 22.80 | 17.40 | 76.40 | 0000041211 | Shipment created |
| 80041312 | Holland Textiles B.V. | NL | 0 | 0 | 0 | 0 | 0 | Error: volume missing on 3 items |
How does the program work?
- Deliveries in the selected shipping point and planned goods issue date that are not yet assigned to a shipment (VTTP) are read from LIKP; the ship-to country is filtered from KNA1.
- Load units are determined: for packed deliveries the gross weight and volume of the handling units in VEKP are used; for unpacked items the LIPS quantity × the weight and volume of the sales unit in MARM. Items with empty volume or weight go to the error list.
- Container types are given on the selection screen as packaging materials; the capacity comes from the allowed loading weight and volume in MARA and is multiplied by a fill factor (for example 90%).
- Deliveries are grouped by ship-to party, sorted by volume from largest to smallest and placed in the first container where they fit (first-fit decreasing). If splitting is not allowed, a delivery is kept in a single container.
- The result is shown in the ALV per container with weight and volume fill rates.
- If test mode is off, a shipment (VTTK) is created for each container with BAPI_SHIPMENT_CREATE, the deliveries are added as shipment items (VTTP) and saved with BAPI_TRANSACTION_COMMIT; the result for each container is written to the log.
Performance notes
Limit deliveries by shipping point and date and check VTTP once with the selected delivery numbers. Read VEKP and MARM once with unique keys. Create shipments in a separate LUW per container.
Features
- Test mode (check without posting)
- Line-by-line result and error log
- ALV list (sort, filter, subtotals)
- Export to Excel The container loading plan can be downloaded as Excel for the loading team.
- Runs as a background job
Authorization objects
- V_LIKP_VSTDelivery authorization by shipping point
- V_VTTK_SHTShipment creation authorization by shipment type
- V_VTTK_TDSAuthorization by transportation planning point
Frequently asked questions
Does the program do three-dimensional placement?
No. It checks weight and volume together with a fill factor, which is enough in most cases to estimate the number of containers in advance. Rules such as roll orientation or no-stacking are reflected through the fill factor or an extra constraint per material.
Are the deliveries changed?
No. The program only creates shipments and adds the deliveries to them; delivery quantities and packing stay as they are. If the plan is not accepted, the shipment can be deleted and the program run again with different parameters.
Does it work on S/4HANA?
Yes. LE-TRA shipments and BAPI_SHIPMENT_CREATE can still be used in S/4HANA. In systems that use SAP TM, the same plan can be adapted to be handed over to TM instead of creating shipments.
Related reports
Overnight Outbound Delivery Creation Job for Due Sales Orders with Exception List
A custom background program that creates outbound deliveries every night for confirmed sales order items whose material availability date has come, …
Picked but Not Goods-Issued Deliveries Report
A custom ALV report that lists deliveries whose picking is complete but whose goods issue has not been posted, with the number of days they have been …
Wave Picking Transfer Order Creation Job by Loading Time
A background job that splits deliveries into waves (WM groups) by route and loading time, creates a group for each wave and automatically creates the …
Let us build this program for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.