I_CHMLCMPLNCREQPRPS

CDS View

Chemical Compliance Request Purposes

I_CHMLCMPLNCREQPRPS is a CDS View in S/4HANA. Chemical Compliance Request Purposes. It contains 2 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 2 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_ChmlCmplncReqPrps view from CONSUMPTION Purpose Overview of a Chemical Compliance Request

Fields (2)

KeyField CDS FieldsUsed in Views
KEY ChmlCmplncRequestUUID ChmlCmplncRequestUUID 1
KEY CmplncPrpsUUID CmplncPrpsUUID 1 
@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
}

Learn More