Backing Up Table T512W (Wage Types)

https://websmp105.sap-ag.de/~sapidb/011000358700008832642001E

acking Up Table T512W (Wage Types)
Use
We generally recommend backing up wage types table T512W before upgrading. However, in the following cases, you must back up table T512W:

You have modified 'technical' wage types, that is wage types beginning with '/' (adjustment of processing class, evaluation class, and so on).
You are using SAP model wage types, that is wage types beginning with a letter, and you have modified these.
You have defined wage types that are not within the customer name range. To find out if this applies, check table TRESC by entering T512W as the table name and TABU as the object.
Procedure
Note
Read SAP note 447984 and implement SAP note 605878 before the upgrade.
Before the upgrade, back up table T512W or selected areas of this table. To do this, use report RPU12W0S. The documentation on the report includes instructions on how to proceed.

Note
Table T512W is client-specific. Make sure you back up the data in the correct client.
You can restore your backup copy after the upgrade. To do this, you can use the following reports:
RPU12W0C restores selected parts of table T512W. This method is particularly suitable if you have exact documentation about the wage types you have modified.
RPU12W0S restores the entire backup or a generically selected area of the table.

Wagetype copy: table to table

(1)T511
(2)T512T
(3)T512W
(4)T512Z
(5)T52D7
(6)T52DZ
(7)T539A
(8)T539J
(9)T591B
(10)T51P6
(11)T510S
(12)T52EK
(13)T52EKT
(14)T52EL
(15)T52EZ

========================
sample sql

T511
WHERE MOLGA = '41' AND LGART BETWEEN '1A00' AND '9ZZZ'

T512T
WHERE SPRSL = '3' AND MOLGA = '41' AND LGART BETWEEN '1A00' AND '9ZZZ'

T512W
WHERE MOLGA = '41' AND LGART BETWEEN '1A00' AND '9ZZZ'

T512Z
WHERE MOLGA = '41'

T52D7
WHERE MOLGA = '41'

T52DZ
WHERE MOLGA = '41'

T52EL
WHERE MOLGA = '41'

T52EZ
WHERE MOLGA = '41'

T539J
WHERE MOLGA = '41' AND BWLGA BETWEEN '1A00' AND '9ZZZ'

T591B
WHERE MOLGA = '41'

Function: SE16N_INTERFACE (Display table as full screen)

SE16N_INTERFACE

I_TAB = Table name
I_EDIT = 'X'

FUNCTION SE16N_INTERFACE.
*"----------------------------------------------------------------------
*"*"Lokale Schnittstelle:
*" IMPORTING
*" VALUE(I_TAB) TYPE SE16N_TAB
*" VALUE(I_EDIT) TYPE CHAR1 DEFAULT ' '
*" VALUE(I_SAPEDIT) TYPE CHAR1 DEFAULT ' '
*" VALUE(I_NO_TXT) TYPE CHAR1 DEFAULT ' '
*" VALUE(I_MAX_LINES) TYPE SYTABIX DEFAULT 500
*" VALUE(I_LINE_DET) TYPE CHAR1 DEFAULT ' '
*" VALUE(I_DISPLAY) TYPE CHAR1 DEFAULT 'X'
*" VALUE(I_CLNT_SPEZ) TYPE CHAR1 DEFAULT ' '
*" VALUE(I_CLNT_DEP) TYPE CHAR1 DEFAULT ' '
*" VALUE(I_VARIANT) TYPE SLIS_VARI DEFAULT ' '
*" VALUE(I_OLD_ALV) TYPE CHAR1 DEFAULT ' '
*" VALUE(I_CHECKKEY) TYPE CHAR1 DEFAULT ' '
*" VALUE(I_TECH_NAMES) TYPE CHAR1 DEFAULT ' '
*" VALUE(I_CWIDTH_OPT_OFF) TYPE CHAR1 DEFAULT ' '
*" VALUE(I_SCROLL) TYPE CHAR1 DEFAULT ' '
*" VALUE(I_NO_CONVEXIT) TYPE CHAR1 DEFAULT ' '
*" VALUE(I_LAYOUT_GET) TYPE CHAR1 DEFAULT ' '
*" EXPORTING
*" VALUE(E_LINE_NR) TYPE SYTABIX
*" VALUE(E_DREF)
*" TABLES
*" IT_SELFIELDS STRUCTURE SE16N_SELTAB OPTIONAL
*" IT_OUTPUT_FIELDS STRUCTURE SE16N_OUTPUT OPTIONAL
*" IT_OR_SELFIELDS TYPE SE16N_OR_T OPTIONAL
*" IT_CALLBACK_EVENTS TYPE SE16N_EVENTS OPTIONAL
*" EXCEPTIONS
*" NO_VALUES
*"----------------------------------------------------------------------

Bangalore in India

Articles: How to Upgrade from SAP R/3 to SAP ERP 6.0 (sap.info)

How to Upgrade from SAP R/3 to SAP ERP 6.0

http://en.sap.info/update_upgrade_erp6-ehp5/37860

URL: SAP related CV / resume

http://www.sapdev.co.uk/jobs/cvhome.htm

RH_GET_POSITION_TAB

RH_GET_POSITION_TAB : 겸직 정보 가져오는 함수

Pattern for FM RH_GET_POSITION_TAB - RH GET POSITION TAB Associated Function Group: RHPR
Released Date: Not Released CALL FUNCTION 'RH_GET_POSITION_TAB' "
EXPORTING
getperson = " person-pernr
getbegda = " plog-begda
getendda = " plog-endda
TABLES
position_tab = " hri_position_tab
EXCEPTIONS
NOTHING_FOUND = 1 "
. " RH_GET_POSITION_TAB


====================================
CALL FUNCTION 'RH_GET_POSITION_TAB'
EXPORTING
getperson = p0001-pernr
getbegda = p0001-begda
getendda = p0001-endda
TABLES
position_tab = get_position_tab
EXCEPTIONS
nothing_found = 1
OTHERS = 2.


=============================================
참고로 겸직입력하는 popup창

CALL FUNCTION 'HR_ASSIGN_MULTIPLE_POSITIONS'
EXPORTING
person_nr = p0001-pernr
org_assignment = p0001
begin_date = p0001-begda
end_date = p0001-endda
IMPORTING
object_type = altass_otype
object_id = altass_objid
object_prozt = altass_prozt
return = ass_return
TABLES
position_tab_import_old = old_postab
position_tab_import_new = new_postab
position_tab_export = new_ass_postab.