SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | VIBDBU
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Real Estate Management :: Flexible Real Estate Management :: Basic Data
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VIBDBU974BuildingBasic Data
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, INTRENO, BUKRS, SWENR, SGENR, OBJNR, IMKEY, CREATIONTYPE, RERF, DERF, TERF, REHER, RBEAR, DBEAR, TBEAR, RBHER, RESPONSIBLE, USEREXCLUSIVE, AUTHGRP, VALIDFROM, VALIDTO, XGETXT, RGEBART, JERBBAU, RGEBZUST, YBAUJAHR, YMODERN, YAUFBAU, DBAUBEGI, BBAUW13, BBAUWX, BBAUWAKT, BBAUWAKTX, BDMCBMRA, DBAUGENE, XBAUGENE, DBEZUGSF, DFERTIG, DSCHLUSS, JDENKMAL, DBAUVOR, DVORBES, DANTBAU, BEINHEITW, BEINHEITWX, NEINHEITW, BVERSWRT, BVERSWRTX, RVERSWRT, DWIRTUB, DVERKAUF, DVRKPLAN, DNUTZEND, DFRDVON, DFRDBIS, BANZGE, SUNUTZA, JUNUTZA, SSTCKBIS, SLIFTBIS, AUGESCH, JANLHIE, RLRALOC, USESRLRA, GEMEINDE, REINS, WAERS, HASCOP, USGFUNCTION, OBJCOND, OBJCAT, YEARDECONSTR, AREAVALUE, HEATINGTYPE, ENERGYHEAT, ENERGYWATER, HOTWATERSUPPLY, POWERCONSUM, GLAZING, ADMINNO, ADMINXGETXT, GEMEINDECH, BANZGECH, SSTCKBISCH, SLIFTBISCH, AUGESCHCH, SECCO, BUPLA, REPKOCH, BDCONSTR, BDFIREPREV, BDOTHOW, BDOWNSHIP, KOCHDATE, VPT, CURRENCY, CONDK FROM VIBDBU
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2INTRENOInternal Key of Real Estate Objectnvarchar130CHAR(N' ')NoRECAINTRENO Allow NULL? 
3BUKRSCompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
4SWENRSite Numbernvarchar80CHAR(N' ')Yes*REBDBENO Allow NULL? 
5SGENRNumber of Buildingnvarchar80CHAR(N' ')YesREBDBUNO Allow NULL? 
6OBJNRObject Numbernvarchar220CHAR(N' ')Yes*RECAOBJNR Allow NULL? 
7IMKEYInternal Key of Real Estate Object (FI)nvarchar80CHAR(N' ')YesRECAIMKEY Allow NULL? 
8CREATIONTYPEHow the Object Was Createdchar10CHAR(N' ')YesRECACREATIONTYPE Allow NULL? 
9RERFEntered bynvarchar120CHAR(N' ')YesRERF Allow NULL? 
10DERFFirst Entered onnvarchar80DATS(N'00000000')YesDERF Allow NULL? 
11TERFTime of Initial Entrynvarchar60TIMS(N'000000')YesTERF Allow NULL? 
12REHERSource of initial entrynvarchar100CHAR(N' ')YesREHER Allow NULL? 
13RBEAREmployee IDnvarchar120CHAR(N' ')YesRBEAR Allow NULL? 
14DBEARLast Edited onnvarchar80DATS(N'00000000')YesDBEAR Allow NULL? 
15TBEARLast Edited atnvarchar60TIMS(N'000000')YesTBEAR Allow NULL? 
16RBHEREditing Sourcenvarchar100CHAR(N' ')YesRBHER Allow NULL? 
17RESPONSIBLEPerson Responsiblenvarchar120CHAR(N' ')YesUSR02RECARESPONSIBLE Allow NULL? 
18USEREXCLUSIVEUser with Exclusive Change Authorizationnvarchar120CHAR(N' ')YesUSR02RECAUSEREXCLUSIVE Allow NULL? 
19AUTHGRPAuthorization Groupnvarchar400CHAR(N' ')YesRECAAUTHGRP Allow NULL? 
20VALIDFROMDate: Object Valid Fromnvarchar80DATS(N'00000000')YesREBDOBJVALIDFROM Allow NULL? 
21VALIDTODate: Object Valid Tonvarchar80DATS(N'00000000')YesREBDOBJVALIDTO Allow NULL? 
22XGETXTDescription of Buildingnvarchar600CHAR(N' ')YesREBDXBU Allow NULL? 
23RGEBARTType of buildingnvarchar20NUMC(N'00')YesTIV5ARGEBART Allow NULL? 
24JERBBAUHeritable building right indicatorchar10CHAR(N' ')YesTDO9JERBBAU Allow NULL? 
25RGEBZUSTGeneral condition of buildingnvarchar20NUMC(N'00')YesTIV83RGEBZUST Allow NULL? 
26YBAUJAHRConstYrnvarchar80DATS(N'00000000')YesVVYBAUJAHR Allow NULL? 
27YMODERNYear of modernizationnvarchar80DATS(N'00000000')YesVVYMODERN Allow NULL? 
28YAUFBAUYear of reconstructionnvarchar80DATS(N'00000000')YesVVYAUFBAU Allow NULL? 
29DBAUBEGIConstruction start datenvarchar80DATS(N'00000000')YesDBAUBEGI Allow NULL? 
30BBAUW13OBSOLETE: Replaced by BBAUWX - See SAP Note 1771933decimal112CURR((0))YesBBAUWXOLD
31BBAUWXBuilding Valuedecimal152CURR((0))YesBBAUWX
32BBAUWAKTOBSOLETE: Replaced by BBAUWAKTX - See SAP Note 1771933decimal112CURR((0))YesBBAUWAKTXOLD
33BBAUWAKTXCurrent Building Valuedecimal152CURR((0))YesBBAUWAKTX
34BDMCBMRAAmount per volume unitdecimal112CURR((0))YesBDMCBMRA
35DBAUGENEBuilding permitnvarchar80DATS(N'00000000')YesDBAUGENE Allow NULL? 
36XBAUGENENote on building permitnvarchar300CHAR(N' ')YesXBAUGENE Allow NULL? 
37DBEZUGSFReady for occupancynvarchar80DATS(N'00000000')YesDBEZUGSF Allow NULL? 
38DFERTIGCompletionnvarchar80DATS(N'00000000')YesDFERTIG Allow NULL? 
39DSCHLUSSFinal Inspectionnvarchar80DATS(N'00000000')YesDSCHLUSS Allow NULL? 
40JDENKMALProtection of Historical Siteschar10CHAR(N' ')YesJDENKMAL Allow NULL? 
41DBAUVORDate of planning inquirynvarchar80DATS(N'00000000')YesDBAUVOR Allow NULL? 
42DVORBESDate of prior noticenvarchar80DATS(N'00000000')YesDVORBES Allow NULL? 
43DANTBAUApplication for building permitnvarchar80DATS(N'00000000')YesDANTBAU Allow NULL? 
44BEINHEITWOBSOLETE: Replaced by BEINHEITWX - See SAP Note 1771933decimal112CURR((0))YesBEINHEITWXOLD
45BEINHEITWXAssessed Value of Buildingdecimal152CURR((0))YesBEINHEITWX
46NEINHEITWAssessed value base yearnvarchar40NUMC(N'0000')YesNEINHEITW Allow NULL? 
47BVERSWRTOBSOLETE: Replaced by BVERSWRTX - See SAP Note 1771933decimal112CURR((0))YesBVERSWRTXOLD
48BVERSWRTXInsurable Value Amountdecimal152CURR((0))YesBVERSWRTX
49RVERSWRTType of insurance valuechar10NUMC(N'0')YesRVERSWRT Allow NULL? 
50DWIRTUBTransfer usage / chargesnvarchar80DATS(N'00000000')YesVVDWIRTUB Allow NULL? 
51DVERKAUFSale datenvarchar80DATS(N'00000000')YesVVDVERKAUF Allow NULL? 
52DVRKPLANPlanned salenvarchar80DATS(N'00000000')YesVVDVRKPLAN Allow NULL? 
53DNUTZENDEnd of usagenvarchar80DATS(N'00000000')YesVVDNUTZEND Allow NULL? 
54DFRDVONPublic funding fromnvarchar80DATS(N'00000000')YesVVDFRDVON Allow NULL? 
55DFRDBISPublic funding tonvarchar80DATS(N'00000000')YesVVDFRDBIS Allow NULL? 
56BANZGENumber of floorsdecimal41DEC((0))YesVVBANZGE
57SUNUTZAMain usage typenvarchar80CHAR(N' ')YesTIV36VVSUNART Allow NULL? 
58JUNUTZAOBSOLETE: Main Usage Typechar10CHAR(N' ')YesREBDJUNUTZAOBS Allow NULL? 
59SSTCKBISUppermost Floor of a Buildingnvarchar30NUMC(N'000')Yes*VVSTCKBIS Allow NULL? 
60SLIFTBISElevator to Floor in Buildingnvarchar30NUMC(N'000')Yes*VVLIFTBIS Allow NULL? 
61AUGESCHNumber of basementsdecimal20DEC((0))YesAUGESCH
62JANLHIEOBSOLETE: Asset Assignment Also Applies for Subord. Buildingchar10CHAR(N' ')YesREBDJANLHIEOBS Allow NULL? 
63RLRALOCLocation Classnvarchar60CHAR(N' ')YesTIVAJRLRALOCREAJRLRALOC Allow NULL? 
64USESRLRARepresentative List of Rents Is Usedchar10CHAR(N' ')YesREAJUSESRLRA Allow NULL? 
65GEMEINDEMunicipality keynvarchar80CHAR(N' ')YesTIVG1VVGEMEINDE Allow NULL? 
66REINSUnit for cubic volumenvarchar30UNIT(N' ')YesT006REINS Allow NULL? 
67WAERSCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
68HASCOPUses Current Occupancy Principlechar10CHAR(N' ')YesRESCHASCOP Allow NULL? 
69USGFUNCTIONFunction of Objectnvarchar40CHAR(N' ')YesTIVBDUSGFUNCREBDUSGFUNCTION Allow NULL? 
70OBJCONDCode of Building Statusnvarchar40NUMC(N'0000')YesTIVXCCHCONDREXCCHBUCOND Allow NULL? 
71OBJCATBuilding Category Codenvarchar40NUMC(N'0000')YesTIVXCCHKATREXCCHBUCATEGORY Allow NULL? 
72YEARDECONSTRYear of Demolitionnvarchar80DATS(N'00000000')YesREXCCHBUDECONYEAR Allow NULL? 
73AREAVALUEFloor Area of Building in Square Metersdecimal102DEC((0))YesREXCCHBUAREA
74HEATINGTYPECode of Heating Typenvarchar40NUMC(N'0000')YesTIVXCCHHEATREXCCHBUHEATINGTYPE Allow NULL? 
75ENERGYHEATEnergy Carrier of Heatingnvarchar40NUMC(N'0000')YesTIVXCCHGENSRCREXCCHBUENERGYSOURCEH Allow NULL? 
76ENERGYWATEREnergy Carrier of Hot Waternvarchar40NUMC(N'0000')YesTIVXCCHGENSRCREXCCHBUENERGYSOURCEW Allow NULL? 
77HOTWATERSUPPLYCentral Hot Water Supplychar10CHAR(N' ')YesREXCCHBUHOTWATER Allow NULL? 
78POWERCONSUMPower Consumption of Building (in kWh)decimal102DEC((0))YesREXCCHBUPOWERCONSUMPTION
79GLAZINGGlazing Typenvarchar150CHAR(N' ')YesREXCCHBUGLAZING Allow NULL? 
80ADMINNOAdministrative Building Numbernvarchar120CHAR(N' ')YesREXCCHBUADMINNO Allow NULL? 
81ADMINXGETXTBuilding Namenvarchar600CHAR(N' ')YesREXCCHBUADMINXBU Allow NULL? 
82GEMEINDECHLand Register Districtnvarchar60CHAR(N' ')Yes*RELMLRDISTRICT Allow NULL? 
83BANZGECHNumber of floorsdecimal41DEC((0))YesVVBANZGE
84SSTCKBISCHUppermost Floor of a Buildingnvarchar30NUMC(N'000')Yes*VVSTCKBIS Allow NULL? 
85SLIFTBISCHElevator to Floor in Buildingnvarchar30NUMC(N'000')Yes*VVLIFTBIS Allow NULL? 
86AUGESCHCHNumber of basementsdecimal20DEC((0))YesAUGESCH
87SECCOSection Codenvarchar40CHAR(N' ')Yes*SECCO Allow NULL? 
88BUPLABusiness Placenvarchar40CHAR(N' ')Yes*BUPLA Allow NULL? 
89REPKOCHKind of Changechar10CHAR(N' ')YesREXCJPREPKOCH Allow NULL? 
90BDCONSTRConstruction Statuschar10CHAR(N' ')YesREXCJPBDCONSTR Allow NULL? 
91BDFIREPREVFire Fighting Method Numbernvarchar80CHAR(N' ')YesREXCJPBDFIREPREV Allow NULL? 
92BDOTHOWNumber of Another Owners in the Same Buildingint100INT4((0))YesREXCJPBDOTHOW Allow NULL? 
93BDOWNSHIPBuilding Ownership Statuschar10CHAR(N' ')YesREXCJPBDOWNSHIP Allow NULL? 
94KOCHDATEDate of Change in Kind of Changenvarchar80DATS(N'00000000')YesREXCJPKOCHDATE Allow NULL? 
95VPTProperty Taxable Valuedecimal152CURR((0))YesREXCPTVPT_NOSIGN
96CURRENCYCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
97CONDKConservation Levelnvarchar40CHAR(N' ')YesTIVXCPTRACONSREXCPTRACONS Allow NULL? 
NamePrimaryUniqueTypeColumns
VIBDBU~0YesYesCLUSTEREDMANDT, INTRENO
VIBDBU~001NoNoNONCLUSTEREDMANDT, BUKRS, SWENR, SGENR
VIBDBU~002NoNoNONCLUSTEREDMANDT, OBJNR
VIBDBU~003NoNoNONCLUSTEREDMANDT, RESPONSIBLE

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy