A_PureSubstance

DDL: A_PURESUBSTANCE SQL: APURESUB Type: view CONSUMPTION

Pure Substance

A_PureSubstance is a Consumption CDS View that provides data about "Pure Substance" in SAP S/4HANA. It reads from 1 data source (I_PureSubstance) and exposes 17 fields with key field PureSubstanceInternalID. It has 1 association to related views.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_PureSubstance I_PureSubstance from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (1)

CardinalityTargetAliasCondition
[0..*] A_PureSubstanceDescription _PureSubstanceDescription _PureSubstanceDescription.PureSubstanceInternalID = $projection.PureSubstanceInternalID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName APURESUB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Pure Substance view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY PureSubstanceInternalID PureSubstanceInternalID
PureSubstance
PureSubstanceCreationDate PureSubstanceCreationDate
PureSubstanceCreatedByUser PureSubstanceCreatedByUser
PureSubstanceChangeDate PureSubstanceChangeDate
PureSubstanceChangedByUser PureSubstanceChangedByUser
PureSubstanceValidityStartDate SpecificationValidityStartDate
PureSubstanceValidityEndDate SpecificationValidityEndDate
PureSubstVersIndepLstChgDate
PureSubstVersIndepLstChgTime
ListedSubstance
PureSubstanceAuthznGroup PureSubstanceAuthznGroup
PureSubstanceType PureSubstanceType
_PureSubstanceDescription _PureSubstanceDescription
_LogAccMObjectTypeActive _LogAccMObjectTypeActive
_LogAccMObjectUserAuthzn _LogAccMObjectUserAuthzn
_LogAccMObjSecureIDAssgmt _LogAccMObjSecureIDAssgmt 
@AbapCatalog.sqlViewName: 'APURESUB'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK

@EndUserText.label: 'Pure Substance'

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED

@VDM.viewType: #CONSUMPTION
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API

define view A_PureSubstance
  with parameters
    @Semantics.businessDate.at: true
    @Consumption.hidden: true
    P_KeyDate : sydate
  as select from I_PureSubstance( P_KeyDate : $parameters.P_KeyDate )

  association [0..*] to A_PureSubstanceDescription as _PureSubstanceDescription on _PureSubstanceDescription.PureSubstanceInternalID = $projection.PureSubstanceInternalID
{

  key PureSubstanceInternalID,
      cast( PureSubstance as /plmb/spc_pure_ext_id_api preserving type ) as PureSubstance,

      PureSubstanceCreationDate,
      PureSubstanceCreatedByUser,

      PureSubstanceChangeDate,
      PureSubstanceChangedByUser,

      SpecificationValidityStartDate                                     as PureSubstanceValidityStartDate,
      SpecificationValidityEndDate                                       as PureSubstanceValidityEndDate,
      
      cast( _SpecificationLastChange.SpecificationLastChangeDate as /plmb/spc_vrsn_indep_lstchg_d preserving type ) as PureSubstVersIndepLstChgDate,
      cast( _SpecificationLastChange.SpecificationLastChangeTime as /plmb/spc_vrsn_indep_lstchg_t preserving type ) as PureSubstVersIndepLstChgTime,

      _SpecListedSubstanceLink( P_KeyDate: $parameters.P_KeyDate ).ListedSubstance,

      @Consumption.hidden: true
      PureSubstanceAuthznGroup,
      @Consumption.hidden: true
      PureSubstanceType,

      _PureSubstanceDescription,

      @Consumption.hidden: true
      _LogAccMObjectTypeActive,
      @Consumption.hidden: true
      _LogAccMObjectUserAuthzn,
      @Consumption.hidden: true
      _LogAccMObjSecureIDAssgmt

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURESUBSTANCE",
"I_SPECIFICATIONLASTCHANGE",
"I_SPECLISTEDSUBSTANCELINK"
],
"ASSOCIATED":
[
"A_PURESUBSTANCEDESCRIPTION",
"I_LOGACCMOBJECTTYPEACTIVE",
"I_LOGACCMOBJECTUSERAUTHZN",
"I_LOGACCMOBJSECUREIDASSGMT"
],
"BASE":
[
"I_PURESUBSTANCE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More