cancel
Showing results for 
Search instead for 
Did you mean: 

LO Extraction

Former Member
0 Kudos

Hi ,

In LO Extraction Some Key fig values are in PSA , But not in cube , So i went to update ruke of Info cube and changed the Radio Button to Source Key Fig and selectec correct info object for that Now the data comes into cube .

When i do changes like this to Key Fig like

" Gross Weight In Kg '. and make source key fig to

0GROSS_WGT . In update rule changes to RED . So i cannt activate , So i could get data in Cube , But it is in PSA and in SETUP Tables ..

Regards

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Shiba,

This is not a LO probelm, but the proper mapping of update rules to your target. The red traffic light in update rules suggest that out of the available characteristics(including time characteristic), some info objects are not mapped for that update rule.

So have a recheck on the rule for populating the key figure and if every mapping in correct then the traffic light automatically converts to green.

Regards,

Naveen.A

Answers (9)

Answers (9)

Former Member
0 Kudos

Raveendra ,

The code you gave is there as default , i didnt change even a single line look at this code in routine

PROGRAM UPDATE_ROUTINE.

$$ begin of global - insert your declaration only below this line -

*

  • TABLES: ...

DATA: IN TYPE F,

OUT TYPE F,

DENOM TYPE F,

NUMER TYPE F.

  • Def. of 'credit-documents': following doc.categ. are 'credit docs'

  • reversal invoice (N)

  • credit memo (O)

  • internal credit memo (6)

  • Credit-documents are delivered with negative sign. Sign is switched

  • to positive to provide positive key-figures in the cube.

*

  • The combination of characteristics DE_CRED and DOC-CLASS provides

  • a comfortable way to distinguisch e.g. positive incoming orders or

  • order returns.

  • Def. der 'Soll-Dokumente': folgende Belegtypen sind 'Soll-Belege'

  • Storno Rechnung (N)

  • Gutschrift (O)

  • Interne Verrechn. Gutschr. (6)

  • Soll-Dokumente werden mit negativem Vorzeichen geliefert. Um die Kenn-

  • zahlen positiv in den Cube zu schreiben, wird das Vorzeich. gedreht

  • Die Kombination der Merkmale DEB_CRED und DOC-CLASS gibt Ihnen die

  • Möglichkeit schnell z.B. zwischen Auftrags-Eingang oder Retouren zu

  • unterscheiden.

DATA: DEB_CRED(2) TYPE C VALUE 'HK'.

DATA: QUOT(1) TYPE C VALUE 'B'.

constants: c_msgty_e value 'E'.

$$ end of global - insert your declaration only before this line -

FORM compute_data_field

TABLES MONITOR STRUCTURE RSMONITOR "user defined monitoring

USING COMM_STRUCTURE LIKE /BIC/CS2LIS_11_VAITM

RECORD_NO LIKE SY-TABIX

RECORD_ALL LIKE SY-TABIX

SOURCE_SYSTEM LIKE RSUPDSIMULH-LOGSYS

CHANGING RESULT LIKE /BI0/V0SD_C05T-GR_WT_KG

RETURNCODE LIKE SY-SUBRC

ABORT LIKE SY-SUBRC. "set ABORT <> 0 to cancel update

*

$$ begin of routine - insert your code only below this line -

  • fill the internal table "MONITOR", to make monitor entries

CLEAR RESULT.

DATA: WEIGHT LIKE COMM_STRUCTURE-GROSS_WGT.

IF COMM_STRUCTURE-DOC_CATEG EQ QUOT.

IF COMM_STRUCTURE-UNIT_OF_WT NE 'KG'.

WEIGHT = COMM_STRUCTURE-GROSS_WGT.

CALL FUNCTION 'UNIT_CONVERSION_SIMPLE'

EXPORTING

INPUT = COMM_STRUCTURE-GROSS_WGT

UNIT_IN = COMM_STRUCTURE-UNIT_OF_WT

UNIT_OUT = 'KG'

IMPORTING

OUTPUT = WEIGHT

EXCEPTIONS

CONVERSION_NOT_FOUND = 1

DIVISION_BY_ZERO = 2

INPUT_INVALID = 3

OUTPUT_INVALID = 4

OVERFLOW = 5

TYPE_INVALID = 6

UNITS_MISSING = 7

UNIT_IN_NOT_FOUND = 8

UNIT_OUT_NOT_FOUND = 9

OTHERS = 10.

IF SY-SUBRC NE 0.

CLEAR MONITOR.

MONITOR-msgno = '009'.

MONITOR-msgid = 'SDBW'.

MONITOR-msgty = c_msgty_e.

MONITOR-msgv1 = COMM_STRUCTURE-UNIT_OF_WT.

append MONITOR.

RETURNCODE = 4.

WEIGHT = 0.

ELSE.

RESULT = WEIGHT.

RETURNCODE = 0.

ENDIF.

