VIIPOBJECT
Real Estate Integration Object
VIIPOBJECT is an SAP database table in S/4HANA. Real Estate Integration Object. It contains 29 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_REIntegrationObject | view | from | EXTENSION | Real Estate Integ Object - Extension Include |
| I_REIntegrationObjectBasicData | view | from | BASIC | Real Estate Integration Object |
| P_REIntegObjToContrByKeyDate | view_entity | inner | COMPOSITE | Integration Object Contract Assignment by Keydate |
Fields (29)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | intreno | RECAINTRENO | RE Key | |||
| extid | REIPEXTID | External Identification | ||||
| objnr | RECAOBJNR | Object Number | ||||
| ionr | REIPIONR | Real Estate Object | ||||
| iotype | REIPOBJECTTYPE | Object Type | ||||
| xsobject | REIPXSOBJECT | Object Name (Short) | ||||
| xlobject | REIPXLOBJECT | Object Name (Long) | ||||
| ioparenttype | REIPPARENTOBJECTTYPE | Parent Object Type | ||||
| ioparentextid | REIPPARENTEXTID | Parent External Identification | ||||
| creationtype | REIPIOCREATIONTYPE | How Created | ||||
| areaunit | REIPAREAUNIT | Area Unit | ||||
| iosgtype | REIPIOSGTYPE | Group Type | ||||
| iosgusagetype | REIPIOSGUSAGETYPE | Group Usage Type | ||||
| iocoobjtype | REIPOBJECTCOOBJTYPE | Controlling Object Type | ||||
| iosgenableusetype | REIPIOSGENABLEUSETYPE | Usage Enablement Type | ||||
| intrenoenableuse | REIPINTRENOENABLEUSE | Internal Number Enable Use | ||||
| bukrs | REIPIOBUKRS | Company Code | ||||
| authgrp | RECAAUTHGRP | Authoriz. Group | ||||
| rerf | RERF | Entered By | ||||
| derf | DERF | First Enterd On | ||||
| terf | TERF | Time | ||||
| reher | REHER | Source.In.Entry | ||||
| rbear | RBEAR | Last Changed By | ||||
| dbear | DBEAR | Last Edited On | ||||
| tbear | TBEAR | Last Edited At | ||||
| rbher | RBHER | Editing Source | ||||
| responsible | RECARESPONSIBLE | Person Respons. | ||||
| dummy_rec_ps | CFD_DUMMY | Dummy |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Real Estate Integration Object
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VIIPOBJECT (
MANDT, -- Client [MANDT]
INTRENO, -- RE Key [RECAINTRENO]
EXTID, -- External Identification [REIPEXTID]
OBJNR, -- Object Number [RECAOBJNR]
IONR, -- Real Estate Object [REIPIONR]
IOTYPE, -- Object Type [REIPOBJECTTYPE]
XSOBJECT, -- Object Name (Short) [REIPXSOBJECT]
XLOBJECT, -- Object Name (Long) [REIPXLOBJECT]
IOPARENTTYPE, -- Parent Object Type [REIPPARENTOBJECTTYPE]
IOPARENTEXTID, -- Parent External Identification [REIPPARENTEXTID]
CREATIONTYPE, -- How Created [REIPIOCREATIONTYPE]
AREAUNIT, -- Area Unit [REIPAREAUNIT]
IOSGTYPE, -- Group Type [REIPIOSGTYPE]
IOSGUSAGETYPE, -- Group Usage Type [REIPIOSGUSAGETYPE]
IOCOOBJTYPE, -- Controlling Object Type [REIPOBJECTCOOBJTYPE]
IOSGENABLEUSETYPE, -- Usage Enablement Type [REIPIOSGENABLEUSETYPE]
INTRENOENABLEUSE, -- Internal Number Enable Use [REIPINTRENOENABLEUSE]
BUKRS, -- Company Code [REIPIOBUKRS]
AUTHGRP, -- Authoriz. Group [RECAAUTHGRP]
RERF, -- Entered By [RERF]
DERF, -- First Enterd On [DERF]
TERF, -- Time [TERF]
REHER, -- Source.In.Entry [REHER]
RBEAR, -- Last Changed By [RBEAR]
DBEAR, -- Last Edited On [DBEAR]
TBEAR, -- Last Edited At [TBEAR]
RBHER, -- Editing Source [RBHER]
RESPONSIBLE, -- Person Respons. [RECARESPONSIBLE]
DUMMY_REC_PS, -- Dummy [CFD_DUMMY]
PRIMARY KEY (MANDT, INTRENO)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA