C_CmplRqRsltSuplrDeclnTP

DDL: C_CMPLRQRSLTSUPLRDECLNTP Type: view_entity CONSUMPTION Package: EHPMA_CRPAT_CDP
13 Fields 1 Data Sources 2 OData Services

CRR Declaration at Supplier

C_CmplRqRsltSuplrDeclnTP is a Consumption CDS View that provides data about "CRR Declaration at Supplier" in SAP S/4HANA. It reads from 1 data source (R_CmplRqRsltDeclnTP) and exposes 13 fields with key field CmplRqRsltDeclnUUID. It is exposed through 2 OData services (ASQL_F7602, UI_EHS_PMA_CRR_MAN_CCI_CDP). Part of development package EHPMA_CRPAT_CDP.

Data Sources (1)

SourceAliasJoin Type
R_CmplRqRsltDeclnTP R_CmplRqRsltDeclnTP projection

Annotations (10)

NameValueLevelField
EndUserText.label CRR Declaration at Supplier view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey CmplRqRsltDeclnUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F7602 ASQL_F7602 C2 NOT_RELEASED
UI_EHS_PMA_CRR_MAN_CCI_CDP UI_EHS_PMA_CRR_MAN_CCI_CDP V4 C1 NOT_RELEASED

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CmplRqRsltDeclnUUID CmplRqRsltDeclnUUID
CmplRqRsltUUID CmplRqRsltUUID SDS Assessment
CmplncDisclUUID CmplncDisclUUID Compliance Disclosure UUID
CmplncDeclnUUID CmplncDeclnUUID Compliance Declaration UUID
Supplier _CmplncDisclSuplrTP Supplier Supplier
SupplierName
CmplncDisclProcgStatus _CmplncDisclSuplrTP CmplncDisclProcgStatus Compliance Disclosure Processing Status
CmplncDisclProcgStatusCritlty
CmplncDisclProcgStatusTxtlocalized
CmplncDeclnCmplncSts _CmplncDeclnSuplrTP CmplncDeclnCmplncSts Compliance Declaration Compliance Status
CmplncDeclnCmplncStsTxtlocalized
CmplncDeclnCmplncStsCritlty
_CmplRqRsltCmplncDisclPatAssmt _CmplRqRsltCmplncDisclPatAssmt

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_CmplRqRsltSuplrDeclnTP.
-- 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_CmplRqRsltSuplrDeclnTP AS
SELECT
  CmplRqRsltDeclnUUID,
  CmplRqRsltUUID,
  CmplncDisclUUID,
  CmplncDeclnUUID,
  _CmplncDisclSuplrTP.Supplier AS Supplier,
  _CmplncDisclSuplrTP._Supplier.BPSupplierName AS SupplierName,
  _CmplncDisclSuplrTP.CmplncDisclProcgStatus AS CmplncDisclProcgStatus,
  _CmplncDisclSuplrTP._CmplncDisclProcgStatusText[1: Language = $session.system_language ].CmplncDisclProcgStatusCritlty AS CmplncDisclProcgStatusCritlty,
  _CmplncDisclSuplrTP._CmplncDisclProcgStatusText.CmplncDisclProcgStatusTxt : localized AS CmplncDisclProcgStatusTxtlocalized,
  _CmplncDeclnSuplrTP.CmplncDeclnCmplncSts AS CmplncDeclnCmplncSts,
  _CmplncDeclnSuplrTP._CmplncDeclnCmplncStsText.CmplncDeclnCmplncStsTxt : localized AS CmplncDeclnCmplncStsTxtlocalized,
  _CmplncDeclnSuplrTP._CmplncDeclnCmplncStsText[1: Language = $session.system_language ].CmplncDeclnCmplncStsCritlty AS CmplncDeclnCmplncStsCritlty
FROM R_CmplRqRsltDeclnTP
;

Learn More