I_CMPLRQRSLT

CDS View
24 Fields 115 CDS Views

CRR - Compliance Requirement Result

I_CMPLRQRSLT is a CDS View in S/4HANA. CRR - Compliance Requirement Result. It contains 24 fields. 115 CDS views read from this table.

CDS Views using this table (115)

ViewTypeJoinVDMDescription
C_AnlytlCmpstnMarnPlltntIMDG view inner CONSUMPTION Marine Pollutants for Analytical Composition for IMDG
C_CA_AnlytlCmpstnMarnPlltntTDG view inner CONSUMPTION Marine Pollutants for Analytical Composition for TDG
C_ChmCmInCmplRqRsltSftyDataSht view from CONSUMPTION SDS Compliance Requirement Results for UP
C_CmplRqRsltDraftAdminvData view from CONSUMPTION Draft admin data for Compliance Assessments
C_CmplRqRsltFltrByProcsr view from CONSUMPTION CmplRqRslt Filtered by Processor
C_CmplRqRsltHistory view from CONSUMPTION History of Compliance Requirement Results
C_CmplRqRsltProductMonitor view from CONSUMPTION Assess Marketability Requirements for Products
C_CmplRqRsltRawMatlMonitor view from CONSUMPTION Assess Marketability Requirements for Raw Materials
C_CmplRqRsltSubstMonitor view from CONSUMPTION Assess Marketability Requirements for Substances
C_CntrbtScenAssgmtEnhanced view inner CONSUMPTION Contributing Scenario Assignment Enhanced
C_ExpsrScenAssgmtEnhanced view inner CONSUMPTION Exposure Scenario Assignment Enhanced
C_PckgdDngrsGoodMarkingOvw view_entity from CONSUMPTION Packaged Dangerous Good Marking Overview
C_SftyDataShtRelatedAssmt view from CONSUMPTION SDS Related Assmt for unpackaged prods
C_UnpackagedDangerousGoodClfn view from CONSUMPTION Unpackaged Dangerous Good Classification
C_UpaDaGdsClfnAssgdPckgdDet view_entity from CONSUMPTION Related Packaged Product Details
C_US_AnlytlCmpstnMarnPlltntCFR view inner CONSUMPTION Marine Pollutants for Analytical Composition for 49 CFR
C_US_AnlytlCmpstnRptblQtyCFR view inner CONSUMPTION Reportable Qunatity from Analytical Composition for 49 CFR
I_ChmCmInCmplRqRsltDngrsGds view from COMPOSITE Dangerous Goods Reqs Unpackaged Product
I_ChmlSuplrMatlCmplRqRslt view from COMPOSITE Compliance Requirement Results for Supplier Material
I_CmplRqRslt1stAidTP view from TRANSACTIONAL First Aid Measure
I_CmplRqRsltCalcdCmplncSts view from COMPOSITE Determination of calculated status on processing status
I_CmplRqRsltCustCmplncChkTP view from TRANSACTIONAL CRR Customer Compliance Check - TP
I_CmplRqRsltDngrsGdsBscClfnTP view from TRANSACTIONAL TP View for CR Result DG Basic Clfn Root
I_CmplRqRsltFrfghtngTP view from TRANSACTIONAL Firefighting Measures
I_CmplRqRsltGHSClfnAssmtTP view from TRANSACTIONAL GHS Classification Assessment - TP
I_CmplRqRsltGHSLblAssmtTP view from TRANSACTIONAL GHS Labeling Assessment - TP
I_CmplRqRsltHzdsClfnTP view from TRANSACTIONAL SARA Classification
I_CmplRqRsltHzdsIngrdntTP view from TRANSACTIONAL Information on Hazardous Ingredients
I_CmplRqRsltMkt view from COMPOSITE CmplRqRslt Marketability for Unpackaged Products
I_CmplRqRsltNFPARatingAssmtTP view from TRANSACTIONAL NFPA Rating Assessment - TP
I_CmplRqRsltOccptlExpsrLmtTP view from TRANSACTIONAL Occupational Exposure Limits
I_CmplRqRsltPCESAnnexAssmtTP view from TRANSACTIONAL Annex Assessment - TP
I_CmplRqRsltPCESAssmtTP view from TRANSACTIONAL Exposure Scenario Assessment - TP
I_CmplRqRsltPCESCnsmrAssmtTP view from TRANSACTIONAL Contributing Scenario Consumer Assessment - TP
I_CmplRqRsltPCESEnvrmtAssmtTP view from TRANSACTIONAL Contributing Scenario Environment Assessment - TP
I_CmplRqRsltPCESWrkrAssmtTP view from TRANSACTIONAL Contributing Scenario Worker Assessment - TP
I_CmplRqRsltPCNTP view from TRANSACTIONAL CRR Poison Centre Notification - TP
I_CmplRqRsltProtTP view from TRANSACTIONAL Personal Protection Measures
I_CmplRqRsltSftyDataShtTP view from TRANSACTIONAL CmplRqRslt Safety Datasheet
I_CmplRqRsltSpillTP view from TRANSACTIONAL Accidental Release Measures
I_CmplRqRsltStorageClassTP view from TRANSACTIONAL Storage Class
I_CmplRqRsltSubstListChkTP view from TRANSACTIONAL CmplRqRslt Substance List Check
I_CmplRqRsltTP view from TRANSACTIONAL CRR - Compliance Requirement Result
I_CmplRqRsltTradeSecretAssmtTP view from TRANSACTIONAL CBI Registration Assessment - TP
I_CmplRqRsltWasteCodeTP view from TRANSACTIONAL Waste Code - TP
I_DngrsGoodReldClassfctnCount view_entity from COMPOSITE
I_NewestDngrsGdsClfnForCmRqVs view_entity from COMPOSITE Newest DG CRR for CRV
I_PackagedDangerousGoodClfn view_entity from COMPOSITE
I_PackagedDngrsGdsCube view from COMPOSITE Packaged Dangerous Goods Cube
I_PckgdCmplRqRsltMkt view from COMPOSITE CmplRqRslt Marketability for Packaged Products
I_ProdMktCmplRqRsltText view from COMPOSITE Text associations for CmplRq for Products
I_SftyDataShtCmplRqRsltCube view from COMPOSITE SafetyDataSheet CRR Cube
I_UnpackagedDngrsGdsCube view from COMPOSITE Unpackaged Dangerous Goods Cube
P_BasicDescForReldRglnMaxCRR view inner COMPOSITE
P_BasicDescForReldRglnScore view from COMPOSITE
P_CCIPPAssmntWithReldUPAssmnt view from CONSUMPTION PP Assmnt (IP and RE) for UP Assmnt (RE)
P_ChmlCmplncCRRGrpByCRVers view from COMPOSITE
P_ChmlCmplncInfoAssmtCmbnd view inner CONSUMPTION CCI assignments combined
P_ChmlCmplncInfoAssmtLastDate view from CONSUMPTION CCI assmt last date
P_ChmlCmplncPrpsRqmtDgCT view inner CONSUMPTION
P_ChmlCmplncPrpsRqmtPmaCT view inner CONSUMPTION
P_ChmlCmplncPrpsRqmtSdsCT view inner CONSUMPTION
P_ChmlCmplRqRsltInProcCt view from COMPOSITE
P_ChmlCmplRqRsltReldCt view from COMPOSITE
P_ChmlCmplRqRsltVersCt view from COMPOSITE
P_ChmlCmpstnCmplRqRsltNmbr view from CONSUMPTION Number of Compliance Requirments for Composition
P_CmplncRqmtRsltRefcdObject view_entity from CONSUMPTION
P_CmplncRqmtRsltRefcdObject view_entity union_all CONSUMPTION
P_CmplRqRsltChmlCmpstn view from CONSUMPTION
P_CmplRqRsltCntClfdAsDgByPStat view from COMPOSITE
P_CmplRqRsltCntPGIDN view from COMPOSITE
P_CmplRqRsltInPrgrsRefcdObj view_entity from CONSUMPTION
P_CmplRqRsltLatestPredecessor view_entity from CONSUMPTION
P_CmplRqRsltListTypeExisting view from CONSUMPTION
P_CmplRqRsltLtst view from CONSUMPTION
P_CmplRqRsltLtstCrtnDte view from CONSUMPTION
P_CmplRqRsltOELTransientFields view from CONSUMPTION
P_CmplRqRsltPredecessorInProc view_entity from CONSUMPTION
P_CmplRqRsltPredecessorRlsd view_entity from CONSUMPTION
P_CmplRqRsltTransientFields view from CONSUMPTION
P_DaGdsLgsPaInsnRglnUpdtCube view_entity from CONSUMPTION
P_DaGdsLgsPaInsnRglnUpdtOvw view_entity from CONSUMPTION
P_DaGdsLogsPaInstrnClfnBscClfn view_entity from CONSUMPTION
P_DangerousGoodInProgress view_entity from CONSUMPTION
P_DangerousGoodsClassification view from COMPOSITE
P_GHSClfnSubstRelMigrtnRqd view_entity from CONSUMPTION
P_GHSLblSubstRelMigrtnRqd view_entity from CONSUMPTION
P_MyDangerousGoodInProgress view_entity from CONSUMPTION
P_MyLatestCRRForPckgdDGCount view from COMPOSITE
P_MyLatestCRRForUnPckgdDGCount view from CONSUMPTION
P_MyPackagedDangerousGoodIP view_entity from CONSUMPTION
P_NewestCRRStatusForCRVAndCCI view from COMPOSITE
P_NewestPPCRRForCRVAndCCI view from COMPOSITE
P_NewestReleasedRsltForCmplRq view_entity from COMPOSITE
P_NwestPPCRRStatusForCRVAndCCI view from COMPOSITE
P_PackagedDangerousGoodInProgr view_entity from CONSUMPTION
P_PckgdRglnUpdtCube view from CONSUMPTION
P_PPCRRStatusForCRVAndCCI_All view from CONSUMPTION
P_RawChmlCmplRqRsltInProcCt view from CONSUMPTION
P_RawChmlCmplRqRsltReldCt view from CONSUMPTION
P_RawChmlCmplRqRsltUnknownCt view from CONSUMPTION
P_RawMatlChmlCmplncSts view left_outer CONSUMPTION Compliance Status of Raw Material for a Supplier Material
P_ReleasedCRRForUnpckgdDGCount view from COMPOSITE
P_UnpckgdRglnUpdtCube view from COMPOSITE
R_CmplRqRsltDisclTP view_entity from TRANSACTIONAL Compliance Assessment Disclosure - TP
R_CmplRqRsltDynPatternAssmtTP view_entity from TRANSACTIONAL Dynamic Pattern Assessment - TP
R_CmplRqRsltGHSClfnAssmtTP view_entity from TRANSACTIONAL GHS Classification Assessment - TP
R_CmplRqRsltGHSLblAssmtTP view_entity from TRANSACTIONAL GHS Labeling Assessment - TP
R_CmplRqRsltHndlgStorageTP view_entity from TRANSACTIONAL Handling Storage root
R_CmplRqRsltLblDataTP view_entity from TRANSACTIONAL Label Data Assesement - TP
R_CmplRqRsltPCNTP view_entity from TRANSACTIONAL CR Result PCN - TP
R_CmplRqRsltSftyDataShtTP view_entity from TRANSACTIONAL SDS Assessment - TP
R_CmplRqRsltStorageClassTP view_entity from TRANSACTIONAL Storage Class Assessment
R_DangerousGoodsClassfctnTP view_entity from TRANSACTIONAL Dangerous Goods Classification - TP
R_DngrsGdsBasicClassfctnTP view_entity from TRANSACTIONAL DG Basic Classification - TP

