T7UNPF_MI_DEPND - UNJSPF Monthly Interface Export key
UNJSPF Monthly Interface Export key information is stored in SAP table T7UNPF_MI_DEPND.
It is part of development package PBUN in software component PY-NPO. This development package consists of objects that can be grouped under "Master Data Non Profit Organizations".
It is part of development package PBUN in software component PY-NPO. This development package consists of objects that can be grouped under "Master Data Non Profit Organizations".
Fields for table T7UNPF_MI_DEPND
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
.INCLUDE | X | PUNPF_MI_TBKEY | 0 | |||
.INCLUDE | X | PUNPF_MI_EXPKEY | 0 | |||
PENSION_NO | Pension Number | X | PUN_PENSION_NO | NUMC | 12 | |
DATA_KEY | Data Key | X | PUN_DATA_KEY | NUMC | 52 | |
DATA_KEY_2 | Data Key | X | PUN_DATA_KEY_2 | NUMC | 6 | |
.INCLUDE | PUNPF_MI_DEPND | 0 | ||||
DEP_LAST_NM | Last name. Left justified. | PUN_LAST_NM | CHAR | 80 | ||
DEP_FIRST_NM | First name. Left justified. | PUN_FIRST_NM | CHAR | 80 | ||
DEP_NAME_VER | Name verification indicator | PUN_NAME_VER | CHAR | 2 | ||
DEP_RELAT_DEP_CD | Relationship of child to Participant. | PUN_RELAT_DEP_CD | CHAR | 2 | ||
DEP_BIRTH_DT | Date of birth. DD-MM-YYYY format | PUN_BIRTH_DT | CHAR | 20 | ||
DEP_DOB_VER | Date of birth verification indicator | PUN_DOB_VER | CHAR | 2 | ||
DEP_MARRI_DT | Marriage date. DD-MM-YYYY format. | PUN_MARRI_DT | CHAR | 20 | ||
DEP_MARRI_DT_VER | Marriage date verification indicator | PUN_MARRI_DT_VER | CHAR | 2 | ||
DEP_DIVOR_DT | Divorce date. DD-MM-YYYY format. | PUN_DIVOR_DT | CHAR | 20 | ||
DEP_DIVOR_DT_VER | Divorce date verification indicator | PUN_DIVOR_DT_VER | CHAR | 2 | ||
DEP_DEATH_DT | Death date. DD-MM-YYYY format. | PUN_DEATH_DT | CHAR | 20 | ||
DEP_DEATH_DT_VER | Death date verification indicator | PUN_DEATH_DT_VER | CHAR | 2 | ||
DEP_NATIONAL_CD | Country of nationality | PUN_NATIONALITY_CD | CHAR | 6 | ||
DEP_LAST_NM_CHG | Changed last name for a alread reported record | PUN_LAST_NM_CHG | CHAR | 40 | ||
DEP_FIRST_NM_CHG | Changed first name for a alread reported record | PUN_FIRST_NM_CHG | CHAR | 40 | ||
DEP_BIRTH_DT_CHG | Changed Dateof birth of a alread reported record | PUN_BIRTH_DT_CHG | CHAR | 20 | ||
.INCLUDE | PUNPF_MI_STATS | 0 | ||||
ERROR_FLAG | Error flag | PUN_ERROR_FLAG | CHAR | 2 | ||
CRNAM | Created By | PUN_CRNAM | CHAR | 24 | ||
CRDAT | Creation Date | CDATE | DATS | 16 | ||
CRTIM | Created At | CREATETIME | TIMS | 12 | ||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 24 | ||
AEDAT | Last Changed On | AEDAT | DATS | 16 | ||
AETIM | Time of last change | PUTIM | TIMS | 12 | ||
DELETE_FLAG | Delete Flag | PUN_DELETE_FLAG | CHAR | 2 | ||
UPDT_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 8 |