I_REServiceGroupDraft

DDL: I_RESERVICEGROUPDRAFT Type: view_entity BASIC Package: VDM_RE_CS
24 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 24 fields with key fields REServiceGroupUUID, InternalRealEstateNumber. Part of development package VDM_RE_CS.

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 (24)

KeyFieldSource TableSource FieldDescription
KEY REServiceGroupUUID reservicegroupuuid
KEY InternalRealEstateNumber internalrealestatenumber RE Key
REStatusObject restatusobject Val. Obj. No.
RealEstateServiceGroupNumber realestateservicegroupnumber Service Group
REServiceGroupOID reservicegroupoid
REServiceGroupAlternativeID reservicegroupalternativeid
REServiceGroupName reservicegroupname Service Group Name (Short)
CompanyCode companycode Receiver Company Code
REServiceGroupParentUUID reservicegroupparentuuid
REArchtrObjectNumberBldngLand rearchtrobjectnumberbldngland Building/Land Object Number
REAuthorizationGroup reauthorizationgroup Authoriz. Group
REServiceGroupType reservicegrouptype Service Group Type
REServiceGroupCategory reservicegroupcategory Service Group Category
ValidityStartDate validitystartdate Validity Start Date
ValidityEndDate validityenddate ValidTo
CreationDateTime creationdatetime Timestamp
LastChangeDateTime lastchangedatetime Timestamp
LocalLastChangeDateTime locallastchangedatetime Time Stamp
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
  REServiceGroupUUID,
  InternalRealEstateNumber,
  REStatusObject,
  RealEstateServiceGroupNumber,
  REServiceGroupOID,
  REServiceGroupAlternativeID,
  REServiceGroupName,
  CompanyCode,
  REServiceGroupParentUUID,
  REArchtrObjectNumberBldngLand,
  REAuthorizationGroup,
  REServiceGroupType,
  REServiceGroupCategory,
  ValidityStartDate,
  ValidityEndDate,
  CreationDateTime,
  LastChangeDateTime,
  LocalLastChangeDateTime,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM vicssg_d AS REServiceGroupDraft
;

Learn More