Skip to Content
0
Former Member
Apr 25, 2009 at 08:37 AM

How i will get subcode along with company code text?

49 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 :

-


Reportnumber | companycodetext| p0001-bukrs | subcode | paypoint

100525 | ALP | 1044 | 0002 | 0001

100525 | JAY | 1032 | 0006 | 0001

ST Translation table 1:

-


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

Edited by: sujan T on Apr 25, 2009 10:38 AM

Edited by: sujan T on Apr 25, 2009 10:39 AM