I_PRODSTRUCVARIANTPLANTUSAGE

CDS View

Product Structure Variant Plant Usage

I_PRODSTRUCVARIANTPLANTUSAGE is a CDS View in S/4HANA. Product Structure Variant Plant Usage. It contains 2 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 2 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProductStructureNodeVariant view left_outer COMPOSITE Product Structure Node Variant

Fields (2)

KeyField CDS FieldsUsed in Views
Plant Plant 1
ProductStructureUsage ProductStructureUsage 1 
@AbapCatalog.sqlViewName: 'IPSVARPLANTUSAGE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck:   #CHECK
@VDM.viewType: #BASIC

//@ObjectModel.representativeKey: 'ProductStructureVariant'

//@ObjectModel.semanticKey: 'ProductStructureVariant'


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

@EndUserText.label: 'Product Structure Variant Plant Usage'
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_ProdStrucVariantPlantUsage
  as select from ppeobj
    inner join   ppelnk on  ppeobj.objid  = ppelnk.objid
                        and ppeobj.objcnt = ppelnk.objcnt
    inner join   ppehdr on ppelnk.ppeguid = ppehdr.ppeguid
    left outer to one join I_ProdStrucVariantBasic        as _Variant                  on ppeobj.pvguid = _Variant.ProductStructureVariantUUID
  association [0..1] to I_ProdStrucLogAccMActive  as _LogAccMObjectTypeActive  on  $projection.ProductStructureGnrcObjType = _LogAccMObjectTypeActive.LogAccMObjectType
  association [0..1] to I_ProdStrucObjSecureIDAssgmt as _LogAccMObjSecureIDAssgmt on  $projection.ProdStrucVariantUniqueID               = _LogAccMObjSecureIDAssgmt.LogAccMObjectID
                                                                                and $projection.ProductStructureGnrcObjType              = _LogAccMObjSecureIDAssgmt.LogAccMObjectType
  association [0..1] to I_ProdStrucObjectUserAuthzn  as _LogAccMObjectUserAuthzn  on  $projection.ProdStrucVariantUniqueID               = _LogAccMObjectUserAuthzn.LogAccMObjectID
                                                                                and   $projection.ProductStructureGnrcObjType            = _LogAccMObjectUserAuthzn.LogAccMObjectType
                                                                                and   $projection.ProductStructureGnrcObjType            = _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject      
{
  ppeobj.pvguid                                as  ProductStructureVariantUUID,
  //bintohex(   ppeobj.pvguid  )                 as  ProdStrucVariantUniqueID,

  _Variant.ProdStrucVariantUniqueID,
  ppehdr.ppeuse                                as  ProductStructureUsage,
  ppehdr.locid                                 as  Plant,
  ppehdr.objid                                 as  Material,
  _Variant.ProductStructureGnrcObjType,
  //_LogAccMObjSecureIDAssgmt.LogAccMObjectID,

  _LogAccMObjectTypeActive,
  _LogAccMObjSecureIDAssgmt,
  _LogAccMObjectUserAuthzn
}
where
  ppeobj.applobj_type = 'CMP'

Learn More