S402

Business entities | #transactional | Component: Real Estate Management

🔑 Keys (10)
💰 Amounts (6)
∑ Quantities (2)
📅 Dates (4)
☰ Categorical (5)
Other (51)
🔗 Relations (24)

Column Name	Description
MANDT FK	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
BUKRS_01 FK	Company Code
GSBER_02 FK	Business Area
SWENR_03 FK	Business Entity Number

Column Name	Description
💲 User field: Unit for value fields (USRCUKY2):
USR07	User field 2 for values (length 10.3)
💲 User field: Unit for value fields (USRCUKY1):
USR06	User field 1 for values (length 10.3)
💲 Currency Key (PURC_PRICE_CURR):
PURC_PRICE_NET	ROZ: Net purchase price
PURC_PRICE_GRO	IPD: Gross purchase price
💲 Currency Key (SALE_PRICE_CURR):
SALE_PRICE_GRO	IPD: Gross sales price
SALE_PRICE_NET	IPD: Net sales price

Column Name	Description
📏 User field: Unit for quantity fields (USRUNIT1):
USR04	User Field 1 for Set (Length 12,3)
📏 User field: Unit for quantity fields (USRUNIT2):
USR05	User Field 2 for Set (Length 12,3)

Column Name	Description
SPTAG	Period to analyze - current date
DAKTBEST	Date active in portfolio
USR08	User field 1 for date
USR09	User field 2 for date

Column Name	Description
USR11	User field 2 indicator for evaluations	Show values
USR10	User field 1 indicator for evaluations	Show values
RKZBEST	Object status	Show values
RETAIL_TYPE	IPD: Type of retail trade object	Show values
INDUSTRY_TYPE	IPD: Commercial object type	Show values

Column Name	Description	Domain name
PERIV	Fiscal Year Variant	PERIV
VWDAT	Pointer to administrative data	VWDAT
XPROFL	Settlement profile for costs	TEXT30
XORT	Address: City	TEXT35
XPLZ	Address: Postal code	PSTLZ
XSTRASSE	Address: Street/house number	TEXT35
ANZWE	No. of business entities	DEC6
USR03	User-defined field 2 for 10 characters	USRCHAR10
USR02	User-defined field 1 for 10 characters	USRCHAR10
USR01	User field 2 for 20 characters	USRCHAR20
USR00	User-defined field 1 for 20 characters	USRCHAR20
FEINS	Unit: area	CHAR5
VVLEN	Unit: length	CHAR5
REINS	Unit: room content	CHAR5
WAERS_01	Unit: currency	CHAR5
RFAKT	Conversion factor for fractional share of property	CHAR6
SINSTBEZ	Location: Maintenance district	SINSTBEZ
XINSTBEZ	Location: Maintenance district	CHAR15
XOBJLAGE	Location: district	CHAR15
XSTDORT	Regional location	XTEXT35
XVERKEHR	Location: Transport connections	XTEXT50
XLAGEWE	Location: Business ent.	CHAR15
XMIETR	Tenancy law	XTEXT30
XMIETSP	Representative list of rents: allocation	CHAR15
ADRNR	Object number (virtual object)	SOBJNR
XPROFIL	Planning profile	TEXT40
STTXT_EXT	Status: Set by user	CHAR40
XKZBEST	Status: portfolio	TEXT40
STTXT_INT	Status: Set by system	CHAR40
XWETEXT	Text for Business Entity	XMBEZ
XVORBK	Predefined operating costs settlement variant	CHAR50
XVORHK	Predefined heating expenses settlement variant	CHAR50
FUND_TYPE	IPD: Classification of participant	VVFUND_TYPE
NATURE_INTEREST	IPD: Ownership structure	VVNATURE_INT
HEADLEASE_EXPIRE	IPD: Expiry year of hereditary tenancy	GJAHR
OFFICE_LOC	IPD: Region (only for usage type office > 50%)	VVOFFICE_LOC
OFFICE_TYPE	IPD: Office type	VVOFFICE_TYPE
INDUSTRY_SIT	IPD: Location of commercial object	VVINDUSTRY_SIT
INDUSTRY_LOC	IPD: Link to commercial object	VVINDUSTRY_LOC
RESIDENT_TYPE	IPD: Type of resid. object (only for usage type apart.> 50%)	VVRESIDENT_TYPE
RENTAL_CATEGORY	IPD: Rent category (only for usage type apartment > 50%)	VVRENTAL_CAT
YEAR_CONSTRUCT	IPD: Constr.year or moderniz. (being modernized = '8888')	GJAHR
BUTXT	Name of Company Code or Company	TEXT25
ADRZUS	Address addit. info. (e.g. storey)	TEXT35
TXJCD	Tax Jurisdiction	TXJCD
PURC_MONTH	IPD: Month of purchase	VVPURC_MONTH
PURC_YEAR	IPD: Year of purchase	GJAHR
SALE_MONTH	IPD: Month of sale	VVSALE_MONTH
SALE_YEAR	IPD: Sales year	GJAHR
BERGRP	Authorization group	VVBERGRP
DUMMYFIELD	Single-Character Flag	CHAR1

