BCA_US_DEA_ESCH

Escheat Accounts Data | #transactional | Component: Bank Customer Accounts
Column Name Description
MANDT FK Client
RPT_YEAR Escheat Reporting Year Show values
BKKRS FK Bank Area
COUNTRY FK Country/Region Key
REGION FK Region (State, Province, County)
PARTNER FK Business Partner Number
ACNUM_INT FK Internal Account Number for Current Account
Column Name Description
💲 Currency of Current Account (BKK42.WAERS):
BALANCE Account balance
DEL_AMT Escheat Deletion Amount
ADD_AMT Escheat Addition Amount
Column Name Description
Column Name Description
DATE_POST Last External Transaction Posting Date
Column Name Description
RPT_YEAR Escheat Reporting Year Show values
Column Name Description Domain name
FLG_REPORTED Indicator: Entry has been reported CHAR1
Master Data Relations Join Conditions
Internal Account Number for Current Account
  • Bank Area
  • Internal Account Number for Current Account
  • Client
  • BCA_US_DEA_ESCH.BKKRS == BKK40.BKKRS
  • BCA_US_DEA_ESCH.ACNUM_INT == BKK40.ACNUM_INT
  • BCA_US_DEA_ESCH.MANDT == BKK40.MANDT
Escheat Property Addition Code
Bank Area
  • BCA_US_DEA_ESCH.MANDT == TBKK01.MANDT
  • BCA_US_DEA_ESCH.BKKRS == TBKK01.BKKRS
Country/Region Key
  • Country/Region Key
  • Client
  • BCA_US_DEA_ESCH.COUNTRY == T005.LAND1
  • BCA_US_DEA_ESCH.MANDT == T005.MANDT
Escheat Property Deletion Code
  • Escheat Property Deletion Code
  • Client
Client BCA_US_DEA_ESCH.MANDT == T000.MANDT
Business Partner Number
  • Business Partner Number
  • Client
  • BCA_US_DEA_ESCH.PARTNER == BUT000.PARTNER
  • BCA_US_DEA_ESCH.MANDT == BUT000.CLIENT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • BCA_US_DEA_ESCH.MANDT == T005S.MANDT
  • BCA_US_DEA_ESCH.COUNTRY == T005S.LAND1
  • BCA_US_DEA_ESCH.REGION == T005S.BLAND