FNDEI_BUT0ID_FILTER

Filter View for table BUT0ID | view: FNDEIFBUT0ID | TRAN | Extraction: Not supported | Component: View Provisioning: Orchestration
Tables used: BUT000BUT0IDBUT0ID
Column Name Description
partner FK Business Partner Number
type FK Identification Type
idnumber Identification Number
Column Name Description
Column Name Description
Column Name Description
valid_date_from Validity Start for ID Number
valid_date_to Validity End for ID Number
Column Name Description
Column Name Description Domain name
institute Responsible Institution for ID Number TEXT40
idnumber_guid GUID of a Business Partner Identification Number SYSUUID
Master Data Relations Join Conditions
Country/Region in Which ID Number is Valid or Was Assigned
  • Client
  • Country/Region in Which ID Number is Valid or Was Assigned
  • FNDEI_BUT0ID_FILTER.MANDT == T005.MANDT
  • FNDEI_BUT0ID_FILTER.COUNTRY == T005.LAND1
Business Partner Number
  • Client
  • Business Partner Number
  • FNDEI_BUT0ID_FILTER.MANDT == BUT000.CLIENT
  • FNDEI_BUT0ID_FILTER.PARTNER == BUT000.PARTNER
Region (State, Province, County)
  • Client
  • Country/Region in Which ID Number is Valid or Was Assigned
  • Region (State, Province, County)
  • FNDEI_BUT0ID_FILTER.MANDT == T005S.MANDT
  • FNDEI_BUT0ID_FILTER.COUNTRY == T005S.LAND1
  • FNDEI_BUT0ID_FILTER.REGION == T005S.BLAND
Identification Type
  • Client
  • Identification Type
  • FNDEI_BUT0ID_FILTER.MANDT == TB039A.CLIENT
  • FNDEI_BUT0ID_FILTER.TYPE == TB039A.TYPE