C_MatlStockReportOverview

DDL: C_MATLSTOCKREPORTOVERVIEW Type: view_entity CONSUMPTION
24 Fields 1 Data Sources 1 Associations

Stock Reporting

C_MatlStockReportOverview is a Consumption CDS View that provides data about "Stock Reporting" in SAP S/4HANA. It reads from 1 data source (R_MatlStockReportOverview) and exposes 24 fields with key field MaterialStockReportUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_MatlStockReportOverview R_MatlStockReportOverview projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_MatlStockDocumentItemSet _MatDocSet $projection.MaterialStockDocumentItemSetID = _MatDocSet.MaterialStockDocumentItemSetID

Annotations (7)

NameValueLevelField
EndUserText.label Stock Reporting view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY MaterialStockReportUUID MaterialStockReportUUID
MaterialStockReportNumber MaterialStockReportNumber
MaterialStockReportYear MaterialStockReportYear
MaterialStockSubscriptionUUID MaterialStockSubscriptionUUID Collection Subs. Id
MaterialStockDocumentItemSetID MaterialStockDocumentItemSetID
EmptyMatlStkReportsAreSent EmptyMatlStkReportsAreSent Send Empty Reports
UserID UserID User Name
CreationDateTime CreationDateTime Timestamp
FirstGoodsMovementPostingDate FirstGoodsMovementPostingDate Period Start
LastGoodsMovementPostingDate LastGoodsMovementPostingDate Period End
MaterialStockReportStep MaterialStockReportStep
MaterialStockReportStepStatus MaterialStockReportStepStatus
MatlStockReportStepMessageText MatlStockReportStepMessageText
Criticality Criticality Status Rating
Supplier Supplier Supplier
CompanyCode CompanyCode Receiver Company Code
Plant Plant Valuation Area
MatlStockSubscriptionNumber _Subscription MatlStockSubscriptionNumber Subscription Nr
MaterialStockSubscriptionItem MaterialStockSubscriptionItem Stock Reporting Subscription Id Item
MatlStkSubscrpnItemIteration MatlStkSubscrpnItemIteration
_MatDocSet _MatDocSet
_SubscriptionHeader _SubscriptionHeader
MaterialStockReportProcedName
MatlStkRptCollectionFrequency

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 C_MatlStockReportOverview.
-- 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 C_MatlStockReportOverview AS
SELECT
  MaterialStockReportUUID,
  MaterialStockReportNumber,
  MaterialStockReportYear,
  MaterialStockSubscriptionUUID,
  MaterialStockDocumentItemSetID,
  EmptyMatlStkReportsAreSent,
  UserID,
  CreationDateTime,
  FirstGoodsMovementPostingDate,
  LastGoodsMovementPostingDate,
  MaterialStockReportStep,
  MaterialStockReportStepStatus,
  MatlStockReportStepMessageText,
  Criticality,
  Supplier,
  CompanyCode,
  Plant,
  _Subscription.MatlStockSubscriptionNumber AS MatlStockSubscriptionNumber,
  MaterialStockSubscriptionItem,
  MatlStkSubscrpnItemIteration,
  _SubscriptionHeader._ProcedureDetails.MaterialStockReportProcedName AS MaterialStockReportProcedName,
  _SubscriptionHeader._ProcedureDetails.MatlStkRptCollectionFrequency AS MatlStkRptCollectionFrequency
FROM R_MatlStockReportOverview
LEFT OUTER JOIN C_MatlStockDocumentItemSet AS _MatDocSet ON MaterialStockDocumentItemSetID = _MatDocSet.MaterialStockDocumentItemSetID  -- association [0..*]
;

Learn More