on 11-07-2006 8:31 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 -
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
*
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What are the steps to be followed to get that key figure inside my 0SD_C05 cube .....
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Yes i have 0GR_WT_KG in cubes Key figure area
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.