SAP ABAP Table REIS_BP_OBJREL_L (ALV Reporting: Real Estate Objects by Business Partner)
Hierarchy
☛
EA-FIN (Software Component) EA-FIN
⤷ RE-FX-IS (Application Component) Information System
⤷ RE_IS_BP (Package) RE: Business Partner Info System
⤷ RE-FX-IS (Application Component) Information System
⤷ RE_IS_BP (Package) RE: Business Partner Info System
Basic Data
Table Category | INTTAB | Structure |
Structure | REIS_BP_OBJREL_L | Table Relationship Diagram |
Short Description | ALV Reporting: Real Estate Objects by Business Partner |
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 | Business Partner (Central Data, Group) | |||||
2 | .INCLUDE | 0 | 0 | SAP BP: BAPI Structure for Group Data | |||||
3 | NAMEGROUP1 | BU_NAMEGR1 | BU_NAME | CHAR | 40 | 0 | Name 1 (group) | ||
4 | NAMEGROUP2 | BU_NAMEGR2 | BU_NAME | CHAR | 40 | 0 | Name 2 (group) | ||
5 | GROUPTYPE | BU_GRPTYP | BU_GRPTYP | CHAR | 4 | 0 | Group type | TB025 | |
6 | .INCLUDE | 0 | 0 | Business Partner-Object Relationship and Add. Fields(VIBPOBJ | |||||
7 | .INCLUDE | 0 | 0 | Business Partner-Object Relationship (VIBPOBJREL) | |||||
8 | .INCLUDE | 0 | 0 | Business Partner-Object Relationship | |||||
9 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
10 | OBJRELGUID | REBPOBJRELGUID | RECAGUID | RAW | 16 | 0 | GUID: Business Partner Object Relationship | ||
11 | .INCLUDE | 0 | 0 | Business Partner-Object Relationship: Key | |||||
12 | INTRENO | RECAINTRENO | RECAINTRENO | CHAR | 13 | 0 | Internal Key of Real Estate Object | ||
13 | PARTNER | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | BUT000 | |
14 | ROLE | REBPROLE | BU_ROLE | CHAR | 6 | 0 | Business Partner: Role | TB003 | |
15 | SUBROLE | REBPSUBROLE | REBPSUBROLE | CHAR | 4 | 0 | Business Partner: Role Type | TIVBPSUBROLE | |
16 | APPL | REBPAPPL | BP_APPL | CHAR | 4 | 0 | Business Partner: Application Category | TPZ12 | |
17 | VALIDFROM | REBPVALIDFROM | RECADATEBEG | DATS | 8 | 0 | Date of Start of Relationship | ||
18 | .INCLUDE | 0 | 0 | Business Partner-Object Relationship: Attribute Fields | |||||
19 | .INCLUDE | 0 | 0 | Business Partner-Object Relationship: Attribute Fields (Gen) | |||||
20 | VALIDTO | REBPVALIDTO | RECADATEEND | DATS | 8 | 0 | Date of End of Relationship | ||
21 | ADDRTYPE | REBPADDRTYPE | BU_ADRKIND | CHAR | 10 | 0 | Address Type | TB009 | |
22 | .INCLUDE | 0 | 0 | BusPartner-Object Relationship: Owner Attribute Fields | |||||
23 | BRUTEIL | REBPBRUEIG | REBPOWNERSHIPSHARE | DEC | 9 | 3 | Fractional share of property | ||
24 | BMITEIG | REBPMITEIG | REBPOWNERSHIPSHARE | DEC | 9 | 3 | Co-ownership share | ||
25 | PANTEIL | REBPANTEIL | DEC4_2 | DEC | 6 | 2 | Ownership share | ||
26 | RFAKT | REBPFAKTEIG | VVRFAKT | NUMC | 6 | 0 | Conversion factor for fractional share of property | ||
27 | XNAME | REBPXNAME | BU_TEXT50 | CHAR | 50 | 0 | Short Name of Business Partner | ||
28 | XPARTNER | REBPXPARTNER | TEXT80 | CHAR | 80 | 0 | Name/Address of Business Partner | ||
29 | ROLECATE | REBPROLECATE | REBPROLECATE | CHAR | 1 | 0 | Category of Role Category | ||
30 | XROLE | REBPXROLE | RECAXMDESCRIPTION | CHAR | 30 | 0 | Name of Business Partner Role | ||
31 | XSUBROLE | REBPXSUBROLE | RECAXMDESCRIPTION | CHAR | 30 | 0 | Name of Role Type | ||
32 | XOBJTYPE | RECAXOBJTYPE | CHAR3 | CHAR | 3 | 0 | Partial Object Type ID, for example "BE" | ||
33 | IDENTKEY | RECAIDENTKEY | CHAR45 | CHAR | 45 | 0 | ID Part Key, for example "1000/123" | ||
34 | .INCLUDE | 0 | 0 | ||||||
35 | .INCLUDE | 0 | 0 | Business Partner (Central Data, Person) | |||||
36 | .INCLUDE | 0 | 0 | SAP BP: BAPI Structure for Personal Data | |||||
37 | FIRSTNAME | BU_NAMEP_F | BU_NAME | CHAR | 40 | 0 | First name of business partner (person) | ||
38 | LASTNAME | BU_NAMEP_L | BU_NAME | CHAR | 40 | 0 | Last name of business partner (person) | ||
39 | BIRTHNAME | BU_BIRTHNM | BU_NAME | CHAR | 40 | 0 | Name at birth of business partner | ||
40 | MIDDLENAME | BU_NAMEMID | BU_NAME | CHAR | 40 | 0 | Middle name or second forename of a person | ||
41 | SECONDNAME | BU_NAMEPL2 | BU_NAME | CHAR | 40 | 0 | Other Last Name of a Person | ||
42 | TITLE_ACA1 | AD_TITLE1 | AD_TITLE1 | CHAR | 4 | 0 | Academic Title: Key | TSAD2 | |
43 | TITLE_ACA2 | AD_TITLE2 | AD_TITLE1 | CHAR | 4 | 0 | Second academic title (key) | TSAD2 | |
44 | TITLE_SPPL | AD_TITLES | AD_TITLES | CHAR | 4 | 0 | Name supplement, e.g. noble title (key) | TSAD5 | |
45 | PREFIX1 | AD_PREFIX | AD_PREFIX | CHAR | 4 | 0 | Name Prefix (Key) | TSAD4 | |
46 | PREFIX2 | AD_PREFIX2 | AD_PREFIX | CHAR | 4 | 0 | 2nd name prefix (key) | TSAD4 | |
47 | NICKNAME | BU_NICKNAM | BU_NAME | CHAR | 40 | 0 | Nickname of Business Partner (Person) | ||
48 | INITIALS | AD_INITS | CHAR10 | CHAR | 10 | 0 | "Middle Initial" or personal initials | ||
49 | NAMEFORMAT | AD_FORMAT | AD_NAMFORM | CHAR | 2 | 0 | Name format | T005N | |
50 | NAMCOUNTRY | AD_NAMCTRY | LAND1 | CHAR | 3 | 0 | Country for name format rule | T005 | |
51 | NAMCOUNTRYISO | INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
52 | SEX | BU_SEXID | BU_SEXID | CHAR | 1 | 0 | Sex of business partner (person) | ||
53 | BIRTHPLACE | BU_BIRTHPL | TEXT40 | CHAR | 40 | 0 | Birthplace of business partner | ||
54 | BIRTHDATE | BU_BIRTHDT | DATUM | DATS | 8 | 0 | Date of Birth of Business Partner | ||
55 | DEATHDATE | BU_DEATHDT | DATUM | DATS | 8 | 0 | Date of death of business partner | ||
56 | MARITALSTATUS | BU_MARST | BU_MARST | CHAR | 1 | 0 | Marital Status of Business Partner | TB027 | |
57 | CORRESPONDLANGUAGE | BU_LANGU_CORR | SPRAS | LANG | 1 | 0 | Business Partner: Correspondence Language | T002 | |
58 | CORRESPONDLANGUAGEISO | LAISO | LAISO | CHAR | 2 | 0 | 2-Character SAP Language Code | ||
59 | FULLNAME | BU_NAME1TX | TEXT80 | CHAR | 80 | 0 | Full Name | ||
60 | EMPLOYER | BU_EMPLO | BU_EMPLO | CHAR | 35 | 0 | Name of Employer of a Natural Person | ||
61 | OCCUPATION | BU_JOBGR | BU_JOBGR | CHAR | 4 | 0 | Occupation/group | * | |
62 | NATIONALITY | BU_NATIO | LAND1 | CHAR | 3 | 0 | Nationality | * | |
63 | NATIONALITYISO | INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
64 | COUNTRYORIGIN | BU_CNDSC | LAND1 | CHAR | 3 | 0 | Ctry of Origin: Non-Res. Companies | * | |
65 | .INCLUDE | 0 | 0 | Business Partner (Central Data, Organization) | |||||
66 | .INCLUDE | 0 | 0 | SAP BP: BAPI Structure for Organization Data | |||||
67 | NAME1 | BU_NAMEOR1 | BU_NAME | CHAR | 40 | 0 | Name 1 of organization | ||
68 | NAME2 | BU_NAMEOR2 | BU_NAME | CHAR | 40 | 0 | Name 2 of organization | ||
69 | NAME3 | BU_NAMEOR3 | BU_NAME | CHAR | 40 | 0 | Name 3 of organization | ||
70 | NAME4 | BU_NAMEOR4 | BU_NAME | CHAR | 40 | 0 | Name 4 of organization | ||
71 | LEGALFORM | BU_LEGENTY | BU_LEGENTY | CHAR | 2 | 0 | BP: Legal form of organization | TB019 | |
72 | INDUSTRYSECTOR | BU_INDSECT | BU_INDSECT | CHAR | 10 | 0 | Industry sector | TB023 | |
73 | FOUNDATIONDATE | BU_FOUND_DAT | DATUM | DATS | 8 | 0 | Date organization founded | ||
74 | LIQUIDATIONDATE | BU_LIQUID_DAT | DATS | 8 | 0 | Liquidation date of organization | |||
75 | LOC_NO_1 | BBBNR | NUM07 | NUMC | 7 | 0 | International location number (part 1) | ||
76 | LOC_NO_2 | BBSNR | NUM05 | NUMC | 5 | 0 | International location number (Part 2) | ||
77 | CHK_DIGIT | BUBKZ | NUM01 | NUMC | 1 | 0 | Check digit for the international location number | ||
78 | LEGALORG | BU_LEGAL_ORG | BU_LEGAL_ORG | CHAR | 2 | 0 | Legal Entity of Organization | * | |
79 | .INCLUDE | 0 | 0 | Reporting Fields: O Hierarchy and O Characteristics | |||||
80 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
81 | SWENR | REBDBENO | REBDBENO | CHAR | 8 | 0 | Business Entity Number | * | |
82 | SGENR | REBDBUNO | REBDBUNO | CHAR | 8 | 0 | Number of Building | ||
83 | SGRNR | REBDPRNO | REBDPRNO | CHAR | 8 | 0 | Number of Land | ||
84 | NORUPS | REBDNORUPS | REBDRONO | CHAR | 8 | 0 | Number of Pooled Space or Rental Unit | ||
85 | NORS | REBDNORS | REBDRONO | CHAR | 8 | 0 | Number of Rental Space | ||
86 | RECNNR | RECNNUMBER | RECNNUMBER | CHAR | 13 | 0 | Contract Number | ||
87 | OBJECTID | REISOBJECTID | CHAR | 40 | 0 | Object ID | |||
88 | OBJECTTEXT | REISOBJECTTEXT | CHAR | 60 | 0 | Short Description of Object | |||
89 | OBJECTICON | REISOBJECTICON | RECAICON | CHAR | 137 | 0 | Icon: Object Type | ||
90 | OBJECT_VALIDFROM | REISOBJVALIDFROM | RECADATEBEG | DATS | 8 | 0 | Date: Object Valid From | ||
91 | OBJECT_VALIDTO | REISOBJVALIDTO | RECADATEEND | DATS | 8 | 0 | Date: Object Valid To | ||
92 | OBJECT_POSSDATEFROM | REBDPOSSDATEFROM | RECADATE | DATS | 8 | 0 | Date From Which the Object Is Made Available for Use | ||
93 | OBJECT_POSSDATETO | REBDPOSSDATETO | RECADATE | DATS | 8 | 0 | Date Up to Which the Object Is Used | ||
94 | AONR | REBDAONR | REBDAONR | CHAR | 13 | 0 | Number of Architectural Object | ||
95 | AOID | REBDAOID | REBDAOID | CHAR | 30 | 0 | Identification of Architectural Object | ||
96 | .INCLUDE | 0 | 0 | SAP BP: BAPI Structure for Address Data | |||||
97 | STANDARDADDRESS | BU_XDFADR | XFELD | CHAR | 1 | 0 | Indicator: Address is standard address | ||
98 | C_O_NAME | AD_NAME_CO | TEXT40 | CHAR | 40 | 0 | c/o name | ||
99 | CITY | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
100 | DISTRICT | AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
101 | REGIOGROUP | REGIOGROUP | REGIOGROUP | CHAR | 8 | 0 | Regional structure grouping | ADRREGGRP | |
102 | POSTL_COD1 | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
103 | POSTL_COD2 | AD_PSTCD2 | CHAR10 | CHAR | 10 | 0 | PO Box postal code | ||
104 | POSTL_COD3 | AD_PSTCD3 | CHAR10 | CHAR | 10 | 0 | Company postal code (for large customers) | ||
105 | PCODE1_EXT | AD_PST1XT | CHAR10 | CHAR | 10 | 0 | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | ||
106 | PCODE2_EXT | AD_PST2XT | CHAR10 | CHAR | 10 | 0 | (Not Supported) PO Box Postal Code Extension | ||
107 | PCODE3_EXT | AD_PST3XT | CHAR10 | CHAR | 10 | 0 | (Not Supported) Major Customer Postal Code Extension | ||
108 | PO_BOX | AD_POBX | CHAR10 | CHAR | 10 | 0 | PO Box | ||
109 | PO_W_O_NO | AD_POBXNUM | XFELD | CHAR | 1 | 0 | Flag: PO Box without number | ||
110 | PO_BOX_CIT | AD_POBXLOC | TEXT40 | CHAR | 40 | 0 | PO Box city | ||
111 | PO_BOX_REG | AD_POBXREG | REGIO | CHAR | 3 | 0 | Region for PO Box (Country, State, Province, ...) | T005S | |
112 | POBOX_CTRY | AD_POBXCTY | LAND1 | CHAR | 3 | 0 | PO box country | T005 | |
113 | PO_CTRYISO | INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
114 | STREET | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
115 | STR_ABBR | AD_STRABBR | STRTYPEAB | CHAR | 2 | 0 | (Not Supported) Abbreviation of Street Name | ADRSTRTYPE | |
116 | HOUSE_NO | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
117 | HOUSE_NO2 | AD_HSNM2 | TEXT10 | CHAR | 10 | 0 | House number supplement | ||
118 | HOUSE_NO3 | AD_HSNM3 | TEXT10 | CHAR | 10 | 0 | (Not supported) House Number Range | ||
119 | STR_SUPPL1 | AD_STRSPP1 | TEXT40 | CHAR | 40 | 0 | Street 2 | ||
120 | STR_SUPPL2 | AD_STRSPP2 | TEXT40 | CHAR | 40 | 0 | Street 3 | ||
121 | STR_SUPPL3 | AD_STRSPP3 | TEXT40 | CHAR | 40 | 0 | Street 4 | ||
122 | LOCATION | AD_LCTN | TEXT40 | CHAR | 40 | 0 | Street 5 | ||
123 | BUILDING | AD_BLDNG | TEXT20 | CHAR | 20 | 0 | Building (Number or Code) | ||
124 | FLOOR | AD_FLOOR | TEXT10 | CHAR | 10 | 0 | Floor in building | ||
125 | ROOM_NO | AD_ROOMNUM | TEXT10 | CHAR | 10 | 0 | Room or Appartment Number | ||
126 | COUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
127 | COUNTRYISO | INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
128 | REGION | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
129 | TIME_ZONE | AD_TZONE | TZNZONE | CHAR | 6 | 0 | Address time zone | TTZZ | |
130 | TAXJURCODE | AD_TXJCD | AD_TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | ||
131 | HOME_CITY | AD_CITY3 | TEXT40 | CHAR | 40 | 0 | City (different from postal city) | ||
132 | TRANSPZONE | LZONE | ZONE | CHAR | 10 | 0 | Transportation zone to or from which the goods are delivered | * | |
133 | LANGU | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | * | |
134 | LANGUISO | LAISO | LAISO | CHAR | 2 | 0 | 2-Character SAP Language Code | ||
135 | COMM_TYPE | AD_COMM | AD_COMM | CHAR | 3 | 0 | Communication Method (Key) (Business Address Services) | * | |
136 | EXTADDRESSNUMBER | BU_ADEXT | BU_ADEXT | CHAR | 20 | 0 | Address number in external system | ||
137 | DONT_USE_P | AD_NO_USEP | AD_NO_USE | CHAR | 4 | 0 | PO Box Address Undeliverable Flag | * | |
138 | DONT_USE_S | AD_NO_USES | AD_NO_USE | CHAR | 4 | 0 | Street Address Undeliverable Flag | * | |
139 | MOVE_DATE | BU_MOVEDAT | DATUM | DATS | 8 | 0 | Date of Move | ||
140 | MOVE_ADDRESS | BU_MOVE_ADDR | AD_ADDRNUM | CHAR | 10 | 0 | Number of Move Target Address for Address Moves | * | |
141 | VALIDFROMDATE | BU_DATFROM | DATUM | DATS | 8 | 0 | Validity Date (Valid From) | ||
142 | VALIDTODATE | BU_DATTO | DATUM | DATS | 8 | 0 | Validity Date (Valid To) | ||
143 | MOVE_ADDR_GUID | SYSUUID_C | SYSUUID_C | CHAR | 32 | 0 | UUID in character form | ||
144 | CITY_NO | AD_CITYNUM | CITY_CODE | CHAR | 12 | 0 | City code for city/street file | * | |
145 | DISTRCT_NO | AD_CITYPNM | CITYP_CODE | CHAR | 8 | 0 | District code for City and Street file | * | |
146 | CHCKSTATUS | AD_CHECKST | AD_CHECKST | CHAR | 1 | 0 | City file test status | ||
147 | PBOXCIT_NO | AD_CIT2NUM | CITY_CODE | CHAR | 12 | 0 | City PO box code (City file) | * | |
148 | STREET_NO | AD_STRNUM | STRT_CODE | CHAR | 12 | 0 | Street Number for City/Street File | * | |
149 | HOMECITYNO | AD_CITYHNM | CITY_CODE | CHAR | 12 | 0 | Different city for city/street file | * | |
150 | PO_BOX_LOBBY | AD_PO_BOX_LBY | TEXT40 | CHAR | 40 | 0 | PO Box Lobby | ||
151 | DELI_SERV_TYPE | AD_DELIVERY_SERVICE_TYPE | AD_DELIVERY_SERVICE_TYPE | CHAR | 4 | 0 | Type of Delivery Service | ||
152 | DELI_SERV_NUMBER | AD_DELIVERY_SERVICE_NUMBER | CHAR10 | CHAR | 10 | 0 | Number of Delivery Service | ||
153 | COUNTY | AD_COUNTY | TEXT40 | CHAR | 40 | 0 | County | ||
154 | COUNTY_NO | AD_CNTYNUM | CNTY_CODE | CHAR | 8 | 0 | County code for county | * | |
155 | TOWNSHIP | AD_TOWNSHIP | TEXT40 | CHAR | 40 | 0 | Township | ||
156 | TOWNSHIP_NO | AD_TWSHPNUM | TWSHP_CODE | CHAR | 8 | 0 | Township code for Township | * | |
157 | TEL_NUMBER_LONG | AD_TELNRLG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
158 | FAX_NUMBER_LONG | AD_FXNRLNG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
159 | SMTP_ADDR | AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | ||
160 | .INCLUDE | 0 | 0 | Time Slot Valid in a Row in the Info System | |||||
161 | RECISVALIDFROM | REISRECVALIDFROM | RECADATE | DATS | 8 | 0 | Displayed Row Is Valid From | ||
162 | RECISVALIDTO | REISRECVALIDTO | RECADATE | DATS | 8 | 0 | Displayed Row Is Valid Until | ||
163 | .INCLUDE | 0 | 0 | Reporting Fields: Generic Part | |||||
164 | GEN_OBJTYPE | RECAOBJTYPE | J_OBART | CHAR | 2 | 0 | Object Type | * | |
165 | GEN_OBJNR | RECAOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number | * | |
166 | GEN_CONTRACT | RECAOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number | * | |
167 | GEN_PARTNER1 | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
168 | GEN_PARTNER2 | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
169 | ALVROWS | REISALVROWS | INT2 | 5 | 0 | Number of Rows | |||
170 | XTITLE_ACA1 | AD_TITLE1T | TEXT20 | CHAR | 20 | 0 | Academic Title: Written Form | ||
171 | XTITLE_ACA2 | AD_TITLE2T | TEXT20 | CHAR | 20 | 0 | 2nd academic title: written form | ||
172 | XTITLE_SPPL | AD_TITLEST | TEXT20 | CHAR | 20 | 0 | Name supplement, e.g. noble title (written form) | ||
173 | XPREFIX1 | AD_PREFIXT | TEXT20 | CHAR | 20 | 0 | Name prefix | ||
174 | XPREFIX2 | AD_PREFIXT | TEXT20 | CHAR | 20 | 0 | Name prefix |
Foreign Keys
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in | 200 |