R_CmplRqRsltDynPatternAssmtTP

DDL: R_CMPLRQRSLTDYNPATTERNASSMTTP Type: view_entity TRANSACTIONAL

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 18 fields. It has 4 associations to related views.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_CmplRqRslt I_CmplRqRslt from

Associations (4)

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..*] R_CmplRqRsltDynPatternDetailTP _CmplRqRsltDynPatternDetail

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 (18)

KeyFieldSource TableSource FieldDescription
CmplRqRsltUUIDkeyCmplRqRsltUUID
ActiveCmplRqRsltUUID CmplRqRsltUUID
ActiveUUIDofCRRUUIDofCRVCmplRqVersUUID
UUIDofCCIChmlCmplncInfoUUID
UUIDofsubstanceSubstanceUUID
UUIDofSupplierMaterialChmlSuplrMatlUUID
CreatedByUser CreatedByUser
LastChangedByUser LastChangedByUser
CmplRqRsltProcessor Processor
ValidtoValidityEndDateTime
ManualstatusCmplRqRsltManualStatus
StatusRemarkCmplRqRsltStatusRemark
CompositionTypeChmlCompositionType
_CmplRqRsltDynPatternDetail _CmplRqRsltDynPatternDetail
_ReleasedByUser _ReleasedByUser
_MaterialDataPrimary _MaterialDataPrimary
_CmplRqVers _CmplRqVers
_ChmlCmplncInfo _ChmlCmplncInfo 
@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',
  semanticKey: ['ChmlCmplncInfoUUID', 'SubstanceUUID', 'ChmlSuplrMatlUUID', 'CmplRqVersUUID' ]
}

define root view entity R_CmplRqRsltDynPatternAssmtTP
  as select from I_CmplRqRslt

  // to child compositions

  composition [0..*] of R_CmplRqRsltDynPatternDetailTP as _CmplRqRsltDynPatternDetail

  -- 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,

      --Status Remark
      CmplRqRsltStatusRemark,

      --Composition Type
      ChmlCompositionType,

      --Material is sold
      MaterialIsSold,

      --Material is transported
      MaterialIsTransported,

      --Material is sourced
      MaterialIsSourced,

      --Material is produced
      MaterialIsProduced,

      /**** Associations ****/
      _CmplRqRsltDynPatternDetail,

      _ReleasedByUser,
      _MaterialDataPrimary,
      _CmplRqVers,
      _ChmlCmplncInfo
}
where
  _CmplRqVers.CmplRqPattern = 'CompliancePatternRgtyDataAssmt'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMPLRQRSLT",
"I_CMPLRQVERSENHANCED"
],
"ASSOCIATED":
[
"C_CHMLCMPLNCPRIMMATL",
"I_BUSINESSUSERBASIC",
"I_CHMLCMPLNCINFO",
"I_CMPLRQVERSENHANCED",
"R_CMPLRQRSLTDYNPATTERNDETAILTP"
],
"BASE":
[
"I_CMPLRQRSLT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More