I_ProdMktCmplRqRsltText

DDL: I_PRODMKTCMPLRQRSLTTEXT SQL: IPRODMKTCRRTEXT Type: view COMPOSITE Package: EHPMA_CNS_CRR
34 Fields 1 Data Sources 4 Associations

Text associations for CmplRq for Products

I_ProdMktCmplRqRsltText is a Composite CDS View that provides data about "Text associations for CmplRq for Products" in SAP S/4HANA. It reads from 1 data source (I_CmplRqRslt) and exposes 34 fields with key fields ChmlCmplncInfoUUID, CmplRqRsltUUID, CmplRqVersUUID, ChmlCmplncMatlAssgmtUUID, CmplRqRsltExmpAssgmtUUID. It has 4 associations to related views. Part of development package EHPMA_CNS_CRR.

Data Sources (1)

SourceAliasJoin Type
I_CmplRqRslt CmplRqRslt from

Associations (4)

CardinalityTargetAliasCondition
[1..*] I_ChmlCmplncMatlAssgmt _ChmlCmplncMatlAssgmt $projection.ChmlCmplncInfoUUID = _ChmlCmplncMatlAssgmt.ChmlCmplncInfoUUID
[0..1] I_BusinessUserBasic _ProcessorUser $projection.Processor = _ProcessorUser.BusinessPartner
[0..1] I_BusinessUserBasic _ReleasedByUser $projection.ReleasedByUser = _ReleasedByUser.BusinessPartner
[0..*] I_CmplRqRsltExemption _CmplRqRsltExemption $projection.CmplRqRsltUUID = _CmplRqRsltExemption.CmplRqRsltUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPRODMKTCRRTEXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Text associations for CmplRq for Products view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID I_CmplRqRslt ChmlCmplncInfoUUID Chemical Compliance Information PP
KEY CmplRqRsltUUID I_CmplRqRslt CmplRqRsltUUID SDS Assessment
KEY CmplRqVersUUID I_CmplRqRslt CmplRqVersUUID NodeID
KEY ChmlCmplncMatlAssgmtUUID _ChmlCmplncMatlAssgmt ChmlCmplncMatlAssgmtUUID Product Assignment
KEY CmplRqRsltExmpAssgmtUUID _CmplRqRsltExemption CmplRqRsltExmpAssgmtUUID Exemption Assignment UUID
ChmlSuplrMatlUUID I_CmplRqRslt ChmlSuplrMatlUUID Supplier Raw Material
SubstanceUUID I_CmplRqRslt SubstanceUUID Substance
Product
ChmlCmplncInfoType
MaterialIsSold
MaterialIsTransported
MaterialIsSourced
MaterialIsProduced
Material _ChmlCmplncPrimMatl Material Vehicle Model
ProdStewardshipRespUnit
ChmlCmplncInfoCombinedName _ChmlCmplncPrimMatl ChmlCmplncInfoCombinedName
ChmlCmplncProdIsResearched
CmplRqRsltProcessingStatus I_CmplRqRslt CmplRqRsltProcessingStatus Processing Status
ComplianceRequirement I_CmplRqRslt ComplianceRequirement Compliance Requirement
ReleasedByUser I_CmplRqRslt ReleasedByUser Released By
Processor I_CmplRqRslt Processor User Name
_ProcessorUser _ProcessorUser
_ReleasedByUser _ReleasedByUser
_ProductGroup
_ProductType
_Division
_RespUnitForProductStewardship
ValidityStartDateTime ValidityStartDateTime Valid From Timestamp
ValidityEndDateTime ValidityEndDateTime Valid To Timestamp
ProductGroup
ProductType
IndustrySector
Division
CmplRqVersExemption _CmplRqRsltExemption CmplRqVersExemption Exemption

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_ProdMktCmplRqRsltText.
-- 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: IPRODMKTCRRTEXT

