0REPARTNER_ATTR

RE BW: Real Estate Objects Partner | #ATTR | Extraction method: V | No Delta | Component: Real Estate Management Master Data
Tables used: BP000, VZGPO → show details
Column Name Description
SNUMOBJ Key for number range object Show values
SOBJEKT Internal key for object for business partner table
PARTNR Business Partner Number
Column Name Description
💲 Currency of Net Income (INCOME_CUR):
NET_INCOME Net Annual Income
MO_NET_INC Monthly Net Income of Business Partner
💲 Balance Sheet Currency (BAL_SH_CUR):
CAP_INCR_A Amount of last capital increase
Column Name Description
Column Name Description
CRDAT Creation Date
BIRTH_DATE Date of Birth of Business Partner
DEATH_DATE Date of Death
COMM_REG_D Date of Entry in Commercial Register
LIQUID_DAT Date of Liquidation
Column Name Description
SNUMOBJ Key for number range object Show values
TYPE Partner category Show values
BP_GROUP BP: Collective Business Partner Indicator Show values
DEL_IND Deletion Flag Show values
PAR_REL Business Partner Released Show values
SEX Gender of Business Partner Show values
MO_INC_M Calendar Month of Monthly Net Income Show values
HR_ORG_REF HR Org. Link Show values
STAFF_REF Employee Show values
BALANCE_FL Balance Sheet Display Show values
MIN_RESERV Bank Subject to Minimum Reserve Requirement Show values
Column Name Description Domain name
EXTPARTNR External Business Partner ID CHAR15
CUSTOMER Customer Number KUNNR
NAME1 Name 1 (surname for persons, else company name) TEXT40
NAME2 Name 2 (Continuation of NAME 1) TEXT40
SORT1 Sort Field 1 CHAR20
SORT2 Sort Field 2 CHAR20
SORT_PHON Sort Field for Phonetic Search; Obsolete CHAR20
MC_NAME1 Field NAME1 in Upper Case CHAR25
MC_NAME2 Field NAME2 in Upper Case CHAR25
SOURCE Source Key of Business Partner Data BP_SOURCE
CRUSER Entered by SYCHAR12
BEGRU Authorization Group BEGRU
XTITLE Text of Form of Address TEXT50
XTIT_LE Salutation TEXT50
NAME_LAST Last Name TEXT40
NAME_FIRST First Name TEXT40
TITLE_AC Academic Title TEXT20
N_PREFIX Name Prefix TEXT20
N_ADDITION Name Affix TEXT20
NICKNAME Known As TEXT20
PROFESSION Description of Occupation for Business Partner TEXT40
BIRTH_PLAC Birthplace TEXT40
BIRTH_NAME Name at Birth TEXT40
BIRTH_N_AD Name at Birth Affix TEXT40
CHILDREN Number of Children Belonging to the Business Partner DEC2
MEM_HOUSE Number of People Living in the Household DEC2
NET_INC_Y Year of Net Annual Income GJAHR
MO_INC_Y Year of Monthly Net Income GJAHR
PERS_NR Personnel Number CHAR15
ORG_NAME Name 1 (surname for persons, else company name) TEXT40
ORG_NAME2 Name 2 (Continuation of NAME 1) TEXT40
FOUND_YEAR Foundation Year of Organization GJAHR
COMM_REGIS Entry in Commercial Register TEXT50
COMP_HEAD Registered Office TEXT35
COMP_NR International location number (part 1) NUM07
COMP_NR_AD International location number (Part 2) NUM05
BUBKZ Check digit for the international location number NUM01
CAP_INCR_Y Year of Last Capital Increase GJAHR
BANKL Bank Keys BANKK
BANKS Country/Region Key of Bank LAND1
Master Data Relations Join Conditions
Address ID
  • Client
  • Address ID
  • 0REPARTNER_ATTR.MANDT == TP14.MANDT
  • 0REPARTNER_ATTR.ADR_REF == TP14.ADR_REF