ELSE.

RESULT = COMM_STRUCTURE-GROSS_WGT.

RETURNCODE = 0.

ENDIF.

IF COMM_STRUCTURE-DOC_CATEG CA DEB_CRED.

RESULT = RESULT * ( -1 ).

ENDIF.

ENDIF.

  • if abort is not equal zero, the update process will be canceled

ABORT = 0.

$$ end of routine - insert your code only before this line -

*

ENDFORM.

Now tell where to change

Former Member
0 Kudos

Hi ,

I have used all the key figures with default routine gi ven , If i view PSA there is data for Subtotal 1 , Subtotal 2 .

If i see i cube i can get data only for Subtotal 1 Not for subtotal 2 .

Similarly there are many fields which have data in PSA but no data in Cube . Cube shows the field name with blank data .

I need your help to solve this issue .

Former Member
0 Kudos

Hi Rana,

write as below shown write the code which i specified in bold.. between the " $$ line " as i specified below

$$ begin of global - insert your declaration only below this line -

<b>DATA: IN TYPE F,

OUT TYPE F,

DENOM TYPE F,

NUMER TYPE F.

DATA: DEB_CRED(2) TYPE C VALUE 'HK'.

DATA: QUOT(1) TYPE C VALUE 'B'.

constants: c_msgty_e value 'E'.</b>

$$ end of global - insert your declaration only before this line -

$$ begin of routine - insert your code only below this line -

<b>CLEAR RESULT.

DATA: WEIGHT LIKE COMM_STRUCTURE-GROSS_WGT.

IF COMM_STRUCTURE-DOC_CATEG EQ QUOT.

IF COMM_STRUCTURE-UNIT_OF_WT NE 'KG'.

WEIGHT = COMM_STRUCTURE-GROSS_WGT.

CALL FUNCTION 'UNIT_CONVERSION_SIMPLE'

EXPORTING

INPUT = COMM_STRUCTURE-GROSS_WGT

UNIT_IN = COMM_STRUCTURE-UNIT_OF_WT

UNIT_OUT = 'KG'

IMPORTING

OUTPUT = WEIGHT

EXCEPTIONS

CONVERSION_NOT_FOUND = 1

DIVISION_BY_ZERO = 2

INPUT_INVALID = 3

OUTPUT_INVALID = 4

OVERFLOW = 5

TYPE_INVALID = 6

UNITS_MISSING = 7

UNIT_IN_NOT_FOUND = 8

UNIT_OUT_NOT_FOUND = 9

OTHERS = 10.

IF SY-SUBRC NE 0.

CLEAR MONITOR.

MONITOR-msgno = '009'.

MONITOR-msgid = 'SDBW'.

MONITOR-msgty = c_msgty_e.

MONITOR-msgv1 = COMM_STRUCTURE-UNIT_OF_WT.

append MONITOR.

RETURNCODE = 4.

WEIGHT = 0.

ELSE.

RESULT = WEIGHT.

RETURNCODE = 0.

ENDIF.

ELSE.

RESULT = COMM_STRUCTURE-GROSS_WGT.

RETURNCODE = 0.

ENDIF.

IF COMM_STRUCTURE-DOC_CATEG CA DEB_CRED.

RESULT = RESULT * ( -1 ).

ENDIF.

ENDIF.

  • if abort is not equal zero, the update process will be canceled

ABORT = 0.</b>

$$ end of routine - insert your code only before this line -

Former Member
0 Kudos

Hi There was error in pasting ,

In my routine i have this code in grey color ,

<b> FORM compute_data_field

TABLES MONITOR STRUCTURE RSMONITOR "user defined monitoring

USING COMM_STRUCTURE LIKE /BIC/CS2LIS_11_VAITM

RECORD_NO LIKE SY-TABIX

RECORD_ALL LIKE SY-TABIX

SOURCE_SYSTEM LIKE RSUPDSIMULH-LOGSYS

CHANGING RESULT LIKE /BI0/V0SD_C05T-GR_WT_KG

RETURNCODE LIKE SY-SUBRC

ABORT LIKE SY-SUBRC. "set ABORT <> 0 to cancel update

*</b>

Others is same , Now what to do

Former Member
0 Kudos

Hi raveendra ,

I checked the routine this code in in grey color ,

FORM compute_data_field

TABLES MONITOR STRUCTURE RSMONITOR "user defined monitoring

USING COMM_STRUCTURE LIKE /BIC/CS2LIS_11_VAITM

RECORD_NO LIKE SY-TABIX

RECORD_ALL LIKE SY-TABIX

SOURCE_SYSTEM LIKE RSUPDSIMULH-LOGSYS

CHANGING RESULT LIKE /BI0/V0SD_C05T-GR_WT_KG

Others are there in routine ..

Now what change should i do ...

Regards ..

RETURNCODE LIKE SY-SUBRC

