R_CmplRqRsltDynPatternAssmtTP

DDL: R_CMPLRQRSLTDYNPATTERNASSMTTP Type: view_entity TRANSACTIONAL Package: EHFND_RAP_CRR_DYN_PAT

Dynamic Pattern Assessment - TP

R_CmplRqRsltDynPatternAssmtTP is a Transactional CDS View that provides data about "Dynamic Pattern Assessment - TP" in SAP S/4HANA. It reads from 1 data source (I_CmplRqRslt) and exposes 21 fields. It has 6 associations to related views. Part of development package EHFND_RAP_CRR_DYN_PAT.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_CmplRqRslt I_CmplRqRslt from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_BusinessUserBasic _ReleasedByUser $projection.ReleasedByUser = _ReleasedByUser.BusinessPartner
[0..1] C_ChmlCmplncPrimMatl _MaterialDataPrimary $projection.ChmlCmplncInfoUUID = _MaterialDataPrimary.ChmlCmplncInfoUUID
[1..1] I_CmplRqVersEnhanced _CmplRqVers $projection.CmplRqVersUUID = _CmplRqVers.CmplRqVersUUID
[0..1] R_CmplRqRsltDynPtrnRsnNoDtaTP _CmplRqRsltDynPtrnRsnNoDta
[0..*] R_CmplRqRsltDynPatternDetailTP _CmplRqRsltDynPatternDetail
[0..*] R_CmplRqRsltDynPatternDet2TP _CmplRqRsltDynPatternDetail2

Annotations (9)

NameValueLevelField
EndUserText.label Dynamic Pattern Assessment - TP view
AccessControl.authorizationCheck #MANDATORY view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.sapObjectNodeType.name RegulatoryDataAssessment view
ObjectModel.representativeKey CmplRqRsltUUID view

Fields (21)

KeyFieldSource TableSource FieldDescription
CmplRqRsltUUIDkeyCmplRqRsltUUID
ActiveCmplRqRsltUUID CmplRqRsltUUID
ActiveUUIDofCRRUUIDofCRVCmplRqVersUUID
UUIDofCCIChmlCmplncInfoUUID
UUIDofsubstanceSubstanceUUID
UUIDofSupplierMaterialChmlSuplrMatlUUID
CreatedByUser CreatedByUser
LastChangedByUser LastChangedByUser
CmplRqRsltProcessor Processor
ValidtoValidityEndDateTime
ManualstatusCmplRqRsltManualStatus
StatusRemarkCmplRqRsltStatusRemark
CompositionTypeChmlCompositionType
_CmplRqRsltDynPatternDetail _CmplRqRsltDynPatternDetail
_CmplRqRsltDynPatternDetail2 _CmplRqRsltDynPatternDetail2
_CmplRqRsltDynPtrnRsnNoDta _CmplRqRsltDynPtrnRsnNoDta
_ReleasedByUser _ReleasedByUser
_MaterialDataPrimary _MaterialDataPrimary
_CmplRqVers _CmplRqVers
_ChmlCmplncInfo _ChmlCmplncInfo
_Substance _Substance 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@EndUserText.label: 'Dynamic Pattern Assessment - TP'

@AccessControl:
{
  authorizationCheck: #MANDATORY
}

@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL
}

@ObjectModel:
{
  usageType:
  {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #XL,
    serviceQuality: #C
  },
  sapObjectNodeType.name: 'RegulatoryDataAssessment',
  representativeKey: 'CmplRqRsltUUID'
}

define root view entity R_CmplRqRsltDynPatternAssmtTP
  as select from I_CmplRqRslt

  // to childs

  composition [0..1] of R_CmplRqRsltDynPtrnRsnNoDtaTP  as _CmplRqRsltDynPtrnRsnNoDta

  composition [0..*] of R_CmplRqRsltDynPatternDetailTP as _CmplRqRsltDynPatternDetail

  composition [0..*] of R_CmplRqRsltDynPatternDet2TP   as _CmplRqRsltDynPatternDetail2

  -- Determines the full name of the business user who has released the CRR
  association [0..1] to I_BusinessUserBasic            as _ReleasedByUser      on $projection.ReleasedByUser = _ReleasedByUser.BusinessPartner

  association [0..1] to C_ChmlCmplncPrimMatl           as _MaterialDataPrimary on $projection.ChmlCmplncInfoUUID = _MaterialDataPrimary.ChmlCmplncInfoUUID

  association [1..1] to I_CmplRqVersEnhanced           as _CmplRqVers          on $projection.CmplRqVersUUID = _CmplRqVers.CmplRqVersUUID

{

      --CmplRqRsltUUID
  key CmplRqRsltUUID,

      CmplRqRsltUUID as ActiveCmplRqRsltUUID, --Active UUID of CRR

      --UUID of CRV
      CmplRqVersUUID,

      --UUID of CCI
      ChmlCmplncInfoUUID,

      --UUID of substance
      SubstanceUUID,

      --UUID of Supplier Material
      ChmlSuplrMatlUUID,

      --Compliance Requirement
      ComplianceRequirement,

      --Create at date/time and by user
      CreationDateTime,
      CreatedByUser,

      --Update at date/time and by user
      LastChangeDateTime,
      LastChangedByUser,

      --Processing status
      CmplRqRsltProcessingStatus,
      Processor      as CmplRqRsltProcessor,

      --Released by user
      ReleasedByUser,

      --Valid from (release date)
      ValidityStartDateTime,

      --Valid to
      ValidityEndDateTime,

      --Released Compliance Status
      CmplRqRsltReldCmplncSts,

      --Calculated Status
      CmplRqRsltCalculatedStatus,

      --Manual status
      CmplRqRsltManualStatus,
      
      --Preleminary Status
      CmplRqRsltPrelimCmplncSts,

      --Status Remark
      CmplRqRsltStatusRemark,

      --Composition Type
      ChmlCompositionType,

      --Material is sold
      MaterialIsSold,

      --Material is transported
      MaterialIsTransported,

      --Material is sourced
      MaterialIsSourced,

      --Material is produced
      MaterialIsProduced,

      /**** Associations ****/
      _CmplRqRsltDynPatternDetail,
      _CmplRqRsltDynPatternDetail2,
      _CmplRqRsltDynPtrnRsnNoDta,

      _ReleasedByUser,
      _MaterialDataPrimary,
      _CmplRqVers,
      _ChmlCmplncInfo,
      _Substance
}
where
  _CmplRqVers.CmplRqPattern = 'CompliancePatternRgtyDataAssmt'

Learn More