C_SuVolRtrckgSubstChmlCmpstnTP
Retrack Substance Based Composition
C_SuVolRtrckgSubstChmlCmpstnTP is a Consumption CDS View that provides data about "Retrack Substance Based Composition" in SAP S/4HANA. It reads from 1 data source (R_SubstVolRetrackingTP) and exposes 38 fields with key field SubstVolRetrackingUUID. It has 3 associations to related views. It is exposed through 1 OData service (UI_SUBSTVOLRETRCKG_MANAGE).
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_SubstVolRetrackingTP | R_SubstVolRetrackingTP | projection |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | C_SubstChmlCmpstnSubstVol | _SubstVolByCRCurrPeriod | $projection.chmlcmplncinfouuid = _SubstVolByCRCurrPeriod.ChmlCmplncInfoUUID and $projection.ComplianceRequirement = _SubstVolByCRCurrPeriod.ComplianceRequirement and _SubstVolByCRCurrPeriod.TrackingPeriodType = 'CURR_PER' |
| [0..*] | C_SubstChmlCmpstnSubstVol | _SubstVolByCRPrevPeriod | $projection.chmlcmplncinfouuid = _SubstVolByCRPrevPeriod.ChmlCmplncInfoUUID and $projection.ComplianceRequirement = _SubstVolByCRPrevPeriod.ComplianceRequirement and _SubstVolByCRPrevPeriod.TrackingPeriodType = 'PREV_PER' |
| [0..*] | C_SubstChmlCmpstnDailySubstVol | _SubstChmlCmpstnDailySubstVol | $projection.chmlcmplncinfouuid = _SubstChmlCmpstnDailySubstVol.ChmlCmplncInfoUUID and $projection.ComplianceRequirement = _SubstChmlCmpstnDailySubstVol.ComplianceRequirement |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Retrack Substance Based Composition | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view | |
| Metadata.allowExtensions | true | view | |
| VDM.viewType | #CONSUMPTION | view | |
| UI.headerInfo.typeImageUrl | sap-icon: title: { label: | view | |
| UI.headerInfo.value | ChmlCmplncInfoCombinedName | view | |
| UI.headerInfo.description.label | ComplianceRequirement | view | |
| UI.headerInfo.description.value | ComplianceRequirement | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| Search.searchable | true | view |
OData Services (1)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| UI_SUBSTVOLRETRCKG_MANAGE | UI_SUBSTVOLRETRCKG_MANAGE | V4 | C1 | NOT_RELEASED |
Fields (38)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SubstVolRetrackingUUID | SubstVolRetrackingUUID | ||
| SubstVolRetrackingStatus | SubstVolRetrackingStatus | |||
| ProdCmplncEventUUID | ProdCmplncEventUUID | |||
| SubstVolRetrackingType | SubstVolRetrackingType | |||
| SubstVolRetrackingSourceUUID | SubstVolRetrackingSourceUUID | |||
| SubstVolRetrackingSource | SubstVolRetrackingSource | |||
| SubstVolRetrckgIsCurTrckgPerd | SubstVolRetrckgIsCurTrckgPerd | |||
| SubstVolRetrckgIsOpnTrckgPerds | SubstVolRetrckgIsOpnTrckgPerds | |||
| SubstVolRetrackingReasonText | SubstVolRetrackingReasonText | |||
| SubstVolRetrackingCategory | SubstVolRetrackingCategory | |||
| ComplianceRequirement | ComplianceRequirement | |||
| ChmlCompositionUUID | _SubstVolRetrckgChmlCmpstn | ChmlCompositionUUID | ||
| SubstVolRetrackingSrceChgdBy | SubstVolRetrackingSrceChgdBy | |||
| SuVolRtrckgSrceChgdByFullName | SuVolRtrckgSrceChgdByFullName | |||
| SubstVolRetrckgSrceChgdDteTme | _SubstVolRetrckgChmlCmpstn | SubstVolRetrckgSrceChgdDteTme | ||
| ChmlCompositionTypeName | ||||
| ChmlCmplncInfoCombinedName | ||||
| SubstVolRetrackingCompletedBy | SubstVolRetrackingCompletedBy | |||
| SuVolRtrckgCmpltdByFullName | SuVolRtrckgCmpltdByFullName | |||
| SubstVolRetrckgCompletedDteTme | SubstVolRetrckgCompletedDteTme | |||
| SubstVolRetrackingDecidedBy | SubstVolRetrackingDecidedBy | |||
| SuVolRtrckgDecidedByFullName | SuVolRtrckgDecidedByFullName | |||
| SuVolRtrckgDecidedBySystemText | SuVolRtrckgDecidedBySystemText | |||
| SubstVolRetrckgDecidedDteTme | SubstVolRetrckgDecidedDteTme | |||
| SubstVolRetrackingStartDate | ||||
| ChmlCompositionType | _SubstVolRetrckgChmlCmpstn | ChmlCompositionType | ||
| Material | _SubstVolRetrckgChmlCmpstn | Material | ||
| ChmlCmplncInfoUUID | _SubstVolRetrckgChmlCmpstn | ChmlCmplncInfoUUID | ||
| SubstVolRetrackingTypeText | _SubstVolRetrackingTypeTxt | SubstVolRetrackingTypeText | ||
| virtualObjectLinkURLstring_unicode | ||||
| _SubstVolByCRCurrPeriod | _SubstVolByCRCurrPeriod | |||
| _SubstVolByCRPrevPeriod | _SubstVolByCRPrevPeriod | |||
| _SubstChmlCmpstnDailySubstVol | _SubstChmlCmpstnDailySubstVol | |||
| _SubstVolRetrckgChmlCmpstn | _SubstVolRetrckgChmlCmpstn | |||
| _ChmlCmplncMatlAssgmt | _ChmlCmplncMatlAssgmt | |||
| _ReleasedByUser | _ReleasedByUser | |||
| _CompletedByUser | _CompletedByUser | |||
| _DecidedByUser | _DecidedByUser |
@EndUserText.label: 'Retrack Substance Based Composition'
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.privilegedAssociations: ['_ReleasedByUser', '_CompletedByUser', '_DecidedByUser']
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.allowExtensions: true
@VDM: {
viewType: #CONSUMPTION,
usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ] }
--Header information
@UI:
{
headerInfo:
{
typeImageUrl: 'sap-icon://tree',
title:
{
label: 'Chemical Compliance View',
value: 'ChmlCmplncInfoCombinedName'
},
description: {
label: 'ComplianceRequirement',
value: 'ComplianceRequirement'
}
}
}
@ObjectModel.usageType:{ serviceQuality: #D,
sizeCategory: #L,
dataClass: #MASTER }
@Search.searchable: true
define root view entity C_SuVolRtrckgSubstChmlCmpstnTP
provider contract transactional_query
as projection on R_SubstVolRetrackingTP as SubstVolRetrackingTP
association [0..*] to C_SubstChmlCmpstnSubstVol as _SubstVolByCRCurrPeriod on $projection.chmlcmplncinfouuid = _SubstVolByCRCurrPeriod.ChmlCmplncInfoUUID
and $projection.ComplianceRequirement = _SubstVolByCRCurrPeriod.ComplianceRequirement
and _SubstVolByCRCurrPeriod.TrackingPeriodType = 'CURR_PER'
association [0..*] to C_SubstChmlCmpstnSubstVol as _SubstVolByCRPrevPeriod on $projection.chmlcmplncinfouuid = _SubstVolByCRPrevPeriod.ChmlCmplncInfoUUID
and $projection.ComplianceRequirement = _SubstVolByCRPrevPeriod.ComplianceRequirement
and _SubstVolByCRPrevPeriod.TrackingPeriodType = 'PREV_PER'
association [0..*] to C_SubstChmlCmpstnDailySubstVol as _SubstChmlCmpstnDailySubstVol on $projection.chmlcmplncinfouuid = _SubstChmlCmpstnDailySubstVol.ChmlCmplncInfoUUID
and $projection.ComplianceRequirement = _SubstChmlCmpstnDailySubstVol.ComplianceRequirement
{
key SubstVolRetrackingUUID,
SubstVolRetrackingStatus,
ProdCmplncEventUUID,
SubstVolRetrackingType,
SubstVolRetrackingSourceUUID,
SubstVolRetrackingSource,
SubstVolRetrckgIsCurTrckgPerd,
SubstVolRetrckgIsOpnTrckgPerds,
SubstVolRetrackingReasonText,
SubstVolRetrackingCategory,
ComplianceRequirement,
_SubstVolRetrckgChmlCmpstn.ChmlCompositionUUID,
SubstVolRetrackingSrceChgdBy as SubstVolRetrackingSrceChgdBy,
SuVolRtrckgSrceChgdByFullName,
_SubstVolRetrckgChmlCmpstn.SubstVolRetrckgSrceChgdDteTme,
cast ( _SubstVolRetrckgChmlCmpstn.ChmlCompositionTypeName as ehpma_svt_retrckg_cmpstn_type preserving type ) as ChmlCompositionTypeName,
cast ( _SubstVolRetrckgChmlCmpstn.ChmlCmplncInfoCombinedName as ehpma_svt_retrckg_cmpstn_link preserving type ) as ChmlCmplncInfoCombinedName,
SubstVolRetrackingCompletedBy,
SuVolRtrckgCmpltdByFullName,
SubstVolRetrckgCompletedDteTme,
SubstVolRetrackingDecidedBy,
SuVolRtrckgDecidedByFullName,
SuVolRtrckgDecidedBySystemText,
SubstVolRetrckgDecidedDteTme,
cast ( SubstVolRetrackingStartDate as ehpma_svt_retrckg_date_from preserving type ) as SubstVolRetrackingStartDate,
_SubstVolRetrckgChmlCmpstn.ChmlCompositionType,
_SubstVolRetrckgChmlCmpstn.Material,
_SubstVolRetrckgChmlCmpstn.ChmlCmplncInfoUUID,
_SubstVolRetrackingTypeTxt.SubstVolRetrackingTypeText,
@ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHPMA_SVT_HIDE_RTRCKG_EXIT'
virtual SubstVolRetrckgDetsAreHidden : abap_boolean,
@ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHPMA_SVT_CCMPS_LINK_EXIT'
virtual ObjectLinkURL : string_unicode,
@ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHPMA_SVT_HIDE_RTRCKG_EXIT'
virtual SubstVolRetrckgIsRejected : abap_boolean,
@ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHPMA_SVT_HIDE_RTRCKG_EXIT'
virtual SubstVolRetrckgIsAccepted : abap_boolean,
@ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHPMA_SVT_DECIDED_BY_EXIT'
virtual SuVolRtrckgIsDecidedBySystem : abap_boolean,
@ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHPMA_SVT_DECIDED_BY_EXIT'
virtual SuVolRtrckgIsDecidedByUser : abap_boolean,
--Combined name of composition category and combined name of CCI
@ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHFND_CMPS_HEADER_EXIT'
virtual ChmlCompositionCombinedName : ehpma_svt_retrckg_cmpstn_link,
_SubstVolByCRCurrPeriod,
_SubstVolByCRPrevPeriod,
_SubstChmlCmpstnDailySubstVol,
_SubstVolRetrckgChmlCmpstn,
_ChmlCmplncMatlAssgmt,
_ReleasedByUser,
_CompletedByUser,
_DecidedByUser
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA