C_SubstVolRetrackingProductTP

DDL: C_SUBSTVOLRETRACKINGPRODUCTTP Type: view_entity CONSUMPTION

Subst Vol Retracking for Products

C_SubstVolRetrackingProductTP is a Consumption CDS View that provides data about "Subst Vol Retracking for Products" in SAP S/4HANA. It reads from 1 data source (R_SubstVolRetrackingTP) and exposes 34 fields with key field SubstVolRetrackingUUID.

Data Sources (1)

SourceAliasJoin Type
R_SubstVolRetrackingTP R_SubstVolRetrackingTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Subst Vol Retracking for Products view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY SubstVolRetrackingUUID SubstVolRetrackingUUID
SubstVolRetrackingStatus SubstVolRetrackingStatus
ProdCmplncEventUUID ProdCmplncEventUUID
SubstVolRetrackingType SubstVolRetrackingType
SubstVolRetrackingSource SubstVolRetrackingSource
SubstVolRetrackingSourceUUID SubstVolRetrackingSourceUUID
SubstVolRetrackingSourceType SubstVolRetrackingSourceType
SubstVolRetrackingSrceChgdBy SubstVolRetrackingSrceChgdBy
SubstVolRetrackingCategory SubstVolRetrackingCategory
ComplianceRequirement ComplianceRequirement
CmplRqUUID CmplRqUUID
SuVolRtrckgSrceSecdrySrchName _SubstVolRetrckgChmlCmpstn SuVolRtrckgSrceSecdrySrchName
SuVolRtrckgSrcePrimSrchName _SubstVolRetrckgChmlCmpstn SuVolRtrckgSrcePrimSrchName
SubstVolRetrackingSrceName _SubstVolRetrckgChmlCmpstn SubstVolRetrackingSrceName
Material _SubstVolRetrckgChmlCmpstn Material
ProductName
ChmlCmplncInternalName
Specification
SuVolRtrckgSrceChgdByFullName SuVolRtrckgSrceChgdByFullName
SubstVolRetrckgSrceChgdDteTme SubstVolRetrckgSrceChgdDteTme
SubstVolRetrackingCompletedBy SubstVolRetrackingCompletedBy
SuVolRtrckgCmpltdByFullName SuVolRtrckgCmpltdByFullName
SubstVolRetrckgCompletedDteTme SubstVolRetrckgCompletedDteTme
SubstVolRetrackingDecidedBy SubstVolRetrackingDecidedBy
SuVolRtrckgDecidedByCmbndName SuVolRtrckgDecidedByCmbndName
SubstVolRetrckgDecidedDteTme SubstVolRetrckgDecidedDteTme
SubstVolRetrackingTypeText _SubstVolRetrackingTypeTxt SubstVolRetrackingTypeText
SubstVolRetrackingStatusText _SubstVolRetrackingStatusTxt SubstVolRetrackingStatusText
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangedByUser
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
_SubstVolRetrckgChmlCmpstn _SubstVolRetrckgChmlCmpstn
_ChmlCmplncMatlAssgmt _ChmlCmplncMatlAssgmt
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Subst Vol Retracking for Products'
@Metadata.allowExtensions: true

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

@UI.presentationVariant: [{ requestAtLeast: ['SubstVolRetrackingType'] }]
@ObjectModel.usageType:{ serviceQuality: #D,
                         sizeCategory:   #L,
                         dataClass:      #MASTER }
@Search.searchable: true
define root view entity C_SubstVolRetrackingProductTP
  provider contract transactional_query
  as projection on R_SubstVolRetrackingTP as SubstVolRetrackingTP
{
  key            SubstVolRetrackingUUID,
                 SubstVolRetrackingStatus,
                 ProdCmplncEventUUID,
                 SubstVolRetrackingType,
                 SubstVolRetrackingSource,
                 SubstVolRetrackingSourceUUID,
                 SubstVolRetrackingSourceType,
                 SubstVolRetrackingSrceChgdBy,
                 SubstVolRetrackingCategory,
                 ComplianceRequirement,
                 CmplRqUUID,

                 _SubstVolRetrckgChmlCmpstn.SuVolRtrckgSrceSecdrySrchName,
                 _SubstVolRetrckgChmlCmpstn.SuVolRtrckgSrcePrimSrchName,
                 _SubstVolRetrckgChmlCmpstn.SubstVolRetrackingSrceName,
                 _SubstVolRetrckgChmlCmpstn.Material,
                 _SubstVolRetrckgChmlCmpstn._ProductText.ProductName,
                 _SubstVolRetrckgChmlCmpstn._ChmlCmplncInfo.ChmlCmplncInternalName,
                 cast( _SubstVolRetrckgChmlCmpstn._ChmlCmplncInfo.Specification as ehfnd_internal_nr_nc preserving type ) as Specification,
                 SuVolRtrckgSrceChgdByFullName,
                 SubstVolRetrckgSrceChgdDteTme,
                 SubstVolRetrackingCompletedBy,
                 SuVolRtrckgCmpltdByFullName,
                 SubstVolRetrckgCompletedDteTme,
                 SubstVolRetrackingDecidedBy,
                 SuVolRtrckgDecidedByCmbndName,
                 SubstVolRetrckgDecidedDteTme,
                 _SubstVolRetrackingTypeTxt.SubstVolRetrackingTypeText,
                 _SubstVolRetrackingStatusTxt.SubstVolRetrackingStatusText,

                 LastChangeDateTime,
                 LastChangedByUser,
                 CreatedByUser,
                 CreationDateTime,

                 @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHPMA_SVT_HIDE_RTRCKG_EXIT'
  virtual        SubstVolRetrckgDetsAreHidden : abap_boolean,

                 _SubstVolRetrckgChmlCmpstn,
                 _ChmlCmplncMatlAssgmt
}
where
  SubstVolRetrackingTP.SubstVolRetrackingCategory = 0
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHMLCMPLNCINFO",
"I_PRODUCTTEXT",
"I_SUBSTVOLRETRACKINGSTATUSTXT",
"I_SUBSTVOLRETRACKINGTYPETXT",
"I_SUVOLRTRCKGCHMLCMPSTNSRCE",
"R_SUBSTVOLRETRACKINGTP"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCMATLASSGMT",
"I_SUVOLRTRCKGCHMLCMPSTNSRCE"
],
"BASE":
[
"R_SUBSTVOLRETRACKINGTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/