I_FMEATaskTP

DDL: I_FMEATASKTP Type: view_entity TRANSACTIONAL

FMEA Task - TP

I_FMEATaskTP is a Transactional CDS View that provides data about "FMEA Task - TP" in SAP S/4HANA. It reads from 1 data source (I_FMEATask) and exposes 58 fields with key field FMEATaskUUID. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FMEATask I_FMEATask from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_FMEACauseTaskTP _FMEACauseTaskTP $projection.FMEAParentNodeUUID = _FMEACauseTaskTP.FMEANodeUUID and $projection.FMEATaskUUID = _FMEACauseTaskTP.FMEATaskUUID
[0..1] I_FMEATaskText _FMEATaskText $projection.FMEATaskUUID = _FMEATaskText.FMEATaskUUID and _FMEATaskText.Language = $session.system_language
[0..1] I_FMEALongText _FMEATaskLangDepdntDescription $projection.FMEATaskUUID = _FMEATaskLangDepdntDescription.FMEANodeUUID and _FMEATaskLangDepdntDescription.Language = $session.system_language and _FMEATaskLangDepdntDescription.LongTextInternalNumber = 1
[0..1] I_FMEATaskPartner _Responsible $projection.FMEATaskUUID = _Responsible.FMEATaskUUID and _Responsible.FMEAPartnerRole = '60'
[0..*] I_FMEATaskPartnerTP _FMEATaskPartnerTP
[0..*] I_FMEATaskTextTP _FMEATaskTextTP
[0..*] I_FMEATaskDescriptionTextTP _FMEATaskDescription

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label FMEA Task - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY FMEATaskUUID FMEATaskUUID
FMEATask _FMEATaskAssignment FMEATask
FMEAHeaderUUID _ParentNodeAssignment FMEAHeaderUUID
FMEANode _ParentNodeAssignment FMEANode
FMEAAuthorizationGroup FMEAAuthorizationGroup
FMEATaskStatus FMEATaskStatus
FMEATaskActionStatus _FMEATaskActionStatus FMEATaskActionStatus
FMEATaskType FMEATaskType
FMEAParentNodeUUID FMEAParentNodeUUID
FMEATaskCompletionRate FMEATaskCompletionRate
FMEAValuationProfile FMEAValuationProfile
FMEAHasTargetValuation FMEAHasTargetValuation
FMEAValnPrflTargetValuation FMEAValnPrflTargetValuation
FMEATargetValuationScoreValue FMEATargetValuationScoreValue
FMEATargetValnResultValue FMEATargetValnResultValue
FMEAValnProfileValuation FMEAValnProfileValuation
FMEAValuationScoreValue FMEAValuationScoreValue
FMEAValuationResultValue FMEAValuationResultValue
FMEATaskGroup FMEATaskGroup
FMEATaskConfirmationDateTime FMEATaskConfirmationDateTime
QualityTaskCodeCatalog QualityTaskCodeCatalog
QualityTaskCodeGroup QualityTaskCodeGroup
QualityTaskCode QualityTaskCode
FMEATaskIsCancelled FMEATaskIsCancelled
FMEATaskIsStartAction FMEATaskIsStartAction
ChangedDateTime ChangedDateTime
FMEATaskDescription _FMEATaskText FMEATaskDescription
FMEATaskPlannedStartDateTime _FMEATaskAssignment FMEATaskPlannedStartDateTime
FMEATaskPlannedFinishDateTime _FMEATaskAssignment FMEATaskPlannedFinishDateTime
FMEATaskActualFinishDateTime _FMEATaskAssignment FMEATaskActualFinishDateTime
CreatedByUser
CreationDate _FMEATaskAssignment CreationDate
LastChangedByUser
LastChangedDate _FMEATaskAssignment LastChangedDate
FMEATaskLongText _FMEATaskLangDepdntDescription FMEALongText
FMEATaskProcessor
PersonFullName
BusinessPartnerUUID _Responsible BusinessPartnerUUID
FMEAPartnerUUID _Responsible FMEAPartnerUUID
_FMEANodeTP _FMEANodeTP
_FMEACauseTaskTP _FMEACauseTaskTP
_FailureModeEffectAnalysisTP _FailureModeEffectAnalysisTP
_FMEATaskPartnerTP _FMEATaskPartnerTP
_FMEATaskTextTP _FMEATaskTextTP
_FMEATaskHierarchy _FMEATaskHierarchy
_FMEAAuthorizationGroup _FMEAAuthorizationGroup
_FMEAValuationProfile _FMEAValuationProfile
_FMEAValnProfileValuation _FMEAValnProfileValuation
_FMEAValnProfileTargetValn _FMEAValnProfileTargetValn
_FMEATaskStatus _FMEATaskStatus
_FMEATaskActionStatus _FMEATaskActionStatus
_ConfigurableCodesCodeGroup _ConfigurableCodesCodeGroup
_ConfigurableCodesCode _ConfigurableCodesCode
_FMEATaskDescription _FMEATaskDescription
_FMEATaskPartner _FMEATaskPartner
_BusinessPartner _BusinessPartner
_FMEATaskType _FMEATaskType
_Responsible _Responsible
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'FMEA Task - TP'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #M,
    serviceQuality: #C
}
define view entity I_FMEATaskTP
  as select from I_FMEATask
  composition [0..*] of I_FMEATaskPartnerTP         as _FMEATaskPartnerTP
  composition [0..*] of I_FMEATaskTextTP            as _FMEATaskTextTP
  composition [0..*] of I_FMEATaskDescriptionTextTP as _FMEATaskDescription
  association        to parent I_FMEANodeTP                as _FMEANodeTP                  on  $projection.FMEAParentNodeUUID = _FMEANodeTP.FMEANodeUUID
  association [0..1] to I_FMEACauseTaskTP           as _FMEACauseTaskTP                    on  $projection.FMEAParentNodeUUID = _FMEACauseTaskTP.FMEANodeUUID
                                                                                           and $projection.FMEATaskUUID       = _FMEACauseTaskTP.FMEATaskUUID
  association        to I_FailureModeEffectAnalysisTP      as _FailureModeEffectAnalysisTP on  $projection.fmeaheaderuuid = _FailureModeEffectAnalysisTP.FMEAHeaderUUID
  association [0..1] to I_FMEATaskText              as _FMEATaskText                       on  $projection.FMEATaskUUID = _FMEATaskText.FMEATaskUUID
                                                                                           and _FMEATaskText.Language   = $session.system_language
  association [0..1] to I_FMEALongText              as _FMEATaskLangDepdntDescription      on  $projection.FMEATaskUUID                              = _FMEATaskLangDepdntDescription.FMEANodeUUID
                                                                                           and _FMEATaskLangDepdntDescription.Language               = $session.system_language
                                                                                           and _FMEATaskLangDepdntDescription.LongTextInternalNumber = 1

  association [0..1] to I_FMEATaskPartner           as _Responsible                        on  $projection.FMEATaskUUID     = _Responsible.FMEATaskUUID
                                                                                           and _Responsible.FMEAPartnerRole = '60'

