SAP ABAP View V_T5D8S_ZAV_BANK (Database View Using Tables T5D8S, T5D8S_ZAV, and T5D8S_BANK)
Hierarchy
☛
SAP_HRCDE (Software Component) Sub component SAP_HRCDE of SAP_HR
⤷ PY-DE-PS-VA (Application Component) Pension Administration
⤷ P01PBSNV (Package) Retroactive Pension Insurance PI Public Sector Germany
⤷ PY-DE-PS-VA (Application Component) Pension Administration
⤷ P01PBSNV (Package) Retroactive Pension Insurance PI Public Sector Germany
Basic Data
View Type | D | Database View |
Database View | V_T5D8S_ZAV_BANK | |
Short Description | Database View Using Tables T5D8S, T5D8S_ZAV, and T5D8S_BANK | |
Root table | T5D8S | Payroll Numbers |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | T5D8S | T5D8S | ||
2 | T5D8S_BANK | |||
3 | T5D8S_ZAV | |||
4 | T5D8S_ZAVT |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | T5D8S | MANDT | JL | EQ | 0 | 0 | ||||
2 | T5D8S_BANK | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | T5D8S | PABNR | JL | EQ | 0 | 0 | ||||
4 | T5D8S_BANK | PABNR | JR | EQ | AND | 0 | 0 | |||
5 | T5D8S | MANDT | JL | EQ | 0 | 0 | ||||
6 | T5D8S_ZAV | MANDT | JR | EQ | AND | 0 | 0 | |||
7 | T5D8S | PABNR | JL | EQ | 0 | 0 | ||||
8 | T5D8S_ZAV | PABNR | JR | EQ | AND | 0 | 0 | |||
9 | T5D8S | MANDT | JL | EQ | 0 | 0 | ||||
10 | T5D8S_ZAVT | MANDT | JR | EQ | AND | 0 | 0 | |||
11 | T5D8S | PABNR | JL | EQ | 0 | 0 | ||||
12 | T5D8S_ZAVT | PABNR | JR | EQ | AND | 0 | 0 | |||
13 | T5D8S_ZAV | PABNR_2 | JL | EQ | 0 | 0 | ||||
14 | T5D8S_ZAVT | PABNR_2 | JR | EQ | AND | 0 | 0 | |||
15 | T5D8S_ZAV | PABNR_2 | JL | EQ | 0 | 0 | ||||
16 | T5D8S_BANK | PABNR_2 | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | T5D8S | MANDT | MANDT | Client | |||
2 | PABNR | T5D8S | PABNR | PABNR | Payroll Number (D) | |||
3 | ENDDA | T5D8S | ENDDA | ENDDA | End Date | |||
4 | BEGDA | T5D8S | BEGDA | BEGDA | Start Date | |||
5 | PANTX | T5D8S | PANTX | PANTX | Name of Pension Insurance Institution (D) | |||
6 | PABNR_2 | T5D8S_ZAV | PABNR_2 | PABNR_2 | Branch Office for Pension Insurer | |||
7 | ENDDA_ZAV | T5D8S_ZAV | ENDDA | ENDDA | End Date | |||
8 | BEGDA_ZAV | T5D8S_ZAV | BEGDA | BEGDA | Start Date | |||
9 | ENDDA_BANK | T5D8S_BANK | ENDDA | ENDDA | End Date | |||
10 | BEGDA_BANK | T5D8S_BANK | BEGDA | BEGDA | Start Date | |||
11 | BANKS | T5D8S_BANK | BANKS | BANKS | Bank country key | |||
12 | BANKL | T5D8S_BANK | BANKL | BANKK | Bank Keys | |||
13 | BKKTO | T5D8S_BANK | BKKTO | BANKN | Bank account number | |||
14 | BKREF | T5D8S_BANK | BKREF | BKREF | Reference specifications for bank details | |||
15 | BKONT | T5D8S_BANK | BKONT | BKONT | Bank Control Key | |||
16 | ZLSCH | T5D8S_BANK | ZLSCH | PCODE | Payment Method | |||
17 | PANTX_2 | T5D8S_ZAVT | PANTX_2 | PANTX_2 | Name of Branch Office for Pension Insurer | |||
18 | SPRSL | T5D8S_ZAVT | SPRSL | SPRAS | Language Key | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |