S408 SAP (Land registers) Table details

Dictionary Type: Table
Description: Land registers




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




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

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

The S408 table consists of various fields, each holding specific information or linking keys about Land registers 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: Not classified


SAP S408 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
SGRUNDB_01Land register number SGRUNDBNUMC8VIGBUCHSGRUNDBGBS
PERIVFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
VWDATPointer to administrative data VWDATNUMC10VWDAT
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
FEINSArea unit FEINSUNIT3T006CUNITMEINSFEH
XNRA3Section 3, number of entry VVXNRA3CHAR6ALPHAVVXNRGB
XORTAddress: City VVXORTCHAR35TEXT35
XPLZAddress: Postal code VVXPLZCHAR10PSTLZ
XSTRASSEAddress: Street/house number VVXSTRASSECHAR35TEXT35
RGBA2LBType of charges and restrictions for land register type VVRGBA2LBCHAR1VVRGBA2LB
DAUFLASSDate of conveyance DAUFLASSDATS8DDAT
NBANDNRLand register volume number NBANDNRCHAR15TEXT15
RBELASTType of encumbrance in section 3 of land register RBELASTNUMC2TIV02RBELAST
XRBELASTType of encumbrance in section 3 of land register VVXBELASTCHAR15TEXT15
XZUATEXTText for entry//removal from land register XZUATEXTCHAR60TEXT60
XEINTXTCharges + restrictions in Section 2 of land register XEINTXTCHAR60TEXT60
BDARLEHTotal amount of right registered in Section III BDARLEHCURR13(2) WRTV7
BAENLOEChange or deletion amount BAENLOECURR13(2) BWHR
DBAUFLDate of approval of conveyance DBAUFLDATS8DATUM
DBEINTRDate of approval of entry DBEINTRDATS8DATUM
DBVORMDate of approval of priority notice DBVORMDATS8DATUM
NBLATTNRLand register page number NBLATTNRCHAR15TEXT15
DATZUABDate of entry/removal from land register DATZUABDATS8DDAT
DEINTRAGDate of entry DEINTRAGDATS8DDAT
DAENDERChange /deletion date DAENDERDATS8DDAT
BEFFECTEffective loan amount BEFFECTCURR11(2) WRBTR
JEIGENRIndividual right indicator JEIGENRCHAR1JANEI
SNRABT1No. of entry in section 1 of land register SNRABT1NUMC3NRABT1
SNRABT2Number of entry in section 2 of land register SNRABT2NUMC3NRABT2
SNRABT3No. of entry in Section 3 of land register SNRABT3NUMC3NRABT3
RFAKTConversion factor for fractional share of property VVXFAKTCHAR6CHAR6
NFLURNRNumber of Tract of Land in Land Register NFLURNRCHAR6NFLURNR
XFLURSTParcel of Land XFLURSTCHAR10TEXT10
FLAECHEArea of area type VVBFLARTQUAN14(4) VVBFLART
FEINS_01Area unit FEINSUNIT3T006CUNITMEINSFEH
JKZLOEIndicator: Land register entry is marked as being deleted JKZLOECHAR1JFLAGG
XGEMARKLocal subdistrict ID XGEMARKCHAR12XTEXT12
PARTNRBusiness Partner Number BP_PARTNRCHAR10BP000ALPHABP_PARTNRBPN
XGLAUBCreditor XGLAUBCHAR25XTEXT25
DAUSZGVDate: Land register extract from DAUSZGVDATS8DAUSZGV
XGBVONLand register district XGBVONCHAR25XTEXT25SH_GEM
XPARTNRLand register: name VVXPARTNRGCHAR35CHAR35
SGRUNDBLand register number SGRUNDBNUMC8VIGBUCHSGRUNDBGBS
XGBAMTLand registry ID XGBAMTCHAR25XTEXT25
SGRBALand register type SGRBANUMC2TDO6SGRBA
XGRBAType of land register XGRBACHAR50TEXT50
XEIGTLSTBasis of entry XEIGTLSTCHAR60TEXT60
ZGRUSCHLand charge interest rate VVZGRUSCHDEC10(7) DEC3_7
SLFDGRSTProperty consecutive number SLFDGRSTNUMC3NEINTRAG
NALTGRSTPrevious number of property NALTGRSTCHAR7XTEXT7
RGRSTLSTReference to relational table properties RGRSTLSTNUMC10RGRSTLST
BWRTMINNet present value of law BWRTMINCURR13(2) WRTV7
XCOMMNTComment about lot VVXCOMMNTCHAR60TEXT60
XGSLAGEDescription of property location XGSLAGECHAR60TEXT60
NLSBUCHNReal properties register number NLSBUCHNNUMC6NLSBUCHN
REIGTLSTReference to relational data base table of owner REIGTLSTNUMC10REIGTLST
XGRSTLSTList of properties for an entry XGRSTLSTCHAR18XTEXT18
DLOESCHDeletion date DLOESCHDATS8DDAT
ZNEBENLAdditional service interest rate VVZNEBENLDEC10(7) DEC3_7
BNOMINNominal loan amount BNOMINCURR11(2) WRBTR
SNRFLSTConsecutive no. of a lot on a property VVSNRFLSTNUMC3VVSNRFLST
SNRZUABNumber of appreciation/depreciation SNRZUABNUMC3NEINTRAG
SNRABT2AChanges section 2 of land register, no. of entry SNRABT2ANUMC3NEINTRAG
SNRABT3ANo. of change/deletion in section 3 of land register SNRABT3ANUMC3NEINTRAG
XRNA2ANo. of change in section II VVXNRA2ACHAR6ALPHAVVXNRGB
XNRA1Section 1, number of entry VVXNRA1CHAR6ALPHAVVXNRGB
NRDARLEHLoan number NRDARLEHNUMC12NRDARLEH
XNRA3ANo of change in sect. III VVXNRARACHAR6ALPHAVVXNRGB
XNRBSTDNumber in property list VVXNRBSTDCHAR6ALPHAVVXNRGB
NRANGRank in section 3 of land register NRANGNUMC4NRANG
JREVALIndicator: Revaluation permitted JREVALCHAR1JANEI
XAENDText for change or deletion VVXAENDCHAR60TEXT60
XBELASTText about charge XBELASTCHAR60TEXT60
DAUFLVORDate of priority notice of conveyance DAUFLVORDATS8DDAT
PWRTMINPercentage decrease in value PWRTMINDEC5(2) DEC03_2
XWIRTARTBusiness type XWIRTARTCHAR60TEXT60
NZUGRSTEntry for property VVNZUGRSTCHAR6ALPHAVVXNRGB
JZUABValue appreciation indicator JZUABCHAR1JZUAB
ANZGBNo. of land registers VVAGBDEC5DEC5
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
SWENRSite Number SWENRCHAR8Assigned to domainSWENRSWENRWEHMCWE
SGRNRProperty Number for BE SGRNRCHAR8Assigned to domainSGRNRSGRNRGRSMCGR

Key field Non-key field



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

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

SELECT SINGLE *
FROM S408
INTO CORRESPONDING FIELDS OF WA_S408
WHERE...

How to access SAP table S408

Within an ECC or HANA version of SAP you can also view further information about S408 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!