I_REServiceGroupDraft

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

RE Service Group - Draft

I_REServiceGroupDraft is a Basic CDS View that provides data about "RE Service Group - Draft" in SAP S/4HANA. It reads from 1 data source (vicssg_d) and exposes 31 fields with key fields InternalRealEstateNumber, DraftUUID.

Data Sources (1)

SourceAliasJoin Type
vicssg_d REServiceGroupDraft from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label RE Service Group - 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 InternalRealEstateNumber internalrealestatenumber RE Key
KEY DraftUUID draftuuid UUID
REStatusObject restatusobject Val. Obj. No.
RealEstateServiceGroupNumber realestateservicegroupnumber Service Group
ValidityStartDate validitystartdate Validity Start Date
ValidityEndDate validityenddate ValidTo
REServiceGroupType reservicegrouptype Service Group Type
REServiceGroupCategory reservicegroupcategory Service Group Category
REServiceGroupName reservicegroupname Service Group Name (Short)
REServiceGroupLongName reservicegrouplongname Service Group Name (Long)
REParentIntRealEstateNumber reparentintrealestatenumber Parent Number
REParentIntegObjectNumber reparentintegobjectnumber Real Estate Object
CompanyCode companycode Receiver Company Code
CreatedByUser createdbyuser User Name
CreationDate creationdate Time Stamp
CreationTime creationtime Time of Change
RESourceOfCreation resourceofcreation Source.In.Entry
LastChangedByUser lastchangedbyuser User Name
LastChangeDate lastchangedate Time Stamp
LastChangeTime lastchangetime Time changed
RESourceOfChange resourceofchange Editing Source
Responsible responsible User Name
REAuthorizationGroup reauthorizationgroup Authoriz. Group
CreationDateTime creationdatetime Timestamp
LastChangeDateTime lastchangedatetime Timestamp
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes

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_REServiceGroupDraft.
-- 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_REServiceGroupDraft AS
SELECT
  InternalRealEstateNumber,
  DraftUUID,
  REStatusObject,
  RealEstateServiceGroupNumber,
  ValidityStartDate,
  ValidityEndDate,
  REServiceGroupType,
  REServiceGroupCategory,
  REServiceGroupName,
  REServiceGroupLongName,
  REParentIntRealEstateNumber,
  REParentIntegObjectNumber,
  CompanyCode,
  CreatedByUser,
  CreationDate,
  CreationTime,
  RESourceOfCreation,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  RESourceOfChange,
  Responsible,
  REAuthorizationGroup,
  CreationDateTime,
  LastChangeDateTime,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM vicssg_d AS REServiceGroupDraft
;

Learn More