SAP ABAP Table RECP_OI_DOC_CN (Document Data: Contract)
Hierarchy
☛
EA-FIN (Software Component) EA-FIN
⤷ RE-FX-CP (Application Component) Correspondence
⤷ RE_CP_OI (Package) RE: Office Integration (Correspondence with OfficeIntegr.)
⤷ RE-FX-CP (Application Component) Correspondence
⤷ RE_CP_OI (Package) RE: Office Integration (Correspondence with OfficeIntegr.)
Basic Data
Table Category | INTTAB | Structure |
Structure | RECP_OI_DOC_CN | Table Relationship Diagram |
Short Description | Document Data: Contract |
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 | .INCLUDE | 0 | 0 | Real Estate Contract and Additional Fields | |||||
2 | .INCLUDE | 0 | 0 | Real Estate Contract | |||||
3 | .INCLUDE | 0 | 0 | Real Estate Contract | |||||
4 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
5 | INTRENO | RECAINTRENO | RECAINTRENO | CHAR | 13 | 0 | Internal Key of Real Estate Object | ||
6 | .INCLUDE | 0 | 0 | RE Contract: Key Fields | |||||
7 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
8 | RECNNR | RECNNUMBER | RECNNUMBER | CHAR | 13 | 0 | Contract Number | ||
9 | .INCLUDE | 0 | 0 | RE Contract: Non-Key Fields | |||||
10 | OBJNR | RECAOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number | * | |
11 | IMKEY | RECAIMKEY | IMKEY | CHAR | 8 | 0 | Internal Key of Real Estate Object (FI) | ||
12 | CREATIONTYPE | RECACREATIONTYPE | RECACREATIONTYPE | CHAR | 1 | 0 | How the Object Was Created | ||
13 | .INCLUDE | 0 | 0 | Field String for Maintenance of User Data | |||||
14 | RERF | RERF | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
15 | DERF | DERF | DATUM | DATS | 8 | 0 | First Entered on | ||
16 | TERF | TERF | TIMES | TIMS | 6 | 0 | Time of Initial Entry | ||
17 | REHER | REHER | CHAR10 | CHAR | 10 | 0 | Source of initial entry | ||
18 | RBEAR | RBEAR | SYCHAR12 | CHAR | 12 | 0 | Employee ID | ||
19 | DBEAR | DBEAR | DATUM | DATS | 8 | 0 | Last Edited on | ||
20 | TBEAR | TBEAR | TIMES | TIMS | 6 | 0 | Last Edited at | ||
21 | RBHER | RBHER | CHAR10 | CHAR | 10 | 0 | Editing Source | ||
22 | RESPONSIBLE | RECARESPONSIBLE | XUBNAME | CHAR | 12 | 0 | Person Responsible | USR02 | |
23 | USEREXCLUSIVE | RECAUSEREXCLUSIVE | XUBNAME | CHAR | 12 | 0 | User with Exclusive Change Authorization | USR02 | |
24 | AUTHGRP | RECAAUTHGRP | RECAAUTHGRP | CHAR | 40 | 0 | Authorization Group | ||
25 | RECNTYPE | RECNCONTRACTTYPE | SMVART | CHAR | 4 | 0 | Contract Type | TIV26 | |
26 | RECNBEG | RECNCNBEG | RECADATE | DATS | 8 | 0 | Date of contract start | ||
27 | RECNENDABS | RECNCNENDABS | RECADATEEND | DATS | 8 | 0 | Term End Date | ||
28 | RECNTXT | RECNTXT | XTEXT80 | CHAR | 80 | 0 | Contract name | ||
29 | RECNDACTIV | DAKTV | DATUM | DATS | 8 | 0 | Contract activation | ||
30 | RECNTLAW | SMIETR | SMIETR | CHAR | 5 | 0 | Tenancy law | TIV03 | |
31 | RECNTXTOLD | VVOSMIVE | VVOSMIVE | CHAR | 20 | 0 | Number of old contract | ||
32 | RECNBUKRSCOLLECT | RECNBUKRSCOLLECT | BUKRS | CHAR | 4 | 0 | Company code of main contract | T001 | |
33 | RECNNRCOLLECT | RECNNUMBERCOLLECT | RECNNUMBER | CHAR | 13 | 0 | Number of Real Estate Main Contract | ||
34 | RECNCNCURR | RECNWAERS_CN | WAERS | CUKY | 5 | 0 | Currency for Contract | * | |
35 | INDUSTRY | BU_IND_SECTOR | BU_INDSECTOR | CHAR | 10 | 0 | Industry | * | |
36 | SRRELEVANT | RECNSALESRENTRELEVANT | RECABOOL | CHAR | 1 | 0 | Relevant to Sales | ||
37 | DPTARGETTYPE | RECNDPTYPE | RECNDPTYPE | CHAR | 4 | 0 | Security Deposit Type | TIVCNDPTYPE | |
38 | RECNDAT | RECNDAT | DDAT | DATS | 8 | 0 | Date of Contract Conclusion | ||
39 | RECN2DAT | RECN2DAT | RECADATE | DATS | 8 | 0 | Date of Second Signature | ||
40 | RECNDPO | RECDCFSTARTFROM | RECADATE | DATS | 8 | 0 | Cash Flow Generated Starting On | ||
41 | RECNEND1ST | RECNCNEND1ST | RECADATE | DATS | 8 | 0 | Date of First Contract End | ||
42 | RECNNOTPER | RECNNTPER | RECADATE | DATS | 8 | 0 | Contract Notice Per | ||
43 | RECNNOTRECEIPT | RECNNTRECEIPT | RECADATE | DATS | 8 | 0 | Date of receipt of notice | ||
44 | RECNNOTREASON | RECNNTREASON | RECNNTREASON | NUMC | 2 | 0 | Reason for Notice | TIVCNNTRE | |
45 | RECNDAKTKU | RECNNTACTIVATEDON | RECADATE | DATS | 8 | 0 | Notice: Date of Activation | ||
46 | CFARCHIVEDTO | RECDCFARCHIVEDTO | RECADATE | DATS | 8 | 0 | Date Up to Which the Cash Flow Is Archived | ||
47 | CFLOCKEDTO | RECDCFLOCKEDTO | RECADATE | DATS | 8 | 0 | Date Until Which the Cash Flow Is Locked | ||
48 | CFPOSTINGFROM | RECDCFPOSTINGFROM | RECADATE | DATS | 8 | 0 | First Posting From | ||
49 | BENOCN | RECNBENOCN | REBDBENO | CHAR | 8 | 0 | Business Entity That Belongs to Contract | * | |
50 | TRANSPOSSFROM | RECNTRANSPOSSFROM | RECADATEBEG | DATS | 8 | 0 | Transfer of Possession: Start Date | ||
51 | TRANSPOSSTO | RECNTRANSPOSSTO | RECADATEEND | DATS | 8 | 0 | Transfer of Possession: End Date | ||
52 | HASMULTIASSIGN | REBDHASMULTIASSIGN | RECABOOL | CHAR | 1 | 0 | Multiple Assignment of Object to Group Allowed | ||
53 | POSSDATEFROM | REBDPOSSDATEFROM | RECADATE | DATS | 8 | 0 | Date From Which the Object Is Made Available for Use | ||
54 | POSSDATETO | REBDPOSSDATETO | RECADATE | DATS | 8 | 0 | Date Up to Which the Object Is Used | ||
55 | .INCLUDE | 0 | 0 | ||||||
56 | .INCLU--AP | 0 | 0 | Country Specific Fields for Spain | |||||
57 | .INCLUDE | 0 | 0 | Country-Specific Fields for Spain - Contract | |||||
58 | SECDEPRELEVANT | REXCESCDREL | XFELD | CHAR | 1 | 0 | Relevant to Security Deposit | ||
59 | NOTADJSDCN | REXCESCDNOTADJ | RECABOOL | CHAR | 1 | 0 | No Data Update in Security Deposit Contract | ||
60 | XRECNNRCOL | RECNTXT | XTEXT80 | CHAR | 80 | 0 | Contract name | ||
61 | XBUKRS | BUTXT | TEXT25 | CHAR | 25 | 0 | Name of Company Code or Company | ||
62 | XRECNTYPE | XMVARTM | XMBEZ | CHAR | 30 | 0 | Description of type of RE contract type | ||
63 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
64 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
65 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
66 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
67 | XTENANCYLAW | XMIETR | XTEXT50 | CHAR | 50 | 0 | Tenancy law long text | ||
68 | XCOLLECT | RECNTXT | XTEXT80 | CHAR | 80 | 0 | Contract name | ||
69 | XAUTHGRP | RECAXAUTHGRP | RECAXLDESCRIPTION | CHAR | 60 | 0 | Description of Authorization Group | ||
70 | XINDUSTRY | RECNINDUSTRY | TEXT20 | CHAR | 20 | 0 | Industry Name | ||
71 | XTRANSPOSSPERIOD | RECNXTRANSPOSSPERIOD | RECAXMDESCRIPTION | CHAR | 30 | 0 | Productive Holdings: Time Period | ||
72 | .INCLUDE | 0 | 0 | General Output Parameters | |||||
73 | TEMPLATE | RECPOITEMPLATE | TEXT64 | CHAR | 64 | 0 | Template for Printing with Office Application | ||
74 | LANGU | RECPOILANGU | SPRAS | LANG | 1 | 0 | Language for Document Creation | * | |
75 | SELDATE | RECPOISELDATE | RECADATE | DATS | 8 | 0 | Key Date for Data Selection | ||
76 | PRNDATE | RECPOIPRNDATE | RECADATE | DATS | 8 | 0 | Print Date | ||
77 | .INCLUDE | 0 | 0 | General Data for the Business Object | |||||
78 | IDENTKEY | RECAIDENTKEY | CHAR45 | CHAR | 45 | 0 | ID Part Key, for example "1000/123" | ||
79 | IDENT | RECAIDENT | CHAR50 | CHAR | 50 | 0 | Complete Object Identification, for Example BE 1000/123 | ||
80 | XIDENT | RECAXIDENT | TEXT80 | CHAR | 80 | 0 | Object ID, for Example, Business Entity 1000/123 | ||
81 | XOBJTYPE | RECAXOBJTYPE | CHAR3 | CHAR | 3 | 0 | Partial Object Type ID, for example "BE" | ||
82 | XLOBJTYPE | RECAXLOBJTYPE | TEXT20 | CHAR | 20 | 0 | Object Type Name (20) | ||
83 | BUSTYPE | SWO_OBJTYP | OJ_NAME | CHAR | 10 | 0 | Object Type | * | |
84 | BUSKEY | SWO_TYPEID | SWO_TYPEID | CHAR | 70 | 0 | Object key | ||
85 | .INCLUDE | 0 | 0 | Sender (Company Code Data) | |||||
86 | .INCLU-_SE | 0 | 0 | Company Code Data | |||||
87 | BUKRS_SE | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
88 | BUTXT_SE | BUTXT | TEXT25 | CHAR | 25 | 0 | Name of Company Code or Company | ||
89 | ORT01_SE | ORT01 | TEXT25 | CHAR | 25 | 0 | City | ||
90 | LAND1_SE | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
91 | WAERS_SE | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
92 | SPRAS_SE | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | * | |
93 | KTOPL_SE | KTOPL | KTOPL | CHAR | 4 | 0 | Chart of Accounts | * | |
94 | WAABW_SE | WAABW_001 | NUM02 | NUMC | 2 | 0 | Maximum exchange rate deviation in percent | ||
95 | PERIV_SE | PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | * | |
96 | KOKFI_SE | KOKFI | KOKFI | CHAR | 1 | 0 | Allocation Indicator | ||
97 | RCOMP_SE | RCOMP_D | RCOMP | CHAR | 6 | 0 | Company | * | |
98 | ADRNR_SE | ADRNR | ADRNR | CHAR | 10 | 0 | Address | * | |
99 | STCEG_SE | STCEG | STCEG | CHAR | 20 | 0 | VAT Registration Number | ||
100 | FIKRS_SE | FIKRS | FIKRS | CHAR | 4 | 0 | Financial Management Area | * | |
101 | TXJCD_SE | TXJCD_NSTX | TXJCD | CHAR | 15 | 0 | Jurisdiction for tax calculation - tax jurisdiction code | * | |
102 | .INCLUDE | 0 | 0 | Recipient | |||||
103 | .INCLU-_RC | 0 | 0 | Business Partner: General Data | |||||
104 | PARTNER_RC | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
105 | PARTN_CAT_RC | BU_TYPE | BU_TYPE | CHAR | 1 | 0 | Business partner category | ||
106 | SEARCHTERM1_RC | BU_SORT1 | BU_SORT1 | CHAR | 20 | 0 | Search term 1 for business partner | ||
107 | SEARCHTERM2_RC | BU_SORT2 | BU_SORT1 | CHAR | 20 | 0 | Search term 2 for business partner | ||
108 | FIRSTNAME_RC | BU_NAMEP_F | BU_NAME | CHAR | 40 | 0 | First name of business partner (person) | ||
109 | LASTNAME_RC | BU_NAMEP_L | BU_NAME | CHAR | 40 | 0 | Last name of business partner (person) | ||
110 | NAME1_RC | BU_NAMEOR1 | BU_NAME | CHAR | 40 | 0 | Name 1 of organization | ||
111 | NAME2_RC | BU_NAMEOR2 | BU_NAME | CHAR | 40 | 0 | Name 2 of organization | ||
112 | NAME3_RC | BU_NAMEOR3 | BU_NAME | CHAR | 40 | 0 | Name 3 of organization | ||
113 | NAME4_RC | BU_NAMEOR4 | BU_NAME | CHAR | 40 | 0 | Name 4 of organization | ||
114 | NAMEGROUP1_RC | BU_NAMEGR1 | BU_NAME | CHAR | 40 | 0 | Name 1 (group) | ||
115 | NAMEGROUP2_RC | BU_NAMEGR2 | BU_NAME | CHAR | 40 | 0 | Name 2 (group) | ||
116 | XNAME_RC | REBPXNAME | BU_TEXT50 | CHAR | 50 | 0 | Short Name of Business Partner | ||
117 | XPARTNER_RC | REBPXPARTNER | TEXT80 | CHAR | 80 | 0 | Name/Address of Business Partner | ||
118 | XSALUTATION_RC | REBPXSALUTATION | CHAR80 | CHAR | 80 | 0 | Salutation for Business Partner | ||
119 | XADDRESS_RC | REBPXADDRESS | REBPXADDRESS | CHAR | 80 | 0 | Compact Display of Address | ||
120 | LINE0_RC | LINES | LINES | CHAR | 80 | 0 | Address line | ||
121 | LINE1_RC | LINES | LINES | CHAR | 80 | 0 | Address line | ||
122 | LINE2_RC | LINES | LINES | CHAR | 80 | 0 | Address line | ||
123 | LINE3_RC | LINES | LINES | CHAR | 80 | 0 | Address line | ||
124 | LINE4_RC | LINES | LINES | CHAR | 80 | 0 | Address line | ||
125 | LINE5_RC | LINES | LINES | CHAR | 80 | 0 | Address line | ||
126 | LINE6_RC | LINES | LINES | CHAR | 80 | 0 | Address line | ||
127 | LINE7_RC | LINES | LINES | CHAR | 80 | 0 | Address line | ||
128 | LINE8_RC | LINES | LINES | CHAR | 80 | 0 | Address line | ||
129 | LINE9_RC | LINES | LINES | CHAR | 80 | 0 | Address line | ||
130 | ADDRCATE_RC | AD_ADRTYPE | AD_ADRTYPE | CHAR | 1 | 0 | Address type (1=Organization, 2=Person, 3=Contact person) | ||
131 | ADDRNUMBER_RC | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | * | |
132 | PERSNUMBER_RC | AD_PERSNUM | AD_PERSNUM | CHAR | 10 | 0 | Person number | * | |
133 | SMTP_ADDR_RC | AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | ||
134 | TEL_COUNTRY_RC | AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
135 | TEL_NUMBER_RC | AD_TLNMBR | CHAR30 | CHAR | 30 | 0 | Telephone no.: dialling code+number | ||
136 | TEL_EXTENS_RC | AD_TLXTNS | CHAR10 | CHAR | 10 | 0 | Telephone no.: Extension | ||
137 | TEL_NUMBER_LONG_RC | AD_TELNRLG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
138 | FAX_COUNTRY_RC | AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
139 | FAX_NUMBER_RC | AD_FXNMBR | CHAR30 | CHAR | 30 | 0 | Fax number: dialling code+number | ||
140 | FAX_EXTENS_RC | AD_FXXTNS | CHAR10 | CHAR | 10 | 0 | Fax no.: Extension | ||
141 | FAX_NUMBER_LONG_RC | AD_FXNRLNG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
142 | INTRENO_RC | RECAINTRENO | RECAINTRENO | CHAR | 13 | 0 | Internal Key of Real Estate Object | ||
143 | ROLE_RC | REBPROLE | BU_ROLE | CHAR | 6 | 0 | Business Partner: Role | * | |
144 | XROLE_RC | REBPXROLE | RECAXMDESCRIPTION | CHAR | 30 | 0 | Name of Business Partner Role | ||
145 | SUBROLE_RC | REBPSUBROLE | REBPSUBROLE | CHAR | 4 | 0 | Business Partner: Role Type | TIVBPSUBROLE | |
146 | XSUBROLE_RC | REBPXSUBROLE | RECAXMDESCRIPTION | CHAR | 30 | 0 | Name of Role Type | ||
147 | ROLECATE_RC | REBPROLECATE | REBPROLECATE | CHAR | 1 | 0 | Category of Role Category | ||
148 | APPL_RC | REBPAPPL | BP_APPL | CHAR | 4 | 0 | Business Partner: Application Category | * | |
149 | VALIDFROM_RC | REBPVALIDFROM | RECADATEBEG | DATS | 8 | 0 | Date of Start of Relationship | ||
150 | VALIDTO_RC | REBPVALIDTO | RECADATEEND | DATS | 8 | 0 | Date of End of Relationship | ||
151 | ADDRTYPE_RC | REBPADDRTYPE | BU_ADRKIND | CHAR | 10 | 0 | Address Type | * | |
152 | .INCLUDE | 0 | 0 | Clerk | |||||
153 | .INCLU-_CL | 0 | 0 | Business Partner: General Data | |||||
154 | PARTNER_CL | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
155 | PARTN_CAT_CL | BU_TYPE | BU_TYPE | CHAR | 1 | 0 | Business partner category | ||
156 | SEARCHTERM1_CL | BU_SORT1 | BU_SORT1 | CHAR | 20 | 0 | Search term 1 for business partner | ||
157 | SEARCHTERM2_CL | BU_SORT2 | BU_SORT1 | CHAR | 20 | 0 | Search term 2 for business partner | ||
158 | FIRSTNAME_CL | BU_NAMEP_F | BU_NAME | CHAR | 40 | 0 | First name of business partner (person) | ||
159 | LASTNAME_CL | BU_NAMEP_L | BU_NAME | CHAR | 40 | 0 | Last name of business partner (person) | ||
160 | NAME1_CL | BU_NAMEOR1 | BU_NAME | CHAR | 40 | 0 | Name 1 of organization | ||
161 | NAME2_CL | BU_NAMEOR2 | BU_NAME | CHAR | 40 | 0 | Name 2 of organization | ||
162 | NAME3_CL | BU_NAMEOR3 | BU_NAME | CHAR | 40 | 0 | Name 3 of organization | ||
163 | NAME4_CL | BU_NAMEOR4 | BU_NAME | CHAR | 40 | 0 | Name 4 of organization | ||
164 | NAMEGROUP1_CL | BU_NAMEGR1 | BU_NAME | CHAR | 40 | 0 | Name 1 (group) | ||
165 | NAMEGROUP2_CL | BU_NAMEGR2 | BU_NAME | CHAR | 40 | 0 | Name 2 (group) | ||
166 | XNAME_CL | REBPXNAME | BU_TEXT50 | CHAR | 50 | 0 | Short Name of Business Partner | ||
167 | XPARTNER_CL | REBPXPARTNER | TEXT80 | CHAR | 80 | 0 | Name/Address of Business Partner | ||
168 | XSALUTATION_CL | REBPXSALUTATION | CHAR80 | CHAR | 80 | 0 | Salutation for Business Partner | ||
169 | XADDRESS_CL | REBPXADDRESS | REBPXADDRESS | CHAR | 80 | 0 | Compact Display of Address | ||
170 | LINE0_CL | LINES | LINES | CHAR | 80 | 0 | Address line | ||
171 | LINE1_CL | LINES | LINES | CHAR | 80 | 0 | Address line | ||
172 | LINE2_CL | LINES | LINES | CHAR | 80 | 0 | Address line | ||
173 | LINE3_CL | LINES | LINES | CHAR | 80 | 0 | Address line | ||
174 | LINE4_CL | LINES | LINES | CHAR | 80 | 0 | Address line | ||
175 | LINE5_CL | LINES | LINES | CHAR | 80 | 0 | Address line | ||
176 | LINE6_CL | LINES | LINES | CHAR | 80 | 0 | Address line | ||
177 | LINE7_CL | LINES | LINES | CHAR | 80 | 0 | Address line | ||
178 | LINE8_CL | LINES | LINES | CHAR | 80 | 0 | Address line | ||
179 | LINE9_CL | LINES | LINES | CHAR | 80 | 0 | Address line | ||
180 | ADDRCATE_CL | AD_ADRTYPE | AD_ADRTYPE | CHAR | 1 | 0 | Address type (1=Organization, 2=Person, 3=Contact person) | ||
181 | ADDRNUMBER_CL | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | * | |
182 | PERSNUMBER_CL | AD_PERSNUM | AD_PERSNUM | CHAR | 10 | 0 | Person number | * | |
183 | SMTP_ADDR_CL | AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | ||
184 | TEL_COUNTRY_CL | AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
185 | TEL_NUMBER_CL | AD_TLNMBR | CHAR30 | CHAR | 30 | 0 | Telephone no.: dialling code+number | ||
186 | TEL_EXTENS_CL | AD_TLXTNS | CHAR10 | CHAR | 10 | 0 | Telephone no.: Extension | ||
187 | TEL_NUMBER_LONG_CL | AD_TELNRLG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
188 | FAX_COUNTRY_CL | AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
189 | FAX_NUMBER_CL | AD_FXNMBR | CHAR30 | CHAR | 30 | 0 | Fax number: dialling code+number | ||
190 | FAX_EXTENS_CL | AD_FXXTNS | CHAR10 | CHAR | 10 | 0 | Fax no.: Extension | ||
191 | FAX_NUMBER_LONG_CL | AD_FXNRLNG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
192 | INTRENO_CL | RECAINTRENO | RECAINTRENO | CHAR | 13 | 0 | Internal Key of Real Estate Object | ||
193 | ROLE_CL | REBPROLE | BU_ROLE | CHAR | 6 | 0 | Business Partner: Role | * | |
194 | XROLE_CL | REBPXROLE | RECAXMDESCRIPTION | CHAR | 30 | 0 | Name of Business Partner Role | ||
195 | SUBROLE_CL | REBPSUBROLE | REBPSUBROLE | CHAR | 4 | 0 | Business Partner: Role Type | TIVBPSUBROLE | |
196 | XSUBROLE_CL | REBPXSUBROLE | RECAXMDESCRIPTION | CHAR | 30 | 0 | Name of Role Type | ||
197 | ROLECATE_CL | REBPROLECATE | REBPROLECATE | CHAR | 1 | 0 | Category of Role Category | ||
198 | APPL_CL | REBPAPPL | BP_APPL | CHAR | 4 | 0 | Business Partner: Application Category | * | |
199 | VALIDFROM_CL | REBPVALIDFROM | RECADATEBEG | DATS | 8 | 0 | Date of Start of Relationship | ||
200 | VALIDTO_CL | REBPVALIDTO | RECADATEEND | DATS | 8 | 0 | Date of End of Relationship | ||
201 | ADDRTYPE_CL | REBPADDRTYPE | BU_ADRKIND | CHAR | 10 | 0 | Address Type | * | |
202 | .INCLUDE | 0 | 0 | Further Partner 1 | |||||
203 | .INCLU-_P1 | 0 | 0 | Business Partner: General Data | |||||
204 | PARTNER_P1 | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
205 | PARTN_CAT_P1 | BU_TYPE | BU_TYPE | CHAR | 1 | 0 | Business partner category | ||
206 | SEARCHTERM1_P1 | BU_SORT1 | BU_SORT1 | CHAR | 20 | 0 | Search term 1 for business partner | ||
207 | SEARCHTERM2_P1 | BU_SORT2 | BU_SORT1 | CHAR | 20 | 0 | Search term 2 for business partner | ||
208 | FIRSTNAME_P1 | BU_NAMEP_F | BU_NAME | CHAR | 40 | 0 | First name of business partner (person) | ||
209 | LASTNAME_P1 | BU_NAMEP_L | BU_NAME | CHAR | 40 | 0 | Last name of business partner (person) | ||
210 | NAME1_P1 | BU_NAMEOR1 | BU_NAME | CHAR | 40 | 0 | Name 1 of organization | ||
211 | NAME2_P1 | BU_NAMEOR2 | BU_NAME | CHAR | 40 | 0 | Name 2 of organization | ||
212 | NAME3_P1 | BU_NAMEOR3 | BU_NAME | CHAR | 40 | 0 | Name 3 of organization | ||
213 | NAME4_P1 | BU_NAMEOR4 | BU_NAME | CHAR | 40 | 0 | Name 4 of organization | ||
214 | NAMEGROUP1_P1 | BU_NAMEGR1 | BU_NAME | CHAR | 40 | 0 | Name 1 (group) | ||
215 | NAMEGROUP2_P1 | BU_NAMEGR2 | BU_NAME | CHAR | 40 | 0 | Name 2 (group) | ||
216 | XNAME_P1 | REBPXNAME | BU_TEXT50 | CHAR | 50 | 0 | Short Name of Business Partner | ||
217 | XPARTNER_P1 | REBPXPARTNER | TEXT80 | CHAR | 80 | 0 | Name/Address of Business Partner | ||
218 | XSALUTATION_P1 | REBPXSALUTATION | CHAR80 | CHAR | 80 | 0 | Salutation for Business Partner | ||
219 | XADDRESS_P1 | REBPXADDRESS | REBPXADDRESS | CHAR | 80 | 0 | Compact Display of Address | ||
220 | LINE0_P1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
221 | LINE1_P1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
222 | LINE2_P1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
223 | LINE3_P1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
224 | LINE4_P1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
225 | LINE5_P1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
226 | LINE6_P1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
227 | LINE7_P1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
228 | LINE8_P1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
229 | LINE9_P1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
230 | ADDRCATE_P1 | AD_ADRTYPE | AD_ADRTYPE | CHAR | 1 | 0 | Address type (1=Organization, 2=Person, 3=Contact person) | ||
231 | ADDRNUMBER_P1 | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | * | |
232 | PERSNUMBER_P1 | AD_PERSNUM | AD_PERSNUM | CHAR | 10 | 0 | Person number | * | |
233 | SMTP_ADDR_P1 | AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | ||
234 | TEL_COUNTRY_P1 | AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
235 | TEL_NUMBER_P1 | AD_TLNMBR | CHAR30 | CHAR | 30 | 0 | Telephone no.: dialling code+number | ||
236 | TEL_EXTENS_P1 | AD_TLXTNS | CHAR10 | CHAR | 10 | 0 | Telephone no.: Extension | ||
237 | TEL_NUMBER_LONG_P1 | AD_TELNRLG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
238 | FAX_COUNTRY_P1 | AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
239 | FAX_NUMBER_P1 | AD_FXNMBR | CHAR30 | CHAR | 30 | 0 | Fax number: dialling code+number | ||
240 | FAX_EXTENS_P1 | AD_FXXTNS | CHAR10 | CHAR | 10 | 0 | Fax no.: Extension | ||
241 | FAX_NUMBER_LONG_P1 | AD_FXNRLNG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
242 | INTRENO_P1 | RECAINTRENO | RECAINTRENO | CHAR | 13 | 0 | Internal Key of Real Estate Object | ||
243 | ROLE_P1 | REBPROLE | BU_ROLE | CHAR | 6 | 0 | Business Partner: Role | * | |
244 | XROLE_P1 | REBPXROLE | RECAXMDESCRIPTION | CHAR | 30 | 0 | Name of Business Partner Role | ||
245 | SUBROLE_P1 | REBPSUBROLE | REBPSUBROLE | CHAR | 4 | 0 | Business Partner: Role Type | TIVBPSUBROLE | |
246 | XSUBROLE_P1 | REBPXSUBROLE | RECAXMDESCRIPTION | CHAR | 30 | 0 | Name of Role Type | ||
247 | ROLECATE_P1 | REBPROLECATE | REBPROLECATE | CHAR | 1 | 0 | Category of Role Category | ||
248 | APPL_P1 | REBPAPPL | BP_APPL | CHAR | 4 | 0 | Business Partner: Application Category | * | |
249 | VALIDFROM_P1 | REBPVALIDFROM | RECADATEBEG | DATS | 8 | 0 | Date of Start of Relationship | ||
250 | VALIDTO_P1 | REBPVALIDTO | RECADATEEND | DATS | 8 | 0 | Date of End of Relationship | ||
251 | ADDRTYPE_P1 | REBPADDRTYPE | BU_ADRKIND | CHAR | 10 | 0 | Address Type | * | |
252 | .INCLUDE | 0 | 0 | Further Partner 2 | |||||
253 | .INCLU-_P2 | 0 | 0 | Business Partner: General Data | |||||
254 | PARTNER_P2 | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
255 | PARTN_CAT_P2 | BU_TYPE | BU_TYPE | CHAR | 1 | 0 | Business partner category | ||
256 | SEARCHTERM1_P2 | BU_SORT1 | BU_SORT1 | CHAR | 20 | 0 | Search term 1 for business partner | ||
257 | SEARCHTERM2_P2 | BU_SORT2 | BU_SORT1 | CHAR | 20 | 0 | Search term 2 for business partner | ||
258 | FIRSTNAME_P2 | BU_NAMEP_F | BU_NAME | CHAR | 40 | 0 | First name of business partner (person) | ||
259 | LASTNAME_P2 | BU_NAMEP_L | BU_NAME | CHAR | 40 | 0 | Last name of business partner (person) | ||
260 | NAME1_P2 | BU_NAMEOR1 | BU_NAME | CHAR | 40 | 0 | Name 1 of organization | ||
261 | NAME2_P2 | BU_NAMEOR2 | BU_NAME | CHAR | 40 | 0 | Name 2 of organization | ||
262 | NAME3_P2 | BU_NAMEOR3 | BU_NAME | CHAR | 40 | 0 | Name 3 of organization | ||
263 | NAME4_P2 | BU_NAMEOR4 | BU_NAME | CHAR | 40 | 0 | Name 4 of organization | ||
264 | NAMEGROUP1_P2 | BU_NAMEGR1 | BU_NAME | CHAR | 40 | 0 | Name 1 (group) | ||
265 | NAMEGROUP2_P2 | BU_NAMEGR2 | BU_NAME | CHAR | 40 | 0 | Name 2 (group) | ||
266 | XNAME_P2 | REBPXNAME | BU_TEXT50 | CHAR | 50 | 0 | Short Name of Business Partner | ||
267 | XPARTNER_P2 | REBPXPARTNER | TEXT80 | CHAR | 80 | 0 | Name/Address of Business Partner | ||
268 | XSALUTATION_P2 | REBPXSALUTATION | CHAR80 | CHAR | 80 | 0 | Salutation for Business Partner | ||
269 | XADDRESS_P2 | REBPXADDRESS | REBPXADDRESS | CHAR | 80 | 0 | Compact Display of Address | ||
270 | LINE0_P2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
271 | LINE1_P2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
272 | LINE2_P2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
273 | LINE3_P2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
274 | LINE4_P2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
275 | LINE5_P2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
276 | LINE6_P2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
277 | LINE7_P2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
278 | LINE8_P2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
279 | LINE9_P2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
280 | ADDRCATE_P2 | AD_ADRTYPE | AD_ADRTYPE | CHAR | 1 | 0 | Address type (1=Organization, 2=Person, 3=Contact person) | ||
281 | ADDRNUMBER_P2 | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | * | |
282 | PERSNUMBER_P2 | AD_PERSNUM | AD_PERSNUM | CHAR | 10 | 0 | Person number | * | |
283 | SMTP_ADDR_P2 | AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | ||
284 | TEL_COUNTRY_P2 | AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
285 | TEL_NUMBER_P2 | AD_TLNMBR | CHAR30 | CHAR | 30 | 0 | Telephone no.: dialling code+number | ||
286 | TEL_EXTENS_P2 | AD_TLXTNS | CHAR10 | CHAR | 10 | 0 | Telephone no.: Extension | ||
287 | TEL_NUMBER_LONG_P2 | AD_TELNRLG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
288 | FAX_COUNTRY_P2 | AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
289 | FAX_NUMBER_P2 | AD_FXNMBR | CHAR30 | CHAR | 30 | 0 | Fax number: dialling code+number | ||
290 | FAX_EXTENS_P2 | AD_FXXTNS | CHAR10 | CHAR | 10 | 0 | Fax no.: Extension | ||
291 | FAX_NUMBER_LONG_P2 | AD_FXNRLNG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
292 | INTRENO_P2 | RECAINTRENO | RECAINTRENO | CHAR | 13 | 0 | Internal Key of Real Estate Object | ||
293 | ROLE_P2 | REBPROLE | BU_ROLE | CHAR | 6 | 0 | Business Partner: Role | * | |
294 | XROLE_P2 | REBPXROLE | RECAXMDESCRIPTION | CHAR | 30 | 0 | Name of Business Partner Role | ||
295 | SUBROLE_P2 | REBPSUBROLE | REBPSUBROLE | CHAR | 4 | 0 | Business Partner: Role Type | TIVBPSUBROLE | |
296 | XSUBROLE_P2 | REBPXSUBROLE | RECAXMDESCRIPTION | CHAR | 30 | 0 | Name of Role Type | ||
297 | ROLECATE_P2 | REBPROLECATE | REBPROLECATE | CHAR | 1 | 0 | Category of Role Category | ||
298 | APPL_P2 | REBPAPPL | BP_APPL | CHAR | 4 | 0 | Business Partner: Application Category | * | |
299 | VALIDFROM_P2 | REBPVALIDFROM | RECADATEBEG | DATS | 8 | 0 | Date of Start of Relationship | ||
300 | VALIDTO_P2 | REBPVALIDTO | RECADATEEND | DATS | 8 | 0 | Date of End of Relationship | ||
301 | ADDRTYPE_P2 | REBPADDRTYPE | BU_ADRKIND | CHAR | 10 | 0 | Address Type | * | |
302 | .INCLU--AP | 0 | 0 | Rental Object Information | |||||
303 | .INCLUDE | 0 | 0 | Rental Object Customer fields | |||||
304 | .INCLUDE | 0 | 0 | Rental Object Customer fields | |||||
305 | .INCLUDE | 0 | 0 | Rental Object Customer fields | |||||
306 | EDID | REXCCHEDID | REXCCHEDID | NUMC | 2 | 0 | Federal Building Entrance Identification Number (EDID) | ||
307 | EGID | REXCCHEGID | REXCCHEGID | NUMC | 9 | 0 | Federal Building Identification Number (EGID) | ||
308 | FLOOR | REXCCHROFLOOR | REXCCHROFLOOR | NUMC | 4 | 0 | Code of Floor | * | |
309 | FLOORLOC | REXCCHROFLOORLOC | REXCCHROFLOORLOC | CHAR | 40 | 0 | Location of Dwelling on a Floor | ||
310 | EWID | REXCCHEWID | REXCCHEWID | NUMC | 3 | 0 | Federal Dwelling Identification Number (EWID) | ||
311 | KITCHEN | REXCCHROKITCHEN | REXCCHROKITCHEN | NUMC | 4 | 0 | Code of Cooking Facilities | * | |
312 | ADMINNO | REXCCHROADMINNO | REXCCHROADMINNO | CHAR | 12 | 0 | Administrative Dwelling Number | ||
313 | DOORNO | REXCCHRODOORNO | REXCCHRODOORNO | CHAR | 8 | 0 | Door Number of Dwelling | ||
314 | OBJCOND | REXCCHROCOND | REXCCHROCOND | NUMC | 4 | 0 | Code of Dwelling Status | * | |
315 | YEARDECONSTR | REXCCHBUDECONYEAR | DATUM | DATS | 8 | 0 | Year of Demolition | ||
316 | NUMROOMS | REXCCHRONUMROOMS | REXCCHRONUMROOMS | NUMC | 4 | 0 | Number of Rooms in the Dwelling | ||
317 | LIVINGAREA | REXCCHROAREA | REXCCHGWRFORMATUNITFIELD | DEC | 10 | 2 | Floor Area of Dwelling in M2 | ||
318 | USAGETYPE | REXCCHROUSAGETYPE | REXCCHROUSAGETYPE | NUMC | 4 | 0 | Code of Usage Type | * | |
319 | GEMEINDECH | RELMLRDISTRICT | RELMLRDISTRICT | CHAR | 6 | 0 | Land Register District | * | |
320 | XKITCHEN | REXCCHXROKITCHEN | RECAXLDESCRIPTION | CHAR | 60 | 0 | Description of Cooking Facilities | ||
321 | XFLOOR | REXCCHXROFLOOR | RECAXLDESCRIPTION | CHAR | 60 | 0 | Description of Floor | ||
322 | XCONDITION | REXCCHXROCOND | RECAXLDESCRIPTION | CHAR | 60 | 0 | Description of Dwelling Status | ||
323 | XUSAGETYPE | REXCCHXROUSAGETYPE | RECAXLDESCRIPTION | CHAR | 60 | 0 | Description of Usage Type | ||
324 | XADDRESS_RO | REBPXADDRESS | REBPXADDRESS | CHAR | 80 | 0 | Compact Display of Address |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RECP_OI_DOC_CN | BUKRS | T001 | BUKRS | KEY | 1 | CN |
2 | RECP_OI_DOC_CN | DPTARGETTYPE | TIVCNDPTYPE | DPTYPE | REF | C | CN |
3 | RECP_OI_DOC_CN | RECNBUKRSCOLLECT | T001 | BUKRS | |||
4 | RECP_OI_DOC_CN | RECNNOTREASON | TIVCNNTRE | NTREASON | REF | C | CN |
5 | RECP_OI_DOC_CN | RECNTLAW | TIV03 | SMIETR | KEY | 1 | CN |
6 | RECP_OI_DOC_CN | RECNTYPE | TIV26 | SMVART | KEY | 1 | CN |
7 | RECP_OI_DOC_CN | RESPONSIBLE | USR02 | BNAME | REF | 1 | CN |
8 | RECP_OI_DOC_CN | SUBROLE_CL | TIVBPSUBROLE | SUBROLE | REF | C | CN |
9 | RECP_OI_DOC_CN | SUBROLE_P1 | TIVBPSUBROLE | SUBROLE | REF | C | CN |
10 | RECP_OI_DOC_CN | SUBROLE_P2 | TIVBPSUBROLE | SUBROLE | REF | C | CN |
11 | RECP_OI_DOC_CN | SUBROLE_RC | TIVBPSUBROLE | SUBROLE | REF | C | CN |
12 | RECP_OI_DOC_CN | USEREXCLUSIVE | USR02 | BNAME | REF | C | CN |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in | 110 |