{
  key FMEATaskUUID,
      _FMEATaskAssignment.FMEATask,
      _ParentNodeAssignment.FMEAHeaderUUID,
      _ParentNodeAssignment.FMEANode,
      FMEAAuthorizationGroup,
      FMEATaskStatus,
      _FMEATaskActionStatus.FMEATaskActionStatus,
      FMEATaskType,
      FMEAParentNodeUUID,
      FMEATaskCompletionRate,
      FMEAValuationProfile,
      FMEAHasTargetValuation,
      FMEAValnPrflTargetValuation,
      FMEATargetValuationScoreValue,
      FMEATargetValnResultValue,
      FMEAValnProfileValuation,
      FMEAValuationScoreValue,
      FMEAValuationResultValue,
      FMEATaskGroup,
      FMEATaskConfirmationDateTime,
      QualityTaskCodeCatalog,
      QualityTaskCodeGroup,
      QualityTaskCode,
      FMEATaskIsCancelled,
      FMEATaskIsStartAction,
      ChangedDateTime,
      _FMEATaskText.FMEATaskDescription,
      _FMEATaskAssignment.FMEATaskPlannedStartDateTime,
      _FMEATaskAssignment.FMEATaskPlannedFinishDateTime,
      _FMEATaskAssignment.FMEATaskActualFinishDateTime,
      cast( _FMEATaskAssignment.CreatedByUser as cgpl_created_by preserving type )     as CreatedByUser,
      _FMEATaskAssignment.CreationDate,
      cast( _FMEATaskAssignment.LastChangedByUser as cgpl_changed_by preserving type ) as LastChangedByUser,
      _FMEATaskAssignment.LastChangedDate,
      _FMEATaskLangDepdntDescription.FMEALongText                                      as FMEATaskLongText,
      _Responsible._Employee.BusinessPartner                                           as FMEATaskProcessor,
      _Responsible._Employee.PersonFullName,
      _Responsible.BusinessPartnerUUID,
      _Responsible.FMEAPartnerUUID,


      //Associations

      _FMEANodeTP,
      _FMEACauseTaskTP,
      _FailureModeEffectAnalysisTP,
      _FMEATaskPartnerTP,
      _FMEATaskTextTP,
      _FMEATaskHierarchy,
      _FMEAAuthorizationGroup,
      _FMEAValuationProfile,
      _FMEAValnProfileValuation,
      _FMEAValnProfileTargetValn,
      _FMEATaskStatus,
      _FMEATaskActionStatus,
      _ConfigurableCodesCodeGroup,
      _ConfigurableCodesCode,
      _FMEATaskDescription,
      _FMEATaskPartner,
      _BusinessPartner,
      _FMEATaskType,
      _Responsible
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSUSER",
"I_FMEALONGTEXT",
"I_FMEANODEASSIGNMENT",
"I_FMEATASK",
"I_FMEATASKASSIGNEDACTIONSTATUS",
"I_FMEATASKASSIGNMENT",
"I_FMEATASKPARTNER",
"I_FMEATASKTEXT"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_CONFIGURABLECODESCODE",
"I_CONFIGURABLECODESCODEGROUP",
"I_FAILUREMODEEFFECTANALYSISTP",
"I_FMEAAUTHORIZATIONGROUP",
"I_FMEACAUSETASKTP",
"I_FMEANODETP",
"I_FMEASTATUS",
"I_FMEATASKASSIGNEDACTIONSTATUS",
"I_FMEATASKDESCRIPTIONTEXTTP",
"I_FMEATASKHIERARCHY",
"I_FMEATASKPARTNER",
"I_FMEATASKPARTNERTP",
"I_FMEATASKTEXTTP",
"I_FMEATASKTYPE",
"I_FMEAVALNPROFILEVALUATION",
"I_FMEAVALUATIONPROFILE"
],
"BASE":
[
"I_FMEATASK"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/