P_RTPC_REM_OrderToBePostedKPI

DDL: P_RTPC_REM_ORDERTOBEPOSTEDKPI SQL: PRTPCREMOTBPK Type: view COMPOSITE
34 Fields 1 Data Sources

P_RTPC_REM_OrderToBePostedKPI is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_RTPC_REM_Order) and exposes 34 fields with key fields OrderID, Ledger.

Data Sources (1)

SourceAliasJoin Type
P_RTPC_REM_Order _Order from

Parameters (2)

NameTypeDefault
P_FiscalPeriodStartDate budat
P_FiscalPeriodEndDate budat

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PRTPCREMOTBPK 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 #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY OrderID P_RTPC_REM_Order OrderID Order ID
KEY Ledger _Doc Ledger Ledger
OrderDescription P_RTPC_REM_Order OrderDescription
ControllingObject P_RTPC_REM_Order ControllingObject Object number
ControllingArea P_RTPC_REM_Order ControllingArea Controlling Area
CompanyCode P_RTPC_REM_Order CompanyCode Receiver Company Code
OrderType P_RTPC_REM_Order OrderType Order Type
Material P_RTPC_REM_Order Material Vehicle Model
Plant P_RTPC_REM_Order Plant Valuation Area
OrderCategory P_RTPC_REM_Order OrderCategory Order Category
ProfitCenter P_RTPC_REM_Order ProfitCenter Profit Center
StatusCode
ProductionVersion P_RTPC_REM_Order ProductionVersion Version ID
OrderSettlementTriggerType P_RTPC_REM_Order OrderSettlementTriggerType
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
AmountInGlobalCurrency AmountInGlobalCurrency Amount in Global Currency
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
CompanyCodeCurrency CompanyCodeCurrency Local Currency
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
FreeDefinedCurrency1 FreeDefinedCurrency1 Freely Defined Currency 1
FreeDefinedCurrency2 FreeDefinedCurrency2 Freely Defined Currency 2
FreeDefinedCurrency3 FreeDefinedCurrency3 Freely Defined Currency 3
FreeDefinedCurrency4 FreeDefinedCurrency4 Freely Defined Currency 4
FreeDefinedCurrency5 FreeDefinedCurrency5 Freely Defined Currency 5
FreeDefinedCurrency6 FreeDefinedCurrency6 Freely Defined Currency 6
FreeDefinedCurrency7 FreeDefinedCurrency7 Freely Defined Currency 7
FreeDefinedCurrency8 FreeDefinedCurrency8 Freely Defined Currency 8

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_RTPC_REM_OrderToBePostedKPI.
-- 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: PRTPCREMOTBPK
-- Parameters: P_FiscalPeriodStartDate : budat, P_FiscalPeriodEndDate : budat

CREATE VIEW P_RTPC_REM_OrderToBePostedKPI AS
SELECT
  _Order.OrderID AS OrderID,
  _Doc.Ledger AS Ledger,
  _Order.OrderDescription AS OrderDescription,
  _Order.ControllingObject AS ControllingObject,
  _Order.ControllingArea AS ControllingArea,
  _Order.CompanyCode AS CompanyCode,
  _Order.OrderType AS OrderType,
  _Order.Material AS Material,
  _Order.Plant AS Plant,
  _Order.OrderCategory AS OrderCategory,
  _Order.ProfitCenter AS ProfitCenter,
  'I0002' AS StatusCode,
  _Order.ProductionVersion AS ProductionVersion,
  _Order.OrderSettlementTriggerType AS OrderSettlementTriggerType,
  AmountInCompanyCodeCurrency,
  AmountInGlobalCurrency,
  AmountInFreeDefinedCurrency1,
  AmountInFreeDefinedCurrency2,
  AmountInFreeDefinedCurrency3,
  AmountInFreeDefinedCurrency4,
  AmountInFreeDefinedCurrency5,
  AmountInFreeDefinedCurrency6,
  AmountInFreeDefinedCurrency7,
  AmountInFreeDefinedCurrency8,
  CompanyCodeCurrency,
  GlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8
FROM P_RTPC_REM_Order AS _Order
;

Learn More