aps_com_cs_auth_I

DDL: APS_COM_CS_AUTH_I SQL: APS_COM_CS_A_I Type: view Package: SR_APS_COM_CSCN
11 Fields 2 Data Sources 2 Associations

COM: CSCN Assigned Auth Instances

aps_com_cs_auth_I is a CDS View that provides data about "COM: CSCN Assigned Auth Instances" in SAP S/4HANA. It reads from 2 data sources (aps_com_w_scnaui, tobjt) and exposes 11 fields with key fields ScenarioId, Uuid, AuthObject. It has 2 associations to related views. Part of development package SR_APS_COM_CSCN.

Data Sources (2)

SourceAliasJoin Type
aps_com_w_scnaui instance from
tobjt text left_outer

Associations (2)

CardinalityTargetAliasCondition
[0..*] APS_COM_CS_AUTH_F _authField _authField.ObjectId = instance.auth_object and _authField.ScenarioId = instance.scenario_id and _authField.ParentId = instance.uuid
[0..1] aps_com_cs_auth_actvt _defaultActvt _defaultActvt.Object = instance.auth_object

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName APS_COM_CS_A_I view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label COM: CSCN Assigned Auth Instances view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ScenarioId aps_com_w_scnaui scenario_id Workflow definition
KEY Uuid aps_com_w_scnaui uuid Waste Partner UUID
KEY AuthObject aps_com_w_scnaui auth_object Object
AuthObjectInstId aps_com_w_scnaui auth_object_inst_id
IbsSource aps_com_w_scnaui ibs_source Name
Status aps_com_w_scnaui status Workflow Status
Inactive aps_com_w_scnaui inactive WO Locked
IbsSourceType aps_com_w_scnaui ibs_source_type Test status type
Description tobjt ttext Text
_authField _authField
_defaultActvt _defaultActvt

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_com_cs_auth_I.
-- 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.
-- SQL view name: APS_COM_CS_A_I

CREATE VIEW aps_com_cs_auth_I AS
SELECT
  instance.scenario_id AS ScenarioId,
  instance.uuid AS Uuid,
  instance.auth_object AS AuthObject,
  instance.auth_object_inst_id AS AuthObjectInstId,
  instance.ibs_source AS IbsSource,
  instance.status AS Status,
  instance.inactive AS Inactive,
  instance.ibs_source_type AS IbsSourceType,
  text.ttext AS Description
FROM aps_com_w_scnaui AS instance
LEFT OUTER JOIN tobjt AS text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN APS_COM_CS_AUTH_F AS _authField ON _authField.ObjectId = instance.auth_object AND _authField.ScenarioId = instance.scenario_id AND _authField.ParentId = instance.uuid  -- association [0..*]
LEFT OUTER JOIN aps_com_cs_auth_actvt AS _defaultActvt ON _defaultActvt.Object = instance.auth_object  -- association [0..1]
;

Learn More