P_CSTRTSWITEM

CDS View

P_CSTRTSWITEM is a CDS View in S/4HANA. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CstrtSwBsc view from BASIC Software Constraint Item Basic view
I_CstrtSwNmbr view from BASIC Software Constraint Items Number 
@AbapCatalog.sqlViewName: 'PCSTRTSWITEM'

@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel.usageType: {serviceQuality: #C,
                          dataClass: #MIXED,
                          sizeCategory: #L}
 
//@EndUserText.label: 'Constraint Software Item data'

define view P_CstrtSwItem as select from /plmi/sw_cstrt_i as _Item {
    key _Item.db_key            as EmbeddedSwConstraintInternalID,
        _Item.parent_key        as EmbeddedSoftwareUUID,
        _Item.sw_module         as EmbeddedSoftwareMaterial,
        _Item.sw_version_min    as EmbeddedSwFromVersion,
        _Item.sw_version_max    as EmbeddedSwToVersion,
        _Item.cstrt_rule        as EmbeddedSwConstraintRule,
        _Item.cstrt_obj_id      as EmbeddedSwConstraintMaterial,
        _Item.cstrt_obj_val_min as EmbeddedSwCstrtSwMinVersion,
        _Item.cstrt_obj_val_max as EmbeddedSwCstrtSwMaxVersion,
        cast (_Item.created_on as tzntstmps ) as CreationDateTime,
        _Item.created_by        as CreatedByUser,
        cast ( _Item.changed_on as tzntstmps) as LastChangeDateTime,
        _Item.changed_by        as LastChangedByUser,
        _Item.rule_no           as EmbeddedSwCstrtRuleNmbr
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/PLMI/SW_CSTRT_I"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More