VIBDOBJASS
Object Assignment
VIBDOBJASS is an SAP database table in S/4HANA. Object Assignment. It contains 20 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_REObjectAssgmt | view_entity | from | BASIC | Real Estate Object Assignments |
| I_REObjectToObjectGroup | view | from | BASIC | Object to Object Group Assignments |
| P_REIntegObjToContrByKeyDate | view_entity | from | COMPOSITE | Integration Object Contract Assignment by Keydate |
Fields (20)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | objnrsrc | RECAOBJNR | Object Number | |||
| KEY | objasstype | REBDOBJASSTYPE | Assignment Type | |||
| KEY | objnrtrg | RECAOBJNR | Object Number | |||
| KEY | validfrom | REBDRELVALIDFROM | Valid From | |||
| validto | REBDRELVALIDTO | Valid To | ||||
| assignonlyinfo | REBDASSIGNONLYINFO | Informational | ||||
| objnrsrcarch | REBDOBJNRSRCARCH | Archived | ||||
| flgentype | REBDFLGENTYPE | GenTyp | ||||
| ismainasset | REBDISMAINASSET | Leading Asset | ||||
| measvalue | REBDOAMEASVALUE | Assigned Amount | ||||
| measunit | REBDMEASUNIT | Units in | ||||
| ismultiassgen | REBDISMULTIASSGEN | MultAsgn.Entry | ||||
| possdatefrom | REBDPOSSDATEFROM | Possession From | ||||
| possdateto | REBDPOSSDATETO | Possession To | ||||
| isdetermoptrate | REITISDETERMOPTRATE | Rel. Opt.Rate | ||||
| peplanneddate | RELMPEPLANDATE | Plan/Decis.Date | ||||
| peeffectdate | RELMPEEFFECTDATE | Effective Date | ||||
| pelocation | RELMPELOCATION | Location | ||||
| isleadingobject | REIPISLEADINGOBJASS | Leading object? |
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.
-- Object Assignment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VIBDOBJASS (
MANDT, -- Client [MANDT]
OBJNRSRC, -- Object Number [RECAOBJNR]
OBJASSTYPE, -- Assignment Type [REBDOBJASSTYPE]
OBJNRTRG, -- Object Number [RECAOBJNR]
VALIDFROM, -- Valid From [REBDRELVALIDFROM]
VALIDTO, -- Valid To [REBDRELVALIDTO]
ASSIGNONLYINFO, -- Informational [REBDASSIGNONLYINFO]
OBJNRSRCARCH, -- Archived [REBDOBJNRSRCARCH]
FLGENTYPE, -- GenTyp [REBDFLGENTYPE]
ISMAINASSET, -- Leading Asset [REBDISMAINASSET]
MEASVALUE, -- Assigned Amount [REBDOAMEASVALUE]
MEASUNIT, -- Units in [REBDMEASUNIT]
ISMULTIASSGEN, -- MultAsgn.Entry [REBDISMULTIASSGEN]
POSSDATEFROM, -- Possession From [REBDPOSSDATEFROM]
POSSDATETO, -- Possession To [REBDPOSSDATETO]
ISDETERMOPTRATE, -- Rel. Opt.Rate [REITISDETERMOPTRATE]
PEPLANNEDDATE, -- Plan/Decis.Date [RELMPEPLANDATE]
PEEFFECTDATE, -- Effective Date [RELMPEEFFECTDATE]
PELOCATION, -- Location [RELMPELOCATION]
ISLEADINGOBJECT, -- Leading object? [REIPISLEADINGOBJASS]
PRIMARY KEY (MANDT, OBJNRSRC, OBJASSTYPE, OBJNRTRG, VALIDFROM)
);
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