SAP ABAP Table RTP_US_HIST (Retirement plan history and audit table)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ IS-B-BCA (Application Component) Bank Customer Accounts
⤷ BCA_US (Package) BCA modification for US specific requirements
⤷ IS-B-BCA (Application Component) Bank Customer Accounts
⤷ BCA_US (Package) BCA modification for US specific requirements
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | RTP_US_HIST | Table Relationship Diagram |
Short Description | Retirement plan history and audit table |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | BKKRS | BKK_BKKRS | BKK_BKKRS | CHAR | 4 | 0 | Bank Area | TBKK01 | |
3 | PLAN_NUMBER | RTP_US_NUMB | RTP_US_NUMB | CHAR | 15 | 0 | Plan number of a retirement plan | RTP_US_PLAN | |
4 | TRANS_DATE | RTP_US_TRANS_DATE | RTP_US_DATE | DATS | 8 | 0 | Transaction date | ||
5 | SEQ_NUMB | RTP_US_SEQ_NUMB | RTP_US_NUMBER | DEC | 3 | 0 | Sequence number of the transaction made that day | ||
6 | TAX_YEAR | RTP_US_TAXYEAR | RTP_US_DATE_YEAR | NUMC | 4 | 0 | Tax-year | ||
7 | AMOUNT_ID | RTP_US_AMN_ID | RTP_US_AMN_ID | CHAR | 2 | 0 | Amount identifier code | TRTP_US_AMNTID | |
8 | CONTRIB_ID | RTP_US_CON_ID | RTP_US_CON_ID | CHAR | 2 | 0 | Contribution identifier | TRTP_US_CONT | |
9 | IRS_DCODE | RTP_US_IRS | RTP_US_IRS | CHAR | 1 | 0 | Retirement plan distribution code | TRTP_US_DIST_S | |
10 | IRS_SCODE | RTP_US_IRS_SUB | RTP_US_IRS | CHAR | 1 | 0 | Retirement plan distribution sub-code | TRTP_US_DIST_S | |
11 | CURRENCY | RTP_US_CURRENCY | WAERS | CUKY | 5 | 0 | Currency of the retirement plan | TCURC | |
12 | AMOUNT | RTP_US_AMOUNT | RTP_US_AMOUNT | CURR | 17 | 2 | Transaction amount | ||
13 | DOCNO | BKK_DOCNO | BKK_DOCNO | NUMC | 12 | 0 | Item number in current accounts | BKKIT |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RTP_US_HIST | AMOUNT_ID | TRTP_US_AMNTID | AMOUNT_ID | KEY | 1 | CN |
2 | RTP_US_HIST | BKKRS | TBKK01 | BKKRS | KEY | 1 | CN |
3 | RTP_US_HIST | CLIENT | T000 | MANDT | KEY | 1 | CN |
4 | RTP_US_HIST | CONTRIB_ID | TRTP_US_CONT | CONTRIB_ID | KEY | 1 | CN |
5 | RTP_US_HIST | CURRENCY | TCURC | WAERS | KEY | 1 | CN |
6 | RTP_US_HIST | DOCNO | BKKIT | DOCNO | |||
7 | RTP_US_HIST | IRS_DCODE | TRTP_US_DIST_S | IRS_CODE | KEY | 1 | CN |
8 | RTP_US_HIST | IRS_SCODE | TRTP_US_DIST_S | IRS_CODE | KEY | 1 | CN |
9 | RTP_US_HIST | PLAN_NUMBER | RTP_US_PLAN | PLAN_NUMBER | KEY | 1 | CN |
History
Last changed by/on | SAP | 20020219 |
SAP Release Created in | 110 |