Object documentationArchiving TU Activities (SCM-EWM-SR)

 

Archiving object WME_TU for archiving and deleting shipping and receiving activities for transportation units (TU activities).

Structure

Tables

SAP Extended Warehouse Management (EWM) uses the archiving object WME_TU to archive data from the following tables:

Table

Description

Explanation

/SCWM/TU_DLV

Assignment of Deliveries and HUs to Transportation Units

This database table shows the relationship between the TU activity and its contents (deliveries).

/SCWM/TU_DOOR

Assignment of Transportation Units to Doors

This database table contains the relationships between TU activities and door activities.

/SCWM/TU_IDENT

Table with TU Identifications

This database table contains identifiers. Each TU activity can be mapped externally by multiple identifiers.

/SCWM/TUNIT

Transportation Unit

This database table contains the data for the transportation unit (TU) itself.

/SCWM/TUNIT_SEAL

Seal for Transportation Units

This database table contains seal information for each TU activity.

/SCWM/TU_SR_ACT

S&R Activity of a Transportation Unit

This database table contains start dates/times and end dates/times. Each TU activity is defined by its start date/time and end date/time.

/SCWM/TU_STATUS

Status of Transportation Unit Activities

This database table contains statuses. The progress of each individual TU activity is described by various statuses.

/SCWM/TU_VEH

Assignment of Transportation Units to Vehicles

This database table contains one or more vehicle activities with which a TU activity can be linked.

Note Note

Each TU is connected to the stock information via a virtual handling unit (HU). The system deletes this HU as soon as the TU has been deleted. The system does not archive the HU information.

End of the note.
Programs

The following programs are available for WME_TU:

Program

Function

WME_ARCH_TU_MARK

Mark only (preprocessing program)

WME_ARCH_TU_WRITE

Write only

WME_ARCH_TU_MARK_AND_WRITE

Mark and write

WME_ARCH_TU_DELETE

Delete

WME_ARCH_TU_READ

Read and display
Write

Before the system writes TU activities to archive files, it changes the status from Archivable to Archived. You can no longer process archived TU activities. The system archives the following data for each TU activity:

  • Relevant TU data

  • All status entries

  • All identifiers

  • All seal information

  • All assignments to door activities

  • All assignments to vehicle activities

  • All assignments to deliveries

Prerequisites for writing TU activities

TU activities must have the status Archivable in order for the system to be able to archive them. The system flags a TU activity with the status Archivable if the following conditions have been met:

  • The activity end was at least 60 days ago (fixed value).

  • No stock is still assigned to the TU activity in Logistics Inventory Management Engine (LIME).

Delete

After writing the archive files, the system performs a test run where it reads the data in the archive files and compares it with the data in the database. If it does not find any differences, the system deletes the database data.

Note Note

Although the system always archives TU master data (/SCWM/TUNIT), it only deletes it from the database if the following condition has been met:

  • No other TU activities still exist.

End of the note.

When the system deletes the TU itself, the relevant HU information is also deleted automatically.

Read

The system uses the selection options to search for suitable activity data in the data sources. The following table shows the selection criteria available:

Text

Table

Field

Internal TU Number

/SCWM/TU_SR_ACT

TU_NUM

External TU Number

/SCWM/TUNIT

TU_NUM_EXT

License Plate Number

/SCWM/TU_SR_ACT

LIC_PLATE

Transportation Service Provider

/SCWM/TU_SR_ACT

TSP_CURR

Actual Activity Start

/SCWM/TU_SR_ACT

START_ACTUAL

Actual Activity End

/SCWM/TU_SR_ACT

END_ACTUAL

You can choose the following data sources:

  • Database

  • Archive file chosen manually

  • Archive Information System (AS)

If you choose all three data sources and the system has archived a TU activity multiple times without deleting it, the system searches through the data sources in the following order:

  1. The system reads the TU activity from the database.

  2. The system reads the TU activity from the archive file chosen manually, as appropriate, and overwrites the version found previously.

  3. The system uses the AS to search for the TU activity in multiple archive files, reads it, and overwrites the version found previously.

The last source that is found determines which data is displayed (in particular for the TU master data).

Display

A list of the TU activities found is displayed. The cursor position determines the current TU activity. You can use the Details pushbutton to display this current TU activity as a form.

Note Note

Only fields for which you have defined values are displayed in this form. The system suppresses fields with initial field values.

End of the note.

You can display the following dependent data:

  • Data record with general TU data (TU Master Data pushbutton)

  • Table with the relevant status entries (Status pushbutton)

  • Table with the external identifiers assigned to the TU activity (Identifiers pushbutton)

  • Table with the seal information assigned to the TU activity (Seal pushbutton)

  • Table with the door activities assigned to the TU activity (TU <-> Door pushbutton)

  • Table with the deliveries assigned to the TU activity (TU <-> Delivery pushbutton)

  • Assignments of the TU activity to one or more vehicle activities (TU <-> Vehicle pushbutton)

You can use the TU Activities pushbutton to return to the activity table.

Note Note

If you double-click the individual pushbuttons, you can display all the data records read, irrespective of the current TU activity. You can use the Details pushbutton to display the data in the format of a form.

End of the note.
ILM-related Information for WME_TU

Archiving object WME_TU is connected to the ILM object WME_TU.

The ILM object WME_TU also has the ILM constants LAST_CHANGE_DATE and START_RET_DATE as available time references. LAST_CHANGE_DATE and START_RET_DATE are mapped to the field END_ACTUAL (End Time) in the database table /SCWM/TU_SR_ACT.

Checks of WME_TU

For ILM actions Archiving and Data Destruction, the preprocessing program /SCDL/BO_ARCHIVE_STD checks the following:

  • The completion status of the PDOs

  • The residence time of the PDOs

For ILM actions Archiving and Data Destruction, the write program does not perform any business or technical checks during document selection. Only documents with archive status X are selected.

For ILM action Snapshot, it is not necessary to do any business checks.

Variant Settings for Preprocessing

As the selection criterion, you can specify the number of days that must have passed since the TU activities were completed (default value: 60 days). For more information about variant maintenance, see SAP Library for SAP NetWeaver at http://help.sap.com/nwInformation published on SAP site. In SAP Library, choose Start of the navigation path SAP NetWeaver Next navigation step SAP NetWeaver by Key Capability Next navigation step Solution Lifecycle Management by Key Capability Next navigation step Data Archiving Next navigation step Data Archiving in the ABAP Application System Next navigation step Data Archiving with Archive Development Kit (ADK) Next navigation step Executing Data Archiving Next navigation step Variant Maintenance for Archiving Jobs End of the navigation path.

Integration

Display Function for Archived TU Activities

You can use the following field catalog and archive information structure to access archived TU activities using the Archive Information System:

  • Field catalog SAP_WME_TU

  • Archive information structure SAP_WME_TU