CREATE VIEW I_ProdMktCmplRqRsltText AS
SELECT
  CmplRqRslt.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  CmplRqRslt.CmplRqRsltUUID AS CmplRqRsltUUID,
  CmplRqRslt.CmplRqVersUUID AS CmplRqVersUUID,
  _ChmlCmplncMatlAssgmt.ChmlCmplncMatlAssgmtUUID AS ChmlCmplncMatlAssgmtUUID,
  _CmplRqRsltExemption.CmplRqRsltExmpAssgmtUUID AS CmplRqRsltExmpAssgmtUUID,
  CmplRqRslt.ChmlSuplrMatlUUID AS ChmlSuplrMatlUUID,
  CmplRqRslt.SubstanceUUID AS SubstanceUUID,
  _ChmlCmplncMatlAssgmt._Product.Product AS Product,
  _ChmlCmplncPrimMatl._ChmlCmplncInfo.ChmlCmplncInfoType AS ChmlCmplncInfoType,
  _ChmlCmplncPrimMatl._ChmlCmplncInfo.MaterialIsSold AS MaterialIsSold,
  _ChmlCmplncPrimMatl._ChmlCmplncInfo.MaterialIsTransported AS MaterialIsTransported,
  _ChmlCmplncPrimMatl._ChmlCmplncInfo.MaterialIsSourced AS MaterialIsSourced,
  _ChmlCmplncPrimMatl._ChmlCmplncInfo.MaterialIsProduced AS MaterialIsProduced,
  _ChmlCmplncPrimMatl.Material AS Material,
  _ChmlCmplncPrimMatl._ChmlCmplncInfo.ProdStewardshipRespUnit AS ProdStewardshipRespUnit,
  _ChmlCmplncPrimMatl.ChmlCmplncInfoCombinedName AS ChmlCmplncInfoCombinedName,
  cast(_ChmlCmplncPrimMatl._ChmlCmplncInfo.ChmlCmplncProdIsResearched as char1) AS ChmlCmplncProdIsResearched,
  CmplRqRslt.CmplRqRsltProcessingStatus AS CmplRqRsltProcessingStatus,
  CmplRqRslt.ComplianceRequirement AS ComplianceRequirement,
  CmplRqRslt.ReleasedByUser AS ReleasedByUser,
  CmplRqRslt.Processor AS Processor,
  _ChmlCmplncMatlAssgmt._Product._ProductGroup AS _ProductGroup,
  _ChmlCmplncMatlAssgmt._Product._ProductType AS _ProductType,
  _ChmlCmplncMatlAssgmt._Product._Division AS _Division,
  _ChmlCmplncPrimMatl._ChmlCmplncInfo._RespUnitForProductStewardship AS _RespUnitForProductStewardship,
  ValidityStartDateTime,
  ValidityEndDateTime,
  _ChmlCmplncMatlAssgmt._Product.ProductGroup AS ProductGroup,
  _ChmlCmplncMatlAssgmt._Product.ProductType AS ProductType,
  _ChmlCmplncMatlAssgmt._Product.IndustrySector AS IndustrySector,
  _ChmlCmplncMatlAssgmt._Product.Division AS Division,
  _CmplRqRsltExemption.CmplRqVersExemption AS CmplRqVersExemption
FROM I_CmplRqRslt AS CmplRqRslt
LEFT OUTER JOIN I_ChmlCmplncMatlAssgmt AS _ChmlCmplncMatlAssgmt ON ChmlCmplncInfoUUID = _ChmlCmplncMatlAssgmt.ChmlCmplncInfoUUID  -- association [1..*]
LEFT OUTER JOIN I_BusinessUserBasic AS _ProcessorUser ON Processor = _ProcessorUser.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _ReleasedByUser ON ReleasedByUser = _ReleasedByUser.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CmplRqRsltExemption AS _CmplRqRsltExemption ON CmplRqRsltUUID = _CmplRqRsltExemption.CmplRqRsltUUID  -- association [0..*]
;

Learn More