VIXCAJRECCH01 SAP (Adjustment Record CH01) Table details
Dictionary Type: Table
Description: Adjustment Record CH01
Description: Adjustment Record CH01
ABAP Code to SELECT data from VIXCAJRECCH01
Related tables to VIXCAJRECCH01
Access table VIXCAJRECCH01
Related tables to VIXCAJRECCH01
Access table VIXCAJRECCH01
Table field list including key, data, relationships and ABAP select examples
VIXCAJRECCH01 is a standard SAP Table which is used to store Adjustment Record CH01 data and is available within R/3 SAP systems depending on the version and release level.
The VIXCAJRECCH01 table consists of various fields, each holding specific information or linking keys about Adjustment Record CH01 data available in SAP. These include RECCH01GUID (Generic Key of Adjustment Record for CH01), PROCESSGUID (Generic Key of Process), INTRENO (Internal Key of Real Estate Object), CONDCURR (Currency of condition item).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VIXCAJRECCH01 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
RECCH01GUID | Generic Key of Adjustment Record for CH01 | REXCAJRECCH01GUID | RAW | 16 | RECAGUID | ||||
PROCESSGUID | Generic Key of Process | RECAPROCESSGUID | RAW | 16 | RECAGUID | ||||
INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | RECAINTRENO | ||||
CONDCURR | Currency of condition item | RECDCONDCURR | CUKY | 5 | Assigned to domain | WAERS | |||
MGRBASEREF | Base Value: Reference Interest Rate | REXCAJMGRBASEREF | CHAR | 10 | T056R | ZIREFKU | |||
MGRBASEDATE | Base Date for Reference Interest Rate | REXCAJMGRBASEDATE | DATS | 8 | RECADATE | ||||
MGRBASERATE | Reference Interest Rate for Adjustment | REXCAJMGRBASERATE | DEC | 10(7) | DEC03 | REXCAJAZINSSATZ_3 | |||
MGRADJMDATE | Adjustment Date of Reference Interest Rate | REXCAJMGRADJMDATE | DATS | 8 | RECADATE | ||||
MGRADJMRATE | New Reference Interest Rate | REXCAJMGRADJMRATE | DEC | 10(7) | DEC03 | REXCAJAZINSSATZ_3 | |||
MGRADJMPERCENT | Percentage Rate of Adjustment of Reference Interest Rate | REXCAJMGRADJMPERCENT | DEC | 5(2) | AD01DEFPCT | ||||
MGRADJMAMOUNT | Absolute Value of Adjustment of Reference Interest Rate | REXCAJMGRADJMAMOUNT | CURR | 15(2) | RECACURR | ||||
MOCBASEINDX | Base Value: Maintenance and Operating Costs as Percentage | REXCAJMOCBASEINDX | DEC | 7(4) | DEC03 | REXCAJDEC3_4_3 | |||
MOCBASEDATE | Base Date for Maintenance and Operating Costs | REXCAJMOCBASEDATE | DATS | 8 | RECADATE | ||||
MOCADJMDATE | Adjustment Date for Maintenance and Operating Costs | REXCAJMOCADJMDATE | DATS | 8 | RECADATE | ||||
MOCADJNBMONTH | Number of Months | REXCAJNUMBERMONTH | INT2 | 5 | REXCAJNUMBERMONTH | ||||
MOCADJMPERCENT | Percentage of Adjustment from Maint. and Operating Costs | REXCAJMOCADJMPERCENT | DEC | 5(2) | AD01DEFPCT | ||||
MOCADJMAMOUNT | Absolute Value of Maintenance and Operating Costs Adjustment | REXCAJMOCADJMAMOUNT | CURR | 15(2) | RECACURR | ||||
PPCBASESERIES | Base Value: Index Series for Purchasing Power Protection | REXCAJPPCBASESERIES | CHAR | 5 | Assigned to domain | WBIND | |||
PPCBASEYEAR | Base Year for Purchasing Power Protection | REXCAJPPCBASEYEAR | NUMC | 4 | Assigned to domain | GJAHR | BASJHR | ||
PPCBASEDATE | Base Date, Purchasing Power Protection | REXCAJPPCBASEDATE | DATS | 8 | RECADATE | ||||
PPCBASEINDX | Base Index Level: Purchasing Power Protection | REXCAJPPCBASEINDX | DEC | 10(7) | DEC03 | REXCAJAZINSSATZ_3 | |||
PPCPRCTPASS | Percentage Passed on of Adj. Based on Purchasing Power Prot. | REXCAJPPCPRCTPASS | DEC | 5(2) | RECAPROZ3_2 | ||||
PPCADJMDATE | Adjustment Date for Purchasing Power Protection | REXCAJPPCADJMDATE | DATS | 8 | RECADATE | ||||
PPCADJMINDX | New Index Level for Purchasing Power Protection | REXCAJPPCADJMINDX | DEC | 10(7) | DEC03 | REXCAJAZINSSATZ_3 | |||
PPCADJMPERCENT | Percentage of Adjustment from Purchasing Power Protection | REXCAJPPCADJMPERCENT | DEC | 5(2) | AD01DEFPCT | ||||
PPCADJMAMOUNT | Absolute Val. of Adjustment from Purchasing Power Protection | REXCAJPPCADJMAMOUNT | CURR | 15(2) | RECACURR | ||||
RELADJMPERCENT | Effective Adjustment from Relative Factors: Percentage | REXCAJRELADJMPERCENT | DEC | 5(2) | AD01DEFPCT | ||||
RELADJMAMOUNT | Effective Adjustment from Relative Factors: Absolute Value | REXCAJRELADJMAMOUNT | CURR | 15(2) | RECACURR | ||||
ACCOMCONDTYPE | Absolute Factors, Condition Category | REXCAJABSBASECONDTYPE | CHAR | 4 | Assigned to domain | ALPHA | RECDCONDTYPE | ||
ACCOMBASEUPRICE | Absolute Factors, Currency Amount (Gross) Condition Item | REXCAJABSBASEUNITPRICE | DEC | 19(6) | RECDUNITPRICE | ||||
ACCOMVALIDFROM | Date from when condition is valid | RECDVALIDFROM | DATS | 8 | RECADATE | ||||
YIELDCONDTYPE | Absolute Factors, Condition Category | REXCAJABSBASECONDTYPE | CHAR | 4 | Assigned to domain | ALPHA | RECDCONDTYPE | ||
YIELDBASEUPRICE | Absolute Factors, Currency Amount (Gross) Condition Item | REXCAJABSBASEUNITPRICE | DEC | 19(6) | RECDUNITPRICE | ||||
YIELDVALIDFROM | Date from when condition is valid | RECDVALIDFROM | DATS | 8 | RECADATE | ||||
WOIINCONDTYPE | Absolute Factors, Condition Category | REXCAJABSBASECONDTYPE | CHAR | 4 | Assigned to domain | ALPHA | RECDCONDTYPE | ||
WOIINBASEUPRICE | Absolute Factors, Currency Amount (Gross) Condition Item | REXCAJABSBASEUNITPRICE | DEC | 19(6) | RECDUNITPRICE | ||||
WOIINVALIDFROM | Date from when condition is valid | RECDVALIDFROM | DATS | 8 | RECADATE | ||||
ABSREASCOND | Absolute Factors, Adjustment Reason for Condition Category | REXCAJABSREASCOND | NUMC | 1 | REXCAJABSREASCOND | ||||
ABSREASAMOUNT | Absolute Method, Adjustment by an Absolute Amount | REXCAJABSREASAMOUNT | CURR | 15(2) | RECACURR | ||||
ABSREASPERCENT | Absolute Factors, Adjustment Reason as Percentage | REXCAJABSREASPERCENT | DEC | 5(2) | RECAPROZ3_2 | ||||
ABSADJOPTION | Option for an Adjustment Based on Absolute Factors | REXCAJABSADJOPTION | CHAR | 1 | RECABOOL | ||||
ABSADJMPERCENT | Absolute Factors, Percentage Rate of Adjustment | REXCAJABSADJPERCENT | DEC | 5(2) | AD01DEFPCT | ||||
ABSADJMAMOUNT | Absolute Factors, Absolute Value of Adjustment | REXCAJABSADJAMOUNT | CURR | 15(2) | RECACURR | ||||
WOIREASCOND | Added Benefits, Adjustment Reason Condition Type | REXCAJWOIREASCOND | NUMC | 1 | REXCAJWOIREASCOND | ||||
WOIREASAMOUNT | Added Benefits, Adjustment Reason as Absolute Value | REXCAJWOIREASAMOUNT | CURR | 15(2) | RECACURR | ||||
WOIREASPERCENT | Added Benefits, Adjustment Reason as Percentage | REXCAJWOIREASPERCENT | DEC | 5(2) | RECAPROZ3_2 | ||||
WOIADJMPERCENT | Added Benefits, Percentage of Adjustment | REXCAJWOIADJPERCENT | DEC | 5(2) | AD01DEFPCT | ||||
WOIADJMAMOUNT | Added Benefits, Absolute Value of Adjustment | REXCAJWOIADJAMOUNT | CURR | 15(2) | RECACURR | ||||
ADJCONDABS | Adj.Parameter REL: Adj. Condition Amount for Absolute Method | REXCAJADJCONDABS | NUMC | 1 | REXCAJADJCONDABS | ||||
ACCOMADJMUPRICE | Absolute Factors, Currency Amount (Adjust.) Condition Item | REXCAJABSADJMUNITPRICE | DEC | 19(6) | RECDUNITPRICE | ||||
YIELDADJMUPRICE | Absolute Factors, Currency Amount (Adjust.) Condition Item | REXCAJABSADJMUNITPRICE | DEC | 19(6) | RECDUNITPRICE | ||||
WOIINADJMUPRICE | Absolute Factors, Currency Amount (Adjust.) Condition Item | REXCAJABSADJMUNITPRICE | DEC | 19(6) | RECDUNITPRICE | ||||
PARMRELLOW | Handling of Reserve: Option When Net Rent Reduced | REXCAJPARMRELLOW | NUMC | 1 | REXCAJPARMRELLOW | ||||
PARMRELLOWPRIO1 | Handling of Reserve: Priority When Reducing Net Rent | REXCAJPARMRELLOWPRIO | NUMC | 1 | REXCAJPARMRELLOWPRIO | ||||
PARMRELLOWPRIO2 | Handling of Reserve: Priority When Reducing Net Rent | REXCAJPARMRELLOWPRIO | NUMC | 1 | REXCAJPARMRELLOWPRIO | ||||
RESVAMOUNTPRIO1 | Reserve, Absolute Value Based on Absolute Factors | REXCAJABSRESVAMOUNT | CURR | 15(2) | RECACURR | ||||
BASEADJMPRIO1 | Effective Adjustment from Relative Factors: Absolute Value | REXCAJRELADJMAMOUNT | CURR | 15(2) | RECACURR | ||||
ADJMPRIO1 | Effective Adjustment from Relative Factors: Absolute Value | REXCAJRELADJMAMOUNT | CURR | 15(2) | RECACURR | ||||
RESVAMOUNTPRIO2 | Reserve, Absolute Value Based on Absolute Factors | REXCAJABSRESVAMOUNT | CURR | 15(2) | RECACURR | ||||
ADJMPRIO2 | Effective Adjustment from Relative Factors: Absolute Value | REXCAJRELADJMAMOUNT | CURR | 15(2) | RECACURR | ||||
FREEVALUEABSINC | Absolute Increase of the Unit Price | REXCAJFREEVALUEABSINC | DEC | 19(6) | RECDUNITPRICE | ||||
FREEVALUEPERCENT | Relative Increase of Unit Price | REXCAJFREEVALUEPERCENT | DEC | 7(2) | DEC5_2V | ||||
FREEADJMPERCENT | Effective Adjustment from Custom Adjustment: Percentage | REXCAJFREEADJMPERCENT | DEC | 5(2) | AD01DEFPCT | ||||
FREEADJMAMOUNT | Effective Adjustment from Custom Adjustmt: Absolute Value | REXCAJFREEADJMAMOUNT | CURR | 15(2) | RECACURR | ||||
FREEADJMTXT | Explanatory Text for Custom Adjustment | REXCAJFREEADJMTXT | CHAR | 70 | REXCAJADJTEXT | ||||
ADJMTXTDESCRIPT | Explanatory Text 'Description of Change' | REXCAJADJMTXTDESCRIPT | CHAR | 70 | REXCAJADJTEXT | ||||
ADJMTXTMOMENT | Explanatory Text 'Time at Which Took Effect' | REXCAJADJMTXTMOMENT | DATS | 8 | RECADATE | ||||
ADJMTXTREASON | Explanatory Text 'Reason for Change' | REXCAJADJMTXTREASON | CHAR | 70 | REXCAJADJTEXT | ||||
ADJMTXTGUID | GUID (RAW16) | RECAGUID | RAW | 16 | RECAGUID |
Key field | Non-key field |
How do I retrieve data from SAP table VIXCAJRECCH01 using ABAP code
The following ABAP code Example will allow you to do a basic selection on VIXCAJRECCH01 to SELECT all data from the tableDATA: WA_VIXCAJRECCH01 TYPE VIXCAJRECCH01.
SELECT SINGLE *
FROM VIXCAJRECCH01
INTO CORRESPONDING FIELDS OF WA_VIXCAJRECCH01
WHERE...
How to access SAP table VIXCAJRECCH01
Within an ECC or HANA version of SAP you can also view further information about VIXCAJRECCH01 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects