I_SPECASSIGNEDMATERIAL

CDS View

Specification Material Assignment

I_SPECASSIGNEDMATERIAL is a CDS View in S/4HANA. Specification Material Assignment. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SpecAssignedMatlForKeyDate view from COMPOSITE Specification Material Assignment for Key Date 
@AbapCatalog.sqlViewName: 'ISPECMATASSGMT'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MASTER

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #BASIC

@EndUserText.label: 'Specification Material Assignment'
define view I_SpecAssignedMaterial
  as select from estmj
  // Association definitions

  // Administrative

  association [0..1] to I_User          as _CreatedByUser     on  $projection.SpecMaterialAssgmtCreatedByUsr = _CreatedByUser.UserID
  association [0..1] to I_User          as _LastChangedByUser on  $projection.SpecMatlAssgmtLastChangedByUsr = _LastChangedByUser.UserID

  // Dependent objects

  association [0..1] to I_Product       as _Product           on  $projection.Material = _Product.Product
  
  association [0..1] to I_Material      as _Material          on  $projection.Material = _Material.Material
                                                              and $projection.Plant    = ''
  association [0..1] to I_MaterialPlant as _MaterialPlant     on  $projection.Material = _MaterialPlant.Material
                                                              and $projection.Plant    = _MaterialPlant.Plant

  association [0..*] to I_Specification as _Specification     on  $projection.SpecificationInternalID = _Specification.SpecificationInternalID
  association [0..1] to I_ProductText   as _MaterialText      on  $projection.Material   = _MaterialText.Product
                                                              and _MaterialText.Language = $session.system_language
{
  key estmj.recn      as SpecMaterialAssgmtInternalID,
  key estmj.actn      as SpecMaterialAssgmtChangeState,
      estmj.recnroot  as SpecificationInternalID,

      estmj.valfr     as SpecMatlAssgmtValdtyStartDate,
      estmj.valto     as SpecMatlAssgmtValdtyEndDate,
      estmj.aennr     as SpecMaterialAssgmtChangeNumber,

      estmj.delflg    as SpecMaterialAssgmtIsDeleted,
      // estmj.parkflg   as SpecMaterialAssgmtIsArchived,      // todo GFNC

      estmj.crdat     as SpecMaterialAssgmtCreationDate,
      estmj.crnam     as SpecMaterialAssgmtCreatedByUsr,
      estmj.upddat    as SpecMaterialAssgmtChangeDate,
      estmj.updnam    as SpecMatlAssgmtLastChangedByUsr,
      //  estmj.srsid     as SpecMaterialAssignmentSource,

      // estmj.ownid     as SpecMaterialAssgmtDataProvider,


      estmj.werks     as Plant,
      estmj.matnr     as Material,

      /* Associations */
      // Administrative

      _CreatedByUser,
      _LastChangedByUser,

      // Dependent objects

      _Product,
      _Material,
      _MaterialPlant,
      _Specification,
      _MaterialText
}

Learn More