Skip to Content
0
Former Member
Apr 27, 2009 at 04:43 AM

How i will get the subcode & paypoint?

76 Views

Hi,

Please help me for below logic.

IF RDSTDCover = 'ST' do the following:

If PA0001-BURKS='1009' go to Table

Z_PR_SOR_LegCoCode to retrieve previous Company Code Text for PA0002-PERID and send

the corresponding Sub Code according to ST Translation Table 2.

Else if no value is found Lookup

PA0001-BURKS along with Report Number '100525'

and send Sub Code value from ST Translation Table 1

Else, send blanks.

IF RDSTDCover = 'ST' do the following:

If PA0001-BURKS='1009' go to Table

Z_PR_SOR_LegCoCode to retrieve previous Company Code Text for

PA0002-PERID and send

the corresponding Paypoint according to ST Translation Table 2

Else if If no value is found Lookup

PA0001-BURKS along with Report Number '100525'

and send Payoint value from ST Translation Table 1

Else, send blanks.

ST Translation table 1 :(z_tran1_subcode)

this table is having the folling fields.

-


Reportnumber | companycodetext| p0001-bukrs | subcode | paypoint

100525 | ALP | 1044 | 0002 | 0001

100525 | JAY | 1032 | 0006 | 0001

100525 | APL | 1099 | 0006 | 0001

ST Translation table 2:(z_tran2_subcode)

-


Reportnumber| companycodetext| subcode | paypoint

100525 | ABH | 0007 | 0002

100525 | API | 0008 | 0005

I was coded like this to get the company code text.But how i will get the subcode and paypoint.

if w_MetLife_detail-rdstdcover = c_st.

if p0001-bukrs = '1009'.

select single ZBUKRS_TEXT from ZGTPA_TL_SSNHIST into l_ZBUKRS_TEXT where perid = w0002-perid.

Please help me.

Regards,

Sujan