BUT0ID_ACT

Master Data Consolidation: Best Record Table for BUT0ID | #masterdata | Component: Business Partner.
Column Name Description
CLIENT Client
PARTNER Business Partner Number
TYPE Identification Type
IDNUMBER Identification Number
Column Name Description
Column Name Description
Column Name Description
ENTRY_DATE Date of Entry for ID Number
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
BP_EEW_BUT0ID Dummy function in length 1 DUMMY
RECENCY Master Data Consolidation: Recency TZNTSTMPS
SOURCE_RECENCY Master Data Consolidation: Recency TZNTSTMPS
Master Data Relations Join Conditions
Country/Region in Which ID Number is Valid or Was Assigned
  • Country/Region in Which ID Number is Valid or Was Assigned
  • Client
  • BUT0ID_ACT.COUNTRY == T005.LAND1
  • BUT0ID_ACT.CLIENT == T005.MANDT
Region (State, Province, County)
  • Country/Region in Which ID Number is Valid or Was Assigned
  • Region (State, Province, County)
  • BUT0ID_ACT.CLIENT == T005S.MANDT
  • BUT0ID_ACT.COUNTRY == T005S.LAND1
  • BUT0ID_ACT.REGION == T005S.BLAND