REHO_CORRESPONDENCE_ALV SAP () Structure details
Description:
Related tables to REHO_CORRESPONDENCE_ALV
Access table REHO_CORRESPONDENCE_ALV
Structure field list including key, data, relationships and ABAP select examples
REHO_CORRESPONDENCE_ALV is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_REHO_CORRESPONDENCE_ALV TYPE REHO_CORRESPONDENCE_ALV.
The REHO_CORRESPONDENCE_ALV table consists of various fields, each holding specific information or linking keys about data available in SAP. These include MANDT (Client), INTRENO (Internal Real Estate Master Data Code), BUKRS (Company Code), RECNTYPE (External Real Estate contract type).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP REHO_CORRESPONDENCE_ALV structure 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 | |||
INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | VVINTRENO | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
RECNTYPE | External Real Estate contract type | SMVART | CHAR | 4 | TIV26 | SMVART | RECNTYPE | ||
RECNNR | Real Estate Contract Number | RECNNR | CHAR | 13 | ALPHA | RECNNR | RECNNR | ||
RECNDAT | Date of Contract Conclusion | RECNDAT | DATS | 8 | DDAT | ||||
RECNBEG | Date of contract start | RECNBEG | DATS | 8 | DDAT | ||||
RECNEND | Date of contract end | RECNEND | DATS | 8 | DDAT | ||||
RECNADJT | Lease-Out Adjustment Type | SMVAR | CHAR | 1 | Assigned to domain | SMVAR | |||
RECNTXT | Contract name | RECNTXT | CHAR | 80 | XTEXT80 | ||||
RECNDPO | Date of first posting | RECNDPO | DATS | 8 | DDAT | ||||
RECNOBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
RECNNOTTYPE | Notice Type of Lease-Out | SMVKUEART | CHAR | 1 | SMVKUEART | ||||
RECNNOTKEY | Notice rule | SKUEKEY | CHAR | 12 | SKUEKEY | ||||
RECNNOTPER | Contract Notice Per | DKUZU | DATS | 8 | DDAT | ||||
RECNAUTHGR | Authorization group | VVBERGRP | CHAR | 40 | VVBERGRP | ||||
RECNBUSAREA | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
RECNPRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
RECNACCDETVAL | Account determination key for account determination | VVWERTN_ADCN | CHAR | 10 | TIVCN08 | VVWERTN_ADCN | |||
RECNADMONTH | Accrual/deferral method | VVJMABGR | CHAR | 1 | JFLAGG | ||||
RECNDDUNNED | Last dunned on | MADAT | DATS | 8 | DATUM | ||||
RECNDCOMPLNT | Date of complaint | VVKLDATUM | DATS | 8 | DATUM | ||||
RECNDCOMPLRC | Complaint reference code | VVKLAKTZEI | CHAR | 20 | CHAR20 | ||||
RECNJURISDIC | Jurisdiction | VVXGERSTD | CHAR | 35 | TEXT35 | ||||
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
RECNUNIT | Area unit | RECNUNIT | UNIT | 3 | T006 | CUNIT | MEINS | H_T006 | |
RECNKUNNR | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
RECNLIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
RECNTXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
RECNCURR | Currency key for local currency | RECNWAERS_H | CUKY | 5 | TCURC | WAERS | FWS | ||
RECNTLAW | Tenancy law | SMIETR | CHAR | 5 | TIV03 | SMIETR | |||
RECNCURR2 | Currency key for the display currency | RECNWAERS_D | CUKY | 5 | TCURC | WAERS | FWS | ||
RECNTXTOLD | Number of old contract | VVOSMIVE | CHAR | 20 | ALPHA | VVOSMIVE | |||
RECNDACTIV | Contract activation | DAKTV | DATS | 8 | DATUM | ||||
RECNNRCOLLECT | Number of Real Estate main contract | RECNNRCOLLECT | CHAR | 13 | ALPHA | RECNNR | RECNNR | ||
RECNKOSTL | Cost center of internal contract | RECNKOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | Assigned to domain | ZLSCH | |||
RECNPREDATA | Flag: Predefined rates | RECNPREDATA | CHAR | 1 | XFELD | ||||
SPARTNR | Business Partner Number | BP_PARTNR | CHAR | 10 | Assigned to domain | ALPHA | BP_PARTNR | BPN | |
RECNNOTRECEIPT | Receipt or issue date of notice | DEKUEA | DATS | 8 | DDAT | ||||
RECNNOTREASON | Reason for notice | RKUEGRU | NUMC | 2 | TIV39 | RKUEGRU | |||
RECNNOTINVREA | Reason for rejection | RABLGRU | NUMC | 2 | TIV41 | RABLGRU | |||
RECNJVSTOPT | Input tax opting (indicator) | VVJVSTOPT | CHAR | 1 | JANE | ||||
RECNVSTSOND | Input tax opting reason | SVSTSOND | CHAR | 1 | TIV63 | SVSTSOND | |||
RECNMANSP | Dunning block | MANSP | CHAR | 1 | T040S | MANSP | |||
RECNMABER | Dunning Area | MABER | CHAR | 2 | T047M | MABER | |||
RECNMAHNA | Dunning Procedure | MAHNA | CHAR | 4 | T047A | MAHNA | |||
RECNMAHNS_D | Dunning level | MAHNS_D | NUMC | 1 | MAHNS | ||||
RECNNOTCAT | Notice Type | SKUAR | CHAR | 1 | SKUAR | ||||
RECNGFZLSCH | Payment method for credit memos | RECNGFZLSCH | CHAR | 1 | Assigned to domain | ZLSCH | |||
RECNZLSPR | Payment Block Key | DZLSPR | CHAR | 1 | T008 | ZAHLS | SPE | ||
RECNHBKID | Short Key for a House Bank | HBKID | CHAR | 5 | T012 | HBKID | |||
RECNXBLNR | Note to payee | RECNXBLNR1 | CHAR | 16 | XBLNR1 | ||||
RECNDKUZUG | Date notice approved | VVDKUZUG | DATS | 8 | DDAT | ||||
RECNDKUABG | Date notice rejected | VVDKUABG | DATS | 8 | DDAT | ||||
RECNDWIKU | Date of objection to notice | VVDWIKU | DATS | 8 | DDAT | ||||
RECNDKUERCK | Date of withdrawal of notice | DKUERCK | DATS | 8 | DATUM | ||||
RECNDKREUEB | Date notice submitted to legal department | VVDKREUEB | DATS | 8 | DDAT | ||||
RECNDAKTKU | Activation date | VVDAKTKU | DATS | 8 | DDAT | ||||
RECNDSTKU | Reversal date | VVDSTKU | DATS | 8 | DDAT | ||||
RECNADJTTYPE | Adjustment triggered by | RECNADJTTYPE | CHAR | 1 | RECNADJTTYPE | ||||
RECNADJTRUECK | Retroactive adjustment possible | RECNADJTRUECK | CHAR | 1 | XFELD | ||||
RECNBUKRSCOLLECT | Company code of main contract | RECNBUKRSCOLLECT | CHAR | 4 | T001 | BUKRS | |||
RECNBASISAEZIF | Base: equivalence number distribution | RECNBASISAEZIF | INT2 | 5 | RECNAEZIF | ||||
RECNXCROSS | Gross amount indicator | RECNXCROSS | CHAR | 1 | XFELD | ||||
RECNMANDAT | Mandate | RECNMANDAT | CHAR | 20 | CHAR20 | ||||
RECNMANDATTYP | Role of Contract in Mandate | RECNMANDATTYP | NUMC | 1 | RECNMANDATTYP | ||||
RECNFLESR | Activation of POR functions | VVKZESR | CHAR | 1 | JANE | ||||
RECNESRNROW | POR participant number of owner | VVESRNR_EIG | NUMC | 9 | TIV9I | NUM9 | |||
RECNESRCUIDOW | POR customer identification number | VVESRKUID_EIG | CHAR | 15 | TIV9I | CHAR15 | |||
RECNVATNROW | Value-added tax of owner | VVMWSTNR_EIG | CHAR | 20 | STCEG | ||||
RECNBUKRSGKT | Object and account CoCd | VVBUKRS_GKT | CHAR | 4 | T001 | BUKRS | |||
RECNKZEIGGKT | Cash account control for owner | VVKZEIGGKT | CHAR | 1 | VVKZEIGGKT | ||||
.INCLU--AP | 0 | ||||||||
RELSKASSENZ | RELSKASSENZ | CHAR | 30 | CHAR30 | |||||
RELSGRDNR | RELSGRDNR | CHAR | 30 | CHAR30 | |||||
RELSSUBTYPE | RELSSUBTYPE | CHAR | 4 | TIVLSCNSTYPE | RELSSUBTYPE | ||||
RELSAKTZ | RELSAKTZ | CHAR | 35 | TEXT35 | |||||
RELSDAT2 | RELSDAT2 | DATS | 8 | DDAT | |||||
RELSWIRTUEBG | RELSWIRTUEBG | DATS | 8 | DDAT | |||||
RELSNOTEARLY | RELSNOTEARLY | DATS | 8 | DATS | |||||
RELSOWNER | Business Partner Number | BP_PARTNR | CHAR | 10 | Assigned to domain | ALPHA | BP_PARTNR | BPN | |
RELSROLETYP | Business Partner Role Category | BP_ROLETYP | CHAR | 4 | Assigned to domain | BP_ROLETYP | BPR | ||
.INCLU--AP | 0 | ||||||||
CREATIONTYPE | How the Object Was Created | RECACREATIONTYPE | CHAR | 1 | RECACREATIONTYPE | ||||
RECNCNCURR | Currency for Contract | RECNWAERS_CN | CUKY | 5 | TCURC | WAERS | FWS | ||
RECNENDABS | Term End Date | RECNCNENDABS | DATS | 8 | REDAT | RECADATEEND | |||
RECN2DAT | Date of Second Signature | RECN2DAT | DATS | 8 | RECADATE | ||||
RESPONSIBLE | Person Responsible | RECARESPONSIBLE | CHAR | 12 | Assigned to domain | XUBNAME | USER_COMP | ||
USEREXCLUSIVE | User with Exclusive Change Authorization | RECAUSEREXCLUSIVE | CHAR | 12 | Assigned to domain | XUBNAME | USER_COMP | ||
SRRELEVANT | Relevant to Sales | RECNSALESRENTRELEVANT | CHAR | 1 | RECABOOL | ||||
CFARCHIVEDTO | Date Up to Which the Cash Flow Is Archived | RECDCFARCHIVEDTO | DATS | 8 | RECADATE | ||||
CFLOCKEDTO | Date Until Which the Cash Flow Is Locked | RECDCFLOCKEDTO | DATS | 8 | RECADATE | ||||
INDUSTRY | Industry | BU_IND_SECTOR | CHAR | 10 | Assigned to domain | BU_INDSECTOR | |||
DPTARGETTYPE | Security Deposit Type | RECNDPTYPE | CHAR | 4 | TIVCNDPTYPE | ALPHA | RECNDPTYPE | ||
.INCLU--AP | 0 | ||||||||
BIRELEASE | RELUBIRELEASE | CHAR | 1 | XFELD | |||||
BIVALIDFROM | RELUBIVALIDFROM | DATS | 8 | DDAT | |||||
BIVALIDTO | RELUBIVALIDTO | DATS | 8 | DDAT | |||||
BIREPRTO | RELUBIREPRTO | DATS | 8 | DDAT | |||||
BIREPRTOTIME | RELUBIREPRTOTIME | TIMS | 6 | UZEIT | |||||
BIRECAT | RELUBIRECAT | CHAR | 2 | TIVLUBIRECAT | CHAR02 | ||||
PUBLICTYPE | RELUPUBLICTYPE | CHAR | 2 | TIVLUPUBLICTYPE | CHAR02 | ||||
FILENO | RELUFILENO | CHAR | 35 | CHAR35 | |||||
BIPURPOSE | RELUBIPURPOSE | CHAR | 2 | TIVLUBIPURPOSE | CHAR02 | ||||
BIPRICING | RELUBIPRICING | CHAR | 2 | TIVLUBIPRICING | CHAR02 | ||||
REHO_ROLETYP | REHOCP_ROLETYP | CHAR | 4 | Assigned to domain | BP_ROLETYP | BPR | |||
REHO_LINEK | REHOLINES | CHAR | 80 | LINES | |||||
REHO_PARTNR | REHOCP_PARTNR | CHAR | 10 | Assigned to domain | ALPHA | BP_PARTNR | BPN |
Key field | Non-key field |
How do I retrieve data from SAP structure REHO_CORRESPONDENCE_ALV using ABAP code?
As REHO_CORRESPONDENCE_ALV is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on REHO_CORRESPONDENCE_ALV as there is no data to select.How to access SAP table REHO_CORRESPONDENCE_ALV
Within an ECC or HANA version of SAP you can also view further information about REHO_CORRESPONDENCE_ALV 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