I_SuVolRtrckgMaterialSource

DDL: I_SUVOLRTRCKGMATERIALSOURCE Type: view BASIC

Subst Vol Retracking Material Source Details

I_SuVolRtrckgMaterialSource is a Basic CDS View that provides data about "Subst Vol Retracking Material Source Details" in SAP S/4HANA. It reads from 1 data source (I_Product) and exposes 9 fields with key field SubstVolRetrackingSource. It has 1 association to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_Product Product from

Associations (1)

CardinalityTargetAliasCondition
[1..1] P_SVTConstants _Constants _Constants.Dummy = _Constants.Dummy

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISVRTRCKGMATSRCE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Subst Vol Retracking Material Source Details view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY SubstVolRetrackingSource I_Product Product
SubstVolRetrackingSrceCrtedBy I_Product CreatedByUser
SubstVolRetrckgSrceChgdDteTme I_Product LastChangeDateTime
SubstVolRetrackingSrceName I_Product Product
SubstVolRetrckgSrceDetsName
SuVolRtrckgSrcePrimSrchName I_Product Product
SuVolRtrckgSrceSecdrySrchName I_Product Product
SubstVolRetrackingSourceUUID _Constants ConstantEmptyRaw16
SubstVolRetrackingSourceType 
@AbapCatalog: {
  sqlViewName: 'ISVRTRCKGMATSRCE',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #NOT_REQUIRED
}

@VDM: {
  viewType: #BASIC
}

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

@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Subst Vol Retracking Material Source Details'
define view I_SuVolRtrckgMaterialSource
  as select from I_Product as Product
  association [1..1] to P_SVTConstants as _Constants on _Constants.Dummy = _Constants.Dummy
{
  key Product.Product                                                      as SubstVolRetrackingSource,
      Product.CreatedByUser                                                as SubstVolRetrackingSrceCrtedBy,
      Product.LastChangeDateTime                                           as SubstVolRetrckgSrceChgdDteTme,
      Product.Product                                                      as SubstVolRetrackingSrceName,
      cast(''       as ehpma_svt_retrckg_chng_dtls)                        as SubstVolRetrckgSrceDetsName,
      Product.Product                                                      as SuVolRtrckgSrcePrimSrchName,
      Product.Product                                                      as SuVolRtrckgSrceSecdrySrchName,
      _Constants.ConstantEmptyRaw16                                        as SubstVolRetrackingSourceUUID,
      cast( _Constants.ConstantMaterial as ehpma_svt_retrckg_source_type ) as SubstVolRetrackingSourceType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCT",
"P_SVTCONSTANTS"
],
"ASSOCIATED":
[
"P_SVTCONSTANTS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More