I_CstrtHardwareBsc

DDL: I_CSTRTHARDWAREBSC SQL: ICSTRTHDBSC Type: view BASIC

Hardware Constraint Item Basic View

I_CstrtHardwareBsc is a Basic CDS View that provides data about "Hardware Constraint Item Basic View" in SAP S/4HANA. It reads from 3 data sources (P_CstrtHardwareItem, makt, mara) and exposes 15 fields with key field EmbeddedSwConstraintInternalID. It has 1 association to related views.

3 data source(s) 15 fields

Data Sources (3)

SourceAliasJoin Type
P_CstrtHardwareItem _Item from
makt makt left_outer
mara mara left_outer

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CstrtRule _Rule _Rule.EmbeddedSwConstraintRule = _Item.EmbeddedSwConstraintRule

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICSTRTHDBSC view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
EndUserText.label Hardware Constraint Item Basic View view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY EmbeddedSwConstraintInternalID EmbeddedSwConstraintInternalID
EmbeddedSoftwareUUID EmbeddedSoftwareUUID
EmbeddedSoftwareMaterial EmbeddedSoftwareMaterial
EmbeddedSwFromVersion EmbeddedSwFromVersion
EmbeddedSwToVersion EmbeddedSwToVersion
EmbeddedSwConstraintRule EmbeddedSwConstraintRule
EmbeddedSwConstraintRuleDesc _Rule EmbeddedSwConstraintRuleDesc
EmbeddedSwHardwareMaterial
CreationDateTime CreationDateTime
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangedByUser
EmbeddedSwCstrtRuleNmbr EmbeddedSwCstrtRuleNmbr
EmbeddedSwHardwareMaterialDesc maktx
AuthorizationGroup begru 
@AbapCatalog.sqlViewName: 'ICSTRTHDBSC'

@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #C,
                          dataClass: #MIXED,
                          sizeCategory: #XXL} 

@EndUserText.label: 'Hardware Constraint Item Basic View'
define view I_CstrtHardwareBsc as select from  P_CstrtHardwareItem as _Item
    left outer join       mara                          on  mara.matnr                     = _Item.EmbeddedSoftwareMaterial
    left outer join       makt                          on  makt.matnr                     = _Item.EmbeddedSwConstraintMaterial
                                                        and spras                          = $session.system_language
    association [1..1] to I_CstrtRule as _Rule          on  _Rule.EmbeddedSwConstraintRule = _Item.EmbeddedSwConstraintRule            
{
    key EmbeddedSwConstraintInternalID,
        EmbeddedSoftwareUUID,
        EmbeddedSoftwareMaterial,
        EmbeddedSwFromVersion,
        EmbeddedSwToVersion,
        EmbeddedSwConstraintRule,
        _Rule.EmbeddedSwConstraintRuleDesc,
        cast ( EmbeddedSwConstraintMaterial as /plmb/cstrt_hd_mat ) as EmbeddedSwHardwareMaterial,
        CreationDateTime,
        CreatedByUser,
        LastChangeDateTime,
        LastChangedByUser,
        EmbeddedSwCstrtRuleNmbr,
        
        maktx                   as EmbeddedSwHardwareMaterialDesc,
        begru                   as AuthorizationGroup
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CSTRTRULE",
"P_CSTRTHARDWAREITEM",
"MAKT",
"MARA"
],
"ASSOCIATED":
[
"I_CSTRTRULE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More