Fields (24)

KeyField CDS FieldsUsed in Views
KEY ChmlCmplncInfoUUID ChmlCmplncInfoUUID,PckgdChmlCmplncInfoUUID 40
KEY CmplRqRsltReferencedObjectType CmplRqRsltReferencedObjectType 3
KEY CmplRqRsltReferencedObjectUUID CmplRqRsltReferencedObjectUUID 8
KEY CmplRqRsltUUID CmplRqRsltUUID 30
KEY CmplRqVersUUID CmplRqVersUUID 23
KEY ComplianceRequirement ComplianceRequirement 23
_ChmlCmplncInfo _ChmlCmplncInfo 5
_CmplRqRsltProcessingStatus _CmplRqRsltProcessingStatus 3
_CmplRqVers _CmplRqVers 1
ChemicalCustomerMaterialUUID ChemicalCustomerMaterialUUID 1
ChmlSuplrMatlUUID ChmlSuplrMatlUUID 5
CmplRqRsltCalculatedStatus CmplRqRsltCalculatedStatus 3
CmplRqRsltManualStatus CmplRqRsltManualStatus 5
CmplRqRsltProcessingStatus CmplRqRsltProcessingStatus 21
CmplRqRsltReldCmplncSts CmplRqRsltReldCmplncSts 1
CreationDateTime CreationDateTime 2
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
PCESScenarioUUID PCESScenarioUUID 1
Processor Processor 7
ReleasedByUser ReleasedByUser 6
SubstanceUUID SubstanceUUID 9
ValidityEndDateTime ValidityEndDateTime 1
ValidityStartDateTime ValidityStartDateTime 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- CRR - Compliance Requirement Result
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMPLRQRSLT (
    CHMLCMPLNCINFOUUID,
    CMPLRQRSLTREFERENCEDOBJECTTYPE,
    CMPLRQRSLTREFERENCEDOBJECTUUID,
    CMPLRQRSLTUUID,
    CMPLRQVERSUUID,
    COMPLIANCEREQUIREMENT,
    _CHMLCMPLNCINFO,
    _CMPLRQRSLTPROCESSINGSTATUS,
    _CMPLRQVERS,
    CHEMICALCUSTOMERMATERIALUUID,
    CHMLSUPLRMATLUUID,
    CMPLRQRSLTCALCULATEDSTATUS,
    CMPLRQRSLTMANUALSTATUS,
    CMPLRQRSLTPROCESSINGSTATUS,
    CMPLRQRSLTRELDCMPLNCSTS,
    CREATIONDATETIME,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PCESSCENARIOUUID,
    PROCESSOR,
    RELEASEDBYUSER,
    SUBSTANCEUUID,
    VALIDITYENDDATETIME,
    VALIDITYSTARTDATETIME,
    PRIMARY KEY (CHMLCMPLNCINFOUUID, CMPLRQRSLTREFERENCEDOBJECTTYPE, CMPLRQRSLTREFERENCEDOBJECTUUID, CMPLRQRSLTUUID, CMPLRQVERSUUID, COMPLIANCEREQUIREMENT)
);

Learn More