C_SubstVolRetrackingRawMatlTP

DDL: C_SUBSTVOLRETRACKINGRAWMATLTP Type: view_entity CONSUMPTION

Subst Vol Retracking for Raw Materials

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

1 data source(s) 34 fields

Data Sources (1)

SourceAliasJoin Type
R_SubstVolRetrackingTP R_SubstVolRetrackingTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Subst Vol Retracking for Raw Materials 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 (34)

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

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


@ObjectModel.usageType:{ serviceQuality: #C,
                         sizeCategory:   #L,
                         dataClass:      #MASTER }
@Search.searchable: true
define root view entity C_SubstVolRetrackingRawMatlTP
  provider contract transactional_query
  as projection on R_SubstVolRetrackingTP as SubstVolRetrackingTP
{
  key            SubstVolRetrackingUUID,
                 SubstVolRetrackingStatus,
                 ProdCmplncEventUUID,
                 SubstVolRetrackingType,
                 SubstVolRetrackingSourceUUID,
                 SubstVolRetrackingSource,
                 SubstVolRetrackingSourceType,
                 SubstVolRetrackingSrceChgdBy,
                 SubstVolRetrackingCategory,
                 SuVolRtrckgSrceChgdByFullName,
                 SubstVolRetrckgSrceChgdDteTme,
                 _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,
                 ComplianceRequirement,
                 CmplRqUUID,

                 _SubstVolRetrackingTypeTxt.SubstVolRetrackingTypeText,
                 _SubstVolRetrackingStatusTxt.SubstVolRetrackingStatusText,

                 CreatedByUser,
                 CreationDateTime,
                 LastChangedByUser,
                 LastChangeDateTime,
                 SubstVolRetrackingCompletedBy,
                 SuVolRtrckgCmpltdByFullName,
                 SubstVolRetrckgCompletedDteTme,
                 SubstVolRetrackingDecidedBy,
                 SuVolRtrckgDecidedByCmbndName,
                 SubstVolRetrckgDecidedDteTme,

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

                 _SubstVolRetrckgChmlCmpstn,
                 _ChmlCmplncMatlAssgmt
}
where
  SubstVolRetrackingTP.SubstVolRetrackingCategory = 2
/*+[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":""
}
}*/

Learn More