Master Data Relations \| to Other Relations ↓	Join Conditions
Company Code	`S402.MANDT == T001.MANDT` `S402.BUKRS == T001.BUKRS`
Company code	`S402.MANDT == T001.MANDT` `S402.BUKRS_01 == T001.BUKRS`
Business Area	`S402.MANDT == TGSB.MANDT` `S402.GSBER == TGSB.GSBER`
Business Area	`S402.MANDT == TGSB.MANDT` `S402.GSBER_02 == TGSB.GSBER`
Controlling Area	`S402.MANDT == TKA01.MANDT` `S402.KOKRS == TKA01.KOKRS`
Cost Center Date active in portfolio Cost Center Controlling Area	`S402.MANDT == CSKS.MANDT` `S402.DAKTBEST == CSKS.DATBI` `S402.KOSTL == CSKS.KOSTL` `S402.KOKRS == CSKS.KOKRS`
Client	`S402.MANDT == T000.MANDT`
Profit Center Date active in portfolio Controlling Area Profit Center	`S402.MANDT == CEPC.MANDT` `S402.DAKTBEST == CEPC.DATBI` `S402.KOKRS == CEPC.KOKRS` `S402.PRCTR == CEPC.PRCTR`
Planning profile for Real Estate objects	`S402.MANDT == TIV98.MANDT` `S402.PROFIL == TIV98.PROFIL`
Settlement profile for costs Settlement profile for costs Client	`S402.PROFL == TKB1A.APROF` `S402.MANDT == TKB1A.MANDT`
Tenancy law	`S402.MANDT == TIV03.MANDT` `S402.SMIETR == TIV03.SMIETR`
Representative list of rents assignment	`S402.MANDT == TIV20.MANDT` `S402.SMIETSP == TIV20.SMIETSP`
Indicator: District Location of Object	`S402.MANDT == TIV45.MANDT` `S402.SOBJLAGE == TIV45.SOBJLAGE`
Location: Transport connections Location: Transport connections Client	`S402.SVERKEHR == TIV44.SVERKEHR` `S402.MANDT == TIV44.MANDT`
Business Entity Number Company Code Business Entity Number	`S402.MANDT == VIOB01.MANDT` `S402.BUKRS == VIOB01.BUKRS` `S402.SWENR == VIOB01.SWENR`
Business Entity Number Company Code Business Entity Number	`S402.MANDT == VIOB01.MANDT` `S402.BUKRS == VIOB01.BUKRS` `S402.SWENR_03 == VIOB01.SWENR`
User field: Unit for value fields	`S402.MANDT == TCURC.MANDT` `S402.USRCUKY1 == TCURC.WAERS`
User field: Unit for quantity fields	`S402.MANDT == T006.MANDT` `S402.USRUNIT1 == T006.MSEHI`
Predefined operating costs settlement variant Predefined operating costs settlement variant Client	`S402.VORBK == TIA01.ABRVAR` `S402.MANDT == TIA01.MANDT`
Predefined heating expenses settlement variant Predefined heating expenses settlement variant Client	`S402.VORHK == TIA01.ABRVAR` `S402.MANDT == TIA01.MANDT`

Other Relations \| to Master Data Relations ↑	Join Conditions
Location: Business entity	`S402.MANDT == TIV10.MANDT` `S402.SLAGEWE == TIV10.SLAGEWE`
Regional location	`S402.MANDT == TIV35.MANDT` `S402.SSTDORT == TIV35.SSTDORT`