SAP ABAP Table REIS_CN_OA_L (ALV Reporting: Objects for Contracts)
Hierarchy
☛
EA-FIN (Software Component) EA-FIN
⤷ RE-FX-IS (Application Component) Information System
⤷ RE_IS_CN (Package) RE: Contract Info System
⤷ RE-FX-IS (Application Component) Information System
⤷ RE_IS_CN (Package) RE: Contract Info System
Basic Data
Table Category | INTTAB | Structure |
Structure | REIS_CN_OA_L | Table Relationship Diagram |
Short Description | ALV Reporting: Objects for Contracts |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | INTRENO | RECAINTRENO | RECAINTRENO | CHAR | 13 | 0 | Internal Key of Real Estate Object | ||
2 | OBJECTID | REISOBJECTID | CHAR | 40 | 0 | Object ID | |||
3 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
4 | RECNNR | RECNNUMBER | RECNNUMBER | CHAR | 13 | 0 | Contract Number | ||
5 | OBJECTTEXT | REISOBJECTTEXT | CHAR | 60 | 0 | Short Description of Object | |||
6 | RECNTYPE | RECNCONTRACTTYPE | SMVART | CHAR | 4 | 0 | Contract Type | * | |
7 | RECNBEG | RECNCNBEG | RECADATE | DATS | 8 | 0 | Date of contract start | ||
8 | RECNENDABS | RECNCNENDABS | RECADATEEND | DATS | 8 | 0 | Term End Date | ||
9 | RECNEND1ST | RECNCNEND1ST | RECADATE | DATS | 8 | 0 | Date of First Contract End | ||
10 | AUTHGRP | RECAAUTHGRP | RECAAUTHGRP | CHAR | 40 | 0 | Authorization Group | ||
11 | .INCLUDE | 0 | 0 | Time Slot Valid in a Row in the Info System | |||||
12 | RECISVALIDFROM | REISRECVALIDFROM | RECADATE | DATS | 8 | 0 | Displayed Row Is Valid From | ||
13 | RECISVALIDTO | REISRECVALIDTO | RECADATE | DATS | 8 | 0 | Displayed Row Is Valid Until | ||
14 | .INCLUDE | 0 | 0 | Object Assignment (VIBDOBJASS) + Additional Fields | |||||
15 | .INCLUDE | 0 | 0 | Object Assignment (VIBDOBJASS) | |||||
16 | .INCLUDE | 0 | 0 | Object Assignment | |||||
17 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
18 | .INCLUDE | 0 | 0 | Object Assignment: Key Fields | |||||
19 | OBJNRSRC | RECAOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number | * | |
20 | OBJASSTYPE | REBDOBJASSTYPE | REBDOBJASSTYPE | CHAR | 2 | 0 | Type of Object Assignment | TIVBDOBJASSTYPE | |
21 | OBJNRTRG | RECAOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number | * | |
22 | VALIDFROM | REBDRELVALIDFROM | RECADATEBEG | DATS | 8 | 0 | Date: Relationship Valid From | ||
23 | .INCLUDE | 0 | 0 | Object Assignment: Non-Key Fields | |||||
24 | VALIDTO | REBDRELVALIDTO | RECADATEEND | DATS | 8 | 0 | Date: Relationship Valid To | ||
25 | ASSIGNONLYINFO | REBDASSIGNONLYINFO | RECABOOL | CHAR | 1 | 0 | Informational Assignment | ||
26 | OBJNRSRCARCH | REBDOBJNRSRCARCH | RECABOOL | CHAR | 1 | 0 | Source Object Was Archived | ||
27 | FLGENTYPE | REBDFLGENTYPE | REBDFLGENTYPE | CHAR | 1 | 0 | Generation Type Functional Location | ||
28 | ISMAINASSET | REBDISMAINASSET | RECABOOL | CHAR | 1 | 0 | Asset Is Leading Asset | ||
29 | MEASVALUE | REBDOAMEASVALUE | REBDMEASVALUE | QUAN | 17 | 4 | Measurement Amount of Assignment | ||
30 | MEASUNIT | REBDMEASUNIT | MEINS | UNIT | 3 | 0 | Measurement Unit | T006 | |
31 | ISMULTIASSGEN | REBDISMULTIASSGEN | RECABOOL | CHAR | 1 | 0 | Generated Entry for Multiple Assignment | ||
32 | POSSDATEFROM | REBDPOSSDATEFROM | RECADATE | DATS | 8 | 0 | Date From Which the Object Is Made Available for Use | ||
33 | POSSDATETO | REBDPOSSDATETO | RECADATE | DATS | 8 | 0 | Date Up to Which the Object Is Used | ||
34 | .INCLUDE | 0 | 0 | Object Assignment: Option Rate Settings | |||||
35 | ISDETERMOPTRATE | REITISDETERMOPTRATE | RECABOOL | CHAR | 1 | 0 | Relevant for Deriving Option Rate | ||
36 | .INCLUDE | 0 | 0 | Object Assignment: Other Public Register | |||||
37 | PEPLANNEDDATE | RELMPEPLANDATE | RECADATE | DATS | 8 | 0 | Planning or Decision Date | ||
38 | PEEFFECTDATE | RELMPEEFFECTDATE | RECADATE | DATS | 8 | 0 | Effective Date | ||
39 | PELOCATION | RELMPELOCATION | RELMPELOCATION | CHAR | 80 | 0 | Location of Assigned Object | ||
40 | .INCLUDE | 0 | 0 | Object Assignment - General Additional Fields | |||||
41 | XOBJASSTYPE | REBDXOBJASSTYPE | RECAXLDESCRIPTION | CHAR | 60 | 0 | Type of Object Assignment (Text) | ||
42 | XOBJTYPESRC | RECAXOBJTYPE | CHAR3 | CHAR | 3 | 0 | Partial Object Type ID, for example "BE" | ||
43 | XOBJTYPETRG | RECAXOBJTYPE | CHAR3 | CHAR | 3 | 0 | Partial Object Type ID, for example "BE" | ||
44 | IDENTSRC | RECAIDENT | CHAR50 | CHAR | 50 | 0 | Complete Object Identification, for Example BE 1000/123 | ||
45 | IDENTTRG | RECAIDENT | CHAR50 | CHAR | 50 | 0 | Complete Object Identification, for Example BE 1000/123 | ||
46 | IDENTKEYSRC | RECAIDENTKEY | CHAR45 | CHAR | 45 | 0 | ID Part Key, for example "1000/123" | ||
47 | IDENTKEYTRG | RECAIDENTKEY | CHAR45 | CHAR | 45 | 0 | ID Part Key, for example "1000/123" | ||
48 | DESCRIPTIONSRC | RECADESCRIPTION | RECAXLDESCRIPTION | CHAR | 60 | 0 | Object Description | ||
49 | DESCRIPTIONTRG | RECADESCRIPTION | RECAXLDESCRIPTION | CHAR | 60 | 0 | Object Description | ||
50 | XLOBJTYPESRC | RECAXLOBJTYPE | TEXT20 | CHAR | 20 | 0 | Object Type Name (20) | ||
51 | XLOBJTYPETRG | RECAXLOBJTYPE | TEXT20 | CHAR | 20 | 0 | Object Type Name (20) | ||
52 | HASNOTE | RECAHASNOTE | RECABOOL | CHAR | 1 | 0 | Memo Exists? | ||
53 | RSOBJTYPE | REORRSOBJTYPE | REORRSOBJTYPE | CHAR | 2 | 0 | Reservation Object Type | * | |
54 | XRSOBJTYPE | REORXRSOBJTYPE | RECAXMDESCRIPTION | CHAR | 30 | 0 | Name of Reservation Object Type | ||
55 | OBJTYPESRC | RECAOBJTYPE | J_OBART | CHAR | 2 | 0 | Object Type | * | |
56 | OBJTYPETRG | RECAOBJTYPE | J_OBART | CHAR | 2 | 0 | Object Type | * | |
57 | .INCLUDE | 0 | 0 | Reporting Fields: Generic Part | |||||
58 | GEN_OBJTYPE | RECAOBJTYPE | J_OBART | CHAR | 2 | 0 | Object Type | * | |
59 | GEN_OBJNR | RECAOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number | * | |
60 | GEN_CONTRACT | RECAOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number | * | |
61 | GEN_PARTNER1 | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
62 | GEN_PARTNER2 | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
63 | ALVROWS | REISALVROWS | INT2 | 5 | 0 | Number of Rows | |||
64 | .INCLUDE | 0 | 0 | Reporting Fields: Main Contractual Partner | |||||
65 | ROLE_BP1 | REBPROLE1 | BU_ROLE | CHAR | 6 | 0 | First Main Contractual Partner: Role | * | |
66 | XROLE_BP1 | REBPXROLE1 | RECAXMDESCRIPTION | CHAR | 30 | 0 | 1st Main Contractual Partner: Name of Role Category | ||
67 | PARTNER_BP1 | REBPPARTNER1 | BU_PARTNER | CHAR | 10 | 0 | First Main Contractual Partner | * | |
68 | XPARTNER_BP1 | REBPXPARTNER1 | TEXT80 | CHAR | 80 | 0 | Name/Address of 1st Business Partner | ||
69 | TEL_NUMBER_LONG_BP1 | AD_TELNRLG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
70 | FAX_NUMBER_LONG_BP1 | AD_FXNRLNG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
71 | SMTP_ADDR_BP1 | AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | ||
72 | XNAME_BP1 | REBPXNAME1 | BU_TEXT50 | CHAR | 50 | 0 | Short Description of 1st Business Partner | ||
73 | STREET_BP1 | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
74 | HOUSE_NUM1_BP1 | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
75 | POST_CODE1_BP1 | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
76 | CITY1_BP1 | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
77 | CITY2_BP1 | AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
78 | REGION_BP1 | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
79 | PO_BOX_BP1 | AD_POBX | CHAR10 | CHAR | 10 | 0 | PO Box | ||
80 | POST_CODE2_BP1 | AD_PSTCD2 | CHAR10 | CHAR | 10 | 0 | PO Box postal code | ||
81 | ROLE_BP2 | REBPROLE2 | BU_ROLE | CHAR | 6 | 0 | Second Main Contractual Partner: Role | * | |
82 | XROLE_BP2 | REBPXROLE2 | RECAXMDESCRIPTION | CHAR | 30 | 0 | 2nd Main Contractual Partner: Name of Role Category | ||
83 | PARTNER_BP2 | REBPPARTNER2 | BU_PARTNER | CHAR | 10 | 0 | Second Main Contractual Partner | * | |
84 | XPARTNER_BP2 | REBPXPARTNER2 | TEXT80 | CHAR | 80 | 0 | Name/Address of 2nd Business Partner | ||
85 | TEL_NUMBER_LONG_BP2 | AD_TELNRLG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
86 | FAX_NUMBER_LONG_BP2 | AD_FXNRLNG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
87 | SMTP_ADDR_BP2 | AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | ||
88 | XNAME_BP2 | REBPXNAME2 | BU_TEXT50 | CHAR | 50 | 0 | Short Description of 2nd Business Partner | ||
89 | STREET_BP2 | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
90 | HOUSE_NUM1_BP2 | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
91 | POST_CODE1_BP2 | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
92 | CITY1_BP2 | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
93 | CITY2_BP2 | AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
94 | REGION_BP2 | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
95 | PO_BOX_BP2 | AD_POBX | CHAR10 | CHAR | 10 | 0 | PO Box | ||
96 | POST_CODE2_BP2 | AD_PSTCD2 | CHAR10 | CHAR | 10 | 0 | PO Box postal code |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | REIS_CN_OA_L | MEASUNIT | T006 | MSEHI | REF | 1 | CN |
2 | REIS_CN_OA_L | OBJASSTYPE | TIVBDOBJASSTYPE | OBJASSTYPE | KEY | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 605 |