I_VariantHeader

DDL: I_VARIANTHEADER SQL: IVARHEADER Type: view BASIC

Variant Header Data

I_VariantHeader is a Basic CDS View that provides data about "Variant Header Data" in SAP S/4HANA. It reads from 2 data sources (I_Variant_Type, posvid) and exposes 12 fields with key field ProductStructureVariantUUID. It has 3 associations to related views.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
I_Variant_Type I_Variant_Type from
posvid posvid left_outer

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_LogAccMObjectTypeActive _LogAccMObjectTypeActive _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_PPEPV' or _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_PPEPIV'
[0..*] I_LogAccMObjSecureIDAssgmt _LogAccMObjSecureIDAssgmt $projection.ProdStrucVariantUniqueID = _LogAccMObjSecureIDAssgmt.LogAccMObjectID and ( _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_PPEPV' or _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_PPEPIV' )
[0..*] I_LogAccMObjectUserAuthzn _LogAccMObjectUserAuthzn $projection.ProdStrucVariantUniqueID = _LogAccMObjectUserAuthzn.LogAccMObjectID and ( _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_PPEPV' or _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_PPEPIV' ) and ( _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_PPEPV' or _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_PPEPIV' ) and ( _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '03' or _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '*' ) and _LogAccMObjectUserAuthzn.LogAccMUserAuthznField = 'ACTVT' and ( _LogAccMObjectUserAuthzn.LogAccMUserEntityID = $session.user or _LogAccMObjectUserAuthzn.UserID = $session.user )

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IVARHEADER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_ProdStrucVariantHeader view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label Variant Header Data view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ProductStructureVariantUUID pvguid
ProdStrucVariantUniqueID
ProductStructureVariantName pvname
ProdStructureVariantParentUUID pnguid
ProductStructureVariantType pvtype
ProductStructureCreationDate creadat
ProductStructureCreatedByUser creaby
ProductStrucLastChangedDate chngdat
ProductStrucLastChangedByUser chngby
_LogAccMObjectTypeActive _LogAccMObjectTypeActive
_LogAccMObjSecureIDAssgmt _LogAccMObjSecureIDAssgmt
_LogAccMObjectUserAuthzn _LogAccMObjectUserAuthzn 
@AbapCatalog.sqlViewName: 'IVARHEADER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@VDM.lifecycle: {
//  contract: {

//    type: #PUBLIC_LOCAL_API

//  },

  status: #DEPRECATED,
  successor: 'I_ProdStrucVariantHeader'
}

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #C
@EndUserText.label: 'Variant Header Data'
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_VariantHeader
  as select from    I_Variant_Type
    left outer join posvid on I_Variant_Type.ProductStructureVariantType = posvid.pvtype
  association [0..1] to I_LogAccMObjectTypeActive  as _LogAccMObjectTypeActive  on  _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_PPEPV'
                                                                                or  _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_PPEPIV'
  association [0..*] to I_LogAccMObjSecureIDAssgmt as _LogAccMObjSecureIDAssgmt on  $projection.ProdStrucVariantUniqueID          = _LogAccMObjSecureIDAssgmt.LogAccMObjectID
                                                                                and (
                                                                                   _LogAccMObjSecureIDAssgmt.LogAccMObjectType    = 'PLM_PPEPV'
                                                                                   or _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_PPEPIV'
                                                                                 )
  association [0..*] to I_LogAccMObjectUserAuthzn  as _LogAccMObjectUserAuthzn  on  $projection.ProdStrucVariantUniqueID               = _LogAccMObjectUserAuthzn.LogAccMObjectID
                                                                                and (
                                                                                   _LogAccMObjectUserAuthzn.LogAccMObjectType          = 'PLM_PPEPV'
                                                                                   or _LogAccMObjectUserAuthzn.LogAccMObjectType       = 'PLM_PPEPIV'
                                                                                 )
                                                                                and (
                                                                                   _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject    = 'PLM_PPEPV'
                                                                                   or _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_PPEPIV'
                                                                                 )
                                                                                and (
                                                                                   _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom      = '03'
                                                                                   or _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom   = '*'
                                                                                 )
                                                                                and _LogAccMObjectUserAuthzn.LogAccMUserAuthznField    = 'ACTVT'
                                                                                and (
                                                                                   _LogAccMObjectUserAuthzn.LogAccMUserEntityID        = $session.user
                                                                                   or _LogAccMObjectUserAuthzn.UserID                  = $session.user
                                                                                 )
{
  key pvguid                             as ProductStructureVariantUUID,
      //ltrim(pvname, '0')                 as ProductStructureVariantName,

      bintohex( pvguid )                 as ProdStrucVariantUniqueID,
      pvname                             as ProductStructureVariantName,
      pnguid                             as ProdStructureVariantParentUUID,
      pvtype                             as ProductStructureVariantType,
      creadat                            as ProductStructureCreationDate,
      creaby                             as ProductStructureCreatedByUser,
      chngdat                            as ProductStrucLastChangedDate,
      chngby                             as ProductStrucLastChangedByUser,
      //_LogAccMObjSecureIDAssgmt.LogAccMObjectID,

      _LogAccMObjectTypeActive,
      _LogAccMObjSecureIDAssgmt,
      _LogAccMObjectUserAuthzn
}
where
  pvname is not null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_VARIANT_TYPE",
"POSVID"
],
"ASSOCIATED":
[
"I_LOGACCMOBJECTTYPEACTIVE",
"I_LOGACCMOBJECTUSERAUTHZN",
"I_LOGACCMOBJSECUREIDASSGMT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More