Archiving Vehicle Activities (SCM-EWM-SR)

Definition

Archiving object WME_VEH for archiving and deleting Shipping and Receiving Activity for Vehicles (vehicle activities).

Structure

Tables

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

Table

Description

Explanation

/SCWM/VEHICLE

Vehicle

This database table contains the data for the vehicle itself.

/SCWM/VEH_IDENT

Table with Vehicle Identifications

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

/SCWM/VEH_SR_ACT

S&R Activities of a Vehicle

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

/SCWM/VEH_STATUS

Status of Vehicle Activities

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

Programs

The following programs are available for WME_VEH:

Program

Function

WME_ARCH_VEH_MARK

Mark only (preprocessing program)

WME_ARCH_VEH_WRITE

Write only

WME_ARCH_VEH_MARK_AND_WRITE

Mark and write

WME_ARCH_VEH_DELETE

Delete

WME_ARCH_VEH_READ

Read and display

Write

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

  • Relevant vehicle data

  • All status entries

  • All identifiers

Prerequisites for writing vehicle activities

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

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

  • No transportation units (TUs) are assigned to the vehicle activity any more.

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.

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

Database Table

Field

Internal Vehicle Number

/SCWM/VEH_SR_ACT

VEH_NUM

External Vehicle Number

/SCWM/VEHICLE

VEH_NUM_EXT

License Plate Number

/SCWM/VEH_SR_ACT

LIC_PLATE

Transportation Service Provider

/SCWM/VEH_SR_ACT

TSP_CURR

Actual Activity Start

/SCWM/VEH_SR_ACT

START_ACTUAL

Actual Activity End

/SCWM/VEH_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 vehicle activity multiple times without deleting it, the system searches through the data sources in the following order:

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

  2. The system reads the vehicle 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 vehicle 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 vehicle master data).

Display

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

You can display the following dependent data for the current vehicle activity:

  • Data record with general vehicle data (Vehicle Master Data pushbutton)

  • Table with the relevant status entries (Status pushbutton)

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

  • Assignments of the vehicle activity to one or more shipping and receiving activities for transportation units (TU activities) (Vehicle <-> TU pushbutton)

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

ILM-related Information for WME_VEH

Archiving object WME_VEH is connected to the ILM object WME_VEH.

The ILM object WME_VEH 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_VEH.

The ILM object WME_VEH is assigned to the policy category RTP (Retention Rules).

Checks of WME_VEH

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 vehicle 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 pathSAP 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 Vehicle Activities

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

  • Field catalog SAP_WME_VEH

  • Archive information structure SAP_WME_VEH