delta data upload

8/11/2019 delta data upload

1/9

Generated by Jive on 2014-09-03+02:00

1

Delta Data Upload Process from TM 9.0 toBW system

Introduction

The document provides the settings and process to be followed to enable delta data upload of Transportation

Management data from TM 9.0 system to BW. The SAP TM has different settings to be enabled to process the

delta data to BW.

Configurations and Pre-settings required for the delta data upload defined in this document.

SAP NetWeaver 7.3, Business content 7.37 SP04

TM 9.0 source system has to be created in the BW system.

RFC connections have to be established between TM and BW system.

TM Datasources should be replicated in BW system.

All TM related BI objects has to be installed from Business content.

TM data targets should have been scheduled with full data load in BW.

TM Standard datasources

Below are the standard TM 9.0 Transactional datasources which requires the delta initialization.


2/9

Delta Data Upload Process from TM 9.0 to BW system


2

Initialization of Delta Process in BW

Once full data is loaded from TM datasources in BW the further task would be uploading the delta records for

which delta initialization should be scheduled firstly in BW system.

Go to the respective infopackage of the datasource in BW (e.g., 0SCM_TM_TOR as in the next screen shot)

and initialize the delta process.


3/9



3

Once delta initialization is performed for the TM datasources in BW system the datasources can be seen in

Delta queue with zero records in TM system.


4/9



4

Enabling Delta Data upload in TM

To enable delta data upload from SAP TM to BW few settings have to be adopted for below Business objects

in SAP TM system.

Transportation Order (TOR) Transportation Request (TRQ)

Freight Settlement (FSD i.e., SFIR)

Forwarding Settlement ( FWSD i.e., CFIR)

Transportation Allocation (TAL)

Business Share (BSH)
http://scn.sap.com/servlet/JiveServlet/showImage/102-45811-1-269828/P3.png


5/9



5

Delta data upload should be enabled for above mentioned business objects in Maintain Output Management

Adapter Settingshighlighted in below customization screenshot.

Choose the Direct Output Agents (w/o PPF & w/o History)highlighted below. Select

TOR_BW_EXTRACTIONand choose details tab highlighted in the below screenshot.

Select the Enablecheckbox.


6/9



6

Once the lifecycle status is set to Completeand we have saved the business document the system writes the

data from TM business objects to the delta queue.

Check the Delta Queue

Go to Delta queue monitor RSA7 we can see 13 records added as delta data. Select the datasource

0SCM_TM_TOR choose display data entries to view the delta records.

Select the delta update and check.


7/9


8/9



8

Similarly select the Enablecheck box for below TM agents in Direct Output Agents (w/o PPF & w/o History)

and check the delta queue for the business objects mentioned in above section of this document.

TRQ_BW_EXTRACTION

SFIR_BW_EXTRACTION

CFIR_BW_EXTRACTION BSH_BW_EXTRACTION

TAL_BW_EXTRACTION

Schedule the Delta load to PSA and Data target in BW

Schedule the infopackage of that TM datasource in BW system for the delta records. Check the delta records

in PSA highlighted in below screenshot.

We can see the 13 delta records loaded to PSA.


9/9



9

Execute the DTP of the related data target of datasource highlighted in left-hand side in below screen, we can

see the request processed with 13 delta records transferred into BW data target.

Alternately the Standard TM metachains and process chains related to respective datasources can be

scheduled for timely update of delta records to BW from SAP TM.

delta data upload

Documents