C_RealTimeOrderCount

DDL: C_REALTIMEORDERCOUNT SQL: CEBORDRTCNT Type: view CONSUMPTION
7 Fields 4 Data Sources

Event Based Order Real Time KPI Count

C_RealTimeOrderCount is a Consumption CDS View that provides data about "Event Based Order Real Time KPI Count" in SAP S/4HANA. It reads from 4 data sources (I_UserSettingsForCompanyCode, I_UserSetGetParamForCtrlgArea, P_CoEvtBsdOrderKeyStatus, I_ProductCostCtrlgOrder) and exposes 7 fields with key field OrderID.

Data Sources (4)

SourceAliasJoin Type
I_UserSettingsForCompanyCode _CompCodeDefault left_outer
I_UserSetGetParamForCtrlgArea _CtrlAreaDefault inner
P_CoEvtBsdOrderKeyStatus _Status inner
I_ProductCostCtrlgOrder EvtBsdOrder from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CEBORDRTCNT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
EndUserText.label Event Based Order Real Time KPI Count view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY OrderID I_ProductCostCtrlgOrder OrderID Order ID
ControllingArea I_ProductCostCtrlgOrder ControllingArea Controlling Area
CompanyCode I_ProductCostCtrlgOrder CompanyCode Receiver Company Code
OrderCategory OrderCategory Order Category
OrderType OrderType Order Type
Plant Plant Valuation Area
ControllingObjectStatus

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_RealTimeOrderCount.
-- 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: CEBORDRTCNT

CREATE VIEW C_RealTimeOrderCount AS
SELECT
  EvtBsdOrder.OrderID AS OrderID,
  EvtBsdOrder.ControllingArea AS ControllingArea,
  EvtBsdOrder.CompanyCode AS CompanyCode,
  OrderCategory,
  OrderType,
  Plant,
  cast( _Status.ControllingObjectStatus as fco_order_status) AS ControllingObjectStatus
FROM I_ProductCostCtrlgOrder AS EvtBsdOrder
INNER JOIN P_CoEvtBsdOrderKeyStatus AS _Status ON /* join condition not captured in parsed metadata */
INNER JOIN I_UserSetGetParamForCtrlgArea AS _CtrlAreaDefault ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UserSettingsForCompanyCode AS _CompCodeDefault ON /* join condition not captured in parsed metadata */
;

Learn More