I_REOBJECTASSGMT
Real Estate Object Assignments
I_REOBJECTASSGMT is a CDS View in S/4HANA. Real Estate Object Assignments. It contains 23 fields. 29 CDS views read from this table.
CDS Views using this table (29)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_REUsblObjAddlAcctAssgmtDEX | view_entity | from | CONSUMPTION | Extractor RE Usbl Obj Addl Acct Assign |
| C_REUsblObjLdngAcctAssgmtDEX | view_entity | from | CONSUMPTION | Extractor RE Usbl Obj Ldng Acct Assign |
| I_REContractAssignSubject | view | inner | COMPOSITE | Real Estate Contract Subject Assignments |
| I_REContractAssignSubjectC_2 | view | inner | COMPOSITE | Real Estate Contract Subject Assignments |
| I_REContractObjectAssgmt | view_entity | from | COMPOSITE | Real Estate Object Assignments |
| I_REGnrcRntlObjAcctAssgmtObj | view_entity | from | COMPOSITE | Real Estate IO Accounting Object Assgmt |
| I_REIntegObjectAcctObjAssgmt | view | from | COMPOSITE | Real Estate IO Accounting Object Assgmt |
| I_REIntegObjectCtrlgObjAssgmt | view | from | COMPOSITE | Real Estate IO Controlling Object Assgmt |
| I_REIntegObjectObjectAssgmt | view | from | COMPOSITE | Real Estate Integration Object Assignment |
| I_REIntegObjToContractAssgmt | view | from | COMPOSITE | Integration Object Contract Assignment |
| I_REObjectAssgmtNoValidityKey | view_entity | from | COMPOSITE | Real Estate Object Assignments |
| I_REOccpcyGrpCtrlgObjAssgmt | view | from | COMPOSITE | Real Estate Occpcy Ctrlg Object Assgmt |
| I_RERntblObjToContractAssgmt | view_entity | from | COMPOSITE | RE Rentable Object Contract Assignment |
| I_REServiceGroupAcctObjAssgmt | view_entity | from | COMPOSITE | Real Estate SG Accounting Object Assgmt |
| I_RESrvcGrpToContractAssgmt | view_entity | from | COMPOSITE | Service Group Contract Assignment |
| I_REUsblObjAddlAcctAssgmtObj | view_entity | from | COMPOSITE | RE Usable Object Addl Account Assign |
| I_REUsblObjectToContractAssgmt | view_entity | from | COMPOSITE | RE Usable Object Contract Assignment |
| I_REUsblObjLdngAcctAssgmtObj | view_entity | from | COMPOSITE | RE Usable Object Leading Account Assign |
| I_REUsblObjRelatedCostCenterVH | view_entity | inner | COMPOSITE | RE Usable Object Related Cost Center |
| I_REUsblObjRelatedWBSElementVH | view_entity | inner | COMPOSITE | RE Usable Object Related WBS Element |
| P_REArchtrObjAssgmtCalc4 | view_entity | from | COMPOSITE | RE AO Controlling Object Assgmt Calc 4 |
| P_REArchtrObjAssgmtCalc4 | view_entity | union_all | COMPOSITE | RE AO Controlling Object Assgmt Calc 4 |
| P_REArchtrObjAssgmtCalc6 | view_entity | from | COMPOSITE | RE Review Booklet: Relevant Account Assignment Objects |
| P_REIntegObjectOccpcyCalc1 | view | from | COMPOSITE | Real Estate Integ Occpy Calc 1 |
| P_REIntegObjectOccpcyCalc1 | view | union | COMPOSITE | Real Estate Integ Occpy Calc 1 |
| R_RESrvcGrpAddlCostObjAssgmtTP | view_entity | from | TRANSACTIONAL | Real Estate ServGrp AddlCostObjAssgmt TP |
| R_RESrvcGrpLdngCostObjAssgmtTP | view_entity | from | TRANSACTIONAL | Real Estate ServGrp LdngCostObjAssgmt TP |
| R_REUsblObjAddlAcctAssgmtObjTP | view_entity | from | TRANSACTIONAL | RE Usable Object Addl Account Assign TP |
| R_REUsblObjLdngAcctAssgmtObjTP | view_entity | from | TRANSACTIONAL | RE Usable Object Leading Account Assign TP |
Fields (23)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | REObjectAssignmentType | REObjectAssignmentType | 14 |
| KEY | REStatusObjectSource | REStatusObjectSource,REStatusObjectTarget | 17 |
| KEY | REStatusObjectTarget | REAccountingObject,REStatusObjectSource,REStatusObjectTarget,REStatusObjectTargetForEdit | 20 |
| KEY | ValidityStartDate | ObjectValidFrom,REObjAssgmtValidityStartDate,ValidityStartDate,ValidityStartDateForEdit | 20 |
| _CostCenter | _CostCenter | 10 | |
| _FixedAsset | _FixedAsset | 9 | |
| _InternalOrder | _InternalOrder | 10 | |
| _REContractSubject | _REContractSubject | 7 | |
| _REGenerationType | _REGenerationType | 10 | |
| _REObjectAssignmentType | _REObjectAssignmentType | 8 | |
| _REObjectGroup | _REObjectGroup | 7 | |
| _REObjectTypeDetails | _REObjectTypeDetails | 13 | |
| _TechnicalObject | _TechnicalObject | 7 | |
| _WBSElement | _WBSElement | 10 | |
| REAssignmentHasMultiple | REAssignmentHasMultiple | 13 | |
| REGenerationType | REGenerationType | 13 | |
| REIsLeadingObject | REIsLeadingObject | 15 | |
| REIsMainAsset | REIsMainAsset | 13 | |
| REObjectPossessionEndDate | REObjectPossessionEndDate | 14 | |
| REObjectPossessionStartDate | REObjectPossessionStartDate | 14 | |
| REOnlyInfoAssgmt | REOnlyInfoAssgmt | 16 | |
| REStatusObjectSourceIsArchived | REStatusObjectSourceIsArchived | 14 | |
| ValidityEndDate | ObjectValidTo,REObjAssgmtValidityEndDate,ValidityEndDate | 20 |
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 Object Assignments
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_REOBJECTASSGMT (
REOBJECTASSIGNMENTTYPE,
RESTATUSOBJECTSOURCE,
RESTATUSOBJECTTARGET,
VALIDITYSTARTDATE,
_COSTCENTER,
_FIXEDASSET,
_INTERNALORDER,
_RECONTRACTSUBJECT,
_REGENERATIONTYPE,
_REOBJECTASSIGNMENTTYPE,
_REOBJECTGROUP,
_REOBJECTTYPEDETAILS,
_TECHNICALOBJECT,
_WBSELEMENT,
REASSIGNMENTHASMULTIPLE,
REGENERATIONTYPE,
REISLEADINGOBJECT,
REISMAINASSET,
REOBJECTPOSSESSIONENDDATE,
REOBJECTPOSSESSIONSTARTDATE,
REONLYINFOASSGMT,
RESTATUSOBJECTSOURCEISARCHIVED,
VALIDITYENDDATE,
PRIMARY KEY (REOBJECTASSIGNMENTTYPE, RESTATUSOBJECTSOURCE, RESTATUSOBJECTTARGET, VALIDITYSTARTDATE)
);
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