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".

Fields for table T7UNPF_MI_DEPND

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
.INCLUDEXPUNPF_MI_TBKEY0
.INCLUDEXPUNPF_MI_EXPKEY0
PENSION_NOPension NumberXPUN_PENSION_NONUMC12
DATA_KEYData KeyXPUN_DATA_KEYNUMC52
DATA_KEY_2Data KeyXPUN_DATA_KEY_2NUMC6
.INCLUDEPUNPF_MI_DEPND0
DEP_LAST_NMLast name. Left justified.PUN_LAST_NMCHAR80
DEP_FIRST_NMFirst name. Left justified.PUN_FIRST_NMCHAR80
DEP_NAME_VERName verification indicatorPUN_NAME_VERCHAR2
DEP_RELAT_DEP_CDRelationship of child to Participant.PUN_RELAT_DEP_CDCHAR2
DEP_BIRTH_DTDate of birth. DD-MM-YYYY formatPUN_BIRTH_DTCHAR20
DEP_DOB_VERDate of birth verification indicatorPUN_DOB_VERCHAR2
DEP_MARRI_DTMarriage date. DD-MM-YYYY format.PUN_MARRI_DTCHAR20
DEP_MARRI_DT_VERMarriage date verification indicatorPUN_MARRI_DT_VERCHAR2
DEP_DIVOR_DTDivorce date. DD-MM-YYYY format.PUN_DIVOR_DTCHAR20
DEP_DIVOR_DT_VERDivorce date verification indicatorPUN_DIVOR_DT_VERCHAR2
DEP_DEATH_DTDeath date. DD-MM-YYYY format.PUN_DEATH_DTCHAR20
DEP_DEATH_DT_VERDeath date verification indicatorPUN_DEATH_DT_VERCHAR2
DEP_NATIONAL_CDCountry of nationalityPUN_NATIONALITY_CDCHAR6
DEP_LAST_NM_CHGChanged last name for a alread reported recordPUN_LAST_NM_CHGCHAR40
DEP_FIRST_NM_CHGChanged first name for a alread reported recordPUN_FIRST_NM_CHGCHAR40
DEP_BIRTH_DT_CHGChanged Dateof birth of a alread reported recordPUN_BIRTH_DT_CHGCHAR20
.INCLUDEPUNPF_MI_STATS0
ERROR_FLAGError flagPUN_ERROR_FLAGCHAR2
CRNAMCreated ByPUN_CRNAMCHAR24
CRDATCreation DateCDATEDATS16
CRTIMCreated AtCREATETIMETIMS12
AENAMName of Person Who Changed ObjectAENAMCHAR24
AEDATLast Changed OnAEDATDATS16
AETIMTime of last changePUTIMTIMS12
DELETE_FLAGDelete FlagPUN_DELETE_FLAGCHAR2
UPDT_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TIMESTAMPDEC8
Privacy Policy