I_CHMLCMPLNCREQ

CDS View

Chemical Compliance Request

I_CHMLCMPLNCREQ is a CDS View in S/4HANA. Chemical Compliance Request. It contains 46 fields. 9 CDS views read from this table.

Used by 9 CDS view(s) 46 fields

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_ChmlCmplncReqRequesterUserVH view from CONSUMPTION Chemical Compliance Request Requester User Value Help
C_ChmlCmplncReqRequesterVH view from CONSUMPTION Value Help for Requester of a Chemical Compliance Request
I_ChmlCmplncReqTP view from TRANSACTIONAL Chemical Compliance Request
I_PckgdReqFromLogsTrigger view from COMPOSITE Packaged Requests from Logistics Trigger
I_UnpckgdReqFromLogsTrigger view from COMPOSITE Unpackaged Requests from Logistics Trigger
P_ChmlCmplncReqMigration view from COMPOSITE
P_ChmlCmplncReqMigration view inner COMPOSITE
P_ChmlCmplncReqUnprocessedCT view from CONSUMPTION
R_ProductComplianceRequestTP view_entity from TRANSACTIONAL Product Compliance Request - TP

Fields (46)

KeyField CDS FieldsUsed in Views
KEY ChmlCmplncRequestUUID ChmlCmplncRequestUUID 2
_BusinessProcess _BusinessProcess 1
_BusinessUserProcessor _BusinessUserProcessor 1
_BusinessUserRequester _BusinessUserRequester 1
_ChemicalCustomerMaterial _ChemicalCustomerMaterial 1
_ChmlCmplncInfo _ChmlCmplncInfo 1
_ChmlCmplncReqCmplncProc _ChmlCmplncReqCmplncProc 1
_CreatedByUser _CreatedByUser 1
_LastChangedByUser _LastChangedByUser 1
_OriginProcess _OriginProcess 1
_OriginType _OriginType 1
_Product _Product 1
_RequestedApplication _RequestedApplication 1
_RequestedMarket _RequestedMarket 1
_RequestedPlnt _RequestedPlnt 1
_RequestedPurpose _RequestedPurpose 1
_RequestedSlsOrg _RequestedSlsOrg 1
_RequesterUser _RequesterUser 1
_RequestStatus _RequestStatus 1
_RouteSegment _RouteSegment 1
_Supplier _Supplier 1
BusinessSystemName BusinessSystemName 1
ChemicalCustomerMaterialUUID ChemicalCustomerMaterialUUID 1
ChmlCmplncBusinessProcess ChmlCmplncBusinessProcess 2
ChmlCmplncInfoUUID ChmlCmplncInfoUUID 2
ChmlCmplncProdUUID ChmlCmplncProdUUID 2
ChmlCmplncReqBPProcessor ChmlCmplncReqBPProcessor 1
ChmlCmplncReqBPRequester ChmlCmplncReqBPRequester 1
ChmlCmplncReqCmplncProc ChmlCmplncReqCmplncProc,CmplncReqSolutionArea 2
ChmlCmplncReqDetails ChmlCmplncReqDetails 1
ChmlCmplncReqLogisticDocCat ChmlCmplncReqLogisticDocCat 1
ChmlCmplncReqOriginProc ChmlCmplncReqOriginProc,CmplncReqReason 2
ChmlCmplncReqRequester ChmlCmplncReqRequester 1
ChmlCmplncRequestDueDate ChmlCmplncRequestDueDate 1
ChmlCmplncRequestOriginType ChmlCmplncRequestOriginType 2
ChmlCmplncRequestPrgrsStatus ChmlCmplncRequestPrgrsStatus 2
ChmlCmplncRequestRemark ChmlCmplncRequestRemark 1
CreatedByUser CreatedByUser 2
CreationUTCDateTime CreationUTCDateTime 2
DngrsGoodsModeOfTransport DngrsGoodsModeOfTransport 1
LastChangedByUser LastChangedByUser 2
LastChangeUTCDateTime LastChangeUTCDateTime 2
Material Material,Product 2
ProdCmplncLogsDocumentItem ProdCmplncLogsDocumentItem 1
ProdCmplncLogsDocumentUUID ProdCmplncLogsDocumentUUID 1
Supplier Supplier 1 
@EndUserText.label: 'Chemical Compliance Request'

