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  | S406
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
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0S4061411Rental unitsReal Estate Management
SQL:  selectupdate insert create

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

SELECT MANDT, SSOUR, VRSIO, SPMON, SPTAG, SPWOC, SPBUP, BUKRS_01, GSBER_02, SWENR_03, SGRNR_04, SGENR_05, SMENR_06, BUKRS, GSBER, SWENR, SGRNR, SGENR, SMENR, PERIV, VWDAT, USRUNIT1, USRUNIT2, USRCUKY1, USRCUKY2, WAERS, MEINS, FEINS, REINS, XORT, XPLZ, XSTRASSE, ANZME, USR02, USR03, USR00, USR01, USR08, USR09, USR10, USR11, USR04, USR05, USR06, USR07, FBEZUG, FQMFLART, DSFLART, SFLART, KOSTL, DATAB, ADRNR, OBJNR, INTRENO, PRCTR, STTXT_EXT, STTXT_INT, XMETXT, SKOART, BKOND, DGULTAB, SNUNR, XNUNR, SALTNR, SRAART, BRAART, SMERKMA, XMERKMA, SSTOCKW, XSTOCKK, XSTOCKW, RLGESCH, XLGESCH, DBEZU, SABRG, DGAB, BABRE, TXT04, TXT30, BELEAB, BELEBIS, DBEGEH, XBEGEH, PERHOE, RPROZGRD, XPROZGRD, SMOEBL, AZIMM, AHALBZI, XSTANDNR, JEIGWOHN, ABNNR, STECHEM, SSTCKBIS, JVORSTEIG, RFAKT, JKONDMV, PKONDMV, DFSTRBIS, JRMSCHPR, DHPZSAKT, DUTBKAKT, DTEURAKT, SMIETSP, XMIETSP, PZUABSP, SLAGK, XLAGK, SAUSTKL, XAUSTKL, DWTVERM, RBELBIND, XBELBIND, DBINDBIS, SBWNR, SPARTNR, XPARTNR, XNNPART, DRESAB, DRESBIS, UMBRAUM, SGEBT, XGEBT, SBASTEU, DRESTAUR, TXJCD, BERGRP, DFLOWFIX, KOEIGR, SPOSINMSP, PPOSINMSP, DFRDVON, DFRDBIS, BMMVALFE, DMMGUELAB, SIHMA, SKOTYP, SGRUNDB, XGBVON, PAUSFW, DUMMYFIELD FROM S406
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2SSOURStatistic(s) originnvarchar40CHAR(N' ')NoSSOUR Allow NULL? 
3VRSIOVersion number in the information structurenvarchar30CHAR(N' ')No*VRSIO Allow NULL? 
4SPMONPeriod to analyze - monthnvarchar60NUMC(N'000000')NoSPMON Allow NULL? 
5SPTAGPeriod to analyze - current datenvarchar80DATS(N'00000000')NoSPTAG Allow NULL? 
6SPWOCPeriod to analyze - weeknvarchar60NUMC(N'000000')NoSPWOC Allow NULL? 
7SPBUPPeriod to analyze - posting periodnvarchar60NUMC(N'000000')NoSPBUP Allow NULL? 
8BUKRS_01Company Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
9GSBER_02Business Areanvarchar40CHAR(N' ')NoTGSBGSBER Allow NULL? 
10SWENR_03Site Numbernvarchar80CHAR(N' ')NoVIOB01SWENR Allow NULL? 
11SGRNR_04Property Number for BEnvarchar80CHAR(N' ')NoVIOB02SGRNR Allow NULL? 
12SGENR_05Building Numbernvarchar80CHAR(N' ')NoVIOB03SGENR Allow NULL? 
13SMENR_06Number of Rental Unitnvarchar80CHAR(N' ')NoVIMI01SMENR Allow NULL? 
14BUKRSCompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
15GSBERBusiness Areanvarchar40CHAR(N' ')YesTGSBGSBER Allow NULL? 
16SWENRSite Numbernvarchar80CHAR(N' ')YesVIOB01SWENR Allow NULL? 
17SGRNRProperty Number for BEnvarchar80CHAR(N' ')YesVIOB02SGRNR Allow NULL? 
18SGENRBuilding: numbernvarchar80CHAR(N' ')YesVIOB03VVSGENR Allow NULL? 
19SMENRRental unit: numbernvarchar80CHAR(N' ')YesVIMI01VVSMENR Allow NULL? 
20PERIVFiscal Year Variantnvarchar20CHAR(N' ')YesT009PERIV Allow NULL? 
21VWDATPointer to administrative datanvarchar100NUMC(N'0000000000')YesVWDAT Allow NULL? 
22USRUNIT1User field: Unit for quantity fieldsnvarchar30UNIT(N' ')YesT006USRUNIT Allow NULL? 
23USRUNIT2User field: Unit for quantity fieldsnvarchar30UNIT(N' ')YesT006USRUNIT Allow NULL? 
24USRCUKY1User field: Unit for value fieldsnvarchar50CUKY(N' ')YesTCURCUSRCUKY Allow NULL? 
25USRCUKY2User field: Unit for value fieldsnvarchar50CUKY(N' ')YesTCURCUSRCUKY Allow NULL? 
26WAERSCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
27MEINSBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
28FEINSArea unitnvarchar30UNIT(N' ')YesT006FEINS Allow NULL? 
29REINSUnit for cubic volumenvarchar30UNIT(N' ')YesT006REINS Allow NULL? 
30XORTAddress: Citynvarchar350CHAR(N' ')YesVVXORT Allow NULL? 
31XPLZAddress: Postal codenvarchar100CHAR(N' ')YesVVXPLZ Allow NULL? 
32XSTRASSEAddress: Street/house numbernvarchar350CHAR(N' ')YesVVXSTRASSE Allow NULL? 
33ANZMENumber of rental unitsdecimal60DEC((0))YesVVAME
34USR02User-defined field 1 for 10 charactersnvarchar100CHAR(N' ')YesUSRCHAR101 Allow NULL? 
35USR03User-defined field 2 for 10 charactersnvarchar100CHAR(N' ')YesUSRCHAR102 Allow NULL? 
36USR00User-defined field 1 for 20 charactersnvarchar200CHAR(N' ')YesUSRCHAR201 Allow NULL? 
37USR01User field 2 for 20 charactersnvarchar200CHAR(N' ')YesUSRCHAR202 Allow NULL? 
38USR08User field 1 for datenvarchar80DATS(N'00000000')YesUSRDATE1 Allow NULL? 
39USR09User field 2 for datenvarchar80DATS(N'00000000')YesUSRDATE2 Allow NULL? 
40USR10User field 1 indicator for evaluationschar10CHAR(N' ')YesUSRFLAG1 Allow NULL? 
41USR11User field 2 indicator for evaluationschar10CHAR(N' ')YesUSRFLAG2 Allow NULL? 
42USR04User Field 1 for Set (Length 12,3)decimal153QUAN((0))YesUSRQUAN151
43USR05User Field 2 for Set (Length 12,3)decimal153QUAN((0))YesUSRQUAN152
44USR06User field 1 for values (length 10.3)decimal133CURR((0))YesUSRCURR131
45USR07User field 2 for values (length 10.3)decimal133CURR((0))YesUSRCURR132
46FBEZUGReference area for calculation of amounts per area unitdecimal152QUAN((0))YesVVFBEZUG
47FQMFLARTArea of area typedecimal144QUAN((0))YesVVBFLART
48DSFLARTArea: effective fromnvarchar80DATS(N'00000000')YesVVDSFLART Allow NULL? 
49SFLARTArea typenvarchar40NUMC(N'0000')YesTIV08SFLART Allow NULL? 
50KOSTLCost center: namenvarchar100CHAR(N' ')Yes*VVXKOSTL Allow NULL? 
51DATABCost center: effective from_nvarchar80DATS(N'00000000')YesVVDKOSTL Allow NULL? 
52ADRNRObject number (virtual object)nvarchar100NUMC(N'0000000000')Yes*SOBJNR Allow NULL? 
53OBJNRObject numbernvarchar220CHAR(N' ')YesONR00J_OBJNR Allow NULL? 
54INTRENOInternal Real Estate Master Data Codenvarchar130CHAR(N' ')YesVVINTRENO Allow NULL? 
55PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
56STTXT_EXTStatus: Set by usernvarchar400CHAR(N' ')YesVVXSTXTEXT Allow NULL? 
57STTXT_INTStatus: Set by systemnvarchar400CHAR(N' ')YesVVXSTTXTIN Allow NULL? 
58XMETXTText for rental unitnvarchar300CHAR(N' ')YesVVXMETXT Allow NULL? 
59SKOARTCondition: Typenvarchar40NUMC(N'0000')YesTZK01VVSKOART Allow NULL? 
60BKONDCondition: amountdecimal132CURR((0))YesVVBKOND
61DGULTABCondition: effective fromnvarchar80DATS(N'00000000')YesVVDKOND Allow NULL? 
62SNUNRRental unit external usage typenvarchar40NUMC(N'0000')YesTIV01SNUNR Allow NULL? 
63XNUNRRental unit usage type (text)nvarchar300CHAR(N' ')YesVVXNUNR Allow NULL? 
64SALTNRNumber of rental unit in existing real estate systemnvarchar200CHAR(N' ')YesSALTNR Allow NULL? 
65SRAARTRoom typenvarchar20NUMC(N'00')YesTIV09SRAART Allow NULL? 
66BRAARTNumber of roomsdecimal120DEC((0))YesVVBRAARTA
67SMERKMAFixtures and Fittings Characteristicsnvarchar30NUMC(N'000')YesTIV71SMERKMA Allow NULL? 
68XMERKMACharacteristicnvarchar300CHAR(N' ')YesVVXMERKMA Allow NULL? 
69SSTOCKWFloornvarchar30NUMC(N'000')YesTIV37VVSSTOCKW Allow NULL? 
70XSTOCKKFloor (short text)nvarchar40CHAR(N' ')YesVVXSTOCKK2 Allow NULL? 
71XSTOCKWFloor (text)nvarchar150CHAR(N' ')YesVVXSTOCKW Allow NULL? 
72RLGESCHLocation on Floornvarchar20CHAR(N' ')YesTIV38RLGESCH Allow NULL? 
73XLGESCHLocation in floor (text)nvarchar150CHAR(N' ')YesVVXLGESCH Allow NULL? 
74DBEZUDate: First usagenvarchar80DATS(N'00000000')YesVVDBEZU Allow NULL? 
75SABRGApportionment unit: typenvarchar40NUMC(N'0000')YesTIV07VVSABRG2 Allow NULL? 
76DGABApportionment unit: effective fromnvarchar80DATS(N'00000000')YesVVDGAB2 Allow NULL? 
77BABREApportionment unitsdecimal62QUAN((0))YesVVBUMLEINH
78TXT04Occupancy type: short textnvarchar40CHAR(N' ')YesVVXJ_TXT04 Allow NULL? 
79TXT30Occupancy type (text)nvarchar300CHAR(N' ')YesVVXJ_TXT30 Allow NULL? 
80BELEABOccupancy type: effet.fromnvarchar80DATS(N'00000000')YesVVDBELEAB Allow NULL? 
81BELEBISOccupancy type: eff. tonvarchar80DATS(N'00000000')YesVVDBELEBIS Allow NULL? 
82DBEGEHLast access: datenvarchar80DATS(N'00000000')YesVVDBEGEH Allow NULL? 
83XBEGEHLast inspection: bynvarchar150CHAR(N' ')YesVVXBEGEH Allow NULL? 
84PERHOEIncrease: percentagedecimal102DEC((0))YesVVPERHOE2
85RPROZGRDIncrease: Reason for differencenvarchar20CHAR(N' ')YesTIV43VVRPROZGRD Allow NULL? 
86XPROZGRDIncrease: Reason for differencenvarchar150CHAR(N' ')YesVVXPROZGRD Allow NULL? 
87SMOEBLFurniture indicatorchar10CHAR(N' ')YesSMOEB Allow NULL? 
88AZIMMNumber of roomsdecimal60DEC((0))YesVVAZIMM
89AHALBZINumber of half roomsdecimal60DEC((0))YesVVAHALBZI
90XSTANDNRNumber of garage / parking spacenvarchar50CHAR(N' ')YesVVXSTANDNR Allow NULL? 
91JEIGWOHNRental Unit in Separate Ownership (COA)char10CHAR(N' ')YesVVJEIGWOHN Allow NULL? 
92ABNNRSettlement firm: numbernvarchar200CHAR(N' ')YesVVABNNR Allow NULL? 
93STECHEMSettlement firm: Evaluation groupnvarchar130CHAR(N' ')YesVVSTECHEM Allow NULL? 
94SSTCKBISFor RUs with Multiple Floors: Top Floor of RUnvarchar30NUMC(N'000')YesTIV37VVSSTCKBIS Allow NULL? 
95JVORSTEIGInput tax deduction for vacancychar10CHAR(N' ')YesJVORSTEIG Allow NULL? 
96RFAKTConversion factor for fractional share of propertynvarchar60CHAR(N' ')YesVVXFAKT Allow NULL? 
97JKONDMVCond.transfer RA: indicatorchar10CHAR(N' ')YesVVJKONDMV2 Allow NULL? 
98PKONDMVCond.transfer LO: percentdecimal52DEC((0))YesVVPKONDMV2
99DFSTRBISDate: Cash flow untilnvarchar80DATS(N'00000000')YesVVDFSTRBI2 Allow NULL? 
100JRMSCHPRTenant service charge settlement?char10CHAR(N' ')YesVVJRMSCHPR Allow NULL? 
101DHPZSAKTCH rent adj.:Date of mort.loan rate status for current rentnvarchar80DATS(N'00000000')YesVVDHPZSAK2 Allow NULL? 
102DUTBKAKTCH rnt adj.:Dte maint./oper.costs index status for new rentnvarchar80DATS(N'00000000')YesVVDUTBKAK2 Allow NULL? 
103DTEURAKTCH rnt adj.:Dte of living stndrd index status for curr.rentnvarchar80DATS(N'00000000')YesVVDTEURAK2 Allow NULL? 
104SMIETSPRepresentative list of rents assignmentnvarchar60CHAR(N' ')YesTIV20SMIETSP Allow NULL? 
105XMIETSPRepresentative list of rents: allocationnvarchar150CHAR(N' ')YesVVXMIETSP Allow NULL? 
106PZUABSPRepresentative list of rents: surcharge/reductiondecimal102DEC((0))YesVVPZUABSP2
107SLAGKLocation classnvarchar20NUMC(N'00')YesTIV22SLAGK Allow NULL? 
108XLAGKRepresentative list of rents: locat.classnvarchar300CHAR(N' ')YesVVXLAGK Allow NULL? 
109SAUSTKLFixtures and fittings categorynvarchar20NUMC(N'00')YesTIV23SAUSKL Allow NULL? 
110XAUSTKLRepresent. list of rents: Fixture/fitting categorynvarchar150CHAR(N' ')YesVVXXAUSTKL Allow NULL? 
111DWTVERMDate: Subsequent rentalnvarchar80DATS(N'00000000')YesDWTVERM Allow NULL? 
112RBELBINDOccupancy obligation keynvarchar40CHAR(N' ')YesTIV31RBELBIND Allow NULL? 
113XBELBINDOccupancy obligation: tonvarchar150CHAR(N' ')YesVVXBELBIND Allow NULL? 
114DBINDBISOccupancy obligation: untilnvarchar80DATS(N'00000000')YesVVDBINDBIS Allow NULL? 
115SBWNRReservation application number of a rental unitnvarchar70CHAR(N' ')YesVVXBWNR Allow NULL? 
116SPARTNRPartner numbernvarchar100CHAR(N' ')YesSPRT1SPARTNR Allow NULL? 
117XPARTNRName of applicant for a rental unitnvarchar350CHAR(N' ')YesVVXPARTNRB Allow NULL? 
118XNNPARTLast name of applicantnvarchar200CHAR(N' ')YesVVNNPART Allow NULL? 
119DRESABDate: Reserved fromnvarchar80DATS(N'00000000')YesDRESA Allow NULL? 
120DRESBISDate: Reserved uptonvarchar80DATS(N'00000000')YesDRESB Allow NULL? 
121UMBRAUMCubic Volumedecimal113QUAN((0))YesVVBUBRA
122SGEBTPart of Buildingnvarchar20CHAR(N' ')YesTIV12SGEBT Allow NULL? 
123XGEBTBuilding: partnvarchar150CHAR(N' ')YesVVXGEBT Allow NULL? 
124SBASTEUSwiss rent adj.: Base year for standard of living indexnvarchar40NUMC(N'0000')Yes*VVSBASTEU Allow NULL? 
125DRESTAURDate of reconstruction/extensive modernizationnvarchar80DATS(N'00000000')YesVVDRESTAUR Allow NULL? 
126TXJCDTax Jurisdictionnvarchar150CHAR(N' ')Yes*TXJCD Allow NULL? 
127BERGRPAuthorization groupnvarchar400CHAR(N' ')YesVVBERGRP Allow NULL? 
128DFLOWFIXFlows fixed uptonvarchar80DATS(N'00000000')YesVVDFLOWFIX Allow NULL? 
129KOEIGRAccount determination key for account determinationnvarchar100CHAR(N' ')Yes*VVWERTN_AD Allow NULL? 
130SPOSINMSPBase value for grouping RU in RLR groupchar10CHAR(N' ')YesVVSPOSINMSP Allow NULL? 
131PPOSINMSPPercentage value for grouping RU in RLR category groupdecimal52DEC((0))YesVVPPOSINMSP
132DFRDVONPublic funding fromnvarchar80DATS(N'00000000')YesVVDFRDVON Allow NULL? 
133DFRDBISPublic funding tonvarchar80DATS(N'00000000')YesVVDFRDBIS Allow NULL? 
134BMMVALFEAmount for each area unit for a fixtures & fittings charact.decimal132CURR((0))YesVVBMMVALUFE
135DMMGUELABValid from date of a fixture and fitting characteristicnvarchar80DATS(N'00000000')YesVVDMMGUELAB Allow NULL? 
136SIHMAModernization Measurenvarchar200CHAR(N' ')Yes*VVSIHMA Allow NULL? 
137SKOTYPCondition categorynvarchar30NUMC(N'000')Yes*SKOTYP Allow NULL? 
138SGRUNDBLand register numbernvarchar80NUMC(N'00000000')Yes*SGRUNDB Allow NULL? 
139XGBVONLand register districtnvarchar250CHAR(N' ')YesXGBVON Allow NULL? 
140PAUSFWService charge stt. apport.loss risk percentage surchargedecimal82DEC((0))YesVVPAUSFW2
141DUMMYFIELDSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
NamePrimaryUniqueTypeColumns
S406~0YesYesCLUSTEREDSMENR_06, SGENR_05, SGRNR_04, SWENR_03, GSBER_02, BUKRS_01, SPBUP, SPWOC, SPTAG, SPMON, VRSIO, SSOUR, MANDT

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