Balance Sheet Currency
  • Balance Sheet Currency
  • Client
  • 0REPARTNER_ATTR.BAL_SH_CUR == TCURC.WAERS
  • 0REPARTNER_ATTR.MANDT == TCURC.MANDT
Factory calendar 0REPARTNER_ATTR.CALENDARID == TFACD.IDENT
Country/Region of Registered Office
  • Client
  • Country/Region of Registered Office
  • 0REPARTNER_ATTR.MANDT == T005.MANDT
  • 0REPARTNER_ATTR.CNTRY_COMP == T005.LAND1
Target Group
  • Target Group
  • Client
  • 0REPARTNER_ATTR.GROUP_D == TP13.GROUP_D
  • 0REPARTNER_ATTR.MANDT == TP13.MANDT
Business Partner Grouping
  • Business Partner Grouping
  • Client
  • 0REPARTNER_ATTR.GROUP_ID == TPZ2.GROUP_ID
  • 0REPARTNER_ATTR.MANDT == TPZ2.MANDT
Currency of Net Income
  • Currency of Net Income
  • Client
  • 0REPARTNER_ATTR.INCOME_CUR == TCURC.WAERS
  • 0REPARTNER_ATTR.MANDT == TCURC.MANDT
Industry Keys
  • Client
  • Industry Keys
  • 0REPARTNER_ATTR.MANDT == T016.MANDT
  • 0REPARTNER_ATTR.IND_SECTOR == T016.BRSCH
Language Key 0REPARTNER_ATTR.LANGU == T002.SPRAS
Legal Form of Organization
  • Legal Form of Organization
  • Client
  • 0REPARTNER_ATTR.LEGAL_ENTY == TP08.LEGAL_ENTY
  • 0REPARTNER_ATTR.MANDT == TP08.MANDT
Legal Entity of Organization
  • Legal Entity of Organization
  • Client
  • 0REPARTNER_ATTR.LEGAL_ORG == TP09.LEGAL_ORG
  • 0REPARTNER_ATTR.MANDT == TP09.MANDT
Marital Status
  • Marital Status
  • Client
  • 0REPARTNER_ATTR.MARITAL_ST == TP03.MARITAL_ST
  • 0REPARTNER_ATTR.MANDT == TP03.MANDT
Nationality
  • Client
  • Nationality
  • 0REPARTNER_ATTR.MANDT == T005.MANDT
  • 0REPARTNER_ATTR.NATION == T005.LAND1
Marital property regime
  • Client
  • Marital property regime
  • 0REPARTNER_ATTR.MANDT == TP04.MANDT
  • 0REPARTNER_ATTR.PROPRTY_ST == TP04.PROPRTY_ST
Employee Group
  • Employee Group
  • Client
  • 0REPARTNER_ATTR.STAFF_GRP == TP05.STAFF_GRP
  • 0REPARTNER_ATTR.MANDT == TP05.MANDT
Citizenship
  • Client
  • Citizenship
  • 0REPARTNER_ATTR.MANDT == T005.MANDT
  • 0REPARTNER_ATTR.STATE == T005.LAND1
Form of Address (Key)
  • Form of Address (Key)
  • Client
  • 0REPARTNER_ATTR.TITLE == TP01.TITLE
  • 0REPARTNER_ATTR.MANDT == TP01.MANDT
Salutation
  • Client
  • Salutation
  • 0REPARTNER_ATTR.MANDT == TP02.MANDT
  • 0REPARTNER_ATTR.TITLE_LET == TP02.TITLE_LET
Business Partner: VIP Partner
  • Client
  • Business Partner: VIP Partner
  • 0REPARTNER_ATTR.MANDT == TVIP.MANDT
  • 0REPARTNER_ATTR.VIP == TVIP.PAVIP
User Name in User Master Record
  • User Name in User Master Record
  • Client
  • 0REPARTNER_ATTR.XUBNAME == USR02.BNAME
  • 0REPARTNER_ATTR.MANDT == USR02.MANDT