Tracking Number Information in B2B sales order line item

[Former Member]

Hello Experts

Does anyone aware of the settings to be done to get tracking number (e.g tracking number given by DHL, Carrier Company) displayed on sales order line item.

Following steps has been followed, but we can not see the tracking number at the line item level:

Tracking the Shipping Status

You can enable customers to track the shipping status of their Web shop orders using an external shipping provider. If the external shipping agency offers shipping information on the Internet, customers can access the shipping status directly via a hyperlink from the order. This enables customers to track their delivery during the shipping process.

Prerequisites

u2022 Your appointed haulage firm offers the shipping status tracking service.

u2022 The haulage firm has assigned a bill of lading for each order and informed you of it.

Activities

1. Call transaction VL03N in the ERP system.

2. Choose Display <-> Change.

3. Choose Goto Header Partners . Enter the data of the corresponding carrier.

4. Choose Shipment. In BillOfLad, enter the tracking number.

Folks, any help will be highly appreciated

Thanks

DJ

[akhil_mishra]

Hi All,

I am facing issue with Tracking Icon at Line Item level of completed orders, after my ECC Backend is upgraded to EHP7. Any idea how to fix the issue and get the functionality back. Thanks in Advance.

[Former Member]

DJ,

Could you achieve the tracking numbers at the line item level. Can you please share your thoughts if I need to change the ECC function modules or I need to do the custom java coding for this.

Thanks!

Surya

[Former Member]

Thanks

[Former Member]

Hi DJ,

Most of the settings that are required to display the tracking number in the web shop are ECC dependent. The function module that gets the tracking related information in the Run Time is CRM_ISA_BASKET_STATUS_ENH.

In the above function module at line number 383 contains the relevant logic to get the tracking related information from the ECC system. At this line number the function module BAPI_XSI_GET_VTRK_G is called remotely in ECC.

ABAP Stack in ECC:

BAPI_XSI_GET_VTRK_G (FUNCTION MODULE)

XSI_CREATE_TRACK_URLS (FUNCTION MODULE)

TRK_GET_URLS (SUBROUTINE)

XSI_CREATE_TRACK_URL_MULTI (FUNCTION MODULE)

XSI_CREATE_TRACK_URL (FUNCTION MODULE)

Transaction Codes where the settings need to be done in ECC:

1. VTRC - Maintain Express Delivery Company

2. 0VVT - Set Up : Express Delivery Company

3. VTRK - Parcel Tracking

Database tables relevant for Tracking in ECC:

1. VXSITDU u2013 Express Delivery Company : URLs

2. VXSITDL u2013 Express Delivery Company Data Field

3. VTRKH u2013 Tracking Data Header

4. VTRKP u2013 Tracking Data Item

5. VLBL u2013 Express Delivery Company Data Field

6. TCAVAR u2013 Carrier URL Connection (Substitution of Variables)

7. TCAURL u2013 Carrier URL Connection

8. EKES u2013 Vendor Confirmations

Best Regards,

Chanakya Reddy

[Former Member]

Friends,

Appreciate any pointers to achieve this functionality.

Thanks!

Surya.

[Former Member]

Make sure you have a Forwarding Agent in the delivery header, as others have noted.

Make sure that the shop settings have "No Tracking with Express Delivery Companies (XSI)" turned on in the Transaction tab, or else it will call a completely different function module to determine the URL from the XSI settings.

Cheers

Dom

[DeborahCJ]

Here is some additional URL info for table TCAURL /TCAVAR for 3 major carriers.

Category User ID URL

TRACK_URL DHL http://www.dhl.com/track/track.post-track?awb=<AWBN>&origin=<COUNTRY>;

TRACK_URL FEDEX http://www.fedex.com/cgi-bin/track_it?trk_num=<AWBN>&dest_cntry=<DES_CTRY>&ship_date=<SHIPDATE>;

TRACK_URL UPS http://www.ups.com/tracking/tracking.cgi?tracknum=<AWBN>;

For TCAVAR. Enter the required data.

Example

Category User ID Function Module

URL <AWBN> WS_READ_AIRWAYBILLNUMBER

URL <COUNTRY> WS_READ_COUNTRY_OF_ORIGIN

URL <DES_CTRY> WS_READ_DEST_COUNTRY

URL <SHIPDATE> WS_READ_SHIPDATE

[Former Member]

Check your configuration steps.

1. In XCM - Tracking with Express Delivery Companies - you have chosen the correct option.

2. Prepare tables in R3. Transaction SM30, table TCAURL and TCAVAR to maintain the URL of tracking companies and the tracking variables.

3. You have created a forwarding agent partner function in transaction VOPA in the SAP R33 System and assigned it to the delivery note LF (for delivery category LF).