A_PureSubstance

DDL: A_PURESUBSTANCE SQL: APURESUB Type: view CONSUMPTION Package: VDM_PLMB_SPC_API_OP

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. It is exposed through 1 OData service (API_PURESUBSTANCE). Part of development package VDM_PLMB_SPC_API_OP.

1 data source(s) Exposed by 1 service(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

OData Services (1)

ServiceBindingVersionContractRelease
API_PURESUBSTANCE API_PURESUBSTANCE V2 C2 C1

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

}

Learn More