0 - Exit Variables BW // FM

*I_STEP = 1 Call takes place directly before variable entry

*I_STEP = 2 Call takes place directly after variable entry. This step is only started up when the same

*variable is not input ready and could not be filled at I_STEP=1.

*I_STEP = 3 In this call, you can check the values of the variables. Triggering an exception (RAISE)

*causes the variable screen to appear once more. Afterwards, I_STEP=2 is also called again.

*I_STEP = 0 The enhancement is not called from the variable screen. The call can come from 

*the authorization check or from the Monitor.

DATA: l_d_fmname(30) TYPE c.

CASE i_step.

  WHEN 0.

    CONCATENATE 'Z_VAR0_' i_vnam INTO l_d_fmname.

  WHEN 1.

    CONCATENATE 'Z_VAR1_' i_vnam INTO l_d_fmname.

  WHEN 2.

    CONCATENATE 'Z_VAR2_' i_vnam INTO l_d_fmname.

  WHEN 3.

    l_d_fmname = 'Z_VAR3'.

ENDCASE.

TRY.

    CALL FUNCTION l_d_fmname

      EXPORTING

        i_vnam        = i_vnam

        i_vartyp      = i_vartyp

        i_iobjnm      = i_iobjnm

        i_s_cob_pro   = i_s_cob_pro

        i_s_rkb1d     = i_s_rkb1d

        i_periv       = i_periv

        i_t_var_range = i_t_var_range

        i_step        = i_step

      IMPORTING

        e_t_range     = e_t_range

        e_meeht       = e_meeht

        e_mefac       = e_mefac

        e_waers       = e_waers

        e_whfac       = e_whfac

      CHANGING

        c_s_customer  = c_s_customer

      EXCEPTIONS

        OTHERS        = 1.

  CATCH cx_sy_dyn_call_illegal_func.

ENDTRY.

IF sy-subrc <> 0.

  MESSAGE ID sy-msgid TYPE sy-msgid

          NUMBER sy-msgno

          WITH

          sy-msgv1 sy-msgv2

          sy-msgv3 sy-msgv4

        RAISING ERROR_IN_VARIABLE.

ENDIF.

0RT_PA_TRAN_CONTROL is not on rsa5

Hi,
We are working with 0RT_DS65 ODS from Retail area.
This DSO uses a BI Datasource is called 0RT_PA_TRAN_CONTROL.
We can not found the extractor no RSA5 to active.
If we go to RSA6 we can see the datasource but when we do double click
over system give us an error with "Extract
structure /POSDW/BW_RETAIL_CONTROL is not active".
Is this the normal delivery for this extractor?
We need to install and add-on to use it?
Our system is:
SAP_BASIS 731 0006
SAP_ABA 731 0006
PI_BASIS 731 0006
ST-PI 2008_1_700 0007
BI_CONT 747 0003
SAP_BW 731 0006
Regards



