P_RealTimeMfgOrderToBePostKPI1

DDL: P_REALTIMEMFGORDERTOBEPOSTKPI1 SQL: PRTMOTBPKPI1 Type: view COMPOSITE
29 Fields 2 Data Sources

P_RealTimeMfgOrderToBePostKPI1 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_LedgerCompanyCodeCrcyRoles, P_RealTimeMfgOrder) and exposes 29 fields with key fields Ledger, OrderID.

Data Sources (2)

SourceAliasJoin Type
I_LedgerCompanyCodeCrcyRoles _CrcyRoles inner
P_RealTimeMfgOrder P_RealTimeMfgOrder from

Parameters (2)

NameTypeDefault
P_FiscalPeriodStartDate budat
P_FiscalPeriodEndDate budat

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PRTMOTBPKPI1 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AbapCatalog.preserveKey true view

Fields (29)

KeyFieldSource TableSource FieldDescription
LedgerName
ProfitCenter ProfitCenter Profit Center
ResultsAnalysisKey ResultsAnalysisKey
LogHandle LogHandle LogsHandle
CompanyCodeCurrency
GlobalCurrency
FreeDefinedCurrency1
FreeDefinedCurrency2
FreeDefinedCurrency3
FreeDefinedCurrency4
FreeDefinedCurrency5
FreeDefinedCurrency6
FreeDefinedCurrency7
FreeDefinedCurrency8
KEY Ledger _Ledger Ledger Ledger
KEY OrderID _Ord OrderID Order ID
OrderDescription _Ord OrderDescription
ControllingObject _Ord ControllingObject Object number
OrderType _Ord OrderType Order Type
OrderCategory _Ord OrderCategory Order Category
ControllingArea _Ord ControllingArea Controlling Area
CompanyCode _Ord CompanyCode Receiver Company Code
Material _Ord Material Vehicle Model
Plant _Ord Plant Valuation Area
StatusCode _Ord StatusCode Statuscode
SimulationStatus _OrderLog SimulationStatus
LogNumber _OrderLog LogNumber UUID
LogMessageText _OrderLog LogMessageText
EventBasedProdnCostWlLogType _OrderLog EventBasedProdnCostWlLogType

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_RealTimeMfgOrderToBePostKPI1.
-- 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: PRTMOTBPKPI1
-- Parameters: P_FiscalPeriodStartDate : budat, P_FiscalPeriodEndDate : budat

CREATE VIEW P_RealTimeMfgOrderToBePostKPI1 AS
SELECT
  _Ledger._Text[1: Language = $session.system_language].LedgerName AS LedgerName,
  ProfitCenter,
  ResultsAnalysisKey,
  LogHandle,
  _CrcyRoles._CoCodeCurrencyRoleCurrency.Currency AS CompanyCodeCurrency,
  _CrcyRoles._GlobalCurrencyRoleCurrency.Currency AS GlobalCurrency,
  _CrcyRoles._FreeDfndCrcyRole1Currency.Currency AS FreeDefinedCurrency1,
  _CrcyRoles._FreeDfndCrcyRole2Currency.Currency AS FreeDefinedCurrency2,
  _CrcyRoles._FreeDfndCrcyRole3Currency.Currency AS FreeDefinedCurrency3,
  _CrcyRoles._FreeDfndCrcyRole4Currency.Currency AS FreeDefinedCurrency4,
  _CrcyRoles._FreeDfndCrcyRole5Currency.Currency AS FreeDefinedCurrency5,
  _CrcyRoles._FreeDfndCrcyRole6Currency.Currency AS FreeDefinedCurrency6,
  _CrcyRoles._FreeDfndCrcyRole7Currency.Currency AS FreeDefinedCurrency7,
  _CrcyRoles._FreeDfndCrcyRole8Currency.Currency AS FreeDefinedCurrency8,
  _Ledger.Ledger AS Ledger,
  _Ord.OrderID AS OrderID,
  _Ord.OrderDescription AS OrderDescription,
  _Ord.ControllingObject AS ControllingObject,
  _Ord.OrderType AS OrderType,
  _Ord.OrderCategory AS OrderCategory,
  _Ord.ControllingArea AS ControllingArea,
  _Ord.CompanyCode AS CompanyCode,
  _Ord.Material AS Material,
  _Ord.Plant AS Plant,
  _Ord.StatusCode AS StatusCode,
  _OrderLog.SimulationStatus AS SimulationStatus,
  _OrderLog.LogNumber AS LogNumber,
  _OrderLog.LogMessageText AS LogMessageText,
  _OrderLog.EventBasedProdnCostWlLogType AS EventBasedProdnCostWlLogType
FROM P_RealTimeMfgOrder
INNER JOIN I_LedgerCompanyCodeCrcyRoles AS _CrcyRoles ON /* join condition not captured in parsed metadata */
;

Learn More