I_ChmlCmplncReqPrps

DDL: I_CHMLCMPLNCREQPRPS Type: view COMPOSITE

Chemical Compliance Request Purposes

I_ChmlCmplncReqPrps is a Composite CDS View that provides data about "Chemical Compliance Request Purposes" in SAP S/4HANA. It reads from 2 data sources (I_ChmlCmplncReqPrpsAssgmt, I_ChmlCmplncPrpsAssgmt) and exposes 11 fields with key fields ChmlCmplncRequestUUID, CmplncPrpsUUID, CmplncPrpsUUID.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_ChmlCmplncReqPrpsAssgmt _ChmlCmplncPrpsAssgmt from
I_ChmlCmplncPrpsAssgmt _ChmlCmplncPrpsAssgmt union

Annotations (10)

NameValueLevelField
EndUserText.label Chemical Compliance Request Purposes view
AbapCatalog.sqlViewName ICRQMREQPRPS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncRequestUUID _ChmlCmplncReq ChmlCmplncRequestUUID
KEY CmplncPrpsUUID I_ChmlCmplncPrpsAssgmt CmplncPrpsUUID
_Purpose I_ChmlCmplncPrpsAssgmt _Purpose
ChmlCmplncInfoUUID _ChmlCmplncReq ChmlCmplncInfoUUID
ChmlCmplncBusinessProcess _ChmlCmplncReq ChmlCmplncBusinessProcess
ChmlCmplncRequestUUID
KEY CmplncPrpsUUID I_ChmlCmplncPrpsAssgmt CmplncPrpsUUID
_Purpose I_ChmlCmplncPrpsAssgmt _Purpose
ChmlCmplncInfoUUID I_ChmlCmplncPrpsAssgmt ChmlCmplncInfoUUID
ChmlCmplncBusinessProcess _ChmlCmplncReq ChmlCmplncBusinessProcess
_ChmlCmplncInfo I_ChmlCmplncPrpsAssgmt _ChmlCmplncInfo 
@EndUserText.label: 'Chemical Compliance Request Purposes'
@AbapCatalog:
{
 sqlViewName: 'ICRQMREQPRPS',
 compiler.compareFilter: true
}

@AccessControl:
{
  authorizationCheck: #MANDATORY
}
--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API

@ObjectModel:
{
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #L,
    serviceQuality: #C
  }
}

/*-----------------------------------------------------------------------------------
Retrieves a distinct list of all involved purposes for a chemical compliance
request which:
  1. Already exists as assessment at the Unpackaged Product
  2. Requested/Assigned Purposes of a chemcial compliance Request
--------------------------------------------------------------------------------------*/

define view I_ChmlCmplncReqPrps

  // Purpose Assignment from Compliance Request

  as select from I_ChmlCmplncReqPrpsAssgmt as _ChmlCmplncPrpsAssgmt
    join         I_ChmlCmplncReq           as _ChmlCmplncReq on _ChmlCmplncPrpsAssgmt.ChmlCmplncRequestUUID = _ChmlCmplncReq.ChmlCmplncRequestUUID
{
  key          _ChmlCmplncReq.ChmlCmplncRequestUUID,
  key          _ChmlCmplncPrpsAssgmt.CmplncPrpsUUID,

               _ChmlCmplncPrpsAssgmt._Purpose,
               // Needed for Auth Check

               _ChmlCmplncReq.ChmlCmplncInfoUUID,
               _ChmlCmplncReq.ChmlCmplncBusinessProcess,
               _ChmlCmplncReq._ChmlCmplncInfo
}
// Purpose Assignment from Unpackaged Product

union select from I_ChmlCmplncPrpsAssgmt as _ChmlCmplncPrpsAssgmt

  join            I_ChmlCmplncReq        as _ChmlCmplncReq on _ChmlCmplncPrpsAssgmt.ChmlCmplncInfoUUID = _ChmlCmplncReq.ChmlCmplncProdUUID

{
  key         _ChmlCmplncReq.ChmlCmplncRequestUUID,
  key         _ChmlCmplncPrpsAssgmt.CmplncPrpsUUID,

              _ChmlCmplncPrpsAssgmt._Purpose,
              // Needed for Auth Check

              _ChmlCmplncPrpsAssgmt.ChmlCmplncInfoUUID,
              _ChmlCmplncReq.ChmlCmplncBusinessProcess,
              _ChmlCmplncPrpsAssgmt._ChmlCmplncInfo
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHMLCMPLNCPRPSASSGMT",
"I_CHMLCMPLNCREQ",
"I_CHMLCMPLNCREQPRPSASSGMT"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCINFO",
"I_CMPLNCPRPS"
],
"BASE":
[
"I_CHMLCMPLNCREQ",
"I_CHMLCMPLNCREQPRPSASSGMT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More