I_ComplianceDisclosure

DDL: I_COMPLIANCEDISCLOSURE Type: view_entity BASIC
20 Fields 1 Data Sources 4 Associations

Compliance Disclosure

I_ComplianceDisclosure is a Basic CDS View that provides data about "Compliance Disclosure" in SAP S/4HANA. It reads from 1 data source (ehfndd_cd) and exposes 20 fields with key field CmplncDisclUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
ehfndd_cd ehfndd_cd from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[0..1] I_User _CreatedByUser _CreatedByUser.UserID = $projection.CreatedByUser
[0..1] I_User _LastChangedByUser _LastChangedByUser.UserID = $projection.LastChangedByUser
[0..*] I_ComplianceDeclaration _ComplianceDeclaration

Annotations (8)

NameValueLevelField
EndUserText.label Compliance Disclosure view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY CmplncDisclUUID cmplncdiscluuid Compliance Disclosure UUID
CreationUTCDateTime creationutcdatetime Time Stamp
CreatedByUser createdbyuser User Name
LastChangeUTCDateTime lastchangeutcdatetime Time Stamp
LastChangedByUser lastchangedbyuser User Name
CmplncDisclInternalNumber cmplncdisclinternalnumber Compliance Disclosure ID
BusinessPartner businesspartner Issuing Authority
CmplncDisclBPRoleIsSupplier cmplncdisclbproleissupplier Compliance Disclosure Supplier BP Role
Supplier supplier Supplier
AddressID addressid Ship-to address
CmplncDisclReceiptDate cmplncdisclreceiptdate Compliance Disclosure Receipt Date
CmplncDisclType cmplncdiscltype Compliance Disclosure Type
CmplncDisclProcgStatus cmplncdisclprocgstatus Compliance Disclosure Processing Status
CmplncDisclScope cmplncdisclscope Compliance Disclosure Scope
CmplncDisclIsBlocked cmplncdisclisblocked Compliance Disclosure Block Indicator
CmplncDisclRtntnPerdStrtDteTme cmplncdisclrtntnperdstrtdtetme End of Business Date
_ComplianceDeclaration _ComplianceDeclaration
_Supplier _Supplier
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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_ComplianceDisclosure.
-- 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_ComplianceDisclosure AS
SELECT
  CmplncDisclUUID,
  CreationUTCDateTime,
  CreatedByUser,
  LastChangeUTCDateTime,
  LastChangedByUser,
  CmplncDisclInternalNumber,
  BusinessPartner,
  CmplncDisclBPRoleIsSupplier,
  Supplier,
  AddressID,
  CmplncDisclReceiptDate,
  CmplncDisclType,
  CmplncDisclProcgStatus,
  CmplncDisclScope,
  CmplncDisclIsBlocked,
  CmplncDisclRtntnPerdStrtDteTme
FROM ehfndd_cd
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON _LastChangedByUser.UserID = LastChangedByUser  -- association [0..1]
LEFT OUTER JOIN I_ComplianceDeclaration AS _ComplianceDeclaration ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More