I_MatlStockReportConsignment

DDL: I_MATLSTOCKREPORTCONSIGNMENT Type: view_entity BASIC
16 Fields 1 Data Sources 1 Associations

Material Stock Report Consignment

I_MatlStockReportConsignment is a Basic CDS View that provides data about "Material Stock Report Consignment" in SAP S/4HANA. It reads from 1 data source (matstkreportcsgn) and exposes 16 fields with key fields MaterialStockReportUUID, MaterialStockSubscriptionItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
matstkreportcsgn matstkreportcsgn from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MaterialStockReport _Report $projection.MaterialStockReportUUID = _Report.MaterialStockReportUUID

Annotations (8)

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

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY MaterialStockReportUUID stockreport_id Stock Report ID
KEY MaterialStockSubscriptionItem subscriptionitem Stock Reporting Subscription Id Item
MaterialStockReportNumber _Report MaterialStockReportNumber
MaterialStockReportYear _Report MaterialStockReportYear
MaterialStockSubscriptionUUID _Report MaterialStockSubscriptionUUID Collection Subs. Id
MaterialStockDocumentItemSetID _Report MaterialStockDocumentItemSetID
MaterialStockQuantitySetID _Report MaterialStockQuantitySetID
CreationDateTime _Report CreationDateTime Timestamp
clientNULLasMaterialStockReportDate
clientNULLasMaterialStockReportTime
clientNULLasMatlStockReportAnalysisDate Time Stamp
clientNULLasMatlStockReportAnalysisTime Time Stamp
FirstGoodsMovementPostingDate firstgoodsmovementpostingdate Period Start
LastGoodsMovementPostingDate lastgoodsmovementpostingdate Period End
StorageLocation group_stoloc Location
Material group_mat Material

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_MatlStockReportConsignment.
-- 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_MatlStockReportConsignment AS
SELECT
  stockreport_id AS MaterialStockReportUUID,
  subscriptionitem AS MaterialStockSubscriptionItem,
  _Report.MaterialStockReportNumber AS MaterialStockReportNumber,
  _Report.MaterialStockReportYear AS MaterialStockReportYear,
  _Report.MaterialStockSubscriptionUUID AS MaterialStockSubscriptionUUID,
  _Report.MaterialStockDocumentItemSetID AS MaterialStockDocumentItemSetID,
  _Report.MaterialStockQuantitySetID AS MaterialStockQuantitySetID,
  _Report.CreationDateTime AS CreationDateTime,
  tstmp_to_dats( cast( _Report.CreationDateTime as abap.dec(15,0) ), abap_system_timezone( $session.client,'NULL' ), $session.client,'NULL' ) as MaterialStockReportDate AS clientNULLasMaterialStockReportDate,
  tstmp_to_tims( cast( _Report.CreationDateTime as abap.dec(15,0) ), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as MaterialStockReportTime AS clientNULLasMaterialStockReportTime,
  tstmp_to_dats( cast( collection_ts as abap.dec(15,0) ), abap_system_timezone( $session.client,'NULL' ), $session.client,'NULL' ) as MatlStockReportAnalysisDate AS clientNULLasMatlStockReportAnalysisDate,
  tstmp_to_tims( cast( collection_ts as abap.dec(15,0) ), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as MatlStockReportAnalysisTime AS clientNULLasMatlStockReportAnalysisTime,
  FirstGoodsMovementPostingDate,
  LastGoodsMovementPostingDate,
  group_stoloc AS StorageLocation,
  group_mat AS Material
FROM matstkreportcsgn
LEFT OUTER JOIN I_MaterialStockReport AS _Report ON MaterialStockReportUUID = _Report.MaterialStockReportUUID  -- association [0..1]
;

Learn More