SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

S405 Table in SAP | Building Table & Fields List

S405 is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of S405 in SAP.

  • Table description : Building
  • Module : CRM
  • Parent Module : CRM
  • Package : FVVI
  • Software Component : BBPCRM
S405 table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP S405 Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
SSOURStatistic(s) originSSOURSSOUR
VRSIOVersion number in the information structureVRSIOVRSIO
SPMONPeriod to analyze - monthSPMONMCPERIOD
SPTAGPeriod to analyze - current dateSPTAGDATUM
SPWOCPeriod to analyze - weekSPWOCMCPERIOD
SPBUPPeriod to analyze - posting periodSPBUPMCPERIOD
BUKRS_01Company CodeBUKRSBUKRS
GSBER_02Business AreaGSBERGSBER
SWENR_03Business Entity NumberSWENRSWENR
SGENR_04Building NumberSGENRSGENR
BUKRSCompany CodeBUKRSBUKRS
GSBERBusiness AreaGSBERGSBER
SWENRBusiness Entity NumberSWENRSWENR
SGENRBuilding NumberSGENRSGENR
PERIVFiscal Year VariantPERIVPERIV
VWDATPointer to administrative dataVWDATVWDAT
USRUNIT1User field: Unit for quantity fieldsUSRUNITMEINS
USRUNIT2User field: Unit for quantity fieldsUSRUNITMEINS
USRCUKY1User field: Unit for value fieldsUSRCUKYWAERS
USRCUKY2User field: Unit for value fieldsUSRCUKYWAERS
WAERSCurrency KeyWAERSWAERS
FEINSArea unitFEINSMEINS
REINSUnit for cubic volumeREINSMEINS
XORTAddress: CityVVXORTTEXT35
XPLZAddress: Postal codeVVXPLZPSTLZ
XSTRASSEAddress: Street/house numberVVXSTRASSETEXT35
ANZGENo. of buildingsVVAGEDEC6
USR02User-defined field 1 for 10 charactersUSRCHAR101USRCHAR10
USR03User-defined field 2 for 10 charactersUSRCHAR102USRCHAR10
USR00User-defined field 1 for 20 charactersUSRCHAR201USRCHAR20
USR01User field 2 for 20 charactersUSRCHAR202USRCHAR20
USR08User field 1 for dateUSRDATE1USRDATE
USR09User field 2 for dateUSRDATE2USRDATE
USR10User field 1 indicator for evaluationsUSRFLAG1FLAG
USR11User field 2 indicator for evaluationsUSRFLAG2FLAG
USR04User Field 1 for Set (Length 12,3)USRQUAN151USRQUAN15
USR05User Field 2 for Set (Length 12,3)USRQUAN152USRQUAN15
USR06User field 1 for values (length 10.3)USRCURR131USRCURR13
USR07User field 2 for values (length 10.3)USRCURR132USRCURR13
FQMFLARTArea of area typeVVBFLARTVVBFLART
DSFLARTArea: effective fromVVDSFLARTDATS
SFLARTArea typeSFLARTSFLART
KOSTLCost CenterKOSTLKOSTL
ADRNRObject number (virtual object)SOBJNRSOBJNR
OBJNRObject numberJ_OBJNRJ_OBJNR
PRCTRProfit CenterPRCTRPRCTR
STTXT_EXTStatus: Set by userVVXSTXTEXTCHAR40
STTXT_INTStatus: Set by systemVVXSTTXTINCHAR40
DVERKAUFDate: SaleVVDVERKAU2DATUM
DVRKPLANDate: Planned saleVVDVRKPLA2DATUM
XUNARTMain usage typeVVXUNARTXTEXT35
SUNUTZAMain usage typeVVSUNARTVVSUNART
RGEBARTType of buildingRGEBARTSOBJART
XGEBARTBuilding: Building typeVVXGEBARTXTEXT50
JERBBAUHeritable building right indicatorJERBBAUSOBJERBBAU
RGEBZUSTGeneral condition of buildingRGEBZUSTVVRZUSTAND
XGEBZUSTCondition: general conditionVVXGEBZUSTXTEXT50
YBAUJAHRYear: construction yearVVYBAUJAH2DATUM
YMODERNYear: modernizationVVYMODERN2DATUM
YAUFBAUYear: reconstructionVVYAUFBAU2DATUM
DBAUBEGIDate: building startVVDBAUBEGIDDAT
BBAUW13Value: Building value 1913VVBBAUW13WRBTR_SUM
BBAUWAKTValue: current building valueVVBBAUWAKTWRBTR_SUM
BBETRIEBValue: facilitiesVVBBETRIE2WRBTR_SUM
BAUSSENValue: GroundsVVBAUSSENWRBTR_SUM
BSCHADENValue: Structural damageVVBSCHADENWRBTR_SUM
BREPSTAUValue: Repair backlogVVBREPSTAUWRBTR_SUM
BDMCBMRAAmount per volume unitBDMCBMRAWRBTR
DBAUGENEBuilding permit: dateVVDBAUGENEDDAT
XBAUGENEBuilding permit: noteVVXBAUGENEXMBEZ
DBEZUGSFDate: Ready for occupancyVVDBEZUGSFDDAT
DFERTIGDate: CompletionVVDFERTIGDDAT
DSCHLUSSDate: final inspectionVVDSCHLUS2DDAT
FDACHFLAttic spaceFDACHFLDEC6_2
RDAZUSTCondition of roofRDAZUSTVVRZUSTAND
XDAZUSTCondition: roofVVXDAZUSTCHAR30
RFAZUSTCondition of facadeRFAZUSTVVRZUSTAND
XFAZUSTCondition: facadeVVXFAZUSTCHAR30
BUBRACubic VolumeBUBRA12REDEC12_3
JDENKMALProtection of Historical SitesJDENKMALJANE
AUGESCHNumber of basementsAUGESCHDEC2
DAKTBESTDate active in portfolioDAKTBESTDATUM
DBAUVORDate: Planning inquiryVVDBAUVORDDAT
DVORBESDate: prior noticeVVDVORBESDDAT
DANTBAUDate: Building permit applicationVVDANTBAUDATUM
SGRUNDBLand register numberSGRUNDBSGRUNDB
XGBVONLand register districtXGBVONXTEXT25
XGETXTBuilding textXGETXTXLBEZ
BEINHEITWAssessed value: valueVVBEINHW2WRBTR_SUM
NEINHEITWAssessed value: base yearVVNEINHWGJAHR
BVERSWRTInsurable value: amountVVBVERSWRTWRBTR_SUM
RVERSWRTType of insurance valueRVERSWRTRVERSWRT
XVERSWRTInsurance value typeVVXVERSWRTTEXT25
SMIETSPRepresentative list of rents assignmentSMIETSPSMIETSP
XMIETSPRepresentative list of rents: allocationVVXMIETSPCHAR15
SLAGKLocation classSLAGKSLAGK
XLAGKRepresentative list of rents: locat.classVVXLAGKXMBEZ
RFAKTConversion factor for fractional share of propertyVVXFAKTCHAR6
JNURJAHRIndicator: Only regard construction date in terms of yearsVVJNURJJANE
DWIRTUBDate: Transfer usage/chargesVVDWIRTUB2DATUM
PROFLSettlement profileAPROFAPROF
DNUTZENDDate: end of usageVVDNUTZEN2DATUM
DFRDVONDate: Public funding fromVVDFRDVON2DATUM
DFRDBISDate: Public funding toVVDFRDBIS2DATUM
NSTCKLFTNumber of highest floor reached by elevatorVVNSTCKLF2CHAR3
BANZGENumber of floorsVVBANZGE2DEC5_1
RPGENRBuilding no. of hierarchical superior building partVVRPGENRSGENR
SMERKMAFixtures and Fittings CharacteristicsSMERKMASMERKMA
XMERKMACharacteristicVVXMERKMAXTEXT30
ANLN1Asset: main numberVVANLN1ANLN1
ANLN2Asset: SubnumberVVANLN2ANLN2
JANLHIEIndicator: Asset allocation valid for subordin. buildingVVJANLHIEJANE
TXJCDTax JurisdictionTXJCDTXJCD
VVSAOGRGroup of object characteristicsVVSAOGRVVSAOGR
VVXAOGRGroup of object characteristicsVVXAOGRXTEXT30
VVSAOBNumber of Object CharacteristicVVSAOBVVSAOB
VVXAOBNumber of Object CharacteristicVVXAOBXTEXT30
VVSAUSPNumber of object characteristic valueVVSAUSPVVSAUSP
VVXAUSPNumber of object characteristic valueVVXAUSPXTEXT30
BERGRPAuthorization groupVVBERGRPVVBERGRP
GEMEINDEMunicipality keyVVGEMEINDEVVGEMEINDE
XGEMEINDEName of municipalityVVXGEMEINDEVVXGEMEINDE
XKREISName of districtVVXKREISVVXKREIS
XREGIOName of federal stateVVXREGIOVVXREGIO
XERBBAUHeritable building rightVVXERBBAUXTEXT30
.INCLUDECustomer Fields LIS: Include for Infostructure    
DUMMYFIELDSingle-Character FlagCHAR1CHAR1
.INCLUDE   

S405 related tables

TableNote
HBSAFFAffected building in Home Building Solution
CCIHC_BUILDINGEHS: Building
CCIHC_BUILDINGTXEHS: Building
CHBSEXPPossible entries for the Building /part Exposure
CHBSEXPTtext for entries for the Building /part Exposure
CHBSFBTFitlist-Relevant Building Types
ESTBBGRPEHS: Header of Building Block Group
ESTBBGRPDEHS: Description of a Building Block Group (Language-Dep.)
ESTBBLKEHS: Administration Data of Building Block
ESTBBLKDEHS: Description of Building Block (Language-Dependent)
FAGL_MIG_TOTALSLog Table for Building Balances in New G/L
GLE_MCA_TPCKBLDMCA Parallel Processing Package Building
HBSCMPCommunity Plan Data within Home Building Solution
HBSRLSAffected Building List
ICLNOLHONotice of Loss Building
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com