I_MatlAvgDailyUsge1

DDL: I_MATLAVGDAILYUSGE1 SQL: IMATADU1 Type: view COMPOSITE Package: PPH_DD_VDM_STLM
15 Fields 3 Data Sources

Material Average Daily Usage

I_MatlAvgDailyUsge1 is a Composite CDS View that provides data about "Material Average Daily Usage" in SAP S/4HANA. It reads from 3 data sources (I_DDAvgDailyUsgeMvtTypeConfig, I_GoodsMovementDocument, P_MRPAreaStorLocSubContractor) and exposes 15 fields with key fields Material, Plant, MRPAreaendasMRPArea, MaterialDocumentYear, MaterialDocument. Part of development package PPH_DD_VDM_STLM.

Data Sources (3)

SourceAliasJoin Type
I_DDAvgDailyUsgeMvtTypeConfig _ADUMvtTypeConfig left_outer
I_GoodsMovementDocument _GoodsMovementDoc from
P_MRPAreaStorLocSubContractor _MRPAreaProd left_outer

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IMATADU1 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Material Average Daily Usage view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY Material I_GoodsMovementDocument Material Vehicle Model
KEY Plant I_GoodsMovementDocument Plant Valuation Area
KEY MRPAreaendasMRPArea
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
KEY MaterialDocumentRecordType MaterialDocumentRecordType
Supplier P_MRPAreaStorLocSubContractor MPRAreaSubcontractor
PostingDate PostingDate Posting Date for GR
IsEffectiveGoodsMovement I_GoodsMovementDocument IsEffectiveGoodsMovement
IsReversalMovementType I_GoodsMovementDocument IsReversalMovementType
MaterialBaseUnit MaterialBaseUnit Valuation Unit
StorageLocation P_MRPAreaStorLocSubContractor MRPAreaStorageLocation
GoodsMovementType GoodsMovementType Movement Type
Customer I_GoodsMovementDocument Customer Sold-to Party

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_MatlAvgDailyUsge1.
-- 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.
-- SQL view name: IMATADU1

CREATE VIEW I_MatlAvgDailyUsge1 AS
SELECT
  _GoodsMovementDoc.Material AS Material,
  _GoodsMovementDoc.Plant AS Plant,
  case when _MRPAreaProd.MRPArea is null then _GoodsMovementDoc.Plant else _MRPAreaProd.MRPArea end as MRPArea AS MRPAreaendasMRPArea,
  MaterialDocumentYear,
  MaterialDocument,
  MaterialDocumentItem,
  MaterialDocumentRecordType,
  _MRPAreaProd.MPRAreaSubcontractor AS Supplier,
  PostingDate,
  _GoodsMovementDoc.IsEffectiveGoodsMovement AS IsEffectiveGoodsMovement,
  _GoodsMovementDoc.IsReversalMovementType AS IsReversalMovementType,
  MaterialBaseUnit,
  _MRPAreaProd.MRPAreaStorageLocation AS StorageLocation,
  GoodsMovementType,
  _GoodsMovementDoc.Customer AS Customer
FROM I_GoodsMovementDocument AS _GoodsMovementDoc
LEFT OUTER JOIN P_MRPAreaStorLocSubContractor AS _MRPAreaProd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DDAvgDailyUsgeMvtTypeConfig AS _ADUMvtTypeConfig ON /* join condition not captured in parsed metadata */
;

Learn More