P_SPECVALASSGMTINSTANCENORMAL

CDS View

Private view for Normal VAs

P_SPECVALASSGMTINSTANCENORMAL is a CDS View in S/4HANA. Private view for Normal VAs. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SpecValAssgmtInstance view from COMPOSITE Specification Value Assignment Instance with Usages
I_SpecValAssgmtWithHeader view from COMPOSITE Specification Value Assignment Instance with Header 
@AbapCatalog.sqlViewName: 'PSPECVANRM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.lifecycle.contract.type: #NONE
@VDM.viewType: #COMPOSITE
@VDM.private: true

define view P_SpecValAssgmtInstanceNormal
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate
  as select from P_SpecValAssgmtWithHeader( P_KeyDate: $parameters.P_KeyDate )
{
  key SpecValAssgmtHdr,
  key SpecValAssgmt,

      SpecificationInternalID,
      // SpecValAssgmtHdrChangeState,

      SpecValAssgmtType,
      SpecValAssgmtHdrIsDeleted,

      SpecValAssgmtChangeState,
      SpecValAssgmtValidityStartDate,
      SpecValAssgmtValidityEndDate,
      SpecValAssgmtChangeNumber,
      SpecValAssgmtCreationDate,
      SpecValAssgmtCreatedByUser,
      SpecValAssgmtLastChangeDate,
      SpecValAssgmtLastChangedByUser,
      SpecValAssgmtSortSequence,
      SpecValAssgmtUnitRefDimension,
      SpecValAssgmtIsInhtncSource,
      InhtdSpecValAssgmtIsTmpChgd,
      InhtdSpecValAssgmtIsPermChgd,
      SpecInheritanceTemplate,
      SpecValAssgmtInheritanceParent,
      SpecValAssgmt                                   as SpecValAssgmtInheritanceRoot, // overwrite with the original key

      SpecificationInternalID                         as SpecValAssgmtRootSpecIntID,   // overwrite with the original key


      SpecValAssgmtIsDeleted,

      concat(SpecValAssgmt, SpecValAssgmtChangeState) as SpecValAssgmtWithChangeState,

      //InheritanceTmplSortSequence,

      'NORMAL'                                        as ValueAssignmentSource,

      //     _SpecificationForKeyDate

      _ValueAssignmentType
}
where
  SpecValAssgmtInheritanceRoot = '00000000000000000000'
// overwrites are removed (to support only normal, not normal+a very limited inheritance)

//  or InhtdSpecValAssgmtIsTmpChgd  = 'X'

//  or InhtdSpecValAssgmtIsPermChgd = 'X'

Learn More