-----> Answer
since BI_CONT 7.X7 POSDM has been extracted to own software Add-on
software component RTLPOSDM 100_7XX. Therefore the /POSDW/* code is not
included anymore, if you don't include the Addon component RTLPOSDM.

Please refer to the following information in note 1678780 (Chapter 5)
and following notes regarding
Release Restrictions for SAP NW 7.0 BI CONT Addon 7.X7:
BI_CONT 707: 1722869
BI_CONT 737: 1722870
BI_CONT 747: 1722871
Upgrade to BI Cont Addon 7.X7 is only possible as soon as dedicated
POS DM software component version is available and can be included intothe upgrade process.

POSDM 1.0 (RTLPOSDM 100_7XX) as add-on to BI CONT 7.X7 is in Rampup
currently.
Therefore Ramp Up nomination and acceptance is required to receive
clearance for software download.
It is planned to be generally available in second quarter 2013.

Please navigate to the following path in service market place:

1. Goto http://service.sap.com/swdc
2. Goto "Ramp-Up Releases and Beta Software" > Installation and
Upgrade

3. Find and click SAP POSDM 1.0
4. Choose the link "Product Availability, Maintenance Dates & Supported
Platforms"
5. A New Window would open-up showing the PAM for POSDM1.0.

2LIS_40_S278 ---> 2lis_03_bx

Este extractor tiene que ser substituido por el 2lis_03_bx.
Para el cubo 0RT_C01 la nueva trasformacion queda:

Rutina inicial:

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

    DATA: l_tabix TYPE sy-tabix,
    wa_source_package TYPE _ty_s_sc_1.

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




*$*$ begin of routine - insert your code only below this line        *-*
*ABB 18.04.2013
* Antigo codigo
** only movements from to evaluated stocks are concerned
** if stock-category is not intitial -> Delete from data-packag
*  LOOP AT DATA_PACKAGE.
** purchase value is intitial -> Delete from data-packag
*    IF Not DATA_PACKAGE-STOCKCAT IS INITIAL.
*      DELETE DATA_PACKAGE.
*    ENDIF.
*  ENDLOOP.
* Novo codigo
** only movements from to evaluated stocks are concerned
** if stock-category is not intitial -> Delete from data-packag
    LOOP AT source_package
    INTO wa_source_package.
      l_tabix = sy-tabix.
      IF not wa_source_package-STOCKCAT IS INITIAL.
        DELETE source_package INDEX l_tabix.
      ENDIF.
    ENDLOOP.
*ABB 18.04.2013

*--  fill table "MONITOR" with values of structure "MONITOR_REC"

Mapeamento de caracteristicas:
Tiempo:  PSTNG_DATE es la fecha de referencia
0RT_PROMO:   CLEAR RESULT.


0MATERIAL  Material 0MATERIAL  Material
0MAT_PLANT  Material do centro 0MATERIAL  Material
0PLANT  Plant 0PLANT  Plant
0RT_MAT_PRM  Nº material agrupado à ação de promoção Retail 0MATERIAL  Material
0RT_PROMO  Promoção Promoção (inicial)



Mapeamento:

0CPTSTREBU  Entrada estoque avaliado total / UM base 0CPQUABU  BW: quantidade
0CPTSTREPV  Entrada em estoque avaliado total / valor de com 0CPPVLC  BW: valor de co
0RTTSTREST  Entrada estoque avaliado total / valor de venda 0CPSTLC  BW: valor de ve
0RTTSTRESV  Entrada estoque avaliado total / valor de venda 0CPSVLC  BW: valor de ve

Logistic extraction

Notas a tener en cuenta:

Note 353042 - Howto: Activate transaction key (PROCESSKEY)
Note 352344 -> Process key + reversals in Inventory Management(Consulting note). 

Para Retail: 
Note 533577 - Incorr cost val diff during revaluatn not affecting margins
Note 1688943 - RMA: 2LIS_40_REVAL returns incorrect transaction key
Note 600460 - Reval at retail updte:2LIS_40_REVAL, 2LIS_03_BF, 2LIS_03_UM

Problemas típicos:
Valores a cero en 2lis_03_BF
Activar la determinación del process KEY: MCB_
Activar el flag de BW en la BF11



 

OLAP Variable for infopackage

Para seleccionar de forma automática todos los centros de coste para una empresa sin tener que ponerlos uno a uno en el infopackage.
Ej. 0CO_OM_CCA_XX


Crear una query
Poner el centro de coste en las filas, mostrar sola la key y quitar los subtotales
poner un filtro para la sociedad que se pretende filtrar.
Crear una variable para el centro de coste, tipo replacement path//multiple single values//mandatory
Utilizar esta variable en el infopackage (tipo 7)

Process chains Tables

Table Description


RSEVENTHEAD Header for the event chain

RSPC_BUFFER Shared Buffer for Processes

RSPC_MONITOR Monitor individual process chains

RSPCCHAIN Process chain

RSPCCHAINATTR Attributes for a Process Chain

RSPCCHAINEVENTS Multiple Events with Process Chains

RSPCCHAINT Texts for Chain -> Text - Chain-ID

RSPCLOGS Application Logs for the Process Chains

RSPCLOGCHAIN Cross-Table Log ID / Chain ID

RSPCPROCESSLOG Logs for the Chain Runs

RSPCRUNVARIABLES Variables for Process Chains for Runtime

RSPCVARIANT* Generic Variant-Storage

RSEVENTCHAIN Event Chain Processing Event Table

RSEVENTHEADT Header for the Event Chain

RSPCCOMMANDLOG System Command Execution Logs

NIF empleado

=Right([L01 Empregado (s) Nº ID (Chave)];Length([L01 Empregado (s) Nº ID (Chave)])-Pos([L01 Empregado (s) Nº ID (Chave)];"/"))