2LIS_02* Data source setup table fillup

[Former Member]

Hi,

One of my 2LIS_02* extractor data load is failing from past few days and we fixed it by performing Initialization WITHOUT data transfer and deltas are running  as expected.

Our task is instead of performing Initialization WITH data transfer by deleting data in corresponding data targets, By considering historical data and time it will take to fill the setup table and system quite time (No transactions processed) we decided to perform selective setup table fillup and  repair full load to minimize down time by identifying the missing PO’s.

As entire system (ECC) quite time (User Lock out) is not possible on our global system, I have been asked to provide

what are transactions that are required to be locked in relation to Purchasing 2LIS_02* and

Any background jobs other that 2LIS_02*  Batch job to be stopped at the time of setup table fill up.

Thanks in advance.

[RamanKorrapati · Accepted solution]

Hi User,

Please name the Exact data source(s), based on that we can lock the t codes thru which are entering data into respective base tables.

Thanks

[Former Member · Accepted solution]

Hi,

The datasource i am loking is

2LIS_02_SCL,

2LIS_02_ITM &

2LIS_02_HDR.

Can you please provide me Transactions needs to be locked and Any background jobs other that 2LIS_02*  Batch job  by data source

Thanks in advance

[RamanKorrapati · Accepted solution]

Hi User,

Once we know the data source, thru that we can find base table related data source.

Like this way you can find base tables for data sources.

Go to LBWE---- select the particular datasource---Maintain Extract structure----You will get the table names Like MCEKKO---MCEKBE.In this remove MC , other term indicates Table name - EKKO,EKBE

Like that way you can find base tables for 3 data source.

Below are respective base tables for data sources, but you can cross check at LBWE

Data source    -  Base tables

2LIS_02_ITM  - EKKO, EKBE, EKPO,

2LIS_02_HDR - EKKO, EKBE,  EKPA.

2LIS_02_SCL  - EKKO, EKBE, EKET, EKPA.

Once we know the base tables, chekc with respective ECC team or MM team, thru them you will know the T- codes which are entering data into these base tables.

,

Thanks