C_SubstVolRetrackingTP

DDL: C_SUBSTVOLRETRACKINGTP Type: view_entity CONSUMPTION

Substance Volume Retracking

C_SubstVolRetrackingTP is a Consumption CDS View that provides data about "Substance Volume Retracking" in SAP S/4HANA. It reads from 1 data source (R_SubstVolRetrackingTP) and exposes 32 fields with key field SubstVolRetrackingUUID.

Data Sources (1)

SourceAliasJoin Type
R_SubstVolRetrackingTP R_SubstVolRetrackingTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Substance Volume Retracking view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY SubstVolRetrackingUUID SubstVolRetrackingUUID
SubstVolRetrackingStatus SubstVolRetrackingStatus
ProdCmplncEventUUID ProdCmplncEventUUID
SubstVolRetrackingType SubstVolRetrackingType
SubstVolRetrackingSourceUUID SubstVolRetrackingSourceUUID
SubstVolRetrackingSource SubstVolRetrackingSource
SubstVolRetrackingSourceType SubstVolRetrackingSourceType
SubstVolRetrackingCategory SubstVolRetrackingCategory
SubstVolRetrckgSrceChgdDteTme SubstVolRetrckgSrceChgdDteTme
SubstVolRetrackingSrceChgdBy
SubstVolRetrackingSrceName _SubstVolRetrckgChmlCmpstn SubstVolRetrackingSrceName
SubstVolRetrackingReasonText SubstVolRetrackingReasonText
SubstVolRetrackingCompletedBy SubstVolRetrackingCompletedBy
SuVolRtrckgCmpltdByFullName SuVolRtrckgCmpltdByFullName
SubstVolRetrckgCompletedDteTme SubstVolRetrckgCompletedDteTme
SuVolRtrckgSrceChgdByFullName SuVolRtrckgSrceChgdByFullName
SubstVolRetrackingDecidedBy SubstVolRetrackingDecidedBy
SuVolRtrckgDecidedByFullName SuVolRtrckgDecidedByFullName
SubstVolRetrckgDecidedDteTme SubstVolRetrckgDecidedDteTme
SuVolRtrckgSrceSecdrySrchName _SubstVolRetrckgChmlCmpstn SuVolRtrckgSrceSecdrySrchName
SuVolRtrckgSrcePrimSrchName _SubstVolRetrckgChmlCmpstn SuVolRtrckgSrcePrimSrchName
ComplianceRequirement ComplianceRequirement
CmplRqUUID CmplRqUUID
SubstVolRetrackingTypeText _SubstVolRetrackingTypeTxt SubstVolRetrackingTypeText
SubstVolRetrackingStatusText _SubstVolRetrackingStatusTxt SubstVolRetrackingStatusText
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangedByUser
_SubstVolRetrackingStatus _SubstVolRetrackingStatus
_SubstVolRetrckgChmlCmpstn _SubstVolRetrckgChmlCmpstn
_ChmlCmplncMatlAssgmt _ChmlCmplncMatlAssgmt
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Substance Volume Retracking'
@Metadata.allowExtensions: true

@VDM: {
  viewType: #CONSUMPTION,
  usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ] }


@ObjectModel.usageType:{ serviceQuality: #C,
                         sizeCategory:   #L,
                         dataClass:      #MASTER }

@UI.presentationVariant: [{ requestAtLeast: ['SubstVolRetrackingType'] }]
@Search.searchable: true
define root view entity C_SubstVolRetrackingTP
  provider contract transactional_query
  as projection on R_SubstVolRetrackingTP as SubstVolRetrackingTP
  association to I_SubstVolRetrackingStatus as _SubstVolRetrackingStatus on $projection.SubstVolRetrackingStatus = _SubstVolRetrackingStatus.SubstVolRetrackingStatus
  /**** association to initiating object ****/
{
  key SubstVolRetrackingUUID,

      @ObjectModel.text.element: ['SubstVolRetrackingStatusText']
      SubstVolRetrackingStatus,
      ProdCmplncEventUUID,
      SubstVolRetrackingType,
      SubstVolRetrackingSourceUUID,
      SubstVolRetrackingSource,
      SubstVolRetrackingSourceType,
      SubstVolRetrackingCategory,
      SubstVolRetrckgSrceChgdDteTme,
      @ObjectModel.text.element: ['SuVolRtrckgSrceChgdByFullName']
      cast( SubstVolRetrackingSrceChgdBy as ehpma_svt_retrckg_rel_by preserving type ) as SubstVolRetrackingSrceChgdBy,

      _SubstVolRetrckgChmlCmpstn.SubstVolRetrackingSrceName,
      SubstVolRetrackingReasonText,
      @ObjectModel.text.element: ['SuVolRtrckgCmpltdByFullName']
      @Search.defaultSearchElement: true
      SubstVolRetrackingCompletedBy,
      @Semantics.text: true
      SuVolRtrckgCmpltdByFullName,
      SubstVolRetrckgCompletedDteTme,
      @Semantics.text: true
      SuVolRtrckgSrceChgdByFullName,
      @ObjectModel.text.element: ['SuVolRtrckgDecidedByFullName']
      SubstVolRetrackingDecidedBy,
      
      @Semantics.text: true
      SuVolRtrckgDecidedByFullName,
      SubstVolRetrckgDecidedDteTme,
      
      @Search.defaultSearchElement: true
      _SubstVolRetrckgChmlCmpstn.SuVolRtrckgSrceSecdrySrchName,
      @Search.defaultSearchElement: true
      _SubstVolRetrckgChmlCmpstn.SuVolRtrckgSrcePrimSrchName,
        
      @Semantics.text: true
      ComplianceRequirement,

      CmplRqUUID,
      _SubstVolRetrackingTypeTxt.SubstVolRetrackingTypeText,
      _SubstVolRetrackingStatusTxt.SubstVolRetrackingStatusText,

      CreatedByUser,
      CreationDateTime,
      LastChangeDateTime,
      LastChangedByUser,

      _SubstVolRetrackingStatus,
      _SubstVolRetrckgChmlCmpstn,
      _ChmlCmplncMatlAssgmt
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUBSTVOLRETRACKINGSTATUSTXT",
"I_SUBSTVOLRETRACKINGTYPETXT",
"I_SUVOLRTRCKGCHMLCMPSTNSRCE",
"R_SUBSTVOLRETRACKINGTP"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCMATLASSGMT",
"I_SUBSTVOLRETRACKINGSTATUS",
"I_SUVOLRTRCKGCHMLCMPSTNSRCE"
],
"BASE":
[
"R_SUBSTVOLRETRACKINGTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/