cancel
Showing results for 
Search instead for 
Did you mean: 

why data is not showing for (wkreg)region delivery plant in( 0sd_c03 )cube after mapping.

Former Member
0 Kudos

Hi experts,

i mapped region delivery plant in transformation(TRCS 2LIS_13_VDITM -> CUBE 0SD_C03) and under this i mapped in transformation(TRCS 2LIS_13_VDITM -> CUBE 0SD_C03) ,both are activated successfully .then i executed the dtp .

But when i am checking display data in(0SD_C03) in cube i am not getting (WKREG) DATA and also i am getting 00000 for remaining field.

since i used sane cube (0SD_C03) for previous issue ,like REGION(0REGION),BILLING TYPE etc fields are missing of previous issue.

But AT PSA LEVEL ALL DATA ARE COMING PROPERLY.

1)how get old  structure of the cube?fields of previous issue like sold to party,fiscal year,region,billing type , document no.,net value.

2) how to get data for material no.,material type,material group,region plant delivery,net value, payer,etc

please do reply me,I am waiting.

Thanks and regards,

jyotsna singh

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi experts,

please guide me the solution , after mapping successfully why data is not loading to cube.

I am waiting.

Thanks and regards,

jyotsna singh

Former Member
0 Kudos

Hi ,

referring to your previous thread

can you share what exactly you did in start routine? Alternatively, you can compare Dev mapping with QA mapping

Former Member
0 Kudos

Hi jyothi,

In TRCS 2LIS_13_VDITM -> CUBE 0SD_C03 transformation .....>change.....>click on start routine...

when i checked start routine then(region plant delivery) was there in  possible source field coloumn i drag it to right side....>conitinue.....activate....then transformation got activated.

Thanks and regards,

jyots

Former Member
0 Kudos
when i checked start routine then(region plant delivery) was there in  possible source field coloumn i drag it to right side....>conitinue.....activate.

sorry, but this statement is not clear to me, have you removed new info-object from start routine global declaration? and what you mean by drag it to right side? can you share the screen shot for better understanding?

Former Member
0 Kudos

yes i removed it.

Former Member
0 Kudos

there should be a standard start routine in this transformation, looks like it got disturbed and that is why you are not getting proper results..

can you cross verify the routine with QA transformation and see if you observe any difference?

Former Member
0 Kudos

Hi jyothi,

There is not any start routine in QA transformation ,its totally same like the screenshot i shred with you.

other than this what can we try?please let me know .

Thanks and regards,

jyotsna singh

Former Member
0 Kudos

Hi all ,

I used SD_C03(INFOCUBE) for two issues, and the problem is when i was working on latest issues to get region delivery plant data in BI ,changed some transformation ,then the old transformations got deleted .

how it happened i do not have any idea?

I took help from a abap consultant he added some break point in start routine aswelll end routine and when i saved  it and activated the transformation then executed dtp .....region delivery plant came till cube level .but still material group data is notcoming.

Thanks and regards,

Jyotsna singh

Former Member
0 Kudos

Hi,

I really do not have clear picture of what have changes in transformation level


..region delivery plant came till cube level .but still material group data is notcoming.

so, you can see data for all fields in cube, except Material Group?

Former Member
0 Kudos

Hi jyothi,

As we know i was not able to activate (TRCS 2LIS_13_VDITM -> CUBE 0SD_C03)  transformation after mapping (WEREG) region delivery plant .

Till psa region was showing data perfectly ,but at cube (0SD_C03) level region delivery plant data was not coming.


I do not have any knowledge of routines and also coding .

so one abaper did some changes in start routine and end routine for exp (break point and some loops).My aim to inform , how my problem got resolve,if any body will face problem like this then can check routines.


Material group i added at info source level  at (TRCS 2LIS_13_VDITM -> CUBE 0SD_C03)  transformation  and successfully ran DTP.I am able to see all data of all filed till cube level.

Thanks alot for the guidance.

Thanks and regards,

jyotsna singh

Former Member
0 Kudos

good to hear that your issue is solved

Former Member
0 Kudos

Hi,

Please  draft here the start routine, so that might be helpful to solve the issue.

Thanks,

Jai Ganesh J