R_MatlStkSubscrpnHeaderTP

DDL: R_MATLSTKSUBSCRPNHEADERTP Type: view_entity TRANSACTIONAL Package: ODATA_MM_IM_STOCKOUTPUT
21 Fields 1 Data Sources 3 Associations

Material Stock Subscription Root - TP

R_MatlStkSubscrpnHeaderTP is a Transactional CDS View that provides data about "Material Stock Subscription Root - TP" in SAP S/4HANA. It reads from 1 data source (I_MatlStkSubscrpn) and exposes 21 fields with key field MaterialStockSubscriptionUUID. It has 3 associations to related views. Part of development package ODATA_MM_IM_STOCKOUTPUT.

Data Sources (1)

SourceAliasJoin Type
I_MatlStkSubscrpn subscription from

Associations (3)

CardinalityTargetAliasCondition
[1..1] R_MatlStockReportProcedureTP _ProcedureDetails subscription.MaterialStockReportProcedUUID = _ProcedureDetails.MaterialStockReportProcedUUID
[0..1] I_User _CreatedByUser $projection.UserID = _CreatedByUser.UserID
[0..*] R_MatlStkSubscrpnItemTP _SubscriptionItem

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Material Stock Subscription Root - TP view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name MaterialStock view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY MaterialStockSubscriptionUUID MaterialStockSubscriptionUUID Collection Subs. Id
MaterialStockSubscriptionType MaterialStockSubscriptionType Subscription Type
MaterialStockReportProcedUUID MaterialStockReportProcedUUID Stock Reporting Procedure Id
MaterialStockReportProcedName _ProcedureDetails MaterialStockReportProcedName
MaterialStockRptProcedStatus _ProcedureDetails MaterialStockRptProcedStatus
MatlStkRptHasOnlyNewMovements _ProcedureDetails MatlStkRptHasOnlyNewMovements
MatlStkRptCollectionFrequency _ProcedureDetails MatlStkRptCollectionFrequency
MatlStkRptProcedColltAftDays _ProcedureDetails MatlStkRptProcedColltAftDays
MatlStkRptCollectionWeekDay _ProcedureDetails MatlStkRptCollectionWeekDay
MatlStkRptCollectionMonthDay _ProcedureDetails MatlStkRptCollectionMonthDay
MatlStkRptCollIsAtEndOfMonth _ProcedureDetails MatlStkRptCollIsAtEndOfMonth
_CollectionDayT _ProcedureDetails _CollectionDayT
_CollectionMonthT _ProcedureDetails _CollectionMonthT
_CollectionFreqT _ProcedureDetails _CollectionFreqT
_ProcedureStatusT _ProcedureDetails _ProcedureStatusT
UserID UserID User Name
_CreatedByUser _CreatedByUser
CreationDateTime CreationDateTime Timestamp
LocalLastChangedDateTime LocalLastChangedDateTime Time Stamp
_SubscriptionItem _SubscriptionItem
_ProcedureDetails _ProcedureDetails

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 R_MatlStkSubscrpnHeaderTP.
-- 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 R_MatlStkSubscrpnHeaderTP AS
SELECT
  MaterialStockSubscriptionUUID,
  MaterialStockSubscriptionType,
  MaterialStockReportProcedUUID,
  _ProcedureDetails.MaterialStockReportProcedName AS MaterialStockReportProcedName,
  _ProcedureDetails.MaterialStockRptProcedStatus AS MaterialStockRptProcedStatus,
  _ProcedureDetails.MatlStkRptHasOnlyNewMovements AS MatlStkRptHasOnlyNewMovements,
  _ProcedureDetails.MatlStkRptCollectionFrequency AS MatlStkRptCollectionFrequency,
  _ProcedureDetails.MatlStkRptProcedColltAftDays AS MatlStkRptProcedColltAftDays,
  _ProcedureDetails.MatlStkRptCollectionWeekDay AS MatlStkRptCollectionWeekDay,
  _ProcedureDetails.MatlStkRptCollectionMonthDay AS MatlStkRptCollectionMonthDay,
  _ProcedureDetails.MatlStkRptCollIsAtEndOfMonth AS MatlStkRptCollIsAtEndOfMonth,
  _ProcedureDetails._CollectionDayT AS _CollectionDayT,
  _ProcedureDetails._CollectionMonthT AS _CollectionMonthT,
  _ProcedureDetails._CollectionFreqT AS _CollectionFreqT,
  _ProcedureDetails._ProcedureStatusT AS _ProcedureStatusT,
  UserID,
  CreationDateTime,
  LocalLastChangedDateTime
FROM I_MatlStkSubscrpn AS subscription
LEFT OUTER JOIN R_MatlStockReportProcedureTP AS _ProcedureDetails ON subscription.MaterialStockReportProcedUUID = _ProcedureDetails.MaterialStockReportProcedUUID  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON UserID = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN R_MatlStkSubscrpnItemTP AS _SubscriptionItem ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More