@AbapCatalog:
{
  sqlViewName: 'ICCMPLCNREQ',
  compiler.compareFilter: true  
}

@AccessControl:
{
  authorizationCheck: #MANDATORY,
  privilegedAssociations:  [ '_CreatedByUser', '_LastChangedByUser', '_RequesterUser' ]
}

@VDM.viewType: #BASIC

@ObjectModel:
{
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #L,
    serviceQuality: #B
  },
  representativeKey: 'ChmlCmplncRequestUUID'
}

@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_ChmlCmplncReq
  as select from ehfndv_crq

  association [0..1] to I_ChmlCmplncInfo            as _ChmlCmplncInfo           on $projection.ChmlCmplncInfoUUID = _ChmlCmplncInfo.ChmlCmplncInfoUUID
  association [0..1] to I_User                      as _CreatedByUser            on $projection.CreatedByUser = _CreatedByUser.UserID
  association [0..1] to I_User                      as _LastChangedByUser        on $projection.LastChangedByUser = _LastChangedByUser.UserID
  association [0..1] to I_User                      as _RequesterUser            on $projection.ChmlCmplncReqRequester = _RequesterUser.UserID
  association [0..1] to I_Product                   as _Product                  on $projection.Material = _Product.Product
  association [0..1] to I_BusinessUserBasic         as _BusinessUserRequester    on $projection.ChmlCmplncReqBPRequester = _BusinessUserRequester.BusinessPartner
  association [0..1] to I_BusinessUserBasic         as _BusinessUserProcessor    on $projection.ChmlCmplncReqBPProcessor = _BusinessUserProcessor.BusinessPartner
  association [0..1] to I_ChmlCmplncReqCmplncProc   as _ChmlCmplncReqCmplncProc  on $projection.ChmlCmplncReqCmplncProc = _ChmlCmplncReqCmplncProc.ChmlCmplncReqCmplncProc
  association [0..1] to I_ChmlCmplncBusProc         as _BusinessProcess          on $projection.ChmlCmplncBusinessProcess = _BusinessProcess.ChmlCmplncBusinessProcess
  association [0..1] to I_ChmlCmplncReqOriginType   as _OriginType               on $projection.ChmlCmplncRequestOriginType = _OriginType.ChmlCmplncRequestOriginType
  association [0..1] to I_ChmlCmplncReqOriginProc   as _OriginProcess            on $projection.ChmlCmplncReqOriginProc = _OriginProcess.ChmlCmplncReqOriginProc
  association [0..1] to I_ChmlCmplncReqStatus       as _RequestStatus            on $projection.ChmlCmplncRequestPrgrsStatus = _RequestStatus.ChmlCmplncReqStatus
  association [0..1] to I_ChemicalCustomerMaterial  as _ChemicalCustomerMaterial on $projection.ChemicalCustomerMaterialUUID = _ChemicalCustomerMaterial.ChemicalCustomerMaterialUUID
  association [0..*] to I_ChmlCmplncReqMkt          as _RequestedMarket          on $projection.ChmlCmplncRequestUUID = _RequestedMarket.ChmlCmplncRequestUUID
  association [0..*] to I_ChmlCmplncReqApplication  as _RequestedApplication     on $projection.ChmlCmplncRequestUUID = _RequestedApplication.ChmlCmplncRequestUUID
  association [0..*] to I_ChmlCmplncReqPrpsAssgmt   as _RequestedPurpose         on $projection.ChmlCmplncRequestUUID = _RequestedPurpose.ChmlCmplncRequestUUID
  association [0..*] to I_ChmlCmplncReqSlsOrg       as _RequestedSlsOrg          on $projection.ChmlCmplncRequestUUID = _RequestedSlsOrg.ChmlCmplncRequestUUID
  association [0..*] to I_ChmlCmplncReqPlnt         as _RequestedPlnt            on $projection.ChmlCmplncRequestUUID = _RequestedPlnt.ChmlCmplncRequestUUID
  association [0..*] to I_ChmlCmplncReqRouteSegment as _RouteSegment             on $projection.ChmlCmplncRequestUUID = _RouteSegment.ChmlCmplncRequestUUID
  association [0..1] to I_Supplier                  as _Supplier                 on $projection.Supplier = _Supplier.Supplier
{
  key chmlcmplncrequestuuid                                                   as ChmlCmplncRequestUUID,

      @Semantics.systemDateTime.createdAt: true
      cast(creationutcdatetime as ehfnd_bo_crea_date_time preserving type )   as CreationUTCDateTime,
      @Semantics.user.createdBy: true
      cast(createdbyuser as ehfnd_bo_crea_uname preserving type )             as CreatedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      cast(lastchangeutcdatetime as ehfnd_bo_lchg_date_time preserving type ) as LastChangeUTCDateTime,
      @Semantics.user.lastChangedBy: true
      cast(lastchangedbyuser as ehfnd_bo_lchg_uname preserving type )         as LastChangedByUser,


      chmlcmplncrequestduedate                                                as ChmlCmplncRequestDueDate,
      chmlcmplncreqcmplncproc                                                 as ChmlCmplncReqCmplncProc,
      chmlcmplncrequestorigintype                                             as ChmlCmplncRequestOriginType,
      chmlcmplncreqoriginproc                                                 as ChmlCmplncReqOriginProc,
      chmlcmplncrequestprgrsstatus                                            as ChmlCmplncRequestPrgrsStatus,
      chmlcmplncbusinessprocess                                               as ChmlCmplncBusinessProcess,
      chmlcmplncreqbpprocessor                                                as ChmlCmplncReqBPProcessor,
      chmlcmplncreqbprequester                                                as ChmlCmplncReqBPRequester,
      chmlcmplncreqrequester                                                  as ChmlCmplncReqRequester,

      chmlcmplncinfouuid                                                      as ChmlCmplncInfoUUID,
      chmlcmplncproduuid                                                      as ChmlCmplncProdUUID,
      chemicalcustomermaterialuuid                                            as ChemicalCustomerMaterialUUID,

      material                                                                as Material,
      salesdocument                                                           as SalesDocument,
      salesdocumentitem                                                       as SalesDocumentItem,
      chmlcmplncreqlogisticdoccat                                             as ChmlCmplncReqLogisticDocCat,

      chmlcmplncrequestremark                                                 as ChmlCmplncRequestRemark,

      chmlcmplncreqdetails                                                    as ChmlCmplncReqDetails,

      prodcmplnclogsdocument                                                  as ProdCmplncLogsDocument,
      prodcmplnclogsdocumentuuid                                              as ProdCmplncLogsDocumentUUID,
      prodcmplnclogsdocumentitem                                              as ProdCmplncLogsDocumentItem,
      businesssystemname                                                      as BusinessSystemName,
      dngrsgoodsmodeoftransport                                               as DngrsGoodsModeOfTransport,

      supplier                                                                as Supplier,


      -- associations
      _CreatedByUser,
      _LastChangedByUser,
      _Product,
      _ChmlCmplncInfo,
      _ChemicalCustomerMaterial,
      _RequesterUser,
      _BusinessUserRequester,
      _BusinessUserProcessor,
      _ChmlCmplncReqCmplncProc,
      _BusinessProcess,
      _OriginType,
      _OriginProcess,
      _RequestStatus,
      _RequestedMarket,
      _RequestedApplication,
      _RequestedPurpose,
      _RequestedSlsOrg,
      _RequestedPlnt,
      _RouteSegment,
      _Supplier

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHFNDV_CRQ"
],
"ASSOCIATED":
[
"I_BUSINESSUSERBASIC",
"I_CHEMICALCUSTOMERMATERIAL",
"I_CHMLCMPLNCBUSPROC",
"I_CHMLCMPLNCINFO",
"I_CHMLCMPLNCREQAPPLICATION",
"I_CHMLCMPLNCREQCMPLNCPROC",
"I_CHMLCMPLNCREQMKT",
"I_CHMLCMPLNCREQORIGINPROC",
"I_CHMLCMPLNCREQORIGINTYPE",
"I_CHMLCMPLNCREQPLNT",
"I_CHMLCMPLNCREQPRPSASSGMT",
"I_CHMLCMPLNCREQROUTESEGMENT",
"I_CHMLCMPLNCREQSLSORG",
"I_CHMLCMPLNCREQSTATUS",
"I_PRODUCT",
"I_SUPPLIER",
"I_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More