C_CmplRqRsltProcessorVH

DDL: C_CMPLRQRSLTPROCESSORVH Type: view CONSUMPTION Package: EHFND_CNS_CRR

Value Help for Processor of Compliance Requirement Results

C_CmplRqRsltProcessorVH is a Consumption CDS View that provides data about "Value Help for Processor of Compliance Requirement Results" in SAP S/4HANA. It reads from 3 data sources (P_ChmlCmplConstants, P_ChmlCmplConstants, SUSR_USERS_FOR_OBJECT_ACTVT) and exposes 31 fields with key field Processor. It is exposed through 11 OData services (ASQL_F2612, ASQL_F2647, ASQL_F2928, ...). Part of development package EHFND_CNS_CRR.

Data Sources (3)

SourceAliasJoin Type
P_ChmlCmplConstants P_ChmlCmplConstants from
P_ChmlCmplConstants P_ChmlCmplConstants union_all
SUSR_USERS_FOR_OBJECT_ACTVT SUSR_USERS_FOR_OBJECT_ACTVT inner

Annotations (14)

NameValueLevelField
EndUserText.label Value Help for Processor of Compliance Requirement Results view
AbapCatalog.sqlViewName CCRRPRCSRVH view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey Processor view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.dataCategory #VALUE_HELP view

OData Services (11)

ServiceBindingVersionContractRelease
ASQL_F2612 ASQL_F2612 C2 NOT_RELEASED
ASQL_F2647 ASQL_F2647 C2 NOT_RELEASED
ASQL_F2928 ASQL_F2928 C2 NOT_RELEASED
ASQL_F3219 ASQL_F3219 C2 NOT_RELEASED
ASQL_F3220 ASQL_F3220 C2 NOT_RELEASED
ASQL_F3221 ASQL_F3221 C2 NOT_RELEASED
ASQL_F3236 ASQL_F3236 C2 NOT_RELEASED
ASQL_F5369 ASQL_F5369 C2 NOT_RELEASED
ASQL_F5995 ASQL_F5995 C2 NOT_RELEASED
ASQL_F6187 ASQL_F6187 C2 NOT_RELEASED
ASQL_F6329 ASQL_F6329 C2 NOT_RELEASED

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY Processor BusinessUser BusinessPartner Issuing Authority
CmplRqRsltProcessorName
UserID BusinessUser UserID User Name
AuthorizationGroup BusinessUser AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted BusinessUser IsBusinessPurposeCompleted Purpose Completed
DataControllerSet BusinessUser DataControllerSet Data Ctrlr. Set
DataController1 BusinessUser DataController1 Data Controller
DataController2 BusinessUser DataController2 Data Controller
DataController3 BusinessUser DataController3 Data Controller
DataController4 BusinessUser DataController4 Data Controller
DataController5 BusinessUser DataController5 Data Controller
DataController6 BusinessUser DataController6 Data Controller
DataController7 BusinessUser DataController7 Data Controller
DataController8 BusinessUser DataController8 Data Controller
DataController9 BusinessUser DataController9 Data Controller
Processor Issuing Authority
CmplRqRsltProcessorName
UserID User Name
AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted Purpose Completed
DataControllerSet Data Ctrlr. Set
DataController1 Data Controller
DataController2 Data Controller
DataController3 Data Controller
DataController4 Data Controller
DataController5 Data Controller
DataController6 Data Controller
DataController7 Data Controller
DataController8 Data Controller
DataController9 Data Controller
DataController10

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 C_CmplRqRsltProcessorVH.
-- 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 C_CmplRqRsltProcessorVH AS
SELECT
  BusinessUser.BusinessPartner AS Processor,
  cast(BusinessUser.PersonFullName as ad_namtext preserving type) AS CmplRqRsltProcessorName,
  BusinessUser.UserID AS UserID,
  BusinessUser.AuthorizationGroup AS AuthorizationGroup,
  BusinessUser.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  BusinessUser.DataControllerSet AS DataControllerSet,
  BusinessUser.DataController1 AS DataController1,
  BusinessUser.DataController2 AS DataController2,
  BusinessUser.DataController3 AS DataController3,
  BusinessUser.DataController4 AS DataController4,
  BusinessUser.DataController5 AS DataController5,
  BusinessUser.DataController6 AS DataController6,
  BusinessUser.DataController7 AS DataController7,
  BusinessUser.DataController8 AS DataController8,
  BusinessUser.DataController9 AS DataController9,
  '' AS DataController10
FROM P_ChmlCmplConstants
INNER JOIN SUSR_USERS_FOR_OBJECT_ACTVT ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_ChmlCmplConstants
;