I_ChmlCmplncMktCvrgTP

DDL: I_CHMLCMPLNCMKTCVRGTP Type: view TRANSACTIONAL
18 Fields 1 Data Sources 1 Associations

Chemical Compliance Market Coverage

I_ChmlCmplncMktCvrgTP is a Transactional CDS View that provides data about "Chemical Compliance Market Coverage" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncMktCvrg) and exposes 18 fields with key field ChmlCmplncMktCvrgUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncMktCvrg I_ChmlCmplncMktCvrg from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ChmlCmplncInfoTP _ChmlCmplncInfo _ChmlCmplncInfo.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID

Annotations (16)

NameValueLevelField
EndUserText.label Chemical Compliance Market Coverage view
AbapCatalog.sqlViewName ICCMKTCOVTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.writeDraftPersistence ehfndw_cci_mcvrg view
ObjectModel.writeActivePersistence ehfndv_cci_mcvrg view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncMktCvrgUUID ChmlCmplncMktCvrgUUID Marketability Coverage
ActiveChmlCmplncMktCvrgUUID ChmlCmplncMktCvrgUUID Marketability Coverage
ActiveUUIDofCoverageChmlCmplncInfoUUID
ActiveChmlCmplncInfoUUID ChmlCmplncInfoUUID Chemical Compliance Information PP
CreationUTCDateTime CreationUTCDateTime Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeUTCDateTime LastChangeUTCDateTime Time Stamp
LastChangedByUser LastChangedByUser User Name
Country Country Venue: Ctry/Reg
ChmlCmplncProdnAllwd ChmlCmplncProdnAllwd Produce In
ChmlCmplncExprtAllwd ChmlCmplncExprtAllwd Export From
ChmlCmplncImprtAllwd ChmlCmplncImprtAllwd Import To
ChmlCmplncSalesAllwd ChmlCmplncSalesAllwd Sell In
ChmlCmplncMktCvrgRemark ChmlCmplncMktCvrgRemark Official Remark
_ChmlCmplncInfo _ChmlCmplncInfo
_Country _Country
_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_ChmlCmplncMktCvrgTP.
-- 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_ChmlCmplncMktCvrgTP AS
SELECT
  ChmlCmplncMktCvrgUUID,
  ChmlCmplncMktCvrgUUID AS ActiveChmlCmplncMktCvrgUUID,
  ChmlCmplncInfoUUID AS ActiveChmlCmplncInfoUUID,
  CreationUTCDateTime,
  CreatedByUser,
  LastChangeUTCDateTime,
  LastChangedByUser,
  Country,
  ChmlCmplncProdnAllwd,
  ChmlCmplncExprtAllwd,
  ChmlCmplncImprtAllwd,
  ChmlCmplncSalesAllwd,
  ChmlCmplncMktCvrgRemark
FROM I_ChmlCmplncMktCvrg
LEFT OUTER JOIN I_ChmlCmplncInfoTP AS _ChmlCmplncInfo ON _ChmlCmplncInfo.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [1..1]
;

Learn More