T7UNPAD_EGEXPMGT

NPO: Expense Management Table | #masterdata | Component: Non Profit Organizations
Column Name Description
MANDT Client
PERNR FK Personnel Number
INFTY FK Infotype
SUBTY Subtype
OBJPS Object Identification
SPRPS Lock Indicator for HR Master Data Record
ENDDA End Date
BEGDA Start Date
SEQNR Number of Infotype Record With Same Key
EXMNR Exp. MM: Numberrange No.
LFDNR Document Number
EGPYT Education Grant Pay Type Show values
Column Name Description
💲 Currency Key (WAERS):
EXAMT Amount on Individual Receipt
EXAMT_E EG: Expense Amount
Column Name Description
Column Name Description
ENDDA End Date
BEGDA Start Date
EGPAY_DATE EG Paydate
AEDTM Last Changed On
EXDAT Receipt Date
Column Name Description
EGPYT Education Grant Pay Type Show values
ITXEX Text Exists for Infotype Show values
REFEX Reference Fields Exist (Primary/Secondary Costs) Show values
ORDEX Confirmation Fields Exist Show values
EXART EG: Cost type Show values
PAPER_RECEIPT Paper Receipt Exists Show values
RECEIPT_VALIDATE Expense Receipt Checked Show values
FLAG Checkbox Show values
PFLAG Checkbox Show values
ADVFLAG Checkbox Show values
Column Name Description Domain name
UNAME Name of Person Who Changed Object USNAM
HISTO Historical Record Flag CHAR1
ITBLD Infotype Screen Control CHAR2
FLAG1 Reserved Field/Unused Field NUSED
FLAG2 Reserved Field/Unused Field NUSED
FLAG3 Reserved Field/Unused Field NUSED
FLAG4 Reserved Field/Unused Field NUSED
RESE1 Reserved Field/Unused Field of Length 2 NUSED2
RESE2 Reserved Field/Unused Field of Length 2 NUSED2
GRPVL Grouping Value for Personnel Assignments PCCE_GPVAL
EXLNR Document Number NRBEL
EXEXT EG: Expense type text TEXT40
KURSB Exchange Rate UKURS
FFACT Ratio for the "from" currency units DEC9
TFACT Ratio for the "to" currency units DEC9
Master Data Relations Join Conditions
EG: Expense Type
  • EG: Expense Type
  • ?
  • Client
  • ?
  • ?
Infotype
  • T7UNPAD_EGEXPMGT.MANDT == T582A.MANDT
  • T7UNPAD_EGEXPMGT.INFTY == T582A.INFTY
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • T7UNPAD_EGEXPMGT.MANDT == T007A.MANDT
  • T7UNPAD_EGEXPMGT.[column in domain "KALSM_D"] == T007A.KALSM
  • T7UNPAD_EGEXPMGT.MWSKZ == T007A.MWSKZ
Reason for Changing Master Data
  • Infotype
  • Reason for Changing Master Data
  • T7UNPAD_EGEXPMGT.MANDT == T530E.MANDT
  • T7UNPAD_EGEXPMGT.INFTY == T530E.INFTY
  • T7UNPAD_EGEXPMGT.PREAS == T530E.PREAS
Currency Key
  • T7UNPAD_EGEXPMGT.MANDT == TCURC.MANDT
  • T7UNPAD_EGEXPMGT.WAERS == TCURC.WAERS