I_ProdSpecStdCmpstnHeader

DDL: I_PRODSPECSTDCMPSTNHEADER SQL: IPRODSPCOMPSH Type: view COMPOSITE Package: VDM_PLMB_SPC_COMP_STD_OP

Product Specification Std. Comp. Hdr.

I_ProdSpecStdCmpstnHeader is a Composite CDS View that provides data about "Product Specification Std. Comp. Hdr." in SAP S/4HANA. It reads from 2 data sources (R_ProdSpecCmpstnHdrWithUsage, I_SpecStdCompositionDefinition) and exposes 16 fields with key fields ProdSpecCmpstnHeader, ProdSpecCmpstnHdrChangeState. It has 1 association to related views. Part of development package VDM_PLMB_SPC_COMP_STD_OP.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
R_ProdSpecCmpstnHdrWithUsage HeaderWUsage from
I_SpecStdCompositionDefinition SpecStdCompositionDefinition inner

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ProdSpecStdCmpstn _ProdSpecStdCmpstn _ProdSpecStdCmpstn.ProdSpecCmpstnHeader = $projection.ProdSpecCmpstnHeader and _ProdSpecStdCmpstn.ProdSpecCompItemValdtyStrtDte <= $projection.ProdSpecCmpstnHdrValdtyStrtDte and _ProdSpecStdCmpstn.ProdSpecCompItemValdtyEndDte >= $projection.ProdSpecCmpstnHdrValdtyEndDte

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPRODSPCOMPSH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Product Specification Std. Comp. Hdr. view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ProdSpecCmpstnHeader ProdSpecCmpstnHeader
KEY ProdSpecCmpstnHdrChangeState ProdSpecCmpstnHdrChangeState
ProductSpecificationInternalID ProductSpecificationInternalID
ProdSpecCmpstnHdrChangeNumber ProdSpecCmpstnHdrChangeNumber
ProdSpecCmpstnHdrSortSequence ProdSpecCmpstnHdrSortSequence
ProdSpecCmpstnHdrValdtyStrtDte ProdSpecCmpstnHdrValdtyStrtDte
ProdSpecCmpstnHdrValdtyEndDte ProdSpecCmpstnHdrValdtyEndDte
ProdSpecCmpstnHdrIsDeleted ProdSpecCmpstnHdrIsDeleted
ProdSpecCmpstnHdrValAssgmtType R_ProdSpecCmpstnHdrWithUsage ProdSpecCmpstnHdrValAssgmtType
ProdSpecCmpstnHdrRating R_ProdSpecCmpstnHdrWithUsage ProdSpecCmpstnHdrRating
ProdSpecCmpstnHdrValidityArea R_ProdSpecCmpstnHdrWithUsage ProdSpecCmpstnHdrValidityArea
ProdSpecCmpstnHdrRefValueCode
ProdSpecCmpstnHdrRefValueDim
_ProductSpecification _ProductSpecification
_ProdSpecNonHistoric _ProdSpecNonHistoric
_ProdSpecificationLastChange _ProdSpecificationLastChange 
@AbapCatalog.sqlViewName: 'IPRODSPCOMPSH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

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

@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@EndUserText.label: 'Product Specification Std. Comp. Hdr.'
define view I_ProdSpecStdCmpstnHeader
  as select from R_ProdSpecCmpstnHdrWithUsage   as HeaderWUsage

    inner join   I_SpecStdCompositionDefinition as SpecStdCompositionDefinition on  SpecStdCompositionDefinition.ProdSpecCompositionType        = 'STANDARD_COMPOSITION'
                                                                                and SpecStdCompositionDefinition.ProdSpecCmpstnHdrValAssgmtType = HeaderWUsage.ProdSpecCmpstnHdrValAssgmtType
                                                                                and SpecStdCompositionDefinition.ProdSpecCmpstnHdrRating        = HeaderWUsage.ProdSpecCmpstnHdrRating
                                                                                and SpecStdCompositionDefinition.ProdSpecCmpstnHdrValidityArea  = HeaderWUsage.ProdSpecCmpstnHdrValidityArea

  association [0..*] to I_ProdSpecStdCmpstn as _ProdSpecStdCmpstn on  _ProdSpecStdCmpstn.ProdSpecCmpstnHeader          = $projection.ProdSpecCmpstnHeader
                                                                  and _ProdSpecStdCmpstn.ProdSpecCompItemValdtyStrtDte <= $projection.ProdSpecCmpstnHdrValdtyStrtDte
                                                                  and _ProdSpecStdCmpstn.ProdSpecCompItemValdtyEndDte  >= $projection.ProdSpecCmpstnHdrValdtyEndDte

{
  key ProdSpecCmpstnHeader,
  key ProdSpecCmpstnHdrChangeState,

      ProductSpecificationInternalID,

      ProdSpecCmpstnHdrChangeNumber,
      ProdSpecCmpstnHdrSortSequence,

      ProdSpecCmpstnHdrValdtyStrtDte,
      ProdSpecCmpstnHdrValdtyEndDte,
      ProdSpecCmpstnHdrIsDeleted,

      HeaderWUsage.ProdSpecCmpstnHdrValAssgmtType,
      HeaderWUsage.ProdSpecCmpstnHdrRating,
      HeaderWUsage.ProdSpecCmpstnHdrValidityArea,

      cast(HeaderWUsage.SpecValAssgmtRefValueCode as /plmb/spc_comp_hdr_ref_v_code preserving type )                                  as ProdSpecCmpstnHdrRefValueCode,
      cast(HeaderWUsage._SpecValAssgmtReferenceValue.SpecValAssgmtRefValueDimension as /plmb/spc_comp_hdr_ref_v_dim preserving type ) as ProdSpecCmpstnHdrRefValueDim,

      // Associations

      _ProductSpecification,
      _ProdSpecNonHistoric,
      _ProdSpecificationLastChange
}

Learn More