I_MatlStkSubscrpnConsignment

DDL: I_MATLSTKSUBSCRPNCONSIGNMENT Type: view_entity BASIC Package: ODATA_MM_IM_STOCKOUTPUT
25 Fields 1 Data Sources 4 Associations

Material Stock Subscription Consignment

I_MatlStkSubscrpnConsignment is a Basic CDS View that provides data about "Material Stock Subscription Consignment" in SAP S/4HANA. It reads from 1 data source (matstksubscsgn) and exposes 25 fields with key fields MaterialStockSubscriptionUUID, MaterialStockSubscriptionItem. It has 4 associations to related views. Part of development package ODATA_MM_IM_STOCKOUTPUT.

Data Sources (1)

SourceAliasJoin Type
matstksubscsgn matstksubscsgn from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_MatlStkSubscrpn _Subscription $projection.MaterialStockSubscriptionUUID = _Subscription.MaterialStockSubscriptionUUID
[1..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[1..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Material Stock Subscription Consignment view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
VDM.private false view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY MaterialStockSubscriptionUUID subscriptionid Collection Subs. Id
KEY MaterialStockSubscriptionItem subscriptionitem Stock Reporting Subscription Id Item
MatlStockSubscriptionNumber matlstocksubscriptionnumber Subscription Nr
IsMarkedForDeletion ismarkedfordeletion Purch.org. data
MaterialStockSubscriptionType _Subscription MaterialStockSubscriptionType
MaterialStockReportProcedUUID _Subscription MaterialStockReportProcedUUID
CompanyCode companycode Receiver Company Code
Plant plant Valuation Area
Supplier supplier Supplier
EmptyMatlStkReportsAreSent emptymatlstkreportsaresent Send Empty Reports
MatlStkRptOnboardingDate onboardingdate Onboarding Date
MatlStkRptOffBoardingDate offboardingdate Offboarding Date
MaterialStockRptProcedStatus
MatlStkRptHasOnlyNewMovements
MatlStkRptCollectionFrequency
MatlStkRptProcedColltAftDays
MatlStkRptCollectionWeekDay
MatlStkRptCollectionMonthDay
MatlStkRptCollIsAtEndOfMonth
CreationDateTime _Subscription CreationDateTime Timestamp
LocalLastChangedDateTime _Subscription LocalLastChangedDateTime Time Stamp
_Procedure _Subscription _Procedure
_Plant _Plant
_Supplier _Supplier
_CompanyCode _CompanyCode

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_MatlStkSubscrpnConsignment.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_MatlStkSubscrpnConsignment AS
SELECT
  subscriptionid AS MaterialStockSubscriptionUUID,
  subscriptionitem AS MaterialStockSubscriptionItem,
  MatlStockSubscriptionNumber,
  IsMarkedForDeletion,
  _Subscription.MaterialStockSubscriptionType AS MaterialStockSubscriptionType,
  _Subscription.MaterialStockReportProcedUUID AS MaterialStockReportProcedUUID,
  CompanyCode,
  Plant,
  Supplier,
  EmptyMatlStkReportsAreSent,
  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,
  _Subscription._Procedure AS _Procedure
FROM matstksubscsgn
LEFT OUTER JOIN I_MatlStkSubscrpn AS _Subscription ON MaterialStockSubscriptionUUID = _Subscription.MaterialStockSubscriptionUUID  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
;

Learn More