S404 SAP (Properties) Table details

Dictionary Type: Table
Description: Properties




ABAP Code to SELECT data from S404
Related tables to S404
Access table S404




Table field list including key, data, relationships and ABAP select examples

S404 is a standard SAP Table which is used to store Properties data and is available within R/3 SAP systems depending on the version and release level.

The S404 table consists of various fields, each holding specific information or linking keys about Properties 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 S404 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
MANDTClient MANDTCLNT3T000MANDT
SSOURStatistic(s) origin SSOURCHAR4SSOUR
VRSIOVersion number in the information structure VRSIOCHAR3Assigned to domainVRSIOMCV
SPMONPeriod to analyze - month SPMONNUMC6PERIMCPERIOD
SPTAGPeriod to analyze - current date SPTAGDATS8DATUM
SPWOCPeriod to analyze - week SPWOCNUMC6PERIMCPERIOD
SPBUPPeriod to analyze - posting period SPBUPNUMC6PERIMCPERIOD
BUKRS_01Company Code BUKRSCHAR4T001BUKRSBUKC_T001
GSBER_01Business Area GSBERCHAR4TGSBGSBERGSB
SWENR_02Site Number SWENRCHAR8VIOB01SWENRSWENRWEHMCWE
SGRNR_03Property Number for BE SGRNRCHAR8VIOB02SGRNRSGRNRGRSMCGR
PERIVFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
VWDATPointer to administrative data VWDATNUMC10VWDAT
USRUNIT1User field: Unit for quantity fields USRUNITUNIT3T006CUNITMEINS
USRUNIT2User field: Unit for quantity fields USRUNITUNIT3T006CUNITMEINS
USRCUKY1User field: Unit for value fields USRCUKYCUKY5TCURCWAERS
USRCUKY2User field: Unit for value fields USRCUKYCUKY5TCURCWAERS
FEINSArea unit FEINSUNIT3T006CUNITMEINSFEH
XORTAddress: City VVXORTCHAR35TEXT35
XPLZAddress: Postal code VVXPLZCHAR10PSTLZ
XSTRASSEAddress: Street/house number VVXSTRASSECHAR35TEXT35
XNUTZGRUCurrent usage of property XNUTZGRUCHAR30XMBEZ
ANZGRNo. of properties VVAGRDEC6DEC6
RBEPLANDevelopment plan: Description VVRBEPLANCHAR30XMBEZ
USR02User-defined field 1 for 10 characters USRCHAR101CHAR10USRCHAR10
USR03User-defined field 2 for 10 characters USRCHAR102CHAR10USRCHAR10
USR00User-defined field 1 for 20 characters USRCHAR201CHAR20USRCHAR20
USR01User field 2 for 20 characters USRCHAR202CHAR20USRCHAR20
USR08User field 1 for date USRDATE1DATS8USRDATE
USR09User field 2 for date USRDATE2DATS8USRDATE
USR10User field 1 indicator for evaluations USRFLAG1CHAR1FLAG
USR11User field 2 indicator for evaluations USRFLAG2CHAR1FLAG
USR04User Field 1 for Set (Length 12,3) USRQUAN151QUAN15(3) USRQUAN15
USR05User Field 2 for Set (Length 12,3) USRQUAN152QUAN15(3) USRQUAN15
USR06User field 1 for values (length 10.3) USRCURR131CURR13(3) USRCURR13
USR07User field 2 for values (length 10.3) USRCURR132CURR13(3) USRCURR13
BDNRWERTLand reference value: Market value determination VVBDNRWERTCURR11(2) WRBTR
BDNWERTLand Value: Market Value Determination VVBDNWERT_2CURR15(2) WRTV8
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
DBDNWERTLand value: date VVDBDNWERTDATS8DDAT
RFAKTConversion factor for fractional share of property VVXFAKTCHAR6CHAR6
FQMFLARTArea of area type VVBFLARTQUAN14(4) VVBFLART
DSFLARTArea: effective from VVDSFLARTDATS8DATS
SFLARTArea type SFLARTNUMC4TIV08SFLART
SGRFRMProperty ground type VVSGRFRMNUMC3TIV58VVSGRFRM
XGRFRMProperty: Ground type VVXGRFRM2CHAR20VVXTEXT20
SGRGZSOverall condition of property VVSGRGZSNUMC3TIV59VVSGRGZS
XGRGZSProperty: Overall condition VVXGRGZS2CHAR20VVXTEXT20
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
XGBVONLand register district XGBVONCHAR25XTEXT25SH_GEM
SGRUNDBLand register number SGRUNDBNUMC8VIGBUCHSGRUNDBGBS
SGRNRProperty Number for BE SGRNRCHAR8VIOB02SGRNRSGRNRGRSMCGR
XGRARTProperty: Type VVXGRART2CHAR20VVXTEXT20
SGRARTProperty type VVSGRARTNUMC4TIV56VVSGRART
XGRTXTText for property VVXGRTXTCHAR60XLBEZ
BDMQMB2Land Price: Purchase Price VVBDMQMB2_2CURR15(2) WRTV8
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
XGRQALProperty: Quality of location VVXGRQAL2CHAR20VVXTEXT20
SGRQALProperty: Quality of location VVSGRQALNUMC3TIV57VVSGRQAL
RGRNARTUsage Type of Property According to Land Use Map RGRNARTCHAR2CHAR2
XGRNARTUsage Type of Property According to Land Use Map VVXGRNARTCHAR40TEXT40
ADRNRObject number (virtual object) SOBJNRNUMC10Assigned to domainSOBJNR
OBJNRObject number J_OBJNRCHAR22ONR00J_OBJNRONR
DBEPLANDevelopment plan: date VVDBEPLANDATS8DDAT
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
STTXT_EXTStatus: Set by user VVXSTXTEXTCHAR40CHAR40
STTXT_INTStatus: Set by system VVXSTTXTINCHAR40CHAR40
ONTBMZActual usage: Construction Dimension No. (Total) VVBNTBMZSDEC8(2) DEC6_2
ONTGFZActual usage: Amount of floor-area ratio (total) VVBNTGFZSDEC8(2) DEC6_2
ONTGRZActual usage: Amount of floor area ratio (total) VVBNTGRZSDEC8(2) DEC6_2
DVERKAUFDate: Sale VVDVERKAU2DATS8DATUM
DVRKPLANDate: Planned sale VVDVRKPLA2DATS8DATUM
BDMQMB1Land price: market value VVBDMQMB1CURR11(2) WRBTR
SWENRSite Number SWENRCHAR8VIOB01SWENRSWENRWEHMCWE
ONZBMZPermitted usage: Construct.dimension no. (total) VVBNZBMZSDEC8(2) DEC6_2
ONZGFZPermitted usage: floor-area ratio (total) VVBNZGFZSDEC8(2) DEC6_2
ONZGRZAllowed Usage: Site Occupancy Index (Total) VVBNZGRZSDEC8(2) DEC6_2
DWIRTUBDate: Transfer usage/charges VVDWIRTUB2DATS8DATUM
XUNARTMain usage type VVXUNARTCHAR35XTEXT35
SUNUTZAMain usage type VVSUNARTCHAR8TIV36VVSUNART
ANLN1Asset: main number VVANLN1CHAR12Assigned to domainALPHAANLN1
ANLN2Asset: Subnumber VVANLN2CHAR4Assigned to domainALPHAANLN2AN2
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
BERGRPAuthorization group VVBERGRPCHAR40VVBERGRP
XGEMARKLocal Subdistrict VVGEMARKCHAR12Assigned to domainVVGEMARK
NFLURNRNumber of Tract of Land in Land Register NFLURNRCHAR6NFLURNR
XFLURSTParcel of Land XFLURSTCHAR10TEXT10
BRFLURSTFractional Parcel of Land VVBRFLURSTCHAR4VVBRFLURST
JERBBAUHeritable building right indicator JERBBAUCHAR1Assigned to domainSOBJERBBAU
GEMEINDEMunicipality key VVGEMEINDECHAR8Assigned to domainVVGEMEINDE
ZULBAUHPermitted building height VVZULBAUHQUAN4VVZULBAUH
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
XGEMEINDEName of municipality VVXGEMEINDECHAR50VVXGEMEINDE
XKREISName of district VVXKREISCHAR30VVXKREIS
XREGIOName of federal state VVXREGIOCHAR30VVXREGIO
XERBBAUHeritable building right VVXERBBAUCHAR30XTEXT30
XLGEMARKExplanation of sub-district VVLGEMARKCHAR25VVLGEMARK
DUMMYFIELDSingle-Character Indicator CHAR1CHAR1CHAR1
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS

Key field Non-key field



How do I retrieve data from SAP table S404 using ABAP code

The following ABAP code Example will allow you to do a basic selection on S404 to SELECT all data from the table
DATA: WA_S404 TYPE S404.

SELECT SINGLE *
FROM S404
INTO CORRESPONDING FIELDS OF WA_S404
WHERE...

How to access SAP table S404

Within an ECC or HANA version of SAP you can also view further information about S404 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!