I_MATLSTKSUBSCRPNCONSIGNMENT

CDS View

Material Stock Subscription Consignment

I_MATLSTKSUBSCRPNCONSIGNMENT is a CDS View in S/4HANA. Material Stock Subscription Consignment. It contains 3 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 3 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_MatlStkCsgnmtDocumentItem view_entity inner COMPOSITE
P_MatlStkCsgnmtStockQuantity view_entity inner COMPOSITE
P_MatlStkRepProcUseInSubs view_entity from COMPOSITE
R_MatlStkSubscrpnItemTP view_entity from TRANSACTIONAL Stock Reporting Subscription Item

Fields (3)

KeyField CDS FieldsUsed in Views
KEY MaterialStockReportProcedUUID MaterialStockReportProcedUUID 1
MaterialStockSubscriptionItem MaterialStockSubscriptionItem 2
MaterialStockSubscriptionUUID MaterialStockSubscriptionUUID 2 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Material Stock Subscription Consignment'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM:{
  viewType: #BASIC,
  private:false
}
define view entity I_MatlStkSubscrpnConsignment
  as select from matstksubscsgn

  association [1..1] to I_MatlStkSubscrpn as _Subscription on $projection.MaterialStockSubscriptionUUID = _Subscription.MaterialStockSubscriptionUUID
  association [1..1] to I_Plant           as _Plant        on $projection.Plant = _Plant.Plant
  association [1..1] to I_Supplier        as _Supplier     on $projection.Supplier = _Supplier.Supplier
  association [1..1] to I_CompanyCode     as _CompanyCode     on $projection.CompanyCode = _CompanyCode.CompanyCode
  
{
  key subscriptionid                                         as MaterialStockSubscriptionUUID,
  key subscriptionitem                                       as MaterialStockSubscriptionItem,
      matlstocksubscriptionnumber                            as MatlStockSubscriptionNumber,
      ismarkedfordeletion                                    as IsMarkedForDeletion,      
      _Subscription.MaterialStockSubscriptionType            as MaterialStockSubscriptionType,
      _Subscription.MaterialStockReportProcedUUID            as MaterialStockReportProcedUUID,
      companycode                                            as CompanyCode,
      plant                                                  as Plant,
      supplier                                               as Supplier,
      emptymatlstkreportsaresent                             as EmptyMatlStkReportsAreSent,
      //      groupingcategory                                 as GroupingCategory,

      onboardingdate                                         as MatlStkRptOnboardingDate,
      offboardingdate                                        as MatlStkRptOffBoardingDate,

      _Subscription._Procedure.MaterialStockRptProcedStatus  as MaterialStockRptProcedStatus,
      _Subscription._Procedure.MatlStkRptHasOnlyNewMovements as MatlStkRptHasOnlyNewMovements,
      _Subscription._Procedure.MatlStkRptCollectionFrequency as MatlStkRptCollectionFrequency,
      _Subscription._Procedure.MatlStkRptProcedColltAftDays  as MatlStkRptProcedColltAftDays,
      _Subscription._Procedure.MatlStkRptCollectionWeekDay   as MatlStkRptCollectionWeekDay,
      _Subscription._Procedure.MatlStkRptCollectionMonthDay  as MatlStkRptCollectionMonthDay,
      _Subscription._Procedure.MatlStkRptCollIsAtEndOfMonth  as MatlStkRptCollIsAtEndOfMonth,
      
//      _Subscription.CreationDateTime                         as CreationDateTime,

//      _Subscription.LocalLastChangedDateTime                 as LocalLastChangedDateTime,


      created_by as UserID,
      created_at                       as CreationDateTime,
      locallastchangedat                 as LocalLastChangedDateTime,



      // associations

      _Subscription._Procedure                               as _Procedure,
      _Plant,
      _Supplier,
      _CompanyCode
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATLSTKREPORTINGPROCEDURE",
"I_MATLSTKSUBSCRPN",
"MATSTKSUBSCSGN"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_MATLSTKREPORTINGPROCEDURE",
"I_PLANT",
"I_SUPPLIER"
],
"BASE":
[
"I_MATLSTKSUBSCRPN"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More