I_SVTCalcChmlCmplncInfoRgln

DDL: I_SVTCALCCHMLCMPLNCINFORGLN SQL: SVTCCIRGLN Type: view BASIC Package: EHPMA_SVT_CALCULATION
11 Fields 1 Data Sources

SVT Calculation for CCI regulation

I_SVTCalcChmlCmplncInfoRgln is a Basic CDS View that provides data about "SVT Calculation for CCI regulation" in SAP S/4HANA. It reads from 1 data source (ehpmad_svt_ccirp) and exposes 11 fields with key field SVTCalcChmCmInRglnUUID. Part of development package EHPMA_SVT_CALCULATION.

Data Sources (1)

SourceAliasJoin Type
ehpmad_svt_ccirp ehpmad_svt_ccirp from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName SVTCCIRGLN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label SVT Calculation for CCI regulation view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SVTCalcChmCmInRglnUUID svtcciregulatoryprofileuuid CCI Regulatory Profile UUID
SVTCalculationStatus calculation_status SVT Calculation Status
SVTCalculationValidityStatus calculation_status SVT Calculation Status
ChmlCmplncInfoUUID chmlcmplncinfouuid Chemical Compliance Information PP
ComplianceRequirement compliancerequirement Compliance Requirement
CmplRqUUID compliancerequirementuuid Compl Req.
CmplRqVersUUID cmplrqversuuid NodeID
ChmlCompositionType chmlcompositiontype Legal Area
SVTBusinessProcess svtbusinessprocess Business Process
SVTCalcChmCmInRglnValdtyStrtDt validitystartdate Validity Start Date
SVTCalcChmCmInRglnValdtyEndDte validityenddate ValidTo

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_SVTCalcChmlCmplncInfoRgln.
-- 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: SVTCCIRGLN

CREATE VIEW I_SVTCalcChmlCmplncInfoRgln AS
SELECT
  svtcciregulatoryprofileuuid AS SVTCalcChmCmInRglnUUID,
  calculation_status AS SVTCalculationStatus,
  calculation_status AS SVTCalculationValidityStatus,
  ChmlCmplncInfoUUID,
  ComplianceRequirement,
  compliancerequirementuuid AS CmplRqUUID,
  CmplRqVersUUID,
  ChmlCompositionType,
  SVTBusinessProcess,
  validitystartdate AS SVTCalcChmCmInRglnValdtyStrtDt,
  validityenddate AS SVTCalcChmCmInRglnValdtyEndDte
FROM ehpmad_svt_ccirp
;

Learn More