I_SVTChmlCmplncInfoRgtyProfile

DDL: I_SVTCHMLCMPLNCINFORGTYPROFILE SQL: SVTCCIRGTYPRFLE Type: view BASIC

SVT Chemical Compliance Info Profile for a regulation

I_SVTChmlCmplncInfoRgtyProfile is a Basic CDS View that provides data about "SVT Chemical Compliance Info Profile for a regulation" in SAP S/4HANA. It reads from 1 data source (ehpmad_svt_ccirp) and exposes 6 fields with key field SVTChmlCmplncInfoRgtyPrflUUID.

Data Sources (1)

SourceAliasJoin Type
ehpmad_svt_ccirp ehpmad_svt_ccirp from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName SVTCCIRGTYPRFLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label SVT Chemical Compliance Info Profile for a regulation view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SVTChmlCmplncInfoRgtyPrflUUID svtcciregulatoryprofileuuid CCI Regulatory Profile UUID
SVTCalculationStatus calculation_status SVT Calculation Status
ChmlCmplncInfoUUID chmlcmplncinfouuid Chemical Compliance Information PP
ComplianceRequirement compliancerequirement Compliance Requirement
ChmlCompositionType chmlcompositiontype Legal Area
SVTBusinessProcess svtbusinessprocess Business Process

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_SVTChmlCmplncInfoRgtyProfile.
-- 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: SVTCCIRGTYPRFLE

CREATE VIEW I_SVTChmlCmplncInfoRgtyProfile AS
SELECT
  svtcciregulatoryprofileuuid AS SVTChmlCmplncInfoRgtyPrflUUID,
  calculation_status AS SVTCalculationStatus,
  ChmlCmplncInfoUUID,
  ComplianceRequirement,
  ChmlCompositionType,
  SVTBusinessProcess
FROM ehpmad_svt_ccirp
;