SAP IRTP_US_PLAN_DB table - Database structure of a retirement plan & indicators details in SAP

SAP IRTP_US_PLAN_DB table summary

Object Name: IRTP_US_PLAN_DB
Dictionary Type: Structure
Description: Database structure of a retirement plan & indicators

Field list for IRTP_US_PLAN_DB table on an S/4 SAP system

Details

IRTP_US_PLAN_DB-CLIENT table field - Client ▼

Description: Client
Field Name: CLIENT
Data Element: MANDT
Data Type: CLNT
length (Dec): 3(0)
Check table: *
Conversion Routine:
Domain Name: MANDT
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLIENT

IRTP_US_PLAN_DB-BKKRS table field - Bank Area ▼

Description: Bank Area
Field Name: BKKRS
Data Element: BKK_BKKRS
Data Type: CHAR
length (Dec): 4(0)
Check table: TBKK01
Conversion Routine:
Domain Name: BKK_BKKRS
MemoryID: BNS
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BKKRS

IRTP_US_PLAN_DB-PLAN_NUMBER table field - Plan number of a retirement plan ▼

Description: Plan number of a retirement plan
Field Name: PLAN_NUMBER
Data Element: RTP_US_NUMB
Data Type: CHAR
length (Dec): 15(0)
Check table:
Conversion Routine: ALPHA
Domain Name: RTP_US_NUMB
MemoryID: RTPN
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field PLAN_NUMBER

IRTP_US_PLAN_DB-TYPE_CODE table field - Type code for a retirement plan ▼

Description: Type code for a retirement plan
Field Name: TYPE_CODE
Data Element: RTP_US_TYPE
Data Type: CHAR
length (Dec): 2(0)
Check table: TRTP_US_PLANTYPE
Conversion Routine:
Domain Name: RTP_US_TYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TYPE_CODE

IRTP_US_PLAN_DB-NATURE table field - Nature of a retirement plan ▼

Description: Nature of a retirement plan
Field Name: NATURE
Data Element: RTP_US_NATURE
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: RTP_US_NATURE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NATURE

IRTP_US_PLAN_DB-PLAN_NAME table field - Plan name of the retirement plan ▼

Description: Plan name of the retirement plan
Field Name: PLAN_NAME
Data Element: RTP_US_NAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: RTP_US_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PLAN_NAME

IRTP_US_PLAN_DB-CHNG_RES table field - Yes/No Indication responsible person may change accountholde ▼

Description: Yes/No Indication responsible person may change accountholde
Field Name: CHNG_RES
Data Element: RTP_US_XIND_RESP
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: RTP_US_XIND
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHNG_RES

IRTP_US_PLAN_DB-RES_TRANS table field - Yes/No Indication responsible person remains responsible ▼

Description: Yes/No Indication responsible person remains responsible
Field Name: RES_TRANS
Data Element: RTP_US_XIND_TRANS
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: RTP_US_XIND
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RES_TRANS

IRTP_US_PLAN_DB-DATE_MAR table field - Date of maturity for the accountholder of a Coverdell ESA ▼

Description: Date of maturity for the accountholder of a Coverdell ESA
Field Name: DATE_MAR
Data Element: RTP_US_MATDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: RTP_US_DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATE_MAR

IRTP_US_PLAN_DB-OP_DAT table field - Opening date ▼

Description: Opening date
Field Name: OP_DAT
Data Element: RTP_US_OPDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: RTP_US_DATE
MemoryID: RTPDAT
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OP_DAT

IRTP_US_PLAN_DB-CLS_DAT table field - Closing date of the retirement plan ▼

Description: Closing date of the retirement plan
Field Name: CLS_DAT
Data Element: RTP_US_CLSDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: RTP_US_DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLS_DAT

IRTP_US_PLAN_DB-STATUS table field - Status of the retirement plan ▼

Description: Status of the retirement plan
Field Name: STATUS
Data Element: RTP_US_STATUS
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: RTP_US_STATUS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATUS

IRTP_US_PLAN_DB-AUGRP table field - Authorization Group ▼

Description: Authorization Group
Field Name: AUGRP
Data Element: BU_AUGRP
Data Type: CHAR
length (Dec): 4(0)
Check table: TB037
Conversion Routine:
Domain Name: BU_AUGRP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AUGRP

IRTP_US_PLAN_DB-CURRENCY table field - Currency of the retirement plan ▼

Description: Currency of the retirement plan
Field Name: CURRENCY
Data Element: RTP_US_CURRENCY
Data Type: CUKY
length (Dec): 5(0)
Check table: TCURC
Conversion Routine:
Domain Name: WAERS
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CURRENCY

IRTP_US_PLAN_DB-SEARCH1 table field - Search item 1 ▼

Description: Search item 1
Field Name: SEARCH1
Data Element: RTP_US_SEAR1
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: RTP_US_SEARCH
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEARCH1

IRTP_US_PLAN_DB-SEARCH2 table field - Search item 2 ▼

Description: Search item 2
Field Name: SEARCH2
Data Element: RTP_US_SEAR2
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: RTP_US_SEARCH
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEARCH2

IRTP_US_PLAN_DB-CHNG_USER table field - Last changed by ▼

Description: Last changed by
Field Name: CHNG_USER
Data Element: RTP_US_CHUSR
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: RTP_US_USER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHNG_USER

IRTP_US_PLAN_DB-CHNG_DATE table field - Date last changed ▼

Description: Date last changed
Field Name: CHNG_DATE
Data Element: RTP_US_CHDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: RTP_US_DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHNG_DATE

IRTP_US_PLAN_DB-CHNG_TIME table field - Time last changed ▼

Description: Time last changed
Field Name: CHNG_TIME
Data Element: RTP_US_CHTIM
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: RTP_US_TIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHNG_TIME

IRTP_US_PLAN_DB-CR_USER table field - Created by ▼

Description: Created by
Field Name: CR_USER
Data Element: RTP_US_CRUSR
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: RTP_US_USER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CR_USER

IRTP_US_PLAN_DB-CR_DATE table field - Date created ▼

Description: Date created
Field Name: CR_DATE
Data Element: RTP_US_CRDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: RTP_US_DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CR_DATE

IRTP_US_PLAN_DB-CR_TIME table field - Time created ▼

Description: Time created
Field Name: CR_TIME
Data Element: RTP_US_CRTIM
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: RTP_US_TIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CR_TIME

IRTP_US_PLAN_DB-ACT_DB table field - Database activity ▼

Description: Database activity
Field Name: ACT_DB
Data Element: RTP_US_ACT_DB
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: RTP_US_ACT_DB
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACT_DB

IRTP_US_PLAN_DB-NRRANGENR table field - Number range number ▼

Description: Number range number
Field Name: NRRANGENR
Data Element: NRNR
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: CHAR2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NRRANGENR

IRTP_US_PLAN_DB-IND_EXT table field - Internal (' ') or external ('X') number range flag ▼

Description: Internal (' ') or external ('X') number range flag
Field Name: IND_EXT
Data Element: NRIND
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IND_EXT

View list of all SAP tables(S4H/ECC)

Select data from SAP table