REIS_CN_RN_RULE_L SAP (ALV Reporting: Renewal Rules for Contracts) Structure details
Description: ALV Reporting: Renewal Rules for Contracts
Related tables to REIS_CN_RN_RULE_L
Access table REIS_CN_RN_RULE_L
Structure field list including key, data, relationships and ABAP select examples
REIS_CN_RN_RULE_L 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 "ALV Reporting: Renewal Rules for Contracts" 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_REIS_CN_RN_RULE_L TYPE REIS_CN_RN_RULE_L.
The REIS_CN_RN_RULE_L table consists of various fields, each holding specific information or linking keys about ALV Reporting: Renewal Rules for Contracts data available in SAP. These include GEN_OBJTYPE (Object Type), GEN_OBJNR (Object Number), GEN_CONTRACT (Object Number), GEN_PARTNER1 (Business Partner Number).. 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 REIS_CN_RN_RULE_L 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 |
GEN_OBJTYPE | Object Type | RECAOBJTYPE | CHAR | 2 | Assigned to domain | J_OBART | RECAOBJTYPE | ||
GEN_OBJNR | Object Number | RECAOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
GEN_CONTRACT | Object Number | RECAOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
GEN_PARTNER1 | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
GEN_PARTNER2 | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
ALVROWS | Number of Rows | REISALVROWS | INT2 | 5 | |||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
RECNNR | Contract Number | RECNNUMBER | CHAR | 13 | ALPHA | RECNNUMBER | RECNNR | RECNCN | |
RECNTXT | Contract name | RECNTXT | CHAR | 80 | XTEXT80 | ||||
RECNBEG | Date of contract start | RECNCNBEG | DATS | 8 | RECADATE | ||||
RECNEND1ST | Date of First Contract End | RECNCNEND1ST | DATS | 8 | RECADATE | ||||
RECNENDABS | Term End Date | RECNCNENDABS | DATS | 8 | REDAT | RECADATEEND | |||
RNHASRULE | Renewal Rule Exists? | RETMRNHASRULE | CHAR | 1 | RECABOOL | ||||
RNENDNEW | Next Contract End Date | RETMRNENDNEW | DATS | 8 | RECADATE | ||||
PESTATE | Status of Contract Term | RETMPESTATE | CHAR | 2 | RETMPESTATE | ||||
XPESTATE | Status of Contract Term | RETMXPESTATE | CHAR | 60 | RECAXLDESCRIPTION | ||||
NTALLOWEDPAR | Next Possible Notice by Partner | RETMNTALLOWEDPAR | DATS | 8 | RECADATE | ||||
NTALLOWEDOWN | Next Possible Own Notice Date | RETMNTALLOWEDOWN | DATS | 8 | RECADATE | ||||
XTERMTYPE | Name of Term Category | RETMXTERMTYPE | CHAR | 30 | RECAXMDESCRIPTION | ||||
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | RECAINTRENO | ||||
TERMTYPE | Term Category | RETMTERMTYPE | CHAR | 4 | TIVTMTERMTYPE | RETMTERMTYPE | |||
TERMNO | Term Number | RETMTERMNO | CHAR | 4 | VITMTERM | ALPHA | RETMTERMNO | ||
RNTYPE | Type of Renewal of Real Estate Contract | RETMRNTYPE | CHAR | 1 | RETMRNTYPE | ||||
RNRULE | Renewal Rule | RETMRNRULE | CHAR | 4 | TIVTMRNRULE | RETMRNRULE | |||
RNAUTTYPE | Type of Automatic Renewal | RETMRNAUTTYPE | CHAR | 1 | RETMRNAUTTYPE | ||||
RNEND1STOBJ | End of First Fixed Term for Renewal of Objects | RETMRNEND1STOBJ | DATS | 8 | RECADATE | ||||
XTERM | Name of Term | RETMXTERM | CHAR | 60 | RECAXLDESCRIPTION | ||||
XRNTYPE | Name of Renewal Type | RETMXRNTYPE | CHAR | 60 | RECAXLDESCRIPTION | ||||
RNEND1ST | End of First Fixed Term | RETMRNEND1ST | DATS | 8 | RECADATE | ||||
XRNRULE | Renewal Rule Name | RETMXRNRULE | CHAR | 60 | RECAXLDESCRIPTION | ||||
RNAUTTYPECUST | Type of Automatic Renewal | RETMRNAUTTYPE | CHAR | 1 | RETMRNAUTTYPE | ||||
XRNAUTTYPE | Name of Type of Automatic Renewal | RETMXRNAUTTYPE | CHAR | 60 | RECAXLDESCRIPTION | ||||
RNRULETYPE | Type of Renewal Rule | RETMRNRULETYPE | CHAR | 1 | RETMRNRULETYPE | ||||
XRNRULETYPE | Name of Rule Type | RETMXRNRULETYPE | CHAR | 30 | RECAXMDESCRIPTION | ||||
RNRULENO | Sequence Number of Extension Period | RETMRNRULENO | NUMC | 4 | RETMRNRULENO | ||||
RNEXTCOUNT | Number of Renewals | RETMRNEXTCOUNT | NUMC | 2 | NUMC2 | ||||
RNEXTYEARS | Contract Renewed for Number of Years | RETMRNEXTYEARS | NUMC | 2 | NUMC2 | ||||
RNEXTMONTHS | Contract Renewed for Number of Months | RETMRNEXTMONTHS | NUMC | 2 | NUMC2 | ||||
RNEXTDAYS | Contract Renewed for Number of Days | RETMRNEXTDAYS | NUMC | 2 | NUMC2 | ||||
RNEXTROUND | Rounding Rule for Determined Renewal Date | RETMRNEXTROUND | CHAR | 1 | RETMRNROUND | ||||
XRNEXTROUND | Rounding Rule for Determined Renewal Date | RETMXRNEXTROUND | CHAR | 30 | RECAXMDESCRIPTION | ||||
RNNOTYEARS | Notification Must Be This No. of Years before Renewal Date | RETMRNNOTYEARS | NUMC | 2 | NUMC2 | ||||
RNNOTMONTHS | Notification Must Be This No. of Months before Renewal Date | RETMRNNOTMONTHS | NUMC | 2 | NUMC2 | ||||
RNNOTWEEKS | Notification Must Be This No. of Weeks before Renewal Date | RETMRNNOTWEEKS | NUMC | 2 | NUMC2 | ||||
RNNOTDAYS | Notification Must Be This No. of Days before Renewal Date | RETMRNNOTDAYS | NUMC | 2 | NUMC2 | ||||
RNNOTROUND | Rounding Rule for Determined Notification Date | RETMRNNOTROUND | CHAR | 1 | RETMRNROUND | ||||
XRNNOTROUND | Rounding Rule for Determined Notification Date | RETMXRNNOTROUND | CHAR | 30 | RECAXMDESCRIPTION | ||||
RECISVALIDFROM | Displayed Row Is Valid From | REISRECVALIDFROM | DATS | 8 | RECADATE | ||||
RECISVALIDTO | Displayed Row Is Valid Until | REISRECVALIDTO | DATS | 8 | RECADATE | ||||
ROLE_BP1 | First Main Contractual Partner: Role | REBPROLE1 | CHAR | 6 | Assigned to domain | BU_ROLE | |||
XROLE_BP1 | 1st Main Contractual Partner: Name of Role Category | REBPXROLE1 | CHAR | 30 | RECAXMDESCRIPTION | ||||
PARTNER_BP1 | First Main Contractual Partner | REBPPARTNER1 | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
XPARTNER_BP1 | Name/Address of 1st Business Partner | REBPXPARTNER1 | CHAR | 80 | TEXT80 | ||||
TEL_NUMBER_LONG_BP1 | Complete number: dialling code+number+extension | AD_TELNRLG | CHAR | 30 | CHAR30 | ||||
FAX_NUMBER_LONG_BP1 | Complete number: dialling code+number+extension | AD_FXNRLNG | CHAR | 30 | CHAR30 | ||||
SMTP_ADDR_BP1 | E-Mail Address | AD_SMTPADR | CHAR | 241 | SXIDN | AD_SMTPADR | |||
XNAME_BP1 | Short Description of 1st Business Partner | REBPXNAME1 | CHAR | 50 | BU_TEXT50 | ||||
STREET_BP1 | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
HOUSE_NUM1_BP1 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
POST_CODE1_BP1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
CITY1_BP1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
CITY2_BP1 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
REGION_BP1 | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
PO_BOX_BP1 | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
POST_CODE2_BP1 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | CHAR10 | ||||
ROLE_BP2 | Second Main Contractual Partner: Role | REBPROLE2 | CHAR | 6 | Assigned to domain | BU_ROLE | |||
XROLE_BP2 | 2nd Main Contractual Partner: Name of Role Category | REBPXROLE2 | CHAR | 30 | RECAXMDESCRIPTION | ||||
PARTNER_BP2 | Second Main Contractual Partner | REBPPARTNER2 | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
XPARTNER_BP2 | Name/Address of 2nd Business Partner | REBPXPARTNER2 | CHAR | 80 | TEXT80 | ||||
TEL_NUMBER_LONG_BP2 | Complete number: dialling code+number+extension | AD_TELNRLG | CHAR | 30 | CHAR30 | ||||
FAX_NUMBER_LONG_BP2 | Complete number: dialling code+number+extension | AD_FXNRLNG | CHAR | 30 | CHAR30 | ||||
SMTP_ADDR_BP2 | E-Mail Address | AD_SMTPADR | CHAR | 241 | SXIDN | AD_SMTPADR | |||
XNAME_BP2 | Short Description of 2nd Business Partner | REBPXNAME2 | CHAR | 50 | BU_TEXT50 | ||||
STREET_BP2 | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
HOUSE_NUM1_BP2 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
POST_CODE1_BP2 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
CITY1_BP2 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
CITY2_BP2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
REGION_BP2 | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
PO_BOX_BP2 | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
POST_CODE2_BP2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | CHAR10 |
Key field | Non-key field |
How do I retrieve data from SAP structure REIS_CN_RN_RULE_L using ABAP code?
As REIS_CN_RN_RULE_L 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 REIS_CN_RN_RULE_L as there is no data to select.How to access SAP table REIS_CN_RN_RULE_L
Within an ECC or HANA version of SAP you can also view further information about REIS_CN_RN_RULE_L 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