I_CmplncDisclDeclnCube

DDL: I_CMPLNCDISCLDECLNCUBE Type: view_entity COMPOSITE Package: EHFND_RAP_CD
34 Fields 1 Data Sources 3 Associations

Analyze Compliance Disclosures - Cube

I_CmplncDisclDeclnCube is a Composite CDS View (Cube) that provides data about "Analyze Compliance Disclosures - Cube" in SAP S/4HANA. It reads from 1 data source (I_CmplncDisclDeclnFact) and exposes 34 fields with key fields CmplncDisclUUID, CmplncDeclnUUID. It has 3 associations to related views. Part of development package EHFND_RAP_CD.

Data Sources (1)

SourceAliasJoin Type
I_CmplncDisclDeclnFact I_CmplncDisclDeclnFact from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_CmplRqVersEnhanced _CmplRqVers $projection.CmplRqVersUUID = _CmplRqVers.CmplRqVersUUID
[1..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[1..1] I_Country _Country $projection.Country = _Country.Country

Annotations (11)

NameValueLevelField
EndUserText.label Analyze Compliance Disclosures - Cube view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY CmplncDisclUUID CmplncDisclUUID Compliance Disclosure UUID
KEY CmplncDeclnUUID CmplncDeclnUUID Compliance Declaration UUID
CmplncDisclInternalNumber CmplncDisclInternalNumber Compliance Disclosure ID
BusinessPartner BusinessPartner Issuing Authority
AddressID AddressID Ship-to address
CmplRqVersUUID CmplRqVersUUID NodeID
Supplier Supplier Supplier
CmplncDisclScope CmplncDisclScope Compliance Disclosure Scope
CmplncDisclType Compliance Disclosure Type
CmplncDisclProcgStatus Compliance Disclosure Processing Status
CmplncDisclBPRoleIsSupplier CmplncDisclBPRoleIsSupplier Compliance Disclosure Supplier BP Role
CmplncDeclnCmplncSts Compliance Declaration Compliance Status
CmplncDeclnIsEffective Compliance Declaration Is Effective
Country
CountryName
CmplncDisclReceiptDate CmplncDisclReceiptDate Compliance Disclosure Receipt Date
CreationUTCDateTime Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeUTCDateTime Time Stamp
LastChangedByUser LastChangedByUser User Name
ComplianceRequirement _CmplRqVers ComplianceRequirement Compliance Requirement
CmplRqVersName _CmplRqVers CmplRqVersName Compliance Requirement Name
BPSupplierName
CmplncDeclnEffectiveText _CmplncDeclnEffectiveText IndicatorText
CmplncDisclProcgStatusTxt _CmplncDisclProcgStatusText CmplncDisclProcgStatusTxt
CmplncDeclnCmplncStsTxt _CmplncDeclnCmplncStsText CmplncDeclnCmplncStsTxt
CmplncDisclTypeTxt _CmplncDisclTypeText CmplncDisclTypeTxt
CreatedByUserName _CreatedByUser UserDescription Full Name
LastChangedByUserName _LastChangedByUser UserDescription Full Name
CmplncDisclProcgStatusCritlty _CmplncDisclProcgStatusText CmplncDisclProcgStatusCritlty
CmplncDeclnCmplncStsCritlty _CmplncDeclnCmplncStsText CmplncDeclnCmplncStsCritlty
NumberOfComplianceDeclaration 1
_CmplRqVers _CmplRqVers
_Country _Country

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 I_CmplncDisclDeclnCube.
-- 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 I_CmplncDisclDeclnCube AS
SELECT
  CmplncDisclUUID,
  CmplncDeclnUUID,
  CmplncDisclInternalNumber,
  BusinessPartner,
  AddressID,
  CmplRqVersUUID,
  Supplier,
  CmplncDisclScope,
  cast( CmplncDisclType as char2 ) AS CmplncDisclType,
  cast( CmplncDisclProcgStatus as char2 ) AS CmplncDisclProcgStatus,
  CmplncDisclBPRoleIsSupplier,
  cast( CmplncDeclnCmplncSts as numc2 ) AS CmplncDeclnCmplncSts,
  cast( CmplncDeclnIsEffective as char1 ) AS CmplncDeclnIsEffective,
  _Supplier._AddressRepresentation.Country AS Country,
  _Supplier._AddressRepresentation._Country._Text[1:Language = $session.system_language].CountryName AS CountryName,
  CmplncDisclReceiptDate,
  cast( CreationUTCDateTime as timestamp ) AS CreationUTCDateTime,
  CreatedByUser,
  cast( LastChangeUTCDateTime as timestamp ) AS LastChangeUTCDateTime,
  LastChangedByUser,
  _CmplRqVers.ComplianceRequirement AS ComplianceRequirement,
  _CmplRqVers.CmplRqVersName AS CmplRqVersName,
  _CmplncDeclnEffectiveText.IndicatorText AS CmplncDeclnEffectiveText,
  _CmplncDisclProcgStatusText.CmplncDisclProcgStatusTxt AS CmplncDisclProcgStatusTxt,
  _CmplncDeclnCmplncStsText.CmplncDeclnCmplncStsTxt AS CmplncDeclnCmplncStsTxt,
  _CmplncDisclTypeText.CmplncDisclTypeTxt AS CmplncDisclTypeTxt,
  _CreatedByUser.UserDescription AS CreatedByUserName,
  _LastChangedByUser.UserDescription AS LastChangedByUserName,
  _CmplncDisclProcgStatusText.CmplncDisclProcgStatusCritlty AS CmplncDisclProcgStatusCritlty,
  _CmplncDeclnCmplncStsText.CmplncDeclnCmplncStsCritlty AS CmplncDeclnCmplncStsCritlty,
  1 AS NumberOfComplianceDeclaration
FROM I_CmplncDisclDeclnFact
LEFT OUTER JOIN I_CmplRqVersEnhanced AS _CmplRqVers ON CmplRqVersUUID = _CmplRqVers.CmplRqVersUUID  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [1..1]
;

Learn More