ABORT LIKE SY-SUBRC. "set ABORT <> 0 to cancel update

*

Former Member
0 Kudos

What are the steps to be followed to get that key figure inside my 0SD_C05 cube .....

Regards

Former Member
0 Kudos

Hi Shiba Prasad,

I think its not support the length and data type for field gross_wgt to 0GR_WT_KG.. so you need to writ e a routine to that try to write the routine to Key figure

0GR_WT_KG..

As follows..

<b>DATA: IN TYPE F,

OUT TYPE F,

DENOM TYPE F,

NUMER TYPE F.

DATA: DEB_CRED(2) TYPE C VALUE 'HK'.

DATA: QUOT(1) TYPE C VALUE 'B'.

constants: c_msgty_e value 'E'.

$$ end of global - insert your declaration only before this line -

FORM compute_data_field

TABLES MONITOR STRUCTURE RSMONITOR "user defined monitoring

USING COMM_STRUCTURE LIKE /BIC/CS2LIS_11_VAITM

RECORD_NO LIKE SY-TABIX

RECORD_ALL LIKE SY-TABIX

SOURCE_SYSTEM LIKE RSUPDSIMULH-LOGSYS

CHANGING RESULT LIKE /BI0/V0SD_C05T-GR_WT_KG

RETURNCODE LIKE SY-SUBRC

ABORT LIKE SY-SUBRC. "set ABORT <> 0 to cancel update

*

$$ begin of routine - insert your code only below this line -

  • fill the internal table "MONITOR", to make monitor entries

CLEAR RESULT.

DATA: WEIGHT LIKE COMM_STRUCTURE-GROSS_WGT.

IF COMM_STRUCTURE-DOC_CATEG EQ QUOT.

IF COMM_STRUCTURE-UNIT_OF_WT NE 'KG'.

WEIGHT = COMM_STRUCTURE-GROSS_WGT.

CALL FUNCTION 'UNIT_CONVERSION_SIMPLE'

EXPORTING

INPUT = COMM_STRUCTURE-GROSS_WGT

UNIT_IN = COMM_STRUCTURE-UNIT_OF_WT

UNIT_OUT = 'KG'

IMPORTING

OUTPUT = WEIGHT

EXCEPTIONS

CONVERSION_NOT_FOUND = 1

DIVISION_BY_ZERO = 2

INPUT_INVALID = 3

OUTPUT_INVALID = 4

OVERFLOW = 5

TYPE_INVALID = 6

UNITS_MISSING = 7

UNIT_IN_NOT_FOUND = 8

UNIT_OUT_NOT_FOUND = 9

OTHERS = 10.

IF SY-SUBRC NE 0.

CLEAR MONITOR.

MONITOR-msgno = '009'.

MONITOR-msgid = 'SDBW'.

MONITOR-msgty = c_msgty_e.

MONITOR-msgv1 = COMM_STRUCTURE-UNIT_OF_WT.

append MONITOR.

RETURNCODE = 4.

WEIGHT = 0.

ELSE.

RESULT = WEIGHT.

RETURNCODE = 0.

ENDIF.

ELSE.

RESULT = COMM_STRUCTURE-GROSS_WGT.

RETURNCODE = 0.

ENDIF.

IF COMM_STRUCTURE-DOC_CATEG CA DEB_CRED.

RESULT = RESULT * ( -1 ).

ENDIF.

ENDIF.

  • if abort is not equal zero, the update process will be canceled

ABORT = 0.

$$ end of routine - insert your code only before this line -

*

ENDFORM.</b>

Thanks,

ravi.p

Former Member
0 Kudos

Yes i have 0GR_WT_KG in cubes Key figure area

Former Member
0 Kudos

Hi ,

If i look update rule Key figure :

Gross weight in Kg . When i select source key fig i get

only

<b>0GROSS_WT</b> .

But the correct info object for this is

<b>0GR_WT_KG</b> . " This is correct Info Object

This is not at all shown in Search help selection list .

I have to select only first , But if i select that it

is not accepting and showing red.

How to bring that 0GR_WT_KG Info object into the search

help of This key figure .

Regards

Former Member
0 Kudos

Hi

Just a small clarification do you have that GR_WR_...object in the infocube

thanks

sreedhar

Former Member
0 Kudos

hI ,

If i look update rule Key figure :

Gross weight in Kg . When i select source key fig i get

only

0GROSS_WT .

But the correct info object for this is

0GR_WT_KG .

This is not at all shown in Search help selection list .

I have to select only first , But if i select that it

is not accepting and showing red.

How to bring that 0GR_WT_KG Info object into the search

help of This key figure .

Regards

shanthi_bhaskar
Active Contributor
0 Kudos

hi,

i update rules u hav to assign source system which should hav same Data Dictionary properties as that of Gross-weght infoobject.

if u dont have that object in bw side then u can write routine for that in object level

hope it helps..

bhaskar