SAP Table BAPI_RE_CN_OFFER
Contract Offer
BAPI_RE_CN_OFFER (Contract Offer) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link BAPI_RE_CN_OFFER to other SAP tables.
Source: BAPI_RE_CN_OFFER (Contract Offer)
BAPI_RE_CN_OFFER table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CN_OFFER_ID | Contract Offer Number | REOROFID | CHAR | 13 | 0 | |||||||
| IDENT_OBJECT_TYPE | ID Part of Object Type, such as "IS" (Real Estate Contract) | RECAIDENTTYPE | TBO00 | CHAR | 2 | 0 | ||||||
| IDENT_KEY | ID Part Key, for example "1000/123" | RECAIDENTKEY | CHAR | 45 | 0 | |||||||
| CREATION_USER | Entered by | RERF | CHAR | 12 | 0 | |||||||
| CREATION_DATE | First Entered on | DERF | DATS | 8 | 0 | |||||||
| CREATION_TIME | Time of Initial Entry | TERF | TIMS | 6 | 0 | |||||||
| LASTCHANGE_USER | Employee ID | RBEAR | CHAR | 12 | 0 | |||||||
| LASTCHANGE_DATE | Last Edited on | DBEAR | DATS | 8 | 0 | |||||||
| LASTCHANGE_TIME | Last Edited at | TBEAR | TIMS | 6 | 0 | |||||||
| CN_OFFER_TEXT | Name of Contract Offer | REORXOF | CHAR | 60 | 0 | |||||||
| COMP_CODE | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||
| CONTRACT_TYPE | Contract Type | RECNCONTRACTTYPE | TIV26 | CHAR | 4 | 0 | ||||||
| CONTRACT_START_DATE | Date of contract start | RECNCNBEG | DATS | 8 | 0 | |||||||
| TERM_END_DATE | Term End Date | RECNCNENDABS | DATS | 8 | 0 | |||||||
| REJECTION_DATE | Rejection of Contract Offer | REOROFREJDATE | DATS | 8 | 0 | |||||||
| CONTRACT_NUMBER | Contract Number | RECNNUMBER | CHAR | 13 | 0 | |||||||
| TENANCY_LAW | Tenancy law | SMIETR | TIV03 | CHAR | 5 | 0 | ||||||
| MAIN_CONTRACT_COMP_CODE | Company code of main contract | RECNBUKRSCOLLECT | T001 | CHAR | 4 | 0 | ||||||
| MAIN_CONTRACT_NUMBER | Number of Real Estate Main Contract | RECNNUMBERCOLLECT | CHAR | 13 | 0 | |||||||
| CURRENCY_CONTRACT | Currency for Contract | RECNWAERS_CN | TCURC | CUKY | 5 | 0 | ||||||
| CURRENCY_ISO | ISO currency code | ISOCD | CHAR | 3 | 0 | |||||||
| INDUSTRYSECTOR | Industry | BU_IND_SECTOR | TB038A | CHAR | 10 | 0 | ||||||
| IS_SALES_RELATED | Relevant to Sales | RECNSALESRENTRELEVANT | CHAR | 1 | 0 |
Possible values
|
||||||
| DEPOSIT_TYPE | Security Deposit Type | RECNDPTYPE | TIVCNDPTYPE | CHAR | 4 | 0 | ||||||
| RESERVED_TO_DATE | Contract Offer Reserved To | REOROFRESTO | DATS | 8 | 0 | |||||||
| CONTRACT_CONCLUSION_DATE | Date of Contract Conclusion | RECNDAT | DATS | 8 | 0 | |||||||
| CASH_FLOW_START_DATE | Cash Flow Generated Starting On | RECDCFSTARTFROM | DATS | 8 | 0 | |||||||
| FIRST_END_DATE | Date of First Contract End | RECNCNEND1ST | DATS | 8 | 0 | |||||||
| BUSINESS_ENTITY | Site That Belongs to Contract | RECNBENOCN | CHAR | 8 | 0 | |||||||
| AUTHORIZATION_GROUP | Authorization Group | RECAAUTHGRP | CHAR | 40 | 0 | |||||||
| RESPONSIBLE | Person Responsible | RECARESPONSIBLE | CHAR | 12 | 0 | |||||||
| STAT_PROF | Status Profile | J_STSMA | TJ20 | CHAR | 8 | 0 | ||||||
| POSSESSION_FROM | Date From Which the Object Is Made Available for Use | REBDPOSSDATEFROM | DATS | 8 | 0 | |||||||
| POSSESSION_TO | Date Up to Which the Object Is Used | REBDPOSSDATETO | DATS | 8 | 0 | |||||||
BAPI_RE_CN_OFFER foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| BAPI_RE_CN_OFFER | COMP_CODE | BAPI_RE_CN_OFFER | COMP_CODE | T001 | Company Codes | BUKRS |
| BAPI_RE_CN_OFFER | COMP_CODE | SYST | MANDT | T001 | Company Codes | MANDT |
| BAPI_RE_CN_OFFER | CONTRACT_TYPE | BAPI_RE_CN_OFFER | CONTRACT_TYPE | TIV26 | Real Estate Contract Type (Entities) | SMVART |
| BAPI_RE_CN_OFFER | CONTRACT_TYPE | SYST | MANDT | TIV26 | Real Estate Contract Type (Entities) | MANDT |
| BAPI_RE_CN_OFFER | CURRENCY_CONTRACT | BAPI_RE_CN_OFFER | CURRENCY_CONTRACT | TCURC | Currency Codes | WAERS |
| BAPI_RE_CN_OFFER | CURRENCY_CONTRACT | SYST | MANDT | TCURC | Currency Codes | MANDT |
| BAPI_RE_CN_OFFER | DEPOSIT_TYPE | BAPI_RE_CN_OFFER | DEPOSIT_TYPE | TIVCNDPTYPE | Security Deposit Type | DPTYPE |
| BAPI_RE_CN_OFFER | DEPOSIT_TYPE | SYST | MANDT | TIVCNDPTYPE | Security Deposit Type | MANDT |
| BAPI_RE_CN_OFFER | IDENT_OBJECT_TYPE | BAPI_RE_CN_OFFER | IDENT_OBJECT_TYPE | TBO00 | Object type control parameters | OBART |
| BAPI_RE_CN_OFFER | INDUSTRYSECTOR | SYST | MANDT | TB038A | BP Industry Key | CLIENT |
| BAPI_RE_CN_OFFER | INDUSTRYSECTOR | * | TB038A | BP Industry Key | ISTYPE | |
| BAPI_RE_CN_OFFER | INDUSTRYSECTOR | BAPI_RE_CN_OFFER | INDUSTRYSECTOR | TB038A | BP Industry Key | IND_SECTOR |
| BAPI_RE_CN_OFFER | MAIN_CONTRACT_COMP_CODE | SYST | MANDT | T001 | Company Codes | MANDT |
| BAPI_RE_CN_OFFER | MAIN_CONTRACT_COMP_CODE | BAPI_RE_CN_OFFER | MAIN_CONTRACT_COMP_CODE | T001 | Company Codes | BUKRS |
| BAPI_RE_CN_OFFER | STAT_PROF | BAPI_RE_CN_OFFER | STAT_PROF | TJ20 | Status profiles | STSMA |
| BAPI_RE_CN_OFFER | STAT_PROF | SYST | MANDT | TJ20 | Status profiles | MANDT |
| BAPI_RE_CN_OFFER | TENANCY_LAW | BAPI_RE_CN_OFFER | TENANCY_LAW | TIV03 | Country-specific tenancy law | SMIETR |
| BAPI_RE_CN_OFFER | TENANCY_LAW | SYST | MANDT | TIV03 | Country-specific tenancy law | MANDT |
