jueves, 18 de abril de 2013

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



 

viernes, 15 de marzo de 2013

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)



martes, 12 de marzo de 2013

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

lunes, 25 de febrero de 2013

NIF empleado

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

Problemas con decimales en el extractor 0HR_PT_2

Nota 1617680

martes, 5 de febrero de 2013

2 last characters of a string

DATA: int TYPE I, PEP TYPE C,
AUX_PEP TYPE /BI0/OIWBS_ELEMT.



CLEAR: INT, AUX_PEP.
PEP = COMM_STRUCTURE-WBS_ELEMT.
DESCRIBE FIELD PEp LENGTH INT IN CHARACTER MODE.
INT = INT - 2.
* result value of the routine
AUX_PEP = COMM_STRUCTURE-WBS_ELEMT+INT(2).
IF AUX_PEP ca SY-ABCDE.
RESULT = AUX_PEP.
ELSE.
RESULT = 99.
ENDIF.

lunes, 4 de febrero de 2013

Reset a selector like combo box or radio button

1. Bind labels of the selector (eg. B2:B5)
2. Set Insertion type and destination (eg. C2)
3. Set the selected item type on Dynamic on the behaviour tab of the selector
4. Bind the item to a cell (eg F2)
5. Bind source cell of Push button (eg. E2)
6. Bind destination cell of Push button (eg. F2, same as selected item of combo!)
7. Add formula in source cell push =if(F2=”x”,B2,”x”)
8. Add “x” value in destion cell F2

Comes in handy when you want to reset only certain parts of the dashboard and not resetting it to its initial state (as you do with the reset button).