C_CmplRqRsltDraftAdminvData

DDL: C_CMPLRQRSLTDRAFTADMINVDATA SQL: CCRRDRAFTADMDATA Type: view CONSUMPTION Package: EHFND_CNS_CRR

Draft admin data for Compliance Assessments

C_CmplRqRsltDraftAdminvData is a Consumption CDS View that provides data about "Draft admin data for Compliance Assessments" in SAP S/4HANA. It reads from 1 data source (I_CmplRqRslt) and exposes 7 fields with key field CmplRqRsltUUID. It is exposed through 13 OData services (ASQL_F2647, ASQL_F3219, ASQL_F3220, ...). Part of development package EHFND_CNS_CRR.

Data Sources (1)

SourceAliasJoin Type
I_CmplRqRslt I_CmplRqRslt from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CCRRDRAFTADMDATA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Draft admin data for Compliance Assessments view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view

OData Services (13)

ServiceBindingVersionContractRelease
ASQL_F2647 ASQL_F2647 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_F3642 ASQL_F3642 C2 NOT_RELEASED
ASQL_F3710 ASQL_F3710 C2 NOT_RELEASED
ASQL_F5995 ASQL_F5995 C2 NOT_RELEASED
ASQL_F8488 ASQL_F8488 C2 NOT_RELEASED
ASQL_F8930 ASQL_F8930 C2 NOT_RELEASED
UI_DNGRSGDSLOGSPACKGINSTRN UI_DNGRSGDSLOGSPACKGINSTRN V4 C1 NOT_RELEASED
UI_DNGRSGDSMULTICOMPONENTPROD UI_DNGRSGDSMULTICOMPONENTPROD V4 C1 NOT_RELEASED
UI_PCKGDDANGEROUSGOOD_MANAGE UI_PCKGDDANGEROUSGOOD_MANAGE V4 C1 NOT_RELEASED
UI_UNPCKGDDNGRSGOOD_MANAGE UI_UNPCKGDDNGRSGOOD_MANAGE V4 C1 NOT_RELEASED

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CmplRqRsltUUID CmplRqRsltUUID SDS Assessment
CmplRqVersUUID CmplRqVersUUID NodeID
LastChangeDateTime
LastChangedByUser
InProcessByUser
LastChangedByUserDescription
InProcessByUserDescription

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_CmplRqRsltDraftAdminvData.
-- 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: CCRRDRAFTADMDATA

CREATE VIEW C_CmplRqRsltDraftAdminvData AS
SELECT
  CmplRqRsltUUID,
  CmplRqVersUUID,
  cast ( 0 as sdraft_last_changed_at ) AS LastChangeDateTime,
  cast ( '' as sdraft_last_changed_by ) AS LastChangedByUser,
  cast ( '' as sdraft_in_process_by ) AS InProcessByUser,
  cast ( '' as sdraft_last_changed_by_desc ) AS LastChangedByUserDescription,
  cast ( '' as sdraft_in_process_by_desc ) AS InProcessByUserDescription
FROM I_CmplRqRslt
;