P_EventBasedTotalVariance

DDL: P_EVENTBASEDTOTALVARIANCE Type: view_entity COMPOSITE Package: ODATA_EBW_ORDER_INSPECTOR
5 Fields 1 Data Sources

Event based total variance

P_EventBasedTotalVariance is a Composite CDS View that provides data about "Event based total variance" in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItemRawData) and exposes 5 fields with key fields SourceLedger, ControllingObject. Part of development package ODATA_EBW_ORDER_INSPECTOR.

Data Sources (1)

SourceAliasJoin Type
I_GLAccountLineItemRawData totalVariance from

Parameters (1)

NameTypeDefault
P_FiscalPeriodEndDate budat

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Event based total variance view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger I_GLAccountLineItemRawData SourceLedger Source Ledger
KEY ControllingObject I_GLAccountLineItemRawData ControllingObject Object number
CompanyCode I_GLAccountLineItemRawData CompanyCode Receiver Company Code
OrderID I_GLAccountLineItemRawData OrderID Order ID
OrderItem I_GLAccountLineItemRawData OrderItem Order item no.

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 P_EventBasedTotalVariance.
-- 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_FiscalPeriodEndDate : budat

CREATE VIEW P_EventBasedTotalVariance AS
SELECT
  totalVariance.SourceLedger AS SourceLedger,
  totalVariance.ControllingObject AS ControllingObject,
  totalVariance.CompanyCode AS CompanyCode,
  totalVariance.OrderID AS OrderID,
  totalVariance.OrderItem AS OrderItem
FROM I_GLAccountLineItemRawData AS totalVariance
;

Learn More