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  | VIXCAJRECCH01
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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
Real Estate Management :: Flexible Real Estate Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VIXCAJRECCH01731Adjustment Record CH01Flexible Real Estate Management
SQL:  selectupdate insert create

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

SELECT MANDT, RECCH01GUID, PROCESSGUID, INTRENO, CONDCURR, MGRBASEREF, MGRBASEDATE, MGRBASERATE, MGRADJMDATE, MGRADJMRATE, MGRADJMPERCENT, MGRADJMAMOUNT, MOCPERCENTTYPE, MOCBASEINDX, MOCBASEDATE, MOCBASEPPCINDX, MOCADJMDATE, MOCADJNBMONTH, MOCADJMPERCENT, MOCADJMPPCINDX, MOCADJMAMOUNT, PPCBASESERIES, PPCBASEYEAR, PPCBASEDATE, PPCBASEINDX, PPCPRCTPASS, PPCADJMDATE, PPCADJMINDX, PPCADJMPERCENT, PPCADJMAMOUNT, RELADJMPERCENT, RELADJMAMOUNT, ACCOMCONDTYPE, ACCOMBASEUPRICE, ACCOMVALIDFROM, YIELDCONDTYPE, YIELDBASEUPRICE, YIELDVALIDFROM, WOIINCONDTYPE, WOIINBASEUPRICE, WOIINVALIDFROM, ABSREASCOND, ABSREASAMOUNT, ABSREASPERCENT, ABSADJOPTION, ABSADJMPERCENT, ABSADJMAMOUNT, WOIREASCOND, WOIREASAMOUNT, WOIREASPERCENT, WOIADJMPERCENT, WOIADJMAMOUNT, ADJCONDABS, ACCOMADJMUPRICE, YIELDADJMUPRICE, WOIINADJMUPRICE, PARMRELLOW, PARMRELLOWPRIO1, PARMRELLOWPRIO2, RESVAMOUNTPRIO1, BASEADJMPRIO1, ADJMPRIO1, RESVAMOUNTPRIO2, ADJMPRIO2, FREEVALUEABSINC, FREEVALUEPERCENT, FREEADJMPERCENT, FREEADJMAMOUNT, FREEADJMTXT, ADJMTXTDESCRIPT, ADJMTXTMOMENT, ADJMTXTREASON, ADJMTXTGUID FROM VIXCAJRECCH01
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2RECCH01GUIDGeneric Key of Adjustment Record for CH01varbinary160
3PROCESSGUIDGeneric Key of Processvarbinary160
4INTRENOInternal Key of Real Estate Objectnvarchar130 Allow NULL? 
5CONDCURRCurrency of condition itemnvarchar50 Allow NULL? 
6MGRBASEREFBase Value: Reference Interest Ratenvarchar100 Allow NULL? 
7MGRBASEDATEBase Date for Reference Interest Ratenvarchar80 Allow NULL? 
8MGRBASERATEReference Interest Rate for Adjustmentdecimal107
9MGRADJMDATEAdjustment Date of Reference Interest Ratenvarchar80 Allow NULL? 
10MGRADJMRATENew Reference Interest Ratedecimal107
11MGRADJMPERCENTPercentage Rate of Adjustment of Reference Interest Ratedecimal52
12MGRADJMAMOUNTAbsolute Value of Adjustment of Reference Interest Ratedecimal152
13MOCPERCENTTYPEMaintenance and Operating Costs Type of Percentagechar10 Allow NULL? 
14MOCBASEINDXBase Value: Maintenance and Operating Costs as Percentagedecimal74
15MOCBASEDATEBase Date for Maintenance and Operating Costsnvarchar80 Allow NULL? 
16MOCBASEPPCINDXMaintenance and Operating Costs as per LKP: Base Index Leveldecimal107
17MOCADJMDATEAdjustment Date for Maintenance and Operating Costsnvarchar80 Allow NULL? 
18MOCADJNBMONTHNumber of Monthssmallint50
19MOCADJMPERCENTPercentage of Adjustment from Maint. and Operating Costsdecimal52
20MOCADJMPPCINDXMaintenance and Operating Costs from LKP: New Index Leveldecimal107
21MOCADJMAMOUNTAbsolute Value of Maintenance and Operating Costs Adjustmentdecimal152
22PPCBASESERIESBase Value: Index Series for Purchasing Power Protectionnvarchar50 Allow NULL? 
23PPCBASEYEARBase Year for Purchasing Power Protectionnvarchar40 Allow NULL? 
24PPCBASEDATEBase Date, Purchasing Power Protectionnvarchar80 Allow NULL? 
25PPCBASEINDXBase Index Level: Purchasing Power Protectiondecimal107
26PPCPRCTPASSPercentage Passed on of Adj. Based on Purchasing Power Prot.decimal52
27PPCADJMDATEAdjustment Date for Purchasing Power Protectionnvarchar80 Allow NULL? 
28PPCADJMINDXNew Index Level for Purchasing Power Protectiondecimal107
29PPCADJMPERCENTPercentage of Adjustment from Purchasing Power Protectiondecimal52
30PPCADJMAMOUNTAbsolute Val. of Adjustment from Purchasing Power Protectiondecimal152
31RELADJMPERCENTEffective Adjustment from Relative Factors: Percentagedecimal52
32RELADJMAMOUNTEffective Adjustment from Relative Factors: Absolute Valuedecimal152
33ACCOMCONDTYPEAbsolute Factors, Condition Categorynvarchar40 Allow NULL? 
34ACCOMBASEUPRICEAbsolute Factors, Currency Amount (Gross) Condition Itemdecimal196
35ACCOMVALIDFROMDate from when condition is validnvarchar80 Allow NULL? 
36YIELDCONDTYPEAbsolute Factors, Condition Categorynvarchar40 Allow NULL? 
37YIELDBASEUPRICEAbsolute Factors, Currency Amount (Gross) Condition Itemdecimal196
38YIELDVALIDFROMDate from when condition is validnvarchar80 Allow NULL? 
39WOIINCONDTYPEAbsolute Factors, Condition Categorynvarchar40 Allow NULL? 
40WOIINBASEUPRICEAbsolute Factors, Currency Amount (Gross) Condition Itemdecimal196
41WOIINVALIDFROMDate from when condition is validnvarchar80 Allow NULL? 
42ABSREASCONDAbsolute Factors, Adjustment Reason for Condition Categorychar10 Allow NULL? 
43ABSREASAMOUNTAbsolute Method, Adjustment by an Absolute Amountdecimal152
44ABSREASPERCENTAbsolute Factors, Adjustment Reason as Percentagedecimal52
45ABSADJOPTIONOption for an Adjustment Based on Absolute Factorschar10 Allow NULL? 
46ABSADJMPERCENTAbsolute Factors, Percentage Rate of Adjustmentdecimal52
47ABSADJMAMOUNTAbsolute Factors, Absolute Value of Adjustmentdecimal152
48WOIREASCONDAdded Benefits, Adjustment Reason Condition Typechar10 Allow NULL? 
49WOIREASAMOUNTAdded Benefits, Adjustment Reason as Absolute Valuedecimal152
50WOIREASPERCENTAdded Benefits, Adjustment Reason as Percentagedecimal52
51WOIADJMPERCENTAdded Benefits, Percentage of Adjustmentdecimal52
52WOIADJMAMOUNTAdded Benefits, Absolute Value of Adjustmentdecimal152
53ADJCONDABSAdj.Parameter REL: Adj. Condition Amount for Absolute Methodchar10 Allow NULL? 
54ACCOMADJMUPRICEAbsolute Factors, Currency Amount (Adjust.) Condition Itemdecimal196
55YIELDADJMUPRICEAbsolute Factors, Currency Amount (Adjust.) Condition Itemdecimal196
56WOIINADJMUPRICEAbsolute Factors, Currency Amount (Adjust.) Condition Itemdecimal196
57PARMRELLOWHandling of Reserve: Option When Net Rent Reducedchar10 Allow NULL? 
58PARMRELLOWPRIO1Handling of Reserve: Priority When Reducing Net Rentchar10 Allow NULL? 
59PARMRELLOWPRIO2Handling of Reserve: Priority When Reducing Net Rentchar10 Allow NULL? 
60RESVAMOUNTPRIO1Reserve, Absolute Value Based on Absolute Factorsdecimal152
61BASEADJMPRIO1Effective Adjustment from Relative Factors: Absolute Valuedecimal152
62ADJMPRIO1Effective Adjustment from Relative Factors: Absolute Valuedecimal152
63RESVAMOUNTPRIO2Reserve, Absolute Value Based on Absolute Factorsdecimal152
64ADJMPRIO2Effective Adjustment from Relative Factors: Absolute Valuedecimal152
65FREEVALUEABSINCAbsolute Increase of the Unit Pricedecimal196
66FREEVALUEPERCENTRelative Increase of Unit Pricedecimal72
67FREEADJMPERCENTEffective Adjustment from Custom Adjustment: Percentagedecimal52
68FREEADJMAMOUNTEffective Adjustment from Custom Adjustmt: Absolute Valuedecimal152
69FREEADJMTXTExplanatory Text for Custom Adjustmentnvarchar700 Allow NULL? 
70ADJMTXTDESCRIPTExplanatory Text 'Description of Change'nvarchar700 Allow NULL? 
71ADJMTXTMOMENTExplanatory Text 'Time at Which Took Effect'nvarchar80 Allow NULL? 
72ADJMTXTREASONExplanatory Text 'Reason for Change'nvarchar700 Allow NULL? 
73ADJMTXTGUIDGUID (RAW16)varbinary160
NamePrimaryUniqueTypeColumns
VIXCAJRECCH01~0YesYesCLUSTEREDMANDT, RECCH01GUID

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