S401

RE standard analysis partner | #masterdata | Component: Real Estate Management
Column Name Description
MANDT Client
SSOUR Statistic(s) origin
VRSIO Version number in the information structure
SPMON Period to analyze - month
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
PARTNR_01 Business Partner Number
ROLE_02 Business Partner Role Type
VWDAT Pointer to administrative data
Column Name Description
Column Name Description
Column Name Description
SPTAG Period to analyze - current date
ADR_DAT Valid-From Date of Business Partner Address Relationship
ADR_D_E Valid-To Date of Business Partner Address Relationship
DBEBEZ Date of start of relationship
DENBEZ Date of end of relationship
Column Name Description
TYPE Partner category Show values
SEX Gender of business partner Show values
HR_ORG_REF HR Org. Link Show values
STAFF_REF Employee Show values
Column Name Description Domain name
PARTNR Business Partner Number BP_PARTNR
ROLE Business Partner Role Type BP_ROLE
BUKRS Company Code BUKRS
SWENR Business Entity Number SWENR
SGRNR Land Number for BE SGRNR
SGENR Building Number SGENR
SMENR Number of Rental Unit SMENR
SMIVE Lease-Out Number VVSMIVE
E_SMIVE Contract No. of Collective Lease-Outs VVSMIVE
XWETEXT Business entity identification XMBEZ
XGRTXT Text for property XLBEZ
XGETXT Building text XLBEZ
XMETXT Text for rental unit XMBEZ
KUNNR Customer Number KUNNR
LIFNR Account Number of Supplier LIFNR
GROUP_ID Business Partner Grouping BP_GRP_ID
NAME1 Name 1 (surname for persons, else company name) TEXT40
NAME2 Name 2 (Continuation of NAME 1) TEXT40
NAME_LAST Last Name TEXT40
NAME_FIRST First Name TEXT40
LANGU Language Key SPRAS
TITLE Form of Address (Key) BP_TITLE
TITLE_LET Salutation BP_TITL_LT
XORT Address: City TEXT35
XPLZ Address: Postal code PSTLZ
XSTRASSE Address: Street/house number TEXT35
ANZPT No. of partners DEC5
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
NATION Nationality LAND1
STATE Citizenship LAND1
PERS_NR Personnel Number CHAR15
STAFF_GRP Employee Group BP_STAFF_G
XUBNAME User Name in User Master Record XUBNAME
ADR_REF_K Address ID BP_ADR_REF
ADRNR Address Number SADRNR
ADR_LOC Partner: Building CHAR20
FLOOR Partner: Storey CHAR10
ROOM_NR Partner: Room number CHAR10
XOBJTXT Text for Real Estate object XMBEZ
ROLETYP Business Partner Role Category BP_ROLETYP
LAND1 Country/Region Key LAND1
XORT2 District TEXT35
PSTBZ Post delivery district PSTBZ
REGIO Region (State, Province, County) REGIO
XSTRASSE2 Street and House Number TEXT35