Load transaction for datasource 2LIS_17_I0CAUSE and 2LIS_18_CAUSE no record

[former_member639260]

Hi All,

     when i actice infocube 0QM_C06. In step load transaction data for data source.I load successfully data source

2LIS_05_CAUSE see below.

but when i try to load data for data source 2LIS_17_I0CAUSE and 2LIS_18_CAUSE i have no records. See below

include steps:

     ERP : tcodes: LBWE : active datasource

                           LBWG: delete setups data.

                           OLIIBW: setup data

please! help me. what wrong??? and how i load transaction success??

[RamanKorrapati · Accepted solution]

Hi Thanh,

plz check the data source having data or not at RSA3 (ERP side) as well as check data was in at Setup tables. setup table naming conversion is SETUP(communication strname)..by seeing attached screen saying there no data at source.

Regards

[former_member639260 · Accepted solution]

Hi CHowthary,

     plz check. The first i active data source in LBWE see below,

and then del data LBWG see below,

and then load data OLIIBW see below,

finally, i check datasource in RSA3 see below,

[RamanKorrapati · Accepted solution]

Hi Thanh,

You deleted setup tables data fine, refilled, even though ur getting zero at RSA3, have check at base tables. if base tables have the data, then setup tables filling path will be the wrong, correct me i am wrong here.

regards

[former_member639260 · Accepted solution]

Hi CHowthary,

     plz guide detail! the next step i have to do?

[RamanKorrapati · Accepted solution]

Hi Thanh,

After refilling the setup tables for two data sources, plz check the data at setup tables using SE11.

names :

setup tables for DS 2LIS_17_I0CASUE  is MC17I00CSE+SETUP = MC17I00CSESETUP

for second data source same follow ,setup table name = Communication str+setup

after filling the setup tables there is no data in setup tables, plz check at sources tables..

Regards

[RamanKorrapati · Accepted solution]

Hi Thanh,

After the successful of filling setup tables, have you got any pop messe saying that with number records was loaded like that..

regards

[former_member639260 · Accepted solution]

Hi CHowthary,

After refilling the setup tables for two data sources, i check the data at setup tables using SE16N. But it not value found.

see below,

[RamanKorrapati · Accepted solution]

Hi Thanh,

your attached screen is table fields screen, you click on execute, it shows data, if available.

you go thru SE11, follow the same,(SE16N also will be the same).

if setup tables don't have data, please check at source tables at R/3 side...

sources table names you can find at LBWE

go to LBWE, click hyper link maintenance , its popup window which have right communication str, left side extract structure fields. in right side pool u wll see names EX: like MCVBAK. MCVBAP for sales data sources, remove MC, VBAK  and VBAP are the sales tables. so follow the same to find base tables for your data sources.

Regards

[former_member639260 · Accepted solution]

Hi CHowthary,

     I click on execute but it not show data ( no value found ) and  then I follow your instructions goto LBWE but i cant not find MC, VBAK  and VBAP

[RamanKorrapati · Accepted solution]

Hi thanh,

i said MCVBAK, MCVBAP is for sales nor Plant maintance.i just said exampls

by seeing ur screen , ur source table QMEL (MCQMEL),,

see the data is there or in table..

Even see the reply which given by Renjith kumar...

Am saying in general extraction ways.

regards

[RenjithKumar]

Dear Pham,

Since this is PM DataSource, have you checkeed these SAP note?

879320 Setup tables not filled

The extract from this note is to Maintain the STAFO field for the relevant message types. Then restart

the setup.

Also see this note

603934 Setup table is empty / no data is extracted (For QM based scenarios)

Also check table VIQMEL, It is header table and it should have value.

Regards

P Renjith kumar

[Former Member]

Hi Pham,

Please check RFC connection in source system. There might be TRFC issue.

Thanks,

Subhash

[former_member639260]

Hi Subhash,

     I load successfully data source 2LIS_05_CAUSE so it's not  TRFC issue.