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  | VIOROO
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 :: Offer and Rental Request
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VIOROO936Offered ObjectOffer and Rental Request
SQL:  selectupdate insert create

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

SELECT MANDT, INTRENO, OOID, OBJNR, CREATIONTYPE, RERF, DERF, TERF, REHER, RBEAR, DBEAR, TBEAR, RBHER, RESPONSIBLE, USEREXCLUSIVE, AUTHGRP, OOBEG, OOEND, MEAS, USAGETYPE, RSOBJTYPE, RSAREA, ACQUISTYPE, XOO, OOIDEXT, OBJTYPEREF, OBJNRREF, OODATAFROM, OODATATO, OORESFROM, OORESTO, BUKRS, BENO, BUNO, PRNO, RONO, OFID, CDVALUE01, CDCURR01, CDVALUE02, CDCURR02, CDVALUE03, CDCURR03, CDVALUE04, CDCURR04, MSVALUE01, MSUNIT01, MSVALUE02, MSUNIT02, MSVALUE03, MSUNIT03, MSVALUE04, MSUNIT04, FLOOR, SSTDORT, SLAGEWE, SOBJLAGE, TRANSPCONN, BUILDYEAR, RRCHARACTSTR, COUNTRY, REGION, POST_CODE1, CITY1, CITY2, STREET, HOUSE_NUM1, NEIGHBORH1, NEIGHBORH2, NEIGHBORH3, AECNEEDED, AECCLASSSTR, OBJNRCN, ACCDETKEY, RESPOBJNRDEF, RESPOBJNR1, RESPOBJNR2, RESPOBJNR3, RESPOBJNR4, PRICECODE1, PRICECODE2, PRICECODE3, PRICECODE4, LOCKEDFROM, LOCKEDTO, LOCKREASON, XLOCKREASONEXT, BILLEDTO, NTPER, NTREQUESTON, BILLFROM, RSBUKRS, RESPOBJNRINV FROM VIOROO
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2INTRENOInternal Key of Real Estate Objectnvarchar130CHAR(N' ')NoRECAINTRENO Allow NULL? 
3OOIDOffered Object Numbernvarchar200CHAR(N' ')YesREOROOID Allow NULL? 
4OBJNRObject Numbernvarchar220CHAR(N' ')Yes*RECAOBJNR Allow NULL? 
5CREATIONTYPEHow the Object Was Createdchar10CHAR(N' ')YesRECACREATIONTYPE Allow NULL? 
6RERFEntered bynvarchar120CHAR(N' ')YesRERF Allow NULL? 
7DERFFirst Entered onnvarchar80DATS(N'00000000')YesDERF Allow NULL? 
8TERFTime of Initial Entrynvarchar60TIMS(N'000000')YesTERF Allow NULL? 
9REHERSource of initial entrynvarchar100CHAR(N' ')YesREHER Allow NULL? 
10RBEAREmployee IDnvarchar120CHAR(N' ')YesRBEAR Allow NULL? 
11DBEARLast Edited onnvarchar80DATS(N'00000000')YesDBEAR Allow NULL? 
12TBEARLast Edited atnvarchar60TIMS(N'000000')YesTBEAR Allow NULL? 
13RBHEREditing Sourcenvarchar100CHAR(N' ')YesRBHER Allow NULL? 
14RESPONSIBLEPerson Responsiblenvarchar120CHAR(N' ')YesUSR02RECARESPONSIBLE Allow NULL? 
15USEREXCLUSIVEUser with Exclusive Change Authorizationnvarchar120CHAR(N' ')YesUSR02RECAUSEREXCLUSIVE Allow NULL? 
16AUTHGRPAuthorization Groupnvarchar400CHAR(N' ')YesRECAAUTHGRP Allow NULL? 
17OOBEGAvailable Fromnvarchar80DATS(N'00000000')YesREOROOBEG Allow NULL? 
18OOENDAvailable Tonvarchar80DATS(N'00000000')YesREOROOEND Allow NULL? 
19MEASMeasurement Typenvarchar40CHAR(N' ')YesTIVBDMEASREBDMEAS Allow NULL? 
20USAGETYPEUsage Type of Rental Objectnvarchar40NUMC(N'0000')YesTIV01REBDUSAGETYPE Allow NULL? 
21RSOBJTYPEReservation Object Typenvarchar20CHAR(N' ')YesTIVORRSOBJTYPEREORRSOBJTYPE Allow NULL? 
22RSAREAReservation Areanvarchar100CHAR(N' ')YesTIVORRSAREAREORRSAREA Allow NULL? 
23ACQUISTYPELease/Buynvarchar20CHAR(N' ')YesREORACQUISTYPE Allow NULL? 
24XOOText for Offered Objectnvarchar2550CHAR(N' ')YesREORXOO Allow NULL? 
25OOIDEXTExternal ID of Reservation Objectnvarchar450CHAR(N' ')YesREOROOIDEXT Allow NULL? 
26OBJTYPEREFObject Typenvarchar20CHAR(N' ')Yes*RECAOBJTYPE Allow NULL? 
27OBJNRREFObject Numbernvarchar220CHAR(N' ')Yes*RECAOBJNR Allow NULL? 
28OODATAFROMOffer Data Valid Fromnvarchar80DATS(N'00000000')YesREOROODATAFROM Allow NULL? 
29OODATATOOffer Data Valid Tonvarchar80DATS(N'00000000')YesREOROODATATO Allow NULL? 
30OORESFROMOffer Reserved Fromnvarchar80DATS(N'00000000')YesREOROORESFROM Allow NULL? 
31OORESTOOffered Object Reserved Tonvarchar80DATS(N'00000000')YesREOROORESTO Allow NULL? 
32BUKRSCompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
33BENOSite Numbernvarchar80CHAR(N' ')Yes*REBDBENO Allow NULL? 
34BUNONumber of Buildingnvarchar80CHAR(N' ')YesREBDBUNO Allow NULL? 
35PRNONumber of Landnvarchar80CHAR(N' ')YesREBDPRNO Allow NULL? 
36RONONumber of Rental Objectnvarchar80CHAR(N' ')YesREBDRONO Allow NULL? 
37OFIDContract Offer Numbernvarchar130CHAR(N' ')YesREOROFID Allow NULL? 
38CDVALUE01Condition Amountdecimal152CURR((0))YesREORCDVALUE
39CDCURR01Currency of condition itemnvarchar50CUKY(N' ')Yes*RECDCONDCURR Allow NULL? 
40CDVALUE02Condition Amountdecimal152CURR((0))YesREORCDVALUE
41CDCURR02Currency of condition itemnvarchar50CUKY(N' ')Yes*RECDCONDCURR Allow NULL? 
42CDVALUE03Condition Amountdecimal152CURR((0))YesREORCDVALUE
43CDCURR03Currency of condition itemnvarchar50CUKY(N' ')Yes*RECDCONDCURR Allow NULL? 
44CDVALUE04Condition Amountdecimal152CURR((0))YesREORCDVALUE
45CDCURR04Currency of condition itemnvarchar50CUKY(N' ')Yes*RECDCONDCURR Allow NULL? 
46MSVALUE01Measurement Amountdecimal174QUAN((0))YesREORMSVALUE
47MSUNIT01Measurement Unitnvarchar30UNIT(N' ')Yes*REBDMEASUNIT Allow NULL? 
48MSVALUE02Measurement Amountdecimal174QUAN((0))YesREORMSVALUE
49MSUNIT02Measurement Unitnvarchar30UNIT(N' ')Yes*REBDMEASUNIT Allow NULL? 
50MSVALUE03Measurement Amountdecimal174QUAN((0))YesREORMSVALUE
51MSUNIT03Measurement Unitnvarchar30UNIT(N' ')Yes*REBDMEASUNIT Allow NULL? 
52MSVALUE04Measurement Amountdecimal174QUAN((0))YesREORMSVALUE
53MSUNIT04Measurement Unitnvarchar30UNIT(N' ')Yes*REBDMEASUNIT Allow NULL? 
54FLOORFloornvarchar20CHAR(N' ')YesREORRRFLOOR Allow NULL? 
55SSTDORTRegional locationnvarchar100CHAR(N' ')YesTIV35VVSSTDORT Allow NULL? 
56SLAGEWEBusiness entity location numbernvarchar40NUMC(N'0000')YesTIV10SLAGEWE Allow NULL? 
57SOBJLAGEIndicator: District Location of Objectnvarchar20NUMC(N'00')YesTIV45RESOBJLAGE Allow NULL? 
58TRANSPCONNTransport Connections of Business Entitychar10CHAR(N' ')YesTIV44SVERKEHR Allow NULL? 
59BUILDYEARConstYrnvarchar80DATS(N'00000000')YesVVYBAUJAHR Allow NULL? 
60RRCHARACTSTRFixtures and Fittings Characteristic Stringnvarchar800CHAR(N' ')YesREORRRCHARACTSTR Allow NULL? 
61COUNTRYCountry Keynvarchar30CHAR(N' ')YesT005LAND1 Allow NULL? 
62REGIONRegion (State, Province, County)nvarchar30CHAR(N' ')YesT005SREGIO Allow NULL? 
63POST_CODE1City postal codenvarchar100CHAR(N' ')YesAD_PSTCD1 Allow NULL? 
64CITY1Citynvarchar400CHAR(N' ')YesAD_CITY1 Allow NULL? 
65CITY2Districtnvarchar400CHAR(N' ')YesAD_CITY2 Allow NULL? 
66STREETStreetnvarchar600CHAR(N' ')YesAD_STREET Allow NULL? 
67HOUSE_NUM1House Numbernvarchar100CHAR(N' ')YesAD_HSNM1 Allow NULL? 
68NEIGHBORH1Neighborhoodnvarchar300CHAR(N' ')YesREBDNEIGHBORHOOD Allow NULL? 
69NEIGHBORH2Neighborhoodnvarchar300CHAR(N' ')YesREBDNEIGHBORHOOD Allow NULL? 
70NEIGHBORH3Neighborhoodnvarchar300CHAR(N' ')YesREBDNEIGHBORHOOD Allow NULL? 
71AECNEEDEDAccommodation Entitlement Certificate Requiredchar10CHAR(N' ')YesREORAECNEEDED Allow NULL? 
72AECCLASSSTRAEC Level Stringnvarchar600CHAR(N' ')YesREORAECCLASSSTR Allow NULL? 
73OBJNRCNOutline Agreementnvarchar220CHAR(N' ')Yes*REOROBJNRCN Allow NULL? 
74ACCDETKEYAccount Determination Valuenvarchar100CHAR(N' ')YesTIVRADETKEYRERAACCDETKEY Allow NULL? 
75RESPOBJNRDEFResponsible Account Assignment Object (Default)nvarchar220CHAR(N' ')Yes*REORRESPOBJNRDEF Allow NULL? 
76RESPOBJNR1Responsible Account Assignment Objectnvarchar220CHAR(N' ')Yes*REORRESPOBJNR Allow NULL? 
77RESPOBJNR2Responsible Account Assignment Objectnvarchar220CHAR(N' ')Yes*REORRESPOBJNR Allow NULL? 
78RESPOBJNR3Responsible Account Assignment Objectnvarchar220CHAR(N' ')Yes*REORRESPOBJNR Allow NULL? 
79RESPOBJNR4Responsible Account Assignment Objectnvarchar220CHAR(N' ')Yes*REORRESPOBJNR Allow NULL? 
80PRICECODE1Price Codenvarchar100CHAR(N' ')YesTIVORPRICECODEREORPRICECODE Allow NULL? 
81PRICECODE2Price Codenvarchar100CHAR(N' ')YesTIVORPRICECODEREORPRICECODE Allow NULL? 
82PRICECODE3Price Codenvarchar100CHAR(N' ')YesTIVORPRICECODEREORPRICECODE Allow NULL? 
83PRICECODE4Price Codenvarchar100CHAR(N' ')YesTIVORPRICECODEREORPRICECODE Allow NULL? 
84LOCKEDFROMStart of Lock Periodnvarchar80DATS(N'00000000')YesREORLOCKEDFROM Allow NULL? 
85LOCKEDTOEnd of Lock Periodnvarchar80DATS(N'00000000')YesREORLOCKEDTO Allow NULL? 
86LOCKREASONLock Reasonnvarchar40CHAR(N' ')YesTIVORLOCKRSREORLOCKREASON Allow NULL? 
87XLOCKREASONEXTOther Lock Reasonnvarchar1000CHAR(N' ')YesREORXLOCKREASONEXT Allow NULL? 
88BILLEDTODate Up to Which Postings Were Madenvarchar80DATS(N'00000000')YesREORBILLEDTO Allow NULL? 
89NTPERContract Notice Pernvarchar80DATS(N'00000000')YesRECNNTPER Allow NULL? 
90NTREQUESTONTenant's notice request datenvarchar80DATS(N'00000000')YesRECNNTREQUESTON Allow NULL? 
91BILLFROMFirst Posting Fromnvarchar80DATS(N'00000000')YesREORBILLFROM Allow NULL? 
92RSBUKRSCompany Code (Reservation - Post with Invoice)nvarchar40CHAR(N' ')Yes*REORBUKRS Allow NULL? 
93RESPOBJNRINVResponsible Account Assignment Object (Billing)nvarchar220CHAR(N' ')Yes*REORRESPOBJNRINV Allow NULL? 
NamePrimaryUniqueTypeColumns
VIOROO~0YesYesCLUSTEREDMANDT, INTRENO
VIOROO~001NoNoNONCLUSTEREDMANDT, OOID
VIOROO~002NoNoNONCLUSTEREDMANDT, OBJNR
VIOROO~003NoNoNONCLUSTEREDMANDT, OBJNRREF
VIOROO~004NoNoNONCLUSTEREDMANDT, OOIDEXT
VIOROO~005NoNoNONCLUSTEREDMANDT, NEIGHBORH1, NEIGHBORH2, NEIGHBORH3

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