I_REObjectAssgmtDraft

DDL: I_REOBJECTASSGMTDRAFT Type: view_entity BASIC
31 Fields 1 Data Sources

RE Object Assignment - Draft

I_REObjectAssgmtDraft is a Basic CDS View that provides data about "RE Object Assignment - Draft" in SAP S/4HANA. It reads from 1 data source (vibdobjass_d) and exposes 31 fields with key fields REStatusObjectSource, REObjectAssignmentType, REStatusObjectTarget, ValidityStartEndDateValue, InternalRealEstateNumber.

Data Sources (1)

SourceAliasJoin Type
vibdobjass_d vibdobjass_d from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label RE Object Assignment - Draft view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY REStatusObjectSource restatusobjectsource Object Number
KEY REObjectAssignmentType reobjectassignmenttype Assignment Type
KEY REStatusObjectTarget restatusobjecttarget Object Number
KEY ValidityStartEndDateValue validitystartenddatevalue Validity Period
KEY InternalRealEstateNumber internalrealestatenumber RE Key
KEY DraftUUID draftuuid UUID
REIdentification reidentification Object
ParentDraftUUID parentdraftuuid NodeID
ValidityStartDate validitystartdate Validity Start Date
ValidityEndDate validityenddate ValidTo
REEntryValidity reentryvalidity Entry Validity
REEntryValidityCriticality reentryvaliditycriticality
REObjectTypeTarget reobjecttypetarget BusObjType
REOnlyInfoAssgmt reonlyinfoassgmt Informational
REObjectPossessionStartDate reobjectpossessionstartdate Possession From
REObjectPossessionEndDate reobjectpossessionenddate Possession To
REGroupNumber regroupnumber Group Number
REObjectGroupName reobjectgroupname Object Group
InternalRealEstateNumberTarget internalrealestatenumbertarget RE Key
REContractSubjectNumber recontractsubjectnumber Contract Object Number
REContractSubjectDescription recontractsubjectdescription Contract Object
REContractSubjectClass recontractsubjectclass CO Class
REContractSubjectType recontractsubjecttype Object Type
REAccountingObject reaccountingobject Object Number Account Assignment
REAccountingObjIdentification reaccountingobjidentification Accounting Object ID
REAccountingObjectType reaccountingobjecttype Object Type
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_REObjectAssgmtDraft.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_REObjectAssgmtDraft AS
SELECT
  REStatusObjectSource,
  REObjectAssignmentType,
  REStatusObjectTarget,
  ValidityStartEndDateValue,
  InternalRealEstateNumber,
  DraftUUID,
  REIdentification,
  ParentDraftUUID,
  ValidityStartDate,
  ValidityEndDate,
  REEntryValidity,
  REEntryValidityCriticality,
  REObjectTypeTarget,
  REOnlyInfoAssgmt,
  REObjectPossessionStartDate,
  REObjectPossessionEndDate,
  REGroupNumber,
  REObjectGroupName,
  InternalRealEstateNumberTarget,
  REContractSubjectNumber,
  REContractSubjectDescription,
  REContractSubjectClass,
  REContractSubjectType,
  REAccountingObject,
  REAccountingObjIdentification,
  REAccountingObjectType,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity
FROM vibdobjass_d
;

Learn More