S402 SAP (Business entities) Table details
Dictionary Type: Table
Description: Business entities
Description: Business entities
Table field list including key, data, relationships and ABAP select examples
S402 is a standard SAP Table which is used to store Business entities data and is available within R/3 SAP systems depending on the version and release level.
The S402 table consists of various fields, each holding specific information or linking keys about Business entities data available in SAP. These include SSOUR (Statistic(s) origin), VRSIO (Version number in the information structure), SPMON (Period to analyze - month), SPTAG (Period to analyze - current date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP S402 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
SSOUR | Statistic(s) origin | SSOUR | CHAR | 4 | SSOUR | ||||
VRSIO | Version number in the information structure | VRSIO | CHAR | 3 | Assigned to domain | VRSIO | MCV | ||
SPMON | Period to analyze - month | SPMON | NUMC | 6 | PERI | MCPERIOD | |||
SPTAG | Period to analyze - current date | SPTAG | DATS | 8 | DATUM | ||||
SPWOC | Period to analyze - week | SPWOC | NUMC | 6 | PERI | MCPERIOD | |||
SPBUP | Period to analyze - posting period | SPBUP | NUMC | 6 | PERI | MCPERIOD | |||
BUKRS_01 | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
GSBER_02 | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
SWENR_03 | Site Number | SWENR | CHAR | 8 | VIOB01 | SWENR | SWENR | WEH | MCWE |
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | Assigned to domain | PERIV | |||
VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | VWDAT | ||||
USRUNIT1 | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
USRUNIT2 | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
USRCUKY1 | User field: Unit for value fields | USRCUKY | CUKY | 5 | TCURC | WAERS | |||
USRCUKY2 | User field: Unit for value fields | USRCUKY | CUKY | 5 | Assigned to domain | WAERS | |||
PROFL | Settlement profile for costs | VVAPROF | CHAR | 6 | TKB1A | ALPHA | APROF | ||
XPROFL | Settlement profile for costs | VVXPROFL | CHAR | 30 | TEXT30 | ||||
XORT | Address: City | VVXORT | CHAR | 35 | TEXT35 | ||||
XPLZ | Address: Postal code | VVXPLZ | CHAR | 10 | PSTLZ | ||||
XSTRASSE | Address: Street/house number | VVXSTRASSE | CHAR | 35 | TEXT35 | ||||
DAKTBEST | Date active in portfolio | DAKTBEST | DATS | 8 | DATUM | ||||
ANLN1 | Asset: main number | VVANLN1 | CHAR | 12 | ANLH | ALPHA | ANLN1 | ||
ANZWE | No. of business entities | VVAWE | DEC | 6 | DEC6 | ||||
USR03 | User-defined field 2 for 10 characters | USRCHAR102 | CHAR | 10 | USRCHAR10 | ||||
USR02 | User-defined field 1 for 10 characters | USRCHAR101 | CHAR | 10 | USRCHAR10 | ||||
USR01 | User field 2 for 20 characters | USRCHAR202 | CHAR | 20 | USRCHAR20 | ||||
USR00 | User-defined field 1 for 20 characters | USRCHAR201 | CHAR | 20 | USRCHAR20 | ||||
USR08 | User field 1 for date | USRDATE1 | DATS | 8 | USRDATE | ||||
USR09 | User field 2 for date | USRDATE2 | DATS | 8 | USRDATE | ||||
USR11 | User field 2 indicator for evaluations | USRFLAG2 | CHAR | 1 | FLAG | ||||
USR10 | User field 1 indicator for evaluations | USRFLAG1 | CHAR | 1 | FLAG | ||||
USR04 | User Field 1 for Set (Length 12,3) | USRQUAN151 | QUAN | 15(3) | USRQUAN15 | ||||
USR05 | User Field 2 for Set (Length 12,3) | USRQUAN152 | QUAN | 15(3) | USRQUAN15 | ||||
USR07 | User field 2 for values (length 10.3) | USRCURR132 | CURR | 13(3) | USRCURR13 | ||||
USR06 | User field 1 for values (length 10.3) | USRCURR131 | CURR | 13(3) | USRCURR13 | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
FEINS | Unit: area | VVKFEINS | CHAR | 5 | CHAR5 | ||||
VVLEN | Unit: length | VVKLEN | CHAR | 5 | CHAR5 | ||||
REINS | Unit: room content | VVKREINS | CHAR | 5 | CHAR5 | ||||
WAERS_01 | Unit: currency | VVKWAERS | CHAR | 5 | CHAR5 | ||||
RFAKT | Conversion factor for fractional share of property | VVXFAKT | CHAR | 6 | CHAR6 | ||||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
SINSTBEZ | Location: Maintenance district | VVSINSTBEZ | NUMC | 5 | Assigned to domain | SINSTBEZ | |||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
KOSTL | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
SLAGEWE | Location: Business entity | VVSLAGEWE | NUMC | 4 | TIV10 | SLAGEWE | |||
XINSTBEZ | Location: Maintenance district | VVXINSTBEZ | CHAR | 15 | CHAR15 | ||||
XOBJLAGE | Location: district | VVXOBJLAGE | CHAR | 15 | CHAR15 | ||||
XSTDORT | Regional location | VVXSTDORT | CHAR | 35 | XTEXT35 | ||||
XVERKEHR | Location: Transport connections | VVXERKEHR | CHAR | 50 | XTEXT50 | ||||
XLAGEWE | Location: Business ent. | VVXLAGEWE | CHAR | 15 | CHAR15 | ||||
XMIETR | Tenancy law | VVXMIETR | CHAR | 30 | XTEXT30 | ||||
SMIETR | Tenancy law | SMIETR | CHAR | 5 | TIV03 | SMIETR | |||
XMIETSP | Representative list of rents: allocation | VVXMIETSP | CHAR | 15 | CHAR15 | ||||
SMIETSP | Representative list of rents assignment | SMIETSP | CHAR | 6 | TIV20 | SMIETSP | |||
ADRNR | Object number (virtual object) | SOBJNR | NUMC | 10 | Assigned to domain | SOBJNR | |||
OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
RKZBEST | Object status | RKZBEST | CHAR | 1 | RKZBEST | ||||
SOBJLAGE | Indicator: District Location of Object | RESOBJLAGE | NUMC | 2 | TIV45 | RESOBJLAGE | |||
XPROFIL | Planning profile | VVXPROFIL | CHAR | 40 | TEXT40 | ||||
PROFIL | Planning profile for Real Estate objects | VVPROFIL | CHAR | 7 | TIV98 | VVPROFIL | |||
PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
SSTDORT | Regional location | VVSSTDORT2 | CHAR | 10 | TIV35 | VVSSTDORT | |||
STTXT_EXT | Status: Set by user | VVXSTXTEXT | CHAR | 40 | CHAR40 | ||||
XKZBEST | Status: portfolio | VVXKZBEST | CHAR | 40 | TEXT40 | ||||
STTXT_INT | Status: Set by system | VVXSTTXTIN | CHAR | 40 | CHAR40 | ||||
XWETEXT | Text for Site | VVXWETEXT | CHAR | 30 | XMBEZ | ||||
SVERKEHR | Location: Transport connections | SVERKEHR2 | CHAR | 1 | TIV44 | SVERKEHR | |||
XVORBK | Predefined operating costs settlement variant | VVXVORBK | CHAR | 50 | CHAR50 | ||||
VORBK | Predefined operating costs settlement variant | VORBK | CHAR | 4 | TIA01 | ABRVAR | |||
XVORHK | Predefined heating expenses settlement variant | VVXVORHK | CHAR | 50 | CHAR50 | ||||
VORHK | Predefined heating expenses settlement variant | VORHK | CHAR | 4 | TIA01 | ABRVAR | |||
SWENR | Site Number | SWENR | CHAR | 8 | VIOB01 | SWENR | SWENR | WEH | MCWE |
FUND_TYPE | IPD: Classification of participant | VVFUND_TYPE | CHAR | 1 | Assigned to domain | VVFUND_TYPE | |||
NATURE_INTEREST | IPD: Ownership structure | VVNATURE_INT | CHAR | 1 | Assigned to domain | VVNATURE_INT | |||
HEADLEASE_EXPIRE | IPD: Expiry year of hereditary tenancy | VVHEADLEASE_EXP | NUMC | 4 | GJAHR | GJAHR | |||
RETAIL_TYPE | IPD: Type of retail trade object | VVRETAIL_TYPE | CHAR | 1 | VVRETAIL_TYPE | ||||
OFFICE_LOC | IPD: Region (only for usage type office > 50%) | VVOFFICE_LOC | CHAR | 1 | Assigned to domain | VVOFFICE_LOC | |||
OFFICE_TYPE | IPD: Office type | VVOFFICE_TYPE | CHAR | 1 | Assigned to domain | VVOFFICE_TYPE | |||
INDUSTRY_TYPE | IPD: Commercial object type | VVINDUSTRY_TYPE | CHAR | 1 | VVINDUSTRY_TYPE | ||||
INDUSTRY_SIT | IPD: Location of commercial object | VVINDUSTRY_SIT | CHAR | 1 | Assigned to domain | VVINDUSTRY_SIT | |||
INDUSTRY_LOC | IPD: Link to commercial object | VVINDUSTRY_LOC | CHAR | 1 | Assigned to domain | VVINDUSTRY_LOC | |||
RESIDENT_TYPE | IPD: Type of resid. object (only for usage type apart.> 50%) | VVRESIDENT_TYPE | CHAR | 1 | Assigned to domain | VVRESIDENT_TYPE | |||
RENTAL_CATEGORY | IPD: Rent category (only for usage type apartment > 50%) | VVRENTAL_CAT | CHAR | 1 | Assigned to domain | VVRENTAL_CAT | |||
YEAR_CONSTRUCT | IPD: Constr.year or moderniz. (being modernized = '8888') | VVYEAR_CONSTRUCT | NUMC | 4 | GJAHR | GJAHR | |||
BUTXT | Name of Company Code or Company | BUTXT | CHAR | 25 | TEXT25 | ||||
ADRZUS | Address addit. info. (e.g. storey) | ADRZUS | CHAR | 35 | TEXT35 | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
PURC_MONTH | IPD: Month of purchase | VVPURC_MONTH | NUMC | 2 | VVPURC_MONTH | ||||
PURC_YEAR | IPD: Year of purchase | VVPURC_YEAR | NUMC | 4 | GJAHR | GJAHR | |||
PURC_PRICE_NET | ROZ: Net purchase price | VVPURC_PRICE_NET | CURR | 13(2) | WRTV7 | ||||
PURC_PRICE_GRO | IPD: Gross purchase price | VVPURC_PRICE_GRO | CURR | 13(2) | WRTV7 | ||||
PURC_PRICE_CURR | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
SALE_MONTH | IPD: Month of sale | VVSALE_MONTH | NUMC | 2 | VVSALE_MONTH | ||||
SALE_YEAR | IPD: Sales year | VVSALE_YEAR | NUMC | 4 | GJAHR | GJAHR | |||
SALE_PRICE_GRO | IPD: Gross sales price | VVSALE_PRICE_GRO | CURR | 13(2) | WRTV7 | ||||
SALE_PRICE_NET | IPD: Net sales price | VVSALE_PRICE_NET | CURR | 13(2) | WRTV7 | ||||
SALE_PRICE_CURR | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
BERGRP | Authorization group | VVBERGRP | CHAR | 40 | VVBERGRP | ||||
DUMMYFIELD | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 |
Key field | Non-key field |
How do I retrieve data from SAP table S402 using ABAP code
The following ABAP code Example will allow you to do a basic selection on S402 to SELECT all data from the tableDATA: WA_S402 TYPE S402.
SELECT SINGLE *
FROM S402
INTO CORRESPONDING FIELDS OF WA_S402
WHERE...
How to access SAP table S402
Within an ECC or HANA version of SAP you can also view further information about S402 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects