APS_IAM_INFO_BU_SERVICE_UNUSED

DDL: APS_IAM_INFO_BU_SERVICE_UNUSED Type: view_entity Package: SR_APS_IAM_INFO
9 Fields 1 Data Sources

Business User - Service Unused

APS_IAM_INFO_BU_SERVICE_UNUSED is a CDS View that provides data about "Business User - Service Unused" in SAP S/4HANA. It reads from 1 data source (APS_IAM_INFO_BU_SERVICE_UN_BSC) and exposes 9 fields with key fields UserID, ServiceName, BusinessRoleID, BusinessCatalogID. Part of development package SR_APS_IAM_INFO.

Data Sources (1)

SourceAliasJoin Type
APS_IAM_INFO_BU_SERVICE_UN_BSC APS_IAM_INFO_BU_SERVICE_UN_BSC from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Business User - Service Unused view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY UserID UserID User Name
KEY ServiceName ServiceName UUID
KEY BusinessRoleID BusinessRoleID WorklistID
KEY BusinessCatalogID BusinessCatalogID
UserName UserName User who owns item
BusinessRoleUUID BusinessRoleUUID Waste Partner UUID
ObjectType ObjectType Type
Description Description Well Code Des.
UsageCounter UsageCounter Version

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_INFO_BU_SERVICE_UNUSED.
-- 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_INFO_BU_SERVICE_UNUSED AS
SELECT
  UserID,
  ServiceName,
  BusinessRoleID,
  BusinessCatalogID,
  UserName,
  BusinessRoleUUID,
  ObjectType,
  Description,
  UsageCounter
FROM APS_IAM_INFO_BU_SERVICE_UN_BSC
;

Learn More