C_MlBalanceSummary

DDL: C_MLBALANCESUMMARY Type: view CONSUMPTION
30 Fields 1 Data Sources

Material Inventory Values - Balance Summary

C_MlBalanceSummary is a Consumption CDS View that provides data about "Material Inventory Values - Balance Summary" in SAP S/4HANA. It reads from 1 data source (I_ML_Balance) and exposes 30 fields.

Data Sources (1)

SourceAliasJoin Type
I_ML_Balance I_ML_Balance from

Parameters (3)

NameTypeDefault
P_KeyDate fis_reporting_key_date
hidden true
P_CalendarDate calendardate

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CMLBALSUM view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
Analytics.query true view
Analytics.settings.maxProcessingEffort #HIGH view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #CONSUMPTION view
EndUserText.label Material Inventory Values - Balance Summary view

Fields (30)

KeyFieldSource TableSource FieldDescription
hiddentrue
P_CalendarDateCompanyCode
Ledger Ledger Ledger
GLAccount GLAccount General Ledger
MaterialGroup MaterialGroup Product Group
ProfitCenter ProfitCenter Profit Center
Segment Segment Segment number
ChartOfAccounts ChartOfAccounts Node Class
Material Material Vehicle Model
InventoryValuationType InventoryValuationType Valuation Type
ValuationArea ValuationArea Valuation Area
MaterialValuationClass MaterialValuationClass Valuation Class
InventoryValuationCategory InventoryValuationCategory
Plant Plant Valuation Area
ProductHierarchy ProductHierarchy Prod.hierarchy
InventoryQty InventoryQty
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
SlsPriceAmountInCoCodeCrcy SlsPriceAmountInCoCodeCrcy Sales Price Book Value
AmountInGroupCurrency AmountInGroupCurrency Amnt in GrpCrcy
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
PostingDate PostingDate Posting Date for GR
BaseUnit BaseUnit Unit of Measure
_ProductHierarchy _ProductHierarchy

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_MlBalanceSummary.
-- 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.
-- Parameters: P_KeyDate : fis_reporting_key_date, hidden : true, P_CalendarDate : calendardate

CREATE VIEW C_MlBalanceSummary AS
SELECT
  hidden: true AS hiddentrue,
  derivation: { lookupEntity: 'I_CalendarDate', resultElement: 'CalendarDate', binding: [ { targetElement : 'CalendarDate', type : #PARAMETER, value : 'P_KeyDate' AS P_CalendarDateCompanyCode,
  Ledger,
  GLAccount,
  MaterialGroup,
  ProfitCenter,
  Segment,
  ChartOfAccounts,
  Material,
  InventoryValuationType,
  ValuationArea,
  MaterialValuationClass,
  InventoryValuationCategory,
  Plant,
  ProductHierarchy,
  InventoryQty,
  AmountInCompanyCodeCurrency,
  SlsPriceAmountInCoCodeCrcy,
  AmountInGroupCurrency,
  AmountInFreeDefinedCurrency1,
  AmountInFreeDefinedCurrency2,
  AmountInFreeDefinedCurrency3,
  AmountInFreeDefinedCurrency4,
  AmountInFreeDefinedCurrency5,
  AmountInFreeDefinedCurrency6,
  AmountInFreeDefinedCurrency7,
  AmountInFreeDefinedCurrency8,
  PostingDate,
  BaseUnit
FROM I_ML_Balance
;

Learn More