C_SubstVolRetrackingSubstTP

DDL: C_SUBSTVOLRETRACKINGSUBSTTP Type: view_entity CONSUMPTION

Subst Vol Retracking for Substance

C_SubstVolRetrackingSubstTP is a Consumption CDS View that provides data about "Subst Vol Retracking for Substance" in SAP S/4HANA. It reads from 1 data source (R_SubstVolRetrackingTP) and exposes 44 fields with key field SubstVolRetrackingUUID. It is exposed through 1 OData service (UI_SUBSTVOLRETRCKG_MANAGE).

1 data source(s) Exposed by 1 service(s) 44 fields

Data Sources (1)

SourceAliasJoin Type
R_SubstVolRetrackingTP R_SubstVolRetrackingTP projection

Annotations (9)

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

OData Services (1)

ServiceBindingVersionContractRelease
UI_SUBSTVOLRETRCKG_MANAGE UI_SUBSTVOLRETRCKG_MANAGE V4 C1 NOT_RELEASED

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY SubstVolRetrackingUUID SubstVolRetrackingUUID
SubstVolRetrackingStatus SubstVolRetrackingStatus
ProdCmplncEventUUID ProdCmplncEventUUID
SubstVolRetrackingType SubstVolRetrackingType
SubstVolRetrackingSourceUUID SubstVolRetrackingSourceUUID
SubstVolRetrackingSource SubstVolRetrackingSource
SubstVolRetrackingSourceType SubstVolRetrackingSourceType
SubstVolRetrackingSrceChgdBy SubstVolRetrackingSrceChgdBy
SubstVolRetrackingCategory SubstVolRetrackingCategory
ComplianceRequirement ComplianceRequirement
CmplRqUUID CmplRqUUID
SuVolRtrckgSrceChgdByFullName SuVolRtrckgSrceChgdByFullName
SubstVolRetrckgSrceChgdDteTme SubstVolRetrckgSrceChgdDteTme
SubstanceName
SubstVolRetrackingCompletedBy SubstVolRetrackingCompletedBy
SuVolRtrckgCmpltdByFullName SuVolRtrckgCmpltdByFullName
SubstVolRetrckgCompletedDteTme SubstVolRetrckgCompletedDteTme
SubstVolRetrackingDecidedBy SubstVolRetrackingDecidedBy
SuVolRtrckgDecidedByCmbndName SuVolRtrckgDecidedByCmbndName
SubstVolRetrckgDecidedDteTme SubstVolRetrckgDecidedDteTme
SubstVolRetrackingTypeText _SubstVolRetrackingTypeTxt SubstVolRetrackingTypeText
SubstVolRetrackingStatusText _SubstVolRetrackingStatusTxt SubstVolRetrackingStatusText
CASNumber
ECNumber
MolecularFormula
CompanySubstanceName
SubstanceInternalName
Specification
CntntListedSubstanceDfltName
CustListedSubstanceDfltName
CntntListedSubstance
CustListedSubstance
CntntCASNumber
CustCASNumber
CntntECNumber
CustECNumber
CntntMolecularFormula
CustMolecularFormula
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
_SubstVolRetrckgChmlCmpstn _SubstVolRetrckgChmlCmpstn
_ChmlCmplncMatlAssgmt _ChmlCmplncMatlAssgmt 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Subst Vol Retracking for Substance'
@Metadata.allowExtensions: true

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

@ObjectModel.usageType:{ serviceQuality: #C,
                       sizeCategory:   #L,
                       dataClass:      #MASTER }
@Metadata.ignorePropagatedAnnotations: true
@Search.searchable: true
define root view entity C_SubstVolRetrackingSubstTP
  provider contract transactional_query
  as projection on R_SubstVolRetrackingTP as SubstVolRetrackingTP
{
  key            SubstVolRetrackingUUID,
                 SubstVolRetrackingStatus,
                 ProdCmplncEventUUID,
                 SubstVolRetrackingType,
                 SubstVolRetrackingSourceUUID,
                 SubstVolRetrackingSource,
                 SubstVolRetrackingSourceType,
                 SubstVolRetrackingSrceChgdBy,
                 SubstVolRetrackingCategory,
                 ComplianceRequirement,
                 CmplRqUUID,

                 SuVolRtrckgSrceChgdByFullName,
                 SubstVolRetrckgSrceChgdDteTme,
                 
                 _SubstVolRetrckgChmlCmpstn._SubstanceTP.SubstanceName,
                 
                 SubstVolRetrackingCompletedBy,
                 SuVolRtrckgCmpltdByFullName,
                 SubstVolRetrckgCompletedDteTme,
                 SubstVolRetrackingDecidedBy,
                 SuVolRtrckgDecidedByCmbndName,
                 SubstVolRetrckgDecidedDteTme,

                 _SubstVolRetrackingTypeTxt.SubstVolRetrackingTypeText,
                 _SubstVolRetrackingStatusTxt.SubstVolRetrackingStatusText,     
                 
                 _SubstVolRetrckgChmlCmpstn._SubstanceTP._ListedSubstance.CASNumber,
                 _SubstVolRetrckgChmlCmpstn._SubstanceTP._ListedSubstance.ECNumber,
                 _SubstVolRetrckgChmlCmpstn._SubstanceTP._ListedSubstance.MolecularFormula,
                 _SubstVolRetrckgChmlCmpstn._SubstanceTP.CompanySubstanceName,
                 _SubstVolRetrckgChmlCmpstn._SubstanceTP.SubstanceInternalName,
                 cast( _SubstVolRetrckgChmlCmpstn._SubstanceTP.Specification as ehfnd_internal_nr_nc preserving type ) as Specification,
                 _SubstVolRetrckgChmlCmpstn._SubstanceTP._ListedSubstance.CntntListedSubstanceDfltName,
                 _SubstVolRetrckgChmlCmpstn._SubstanceTP._ListedSubstance.CustListedSubstanceDfltName,
                 _SubstVolRetrckgChmlCmpstn._SubstanceTP._ListedSubstance.CntntListedSubstance,
                 _SubstVolRetrckgChmlCmpstn._SubstanceTP._ListedSubstance.CustListedSubstance,
                 _SubstVolRetrckgChmlCmpstn._SubstanceTP._ListedSubstance.CntntCASNumber,
                 _SubstVolRetrckgChmlCmpstn._SubstanceTP._ListedSubstance.CustCASNumber,
                 _SubstVolRetrckgChmlCmpstn._SubstanceTP._ListedSubstance.CntntECNumber,
                 _SubstVolRetrckgChmlCmpstn._SubstanceTP._ListedSubstance.CustECNumber,
                 _SubstVolRetrckgChmlCmpstn._SubstanceTP._ListedSubstance.CntntMolecularFormula,
                 _SubstVolRetrckgChmlCmpstn._SubstanceTP._ListedSubstance.CustMolecularFormula,  
                 
                 CreatedByUser,
                 CreationDateTime,
                 LastChangedByUser,
                 LastChangeDateTime,

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

                 _SubstVolRetrckgChmlCmpstn,
                 _ChmlCmplncMatlAssgmt
}
where
  SubstVolRetrackingTP.SubstVolRetrackingCategory = 1

Learn More