APS_IAM_BROLE_RVAL_RTTEXT

DDL: APS_IAM_BROLE_RVAL_RTTEXT Type: view_entity Package: SR_APS_IAM_BROLE
21 Fields 3 Data Sources

Restriction type texts for value changes

APS_IAM_BROLE_RVAL_RTTEXT is a CDS View that provides data about "Restriction type texts for value changes" in SAP S/4HANA. It reads from 3 data sources (APS_IAM_BR_UUID, I_ChangeDocument, I_ChangeDocumentItem) and exposes 21 fields with key fields ChangeDocObjectClass, ChangeDocObject, ChangeDocument, DatabaseTable, ChangeDocDatabaseTableField. Part of development package SR_APS_IAM_BROLE.

Data Sources (3)

SourceAliasJoin Type
APS_IAM_BR_UUID _brole inner
I_ChangeDocument changedoc from
I_ChangeDocumentItem p inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Restriction type texts for value changes view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObjectClass I_ChangeDocument ChangeDocObjectClass Change Doc. Object
KEY ChangeDocObject I_ChangeDocument ChangeDocObject Object Value
KEY ChangeDocument I_ChangeDocument ChangeDocument Document Number
KEY DatabaseTable I_ChangeDocumentItem DatabaseTable Table Name
KEY ChangeDocDatabaseTableField I_ChangeDocumentItem ChangeDocDatabaseTableField User
KEY ChangeDocItemChangeType I_ChangeDocumentItem ChangeDocItemChangeType Change Indicator
ChangeDocTableKey I_ChangeDocumentItem ChangeDocTableKey Table Keys
Id APS_IAM_BR_UUID Id WorklistID
role_uuid APS_IAM_BR_UUID Uuid Waste Partner UUID
change_user I_ChangeDocument CreatedByUser User Name
CreationDate I_ChangeDocument CreationDate Time Stamp
CreationTime I_ChangeDocument CreationTime Time of Change
ChangeTransactionCode I_ChangeDocument ChangeTransactionCode Change Tcode
ChangeDocChangeType I_ChangeDocument ChangeDocChangeType Object Change
new_value I_ChangeDocumentItem ChangeDocNewFieldValue New Value
old_value I_ChangeDocumentItem ChangeDocPreviousFieldValue Old Value
uuidchar APS_IAM_BR_UUID uuidchar
action
attribute
Restriction_Type
fieldname

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 APS_IAM_BROLE_RVAL_RTTEXT.
-- 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 APS_IAM_BROLE_RVAL_RTTEXT AS
SELECT
  changedoc.ChangeDocObjectClass AS ChangeDocObjectClass,
  changedoc.ChangeDocObject AS ChangeDocObject,
  changedoc.ChangeDocument AS ChangeDocument,
  p.DatabaseTable AS DatabaseTable,
  p.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  p.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  p.ChangeDocTableKey AS ChangeDocTableKey,
  _brole.Id AS Id,
  _brole.Uuid AS role_uuid,
  changedoc.CreatedByUser AS change_user,
  changedoc.CreationDate AS CreationDate,
  changedoc.CreationTime AS CreationTime,
  changedoc.ChangeTransactionCode AS ChangeTransactionCode,
  changedoc.ChangeDocChangeType AS ChangeDocChangeType,
  p.ChangeDocNewFieldValue AS new_value,
  p.ChangeDocPreviousFieldValue AS old_value,
  _brole.uuidchar AS uuidchar,
  '' AS action,
  '' AS attribute,
  substring(p.ChangeDocTableKey,1,30) AS Restriction_Type,
  substring(p.ChangeDocTableKey,31,30) AS fieldname
FROM I_ChangeDocument AS changedoc
INNER JOIN I_ChangeDocumentItem AS p ON /* join condition not captured in parsed metadata */
INNER JOIN APS_IAM_BR_UUID AS _brole ON /* join condition not captured in parsed metadata */
;

Learn More