I_SpecAssignedMaterial

DDL: I_SPECASSIGNEDMATERIAL SQL: ISPECMATASSGMT Type: view BASIC

Specification Material Assignment

I_SpecAssignedMaterial is a Basic CDS View that provides data about "Specification Material Assignment" in SAP S/4HANA. It reads from 1 data source (estmj) and exposes 20 fields with key fields SpecMaterialAssgmtInternalID, SpecMaterialAssgmtChangeState. It has 7 associations to related views.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
estmj estmj from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_User _CreatedByUser $projection.SpecMaterialAssgmtCreatedByUsr = _CreatedByUser.UserID
[0..1] I_User _LastChangedByUser $projection.SpecMatlAssgmtLastChangedByUsr = _LastChangedByUser.UserID
[0..1] I_Product _Product $projection.Material = _Product.Product
[0..1] I_Material _Material $projection.Material = _Material.Material and $projection.Plant = ''
[0..1] I_MaterialPlant _MaterialPlant $projection.Material = _MaterialPlant.Material and $projection.Plant = _MaterialPlant.Plant
[0..*] I_Specification _Specification $projection.SpecificationInternalID = _Specification.SpecificationInternalID
[0..1] I_ProductText _MaterialText $projection.Material = _MaterialText.Product and _MaterialText.Language = $session.system_language

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISPECMATASSGMT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view
EndUserText.label Specification Material Assignment view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY SpecMaterialAssgmtInternalID estmj recn
KEY SpecMaterialAssgmtChangeState estmj actn
SpecificationInternalID estmj recnroot
SpecMatlAssgmtValdtyStartDate estmj valfr
SpecMatlAssgmtValdtyEndDate estmj valto
SpecMaterialAssgmtChangeNumber estmj aennr
SpecMaterialAssgmtIsDeleted estmj delflg
SpecMaterialAssgmtCreationDate estmj crdat
SpecMaterialAssgmtCreatedByUsr estmj crnam
SpecMaterialAssgmtChangeDate estmj upddat
SpecMatlAssgmtLastChangedByUsr estmj updnam
Plant estmj werks
Material estmj matnr
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_Product _Product
_Material _Material
_MaterialPlant _MaterialPlant
_Specification _Specification
_MaterialText _MaterialText 
@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ESTMJ"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_MATERIALPLANT",
"I_PRODUCT",
"I_PRODUCTTEXT",
"I_SPECIFICATION",
"I_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More