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  | VIMI16
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.0VIMI161051RE: Records of a Rent Adjustment RunReal Estate Management
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, SMIVE, SWENR, SMENR, SKOART, DGUELAB, DANPASS, SANPNR, XIDENT, SWHRKOND, BKONDALT, BANPASS, BAUTANP, BGESZUL, BVGLAVG, BINDPKT, BINDALT, BMSPVON, BMSPBIS, BMSPGRD, BMSPZUA, JZUSCHLAG, JZUSTIM, DZUSTIM, DZUBIS, DSTORNO, DAKTIV, DGUELBI, BANPBM, BMZUGBM, RANTWF, IMKEY, PERHREL, BERHABS, BERHGES, BNEUMIET, SFUTANP, FQMFLART, FEINS, BPKTSUM, PERHPROZ, PERHHPZS, PERHUTBK, PERHTEUR, PERHGES, SANPME, DHPZS, DUTBK, DTEUR, DHPZSALT, DUTBKALT, DTEURALT, BRDBRTZZ, SBSANPCH, BRDBRTKD, SSTDORT, INTRENO, MFACH, SANPSTAF, SIHMA, JCHBASMOD, JCHBASBMR, BCHBASMOD, BMSPBAS, BNEUABS, NDOCCNT, CURR_GS, AREA_GS, SMIETSP, SBAUAKL, SLAGEKL, SGROEKL, SAUSTKL, DBAUALT, JAREA, BKONDALTFE, SKOPO, SCOMMIT, SREJECT, DREJECT, NDUNLEV, DLASTDC, DADJPRN, BANPASSFE, BAUTANPFE, BVGLAVGGS, BGESZULGS, SINDART_OLD, YBASISJ_OLD, BINDPKT_OLD, BINDPKT1_OLD, BPKTERH_OLD, PPKTERH_OLD, SINDART_NEW, YBASISJ_NEW, BINDPKT_NEW, BINDPKT1_NEW, BPKTERH_NEW, PPKTERH_NEW, AMMRHY, ATTRHY, JBMONAT, JADJRHY, JNULLKON FROM VIMI16
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
3SMIVELease-Out Numbernvarchar130CHAR(N' ')NoSMIVE Allow NULL? 
4SWENRSite Numbernvarchar80CHAR(N' ')NoVIOB01SWENR Allow NULL? 
5SMENRNumber of Rental Unitnvarchar80CHAR(N' ')NoVIMI01SMENR Allow NULL? 
6SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40NUMC(N'0000')NoTZK01SKOART Allow NULL? 
7DGUELABDate when the rent adjustment becomes validnvarchar80DATS(N'00000000')NoDGUELAB Allow NULL? 
8DANPASSRental Adjustment Date Planned Fornvarchar80DATS(N'00000000')NoDANPASS Allow NULL? 
9SANPNRRent Adjustment Methodnvarchar30NUMC(N'000')NoTIV11SANPNR Allow NULL? 
10XIDENTIdentification of adjustment runnvarchar160CHAR(N' ')NoXIDENT1 Allow NULL? 
11SWHRKONDCurrency of Condition Itemnvarchar50CUKY(N' ')Yes*SWHRKOND Allow NULL? 
12BKONDALTPrevious condition amountdecimal132CURR((0))YesBKONDALT
13BANPASSNew condition amount (total)decimal132CURR((0))YesBANPASS
14BAUTANPNew Total Condition Amount (Original)decimal132CURR((0))YesBAUTANP
15BGESZULNew legally permitted amount per area unitdecimal132CURR((0))YesBGESZUL
16BVGLAVGAverage rent per area unitdecimal132CURR((0))YesBVGLAVG
17BINDPKTIndex marker status at last rent adjustmentdecimal83DEC((0))YesBINDPKT
18BINDALTPrevious index marker (from VIMI06)decimal83DEC((0))YesBINDALT
19BMSPVONLower limit for rent per area unit acc. to rep.list of rentsdecimal112CURR((0))YesBBETRV
20BMSPBISUpper limit for rent per area unit acc. to rep.list rentsdecimal112CURR((0))YesBBETRB
21BMSPGRDMean value of rent per area unit acc. to rep.list of rentsdecimal112CURR((0))YesBGRBTR
22BMSPZUARent adj.acc.to rep.rent list: Total surch./reduct./tot.pntsdecimal132CURR((0))YesBMSPZUA
23JZUSCHLAGSurcharge contained in new basic rentchar10CHAR(N' ')YesJZUSCHLAG Allow NULL? 
24JZUSTIMApproval indicatorchar10CHAR(N' ')YesJZUSTIM Allow NULL? 
25DZUSTIMApproval date of rent adjustmentnvarchar80DATS(N'00000000')YesDZUSTIM Allow NULL? 
26DZUBISDate up to which approval has to be givennvarchar80DATS(N'00000000')YesDZUBIS Allow NULL? 
27DSTORNOReversal date of rent adjustmentnvarchar80DATS(N'00000000')YesDSTORNO Allow NULL? 
28DAKTIVActivation date of rental adjustmentnvarchar80DATS(N'00000000')YesVVDAKTIV Allow NULL? 
29DGUELBIDate when index markers are valid for this rent adjustmentnvarchar80DATS(N'00000000')YesVVDINDPKT Allow NULL? 
30BANPBMTotal pro rata modernization costs for the rental unitdecimal132CURR((0))YesVVBANPBM
31BMZUGBMMonthly surcharge planned in acc. with German tenancy lawdecimal132CURR((0))YesVVBMZUGBM
32RANTWFApportionment factor calculation unitsdecimal82DEC((0))YesVVRANTWF
33IMKEYInternal Key for Real Estate Objectnvarchar80CHAR(N' ')YesIMKEY Allow NULL? 
34PERHRELRelative increase in amount (in percentage)decimal52DEC((0))YesPERHREL
35BERHABSIncrease amount per area unitdecimal132CURR((0))YesBERHABS
36BERHGESIncrease amount in full (not referring to the area)decimal132CURR((0))YesVVBERHGES
37BNEUMIETTotal new amount (not relative to the area)decimal132CURR((0))YesVVBNEUGES
38SFUTANPSubsequent adjustment ? (No, initial adj., subsequent adj.)char10CHAR(N' ')YesVVSFUTANP Allow NULL? 
39FQMFLARTArea of area typedecimal144QUAN((0))YesVVBFLART
40FEINSArea unitnvarchar30UNIT(N' ')YesT006FEINS Allow NULL? 
41BPKTSUMTotal number of points for feature class or objectdecimal72DEC((0))YesVVBPKTSUM
42PERHPROZPercentage rate of calculated increase to be passed ondecimal52DEC((0))YesVVPERWEIT
43PERHHPZSPercent.increase on the basis of a mortg.rate loan changedecimal63DEC((0))YesVVPERHHPZS
44PERHUTBKPercent.incr. on basis of maintenance/operating costs changedecimal63DEC((0))YesVVPERHUTBK
45PERHTEURPercent.incr.on basis of change in standard of living indexdecimal63DEC((0))YesVVPERHTEUR
46PERHGESPercent increase on basis of all relative/an absolute factordecimal63DEC((0))YesVVPERHGES
47SANPMESpecifies Adjustment Object (Only LO/Only RU/both)char10CHAR(N' ')YesVVSANPME Allow NULL? 
48DHPZSCH rent adj.:Date of mortgage rate loan status for new rentnvarchar80DATS(N'00000000')YesVVDHPZS Allow NULL? 
49DUTBKCH rnt adj.:Dte maint./oper.csts index status for new rentnvarchar80DATS(N'00000000')YesVVDUTBK Allow NULL? 
50DTEURCH rent adj.:Date of standard of living status for new rentnvarchar80DATS(N'00000000')YesVVDTEUR Allow NULL? 
51DHPZSALTCH rent adj.:Date of mort.loan rate status for current rentnvarchar80DATS(N'00000000')YesVVDHPZSAKT Allow NULL? 
52DUTBKALTCH rnt adj.:Dte maint./oper.costs index status for new rentnvarchar80DATS(N'00000000')YesVVDUTBKAKT Allow NULL? 
53DTEURALTCH rnt adj.:Dte of living stndrd index status for curr.rentnvarchar80DATS(N'00000000')YesVVDTEURAKT Allow NULL? 
54BRDBRTZZCH rent adj: Actual gross yield earneddecimal107DEC((0))YesVVBRDBRTZZ
55SBSANPCHCH rent adjustment: Adjustment basisnvarchar20NUMC(N'00')YesVVSBSANPCH Allow NULL? 
56BRDBRTKDMarginal Gross Yielddecimal107DEC((0))YesVVBRDBRTKD
57SSTDORTRegional locationnvarchar100CHAR(N' ')YesTIV35VVSSTDORT Allow NULL? 
58INTRENOInternal Real Estate Master Data Codenvarchar130CHAR(N' ')YesVVINTRENO Allow NULL? 
59MFACHRent table fieldnvarchar100CHAR(N' ')YesVVMFACH Allow NULL? 
60SANPSTAFScope of adjustment (conditions, sales grading, both)char10CHAR(N' ')YesVVSANPSTAF Allow NULL? 
61SIHMAModernization Measurenvarchar200CHAR(N' ')Yes*VVSIHMA Allow NULL? 
62JCHBASMODCH rent adj: Adj. on basis overhaul/appr.surch. investmentchar10CHAR(N' ')YesVVCHBASMOD Allow NULL? 
63JCHBASBMRRent adj. CH: Adj. on basis reserves from modernizationschar10CHAR(N' ')YesVVCHBASBMR Allow NULL? 
64BCHBASMODActual total costs of modernizationdecimal132CURR((0))YesVVBGESBMI
65BMSPBASBase rent per area unit acc. to rep.list of rentsdecimal112CURR((0))YesVVBMSPBAS
66BNEUABSNew amount per area unitdecimal132CURR((0))YesVVBNEUFE
67NDOCCNTNumber of printed letters for an adjustmentnvarchar30NUMC(N'000')YesVVNDOCCNT Allow NULL? 
68CURR_GSTotal amount as basis for adjustment without roundingsdecimal132CURR((0))YesVVCURR_GS
69AREA_GSTotal area as base for adjustment without rounding errorsdecimal144QUAN((0))YesVVAREA_GS
70SMIETSPRepresentative list of rents assignmentnvarchar60CHAR(N' ')YesTIV20SMIETSP Allow NULL? 
71SBAUAKLBuilding age categorynvarchar20NUMC(N'00')YesTIV21SBAUALT Allow NULL? 
72SLAGEKLLocation classnvarchar20NUMC(N'00')YesTIV22SLAGK Allow NULL? 
73SGROEKLSize classnvarchar30NUMC(N'000')YesTIV19SGROEKL Allow NULL? 
74SAUSTKLFixtures and fittings categorynvarchar20NUMC(N'00')YesTIV23SAUSKL Allow NULL? 
75DBAUALTBuilding age for rental unit relevant for rep.list of rentsnvarchar80DATS(N'00000000')YesVVDBAUALT Allow NULL? 
76JAREARental on basis of area?char10CHAR(N' ')YesVVJAREA Allow NULL? 
77BKONDALTFECurrency amount per area unitdecimal132CURR((0))YesBKONDQM
78SKOPODetailed identification for condition itemsnvarchar20NUMC(N'00')YesTZK07VVSKOPO Allow NULL? 
79SCOMMITReservation for approval for a rent adjustmentnvarchar20NUMC(N'00')YesTIVM4VVSRACOMMIT Allow NULL? 
80SREJECTReason for rejecting a rent adjustmentnvarchar20NUMC(N'00')YesTIVM5VVSRAREJECT Allow NULL? 
81DREJECTRejection date of a rent adjustmentnvarchar80DATS(N'00000000')YesVVDRAREJECT Allow NULL? 
82NDUNLEVReminder level for reminders for rnt adjs not subj.to appr.nvarchar20NUMC(N'00')YesVVRADUNLEVEL Allow NULL? 
83DLASTDCDate of last dunning due to missing tenant approvalnvarchar80DATS(N'00000000')YesVVRADLASTDUN Allow NULL? 
84DADJPRNLetter date of adjustment correspondencenvarchar80DATS(N'00000000')YesVVDADJPRN Allow NULL? 
85BANPASSFENew condition amount for each area unit (changeable)decimal132CURR((0))YesVVBANPASSFE
86BAUTANPFENew condition amount for each area unit (original)decimal132CURR((0))YesVVBAUTANPFE
87BVGLAVGGSAverage total rentdecimal132CURR((0))YesVVBAVGGSMT
88BGESZULGSLegally permitted total amountdecimal132CURR((0))YesVVBGESZULGS
89SINDART_OLDIndex series for replacement valuesnvarchar50CHAR(N' ')Yes*WBIND Allow NULL? 
90YBASISJ_OLDIndex series base yearnvarchar40NUMC(N'0000')Yes*BASJHR Allow NULL? 
91BINDPKT_OLDIndex marker status at last rent adjustmentdecimal83DEC((0))YesBINDPKT
92BINDPKT1_OLDIndex status as base for first rental adjustmentdecimal83DEC((0))YesBINDPKT1
93BPKTERH_OLDAbsolute change of index points for rent adjustmentdecimal62DEC((0))YesVVBPKTERH
94PPKTERH_OLDMinimum change of index series change in percentage termsdecimal52DEC((0))YesPPKTERH
95SINDART_NEWIndex series for replacement valuesnvarchar50CHAR(N' ')Yes*WBIND Allow NULL? 
96YBASISJ_NEWIndex series base yearnvarchar40NUMC(N'0000')Yes*BASJHR Allow NULL? 
97BINDPKT_NEWIndex marker status at last rent adjustmentdecimal83DEC((0))YesBINDPKT
98BINDPKT1_NEWIndex status as base for first rental adjustmentdecimal83DEC((0))YesBINDPKT1
99BPKTERH_NEWAbsolute change of index points for rent adjustmentdecimal62DEC((0))YesVVBPKTERH
100PPKTERH_NEWMinimum change of index series change in percentage termsdecimal52DEC((0))YesPPKTERH
101AMMRHYFrequency in monthsnvarchar30NUMC(N'000')YesAMMRHY Allow NULL? 
102ATTRHYFrequency in Daysnvarchar30NUMC(N'000')YesATTRHY Allow NULL? 
103JBMONATIndicator for calculating amount per monthchar10CHAR(N' ')YesJBMONAT Allow NULL? 
104JADJRHYRent Adjustment Dependent on Condition Frequencychar10CHAR(N' ')YesJADJRHY Allow NULL? 
105JNULLKONCondition Formchar10CHAR(N' ')YesJNULLKON Allow NULL? 
NamePrimaryUniqueTypeColumns
VIMI16~0YesYesCLUSTEREDMANDT, BUKRS, SMIVE, SWENR, SMENR, SKOART, DGUELAB, DANPASS, SANPNR, XIDENT

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