I_ChmlCmplncReqTP

DDL: I_CHMLCMPLNCREQTP Type: view TRANSACTIONAL Package: EHFND_BO_CRQ

Chemical Compliance Request

I_ChmlCmplncReqTP is a Transactional CDS View that provides data about "Chemical Compliance Request" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncReq) and exposes 57 fields with key field ChmlCmplncRequestUUID. It has 7 associations to related views. Part of development package EHFND_BO_CRQ.

1 data source(s) 57 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncReq I_ChmlCmplncReq from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_ChmlCmplncReqNewCmplncInfoTP _NewComplInfo $projection.ChmlCmplncRequestUUID = _NewComplInfo.ChmlCmplncRequestUUID
[0..*] I_ChmlCmplncReqMktTP _RequestedMarket $projection.ChmlCmplncRequestUUID = _RequestedMarket.ChmlCmplncRequestUUID
[0..*] I_ChmlCmplncReqApplicationTP _RequestedApplication $projection.ChmlCmplncRequestUUID = _RequestedApplication.ChmlCmplncRequestUUID
[0..*] I_ChmlCmplncReqPrpsAssgmtTP _RequestedPurpose $projection.ChmlCmplncRequestUUID = _RequestedPurpose.ChmlCmplncRequestUUID
[0..*] I_ChmlCmplncReqSlsOrgTP _RequestedSlsOrg $projection.ChmlCmplncRequestUUID = _RequestedSlsOrg.ChmlCmplncRequestUUID
[0..*] I_ChmlCmplncReqPlntTP _RequestedPlnt $projection.ChmlCmplncRequestUUID = _RequestedPlnt.ChmlCmplncRequestUUID
[0..*] I_ChmlCmplncReqRouteSegmentTP _RouteSegment $projection.ChmlCmplncRequestUUID = _RouteSegment.ChmlCmplncRequestUUID

Annotations (20)

NameValueLevelField
EndUserText.label Chemical Compliance Request view
AbapCatalog.sqlViewName ICRQTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.compositionRoot true view
ObjectModel.writeActivePersistence EHFNDV_CRQ view
ObjectModel.createEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.entityChangeStateId LastChangeUTCDateTime view
ObjectModel.sapObjectNodeType.name ProdCmplncLogisticsRequest view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncRequestUUID ChmlCmplncRequestUUID
CreationUTCDateTime CreationUTCDateTime
CreatedByUser CreatedByUser
LastChangeUTCDateTime LastChangeUTCDateTime
LastChangedByUser LastChangedByUser
ChmlCmplncRequestDueDate ChmlCmplncRequestDueDate
ChmlCmplncReqCmplncProc ChmlCmplncReqCmplncProc
ChmlCmplncRequestOriginType ChmlCmplncRequestOriginType
ChmlCmplncReqOriginProc ChmlCmplncReqOriginProc
ChmlCmplncRequestPrgrsStatus ChmlCmplncRequestPrgrsStatus
ChmlCmplncBusinessProcess ChmlCmplncBusinessProcess
ChmlCmplncReqRequester ChmlCmplncReqRequester
ChmlCmplncReqBPRequester ChmlCmplncReqBPRequester
ChmlCmplncReqBPProcessor ChmlCmplncReqBPProcessor
ChmlCmplncInfoUUID ChmlCmplncInfoUUID
ChmlCmplncProdUUID ChmlCmplncProdUUID
ChemicalCustomerMaterialUUID ChemicalCustomerMaterialUUID
Material Material
SalesDocument SalesDocument
SalesDocumentItem SalesDocumentItem
ChmlCmplncReqLogisticDocCat ChmlCmplncReqLogisticDocCat
MultiComponentProduct MultiComponentProduct
ChmlCmplncRequestRemark ChmlCmplncRequestRemark
ChmlCmplncReqDetails ChmlCmplncReqDetails
ProdCmplncLogsDocument ProdCmplncLogsDocument
ProdCmplncLogsDocumentUUID ProdCmplncLogsDocumentUUID
ProdCmplncLogsDocumentItem ProdCmplncLogsDocumentItem
BusinessSystemName BusinessSystemName
DngrsGoodsModeOfTransport DngrsGoodsModeOfTransport
Supplier Supplier
Customer Customer
ProductComplianceRequest ProductComplianceRequest
DngrsGdsLogsPackgInstrnUUID DngrsGdsLogsPackgInstrnUUID
_NewComplInfo _NewComplInfo
_RequestedMarket _RequestedMarket
_RequestedApplication _RequestedApplication
_RequestedPurpose _RequestedPurpose
_RequestedSlsOrg _RequestedSlsOrg
_RequestedPlnt _RequestedPlnt
_RouteSegment _RouteSegment
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_Product _Product
_ChmlCmplncInfo _ChmlCmplncInfo
_ChemicalCustomerMaterial _ChemicalCustomerMaterial
_BusinessUserProcessor _BusinessUserProcessor
_BusinessUserRequester _BusinessUserRequester
_RequesterUser _RequesterUser
_ChmlCmplncReqCmplncProc _ChmlCmplncReqCmplncProc
_BusinessProcess _BusinessProcess
_OriginType _OriginType
_OriginProcess _OriginProcess
_Supplier _Supplier
_Customer _Customer
_RequestStatus _RequestStatus
_MultiComponentProduct _MultiComponentProduct
_PackingInstruction _PackingInstruction 
@EndUserText.label: 'Chemical Compliance Request'
@AbapCatalog:
{
 sqlViewName: 'ICRQTP',
 compiler.compareFilter: true
}

