P_EBWIP_OrderCost1

DDL: P_EBWIP_ORDERCOST1 SQL: PEBWIPORDCST1 Type: view COMPOSITE Package: ODATA_CO_RT_WIP_REPORTING
3 Fields 1 Data Sources

Event-Based Work In Process Order Cost layer 1

P_EBWIP_OrderCost1 is a Composite CDS View that provides data about "Event-Based Work In Process Order Cost layer 1" in SAP S/4HANA. It reads from 1 data source (P_EBWIP_Order) and exposes 3 fields with key fields CompanyCode, OrderID. Part of development package ODATA_CO_RT_WIP_REPORTING.

Data Sources (1)

SourceAliasJoin Type
P_EBWIP_Order P_EBWIP_Order from

Parameters (3)

NameTypeDefault
P_KeyDate fins_fperiod_enddate
P_Ledger fins_ledger
P_CurrencyRole fac_crcyrole

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PEBWIPORDCST1 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode _OrderHeader CompanyCode Receiver Company Code
KEY OrderID _OrderHeader OrderID Order ID
Material Material Vehicle Model

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_EBWIP_OrderCost1.
-- 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: PEBWIPORDCST1
-- Parameters: P_KeyDate : fins_fperiod_enddate, P_Ledger : fins_ledger, P_CurrencyRole : fac_crcyrole

CREATE VIEW P_EBWIP_OrderCost1 AS
SELECT
  _OrderHeader.CompanyCode AS CompanyCode,
  _OrderHeader.OrderID AS OrderID,
  Material
FROM P_EBWIP_Order
;

Learn More