C_ProdMktCmplRqRsltQuery

Marketability Assessments Query | view: CPRODMKTCRRQUERY | Extraction: Not supported | Component: Product Marketability
Column Name Description
CmplRqRsltUUID Compliance Assessment UUID
CmplncPrpsUUID Compliance Purpose
CmplRqVersUUID Compliance Requirement UUID
ChmlCmplncApplUUID Application UUID
ChmlCmplncInfoUUID Chemical Compliance Information
CmplRqRsltExmpAssgmtUUID Exemption Assignment UUID
ChmlCmplncBusinessProcess Business Process
Country Country/Region
ChmlCmplncMatlAssgmtUUID Material Assignment
CmplncPrpsRqmtAssgmtUUID UUID for Compliance Purpose CR Assignment
Column Name Description
Column Name Description
Column Name Description
ValidityStartDateTime null
ValidityEndDateTime null
Column Name Description
ChmlCmplncInfoType CCI Type Show values
MaterialIsSold Material is Sold Show values
MaterialIsTransported Material is Transported Show values
MaterialIsSourced Material is Sourced Show values
MaterialIsProduced Material is Produced Show values
Column Name Description Domain name
ChmlSuplrMatlUUID Material of Chemical Supplier SYSUUID
SubstanceUUID Substance SYSUUID
Product Product Number MATNR
Material Product MATNR
CmplncPrpsName null
CmplRqVersName Compliance Requirement Name EHFND_DESCRIPTION_XL
CmplRqPattern null
MaterialTypeName null
IndustrySectorName null
MaterialGroupName null
DivisionName null
ChmlCmplncBusinessProcessName null
ProdStewardshipRespUnit Responsible Unit EHFND_CCI_RESPONSIBLE_UNIT
ResponsibleUnitName null
ChmlCmplncApplication Application EHFND_CCI_APPLICATION_NCE
ChmlCmplncApplicationName null
ComplianceRequirement Compliance Requirement EHFND_DESCRIPTION_XXS
CmplRqRsltReldCmplncSts Marketability Status for Manually Set Status
CmplRqRsltCmplncStsTxt Compliance Status DDTEXT
CmplRqVersExemption Exemption Code EHFND_TEXT21
CmplRqVersExemptionText null
CmplRqRsltProcessingStatus Processing Status of a Compliance Requirement
ProcessingStatusText null
CountryName null
PersonFullName Processor/Released By TEXT80
ChmlCmplncProdIsResearched Single-Character Flag CHAR1
IndicatorText null
ProductName Product Name EHFND_DESCRIPTION_L
NmbrOfCmplRqRslts null
Master Data Relations Join Conditions
Division
  • Division
  • Client
  • C_PRODMKTCMPLRQRSLTQUERY.DIVISION == TSPA.SPART
  • C_PRODMKTCMPLRQRSLTQUERY.MANDT == TSPA.MANDT
Industry Sector
  • Client
  • Industry Sector
  • C_PRODMKTCMPLRQRSLTQUERY.MANDT == T137.MANDT
  • C_PRODMKTCMPLRQRSLTQUERY.INDUSTRYSECTOR == T137.MBRSH
Material Group
  • Client
  • Product Group
  • C_PRODMKTCMPLRQRSLTQUERY.MANDT == T023.MANDT
  • C_PRODMKTCMPLRQRSLTQUERY.PRODUCTGROUP == T023.MATKL
Product Type
  • Client
  • Product Type
  • C_PRODMKTCMPLRQRSLTQUERY.MANDT == T134.MANDT
  • C_PRODMKTCMPLRQRSLTQUERY.PRODUCTTYPE == T134.MTART