@AccessControl:
{
  authorizationCheck: #MANDATORY,
  privilegedAssociations:  [ '_CreatedByUser', '_LastChangedByUser', '_RequesterUser' ],
  personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #TRANSACTIONAL 
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
 
@ObjectModel:
{
  transactionalProcessingEnabled: true,
  modelCategory: #BUSINESS_OBJECT,
  compositionRoot: true,
  writeActivePersistence: 'EHFNDV_CRQ',
  createEnabled: 'EXTERNAL_CALCULATION',
  updateEnabled: 'EXTERNAL_CALCULATION',
  deleteEnabled: 'EXTERNAL_CALCULATION',
  entityChangeStateId: 'LastChangeUTCDateTime',
  sapObjectNodeType.name: 'ProdCmplncLogisticsRequest',
  semanticKey:  [ 'ChmlCmplncRequestUUID' ],

  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #L,
    serviceQuality: #B
  }
}

/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
define view I_ChmlCmplncReqTP
  as select from I_ChmlCmplncReq

  //expected cardinality: don't change 

  association [0..1] to I_ChmlCmplncReqNewCmplncInfoTP  as _NewComplInfo         on $projection.ChmlCmplncRequestUUID = _NewComplInfo.ChmlCmplncRequestUUID
  association [0..*] to I_ChmlCmplncReqMktTP            as _RequestedMarket      on $projection.ChmlCmplncRequestUUID = _RequestedMarket.ChmlCmplncRequestUUID
  association [0..*] to I_ChmlCmplncReqApplicationTP    as _RequestedApplication on $projection.ChmlCmplncRequestUUID = _RequestedApplication.ChmlCmplncRequestUUID
  association [0..*] to I_ChmlCmplncReqPrpsAssgmtTP     as _RequestedPurpose     on $projection.ChmlCmplncRequestUUID = _RequestedPurpose.ChmlCmplncRequestUUID
  association [0..*] to I_ChmlCmplncReqSlsOrgTP         as _RequestedSlsOrg      on $projection.ChmlCmplncRequestUUID = _RequestedSlsOrg.ChmlCmplncRequestUUID
  association [0..*] to I_ChmlCmplncReqPlntTP           as _RequestedPlnt        on $projection.ChmlCmplncRequestUUID = _RequestedPlnt.ChmlCmplncRequestUUID
  association [0..*] to I_ChmlCmplncReqRouteSegmentTP   as _RouteSegment         on $projection.ChmlCmplncRequestUUID = _RouteSegment.ChmlCmplncRequestUUID

{

      @ObjectModel.mandatory: true
  key ChmlCmplncRequestUUID,
      CreationUTCDateTime,
      CreatedByUser,
      LastChangeUTCDateTime,
      LastChangedByUser,

      ChmlCmplncRequestDueDate,
      ChmlCmplncReqCmplncProc, 
      @ObjectModel.mandatory: true
      ChmlCmplncRequestOriginType,
      ChmlCmplncReqOriginProc,
      @ObjectModel.mandatory: true
      ChmlCmplncRequestPrgrsStatus,
      @ObjectModel.mandatory: true
      ChmlCmplncBusinessProcess,

      @ObjectModel.mandatory: true
      ChmlCmplncReqRequester,
      ChmlCmplncReqBPRequester,
      ChmlCmplncReqBPProcessor,

      ChmlCmplncInfoUUID,
      ChmlCmplncProdUUID,
      ChemicalCustomerMaterialUUID,
      
      Material,
      SalesDocument,
      SalesDocumentItem,  
      ChmlCmplncReqLogisticDocCat,
      MultiComponentProduct,
          
      ChmlCmplncRequestRemark,
      
      ChmlCmplncReqDetails,
      
      ProdCmplncLogsDocument,
      ProdCmplncLogsDocumentUUID,
      ProdCmplncLogsDocumentItem,
      BusinessSystemName,
      DngrsGoodsModeOfTransport,
      
      Supplier,
      Customer,
      
      ProductComplianceRequest, 
      DngrsGdsLogsPackgInstrnUUID,

      /* Associations */
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _NewComplInfo,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _RequestedMarket,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _RequestedApplication,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _RequestedPurpose,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _RequestedSlsOrg,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _RequestedPlnt,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _RouteSegment,

      _CreatedByUser,
      _LastChangedByUser,
      _Product,
      _ChmlCmplncInfo,
      _ChemicalCustomerMaterial,
      _BusinessUserProcessor,
      _BusinessUserRequester,
      _RequesterUser,
      _ChmlCmplncReqCmplncProc,
      _BusinessProcess,
      _OriginType,
      _OriginProcess,
      _Supplier,
      _Customer,
      _RequestStatus,
      _MultiComponentProduct,
      _PackingInstruction

}

Learn More