/APE/C_CheckActAssignCust_UI

DDL: /APE/C_CHECKACTASSIGNCUST_UI SQL: /APE/C_CHAACEUI Type: view CONSUMPTION
8 Fields 1 Data Sources 3 Associations

Check Action Assignment for Customer

/APE/C_CheckActAssignCust_UI is a Consumption CDS View that provides data about "Check Action Assignment for Customer" in SAP S/4HANA. It reads from 1 data source (/APE/C_CheckActionAssignCust) and exposes 8 fields. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
/APE/C_CheckActionAssignCust Cust from

Associations (3)

CardinalityTargetAliasCondition
[0..1] /APE/C_Ext_ExceptionID_VH _ExceptionIDVH _ExceptionIDVH.ExceptionIDKey = Cust.exception_code_uuid
[0..1] /APE/C_CheckActionID_VH _CheckActionIDVH _CheckActionIDVH.CheckActionIDKey = $projection.CheckActionIDKey
[0..1] /APE/C_ProcessStepStatus_VH _ProcessStepStatusVH _ProcessStepStatusVH.Value = $projection.ProcessStepStatus

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName /APE/C_CHAACEUI view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Check Action Assignment for Customer view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #CONSUMPTION view

Fields (8)

KeyFieldSource TableSource FieldDescription
ExceptionCodeUuid /APE/C_CheckActionAssignCust exception_code_uuid
ExceptionID _ExceptionIDVH ExceptionID
ExceptionIDDescription _ExceptionIDVH ExceptionIDDescription
CheckActionIDKey /APE/C_CheckActionAssignCust action_code_uuid
CheckActionID /APE/C_CheckActionAssignCust action_code Single-Character Flag
CheckActionIDDescription _CheckActionIDVH CheckActionIDDescription
ProcessStepStatus /APE/C_CheckActionAssignCust prst_status
ProcessStepStatusDesc _ProcessStepStatusVH Description Well Code Des.

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 /APE/C_CheckActAssignCust_UI.
-- 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: /APE/C_CHAACEUI

CREATE VIEW /APE/C_CheckActAssignCust_UI AS
SELECT
  Cust.exception_code_uuid AS ExceptionCodeUuid,
  _ExceptionIDVH.ExceptionID AS ExceptionID,
  _ExceptionIDVH.ExceptionIDDescription AS ExceptionIDDescription,
  Cust.action_code_uuid AS CheckActionIDKey,
  Cust.action_code AS CheckActionID,
  _CheckActionIDVH.CheckActionIDDescription AS CheckActionIDDescription,
  Cust.prst_status AS ProcessStepStatus,
  _ProcessStepStatusVH.Description AS ProcessStepStatusDesc
FROM /APE/C_CheckActionAssignCust AS Cust
LEFT OUTER JOIN /APE/C_Ext_ExceptionID_VH AS _ExceptionIDVH ON _ExceptionIDVH.ExceptionIDKey = Cust.exception_code_uuid  -- association [0..1]
LEFT OUTER JOIN /APE/C_CheckActionID_VH AS _CheckActionIDVH ON _CheckActionIDVH.CheckActionIDKey = CheckActionIDKey  -- association [0..1]
LEFT OUTER JOIN /APE/C_ProcessStepStatus_VH AS _ProcessStepStatusVH ON _ProcessStepStatusVH.Value = ProcessStepStatus  -- association [0..1]
;

Learn More