I_ProdSpecComponentBaseUoM

DDL: I_PRODSPECCOMPONENTBASEUOM SQL: IPRSPCOMPUOM Type: view COMPOSITE Package: VDM_PLMB_SPC_COMP_CUST_OP

Prod Specification Component Base UoM

I_ProdSpecComponentBaseUoM is a Composite CDS View that provides data about "Prod Specification Component Base UoM" in SAP S/4HANA. It reads from 3 data sources (I_SpecCharByValueAssgmtInst, I_ProdSpecComponent, I_SpecTypeBaseUnitOfMeasure) and exposes 7 fields with key field ProdSpecComponentInternalID. It has 1 association to related views. Part of development package VDM_PLMB_SPC_COMP_CUST_OP.

3 data source(s) 7 fields

Data Sources (3)

SourceAliasJoin Type
I_SpecCharByValueAssgmtInst I_SpecCharByValueAssgmtInst from
I_ProdSpecComponent prodspecomponent inner
I_SpecTypeBaseUnitOfMeasure spectypebaseunitofmeasure inner

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ProdSpecComponent _ProdSpecComponent $projection.ProdSpecComponentInternalID = _ProdSpecComponent.ProdSpecComponentInternalID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPRSPCOMPUOM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Prod Specification Component Base UoM view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ProdSpecComponentInternalID I_ProdSpecComponent ProdSpecComponentInternalID
ProdSpecCompBaseUnitOfMeasure
Characteristic speccharbyvalueassgmtinst Characteristic
SpecValAssgmtType speccharbyvalueassgmtinst SpecValAssgmtType
SpecificationRating speccharbyvalueassgmtinst SpecificationRating
SpecificationValidityArea speccharbyvalueassgmtinst SpecificationValidityArea
_ProdSpecComponent _ProdSpecComponent 
@AbapCatalog.sqlViewName: 'IPRSPCOMPUOM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

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

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


@EndUserText.label: 'Prod Specification Component Base UoM'
define view I_ProdSpecComponentBaseUoM
  with parameters
    @Semantics.businessDate.at: true
    @Consumption.hidden: true
    P_KeyDate : sydate
  as select from I_SpecCharByValueAssgmtInst( P_KeyDate : $parameters.P_KeyDate ) as speccharbyvalueassgmtinst
    inner join   I_ProdSpecComponent                                              as prodspecomponent          on speccharbyvalueassgmtinst.SpecificationInternalID = prodspecomponent.ProdSpecComponentInternalID
    inner join   I_SpecTypeBaseUnitOfMeasure                                      as spectypebaseunitofmeasure on  spectypebaseunitofmeasure.ProdSpecCmpstnSpecType         = prodspecomponent.SpecificationType
                                                                                                               and spectypebaseunitofmeasure.ProdSpecBaseUnitValAssgmtType  = speccharbyvalueassgmtinst.SpecValAssgmtType
                                                                                                               and spectypebaseunitofmeasure.ProdSpecBaseUnitCharacteristic = speccharbyvalueassgmtinst.Characteristic
                                                                                                               and spectypebaseunitofmeasure.ProdSpecCmpstnHdrRating        = speccharbyvalueassgmtinst.SpecificationRating
                                                                                                               and spectypebaseunitofmeasure.ProdSpecCmpstnHdrValidityArea  = speccharbyvalueassgmtinst.SpecificationValidityArea
                                                                                                               and speccharbyvalueassgmtinst.SpecValAssgmtUsageIsExcluded   = ''
                                                                                                               and speccharbyvalueassgmtinst.SpecValAssgmtUsageIsActive     = 'X'
  association [1..1] to I_ProdSpecComponent as _ProdSpecComponent on $projection.ProdSpecComponentInternalID = _ProdSpecComponent.ProdSpecComponentInternalID
{
  key prodspecomponent.ProdSpecComponentInternalID,

      cast( CharacteristicValue as /plmb/spc_nutr_base_uom preserving type ) as ProdSpecCompBaseUnitOfMeasure,

      @Consumption.hidden: true
      speccharbyvalueassgmtinst.Characteristic,

      @Consumption.hidden: true
      speccharbyvalueassgmtinst.SpecValAssgmtType,
      @Consumption.hidden: true
      speccharbyvalueassgmtinst.SpecificationRating,
      @Consumption.hidden: true
      speccharbyvalueassgmtinst.SpecificationValidityArea,

      _ProdSpecComponent

}
where
      SpecValAssgmtUsageIsActive   = 'X'
  and SpecValAssgmtUsageIsExcluded = ''

Learn More