CRMM_BUT_FRG0041

Business Partner Sales Classification | #masterdata | Component: Business Partners
Column Name Description
CLIENT FK Client
PARTNER_GUID Business Partner GUID
VALID_TO UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
Column Name Description
Column Name Description
Column Name Description
CUSTOMER_SINCE Customer Since Date
Column Name Description
IS_COMPETITOR Indicator: Business partner is competitor Show values
IS_PROSPECT Indicator: Business partner is a prospect Show values
IS_CONSUMER Indicator: Business partner is consumer Show values
IS_CUSTOMER Indicator: Business partner is customer Show values
IS_COD_CUSTOMER Indicator: Business partner is cash on delivery customer Show values
IS_RENTED Indicator: Rented Address Show values
Column Name Description Domain name
VALID_FROM UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
INDUSTRY_CODE_1 Industry Code 1 BRACO
INDUSTRY_CODE_2 Industry Code 2 BRACO
INDUSTRY_CODE_3 Industry Code 3 BRACO
INDUSTRY_CODE_4 Industry Code 4 BRACO
INDUSTRY_CODE_5 Industry Code 5 BRACO
Master Data Relations Join Conditions
Account Group
  • CRMM_BUT_FRG0041.CLIENT == T077D.MANDT
  • CRMM_BUT_FRG0041.ACCOUNT_GROUP == T077D.KTOKD
Attribute 1
  • CRMM_BUT_FRG0041.CLIENT == TVK1.MANDT
  • CRMM_BUT_FRG0041.ATTRIBUTE == TVK1.KATR1
Attribute 10
  • CRMM_BUT_FRG0041.CLIENT == TVK0.MANDT
  • CRMM_BUT_FRG0041.ATTRIB_10 == TVK0.KATR10
Attribute 2
  • CRMM_BUT_FRG0041.CLIENT == TVK2.MANDT
  • CRMM_BUT_FRG0041.ATTRIB_2 == TVK2.KATR2
Attribute 3
  • CRMM_BUT_FRG0041.CLIENT == TVK3.MANDT
  • CRMM_BUT_FRG0041.ATTRIB_3 == TVK3.KATR3
Attribute 4
  • Attribute 4
  • Client
  • CRMM_BUT_FRG0041.ATTRIB_4 == TVK4.KATR4
  • CRMM_BUT_FRG0041.CLIENT == TVK4.MANDT
Attribute 5
  • CRMM_BUT_FRG0041.CLIENT == TVK5.MANDT
  • CRMM_BUT_FRG0041.ATTRIB_5 == TVK5.KATR5
Attribute 6
  • CRMM_BUT_FRG0041.CLIENT == TVK6.MANDT
  • CRMM_BUT_FRG0041.ATTRIB_6 == TVK6.KATR6
Attribute 7
  • CRMM_BUT_FRG0041.CLIENT == TVK7.MANDT
  • CRMM_BUT_FRG0041.ATTRIB_7 == TVK7.KATR7
Attribute 8
  • CRMM_BUT_FRG0041.CLIENT == TVK8.MANDT
  • CRMM_BUT_FRG0041.ATTRIB_8 == TVK8.KATR8
Attribute 9
  • CRMM_BUT_FRG0041.CLIENT == TVK9.MANDT
  • CRMM_BUT_FRG0041.ATTRIB_9 == TVK9.KATR9
Customer Classification
  • CRMM_BUT_FRG0041.CLIENT == TKUKL.MANDT
  • CRMM_BUT_FRG0041.CLASSIFIC == TKUKL.KUKLA
Client CRMM_BUT_FRG0041.CLIENT == T000.MANDT
Industry Sector
Nielsen ID
  • CRMM_BUT_FRG0041.CLIENT == TNLS.MANDT
  • CRMM_BUT_FRG0041.NIELSEN_ID == TNLS.NIELS