P_EvtBsdOrdSubReserves

DDL: P_EVTBSDORDSUBRESERVES SQL: PEBORDSUBRSRV Type: view COMPOSITE
11 Fields 1 Data Sources

P_EvtBsdOrdSubReserves is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_JournalEntryItem) and exposes 11 fields with key field OrderID.

Data Sources (1)

SourceAliasJoin Type
I_JournalEntryItem _item from

Parameters (2)

NameTypeDefault
P_ToFiscalYearPeriod fins_fyearperiod
P_ReferenceDocumentType awtyp

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PEBORDSUBRSRV 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

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY OrderID OrderID Order ID
AmountInCompanyCodeCurrency
AmountInGlobalCurrency
AmountInFreeDefinedCurrency1
AmountInFreeDefinedCurrency2
AmountInFreeDefinedCurrency3
AmountInFreeDefinedCurrency4
AmountInFreeDefinedCurrency5
AmountInFreeDefinedCurrency6
AmountInFreeDefinedCurrency7
AmountInFreeDefinedCurrency8

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_EvtBsdOrdSubReserves.
-- 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: PEBORDSUBRSRV
-- Parameters: P_ToFiscalYearPeriod : fins_fyearperiod, P_ReferenceDocumentType : awtyp

CREATE VIEW P_EvtBsdOrdSubReserves AS
SELECT
  OrderID,
  sum(AmountInCompanyCodeCurrency) AS AmountInCompanyCodeCurrency,
  sum(AmountInGlobalCurrency) AS AmountInGlobalCurrency,
  sum(AmountInFreeDefinedCurrency1) AS AmountInFreeDefinedCurrency1,
  sum(AmountInFreeDefinedCurrency2) AS AmountInFreeDefinedCurrency2,
  sum(AmountInFreeDefinedCurrency3) AS AmountInFreeDefinedCurrency3,
  sum(AmountInFreeDefinedCurrency4) AS AmountInFreeDefinedCurrency4,
  sum(AmountInFreeDefinedCurrency5) AS AmountInFreeDefinedCurrency5,
  sum(AmountInFreeDefinedCurrency6) AS AmountInFreeDefinedCurrency6,
  sum(AmountInFreeDefinedCurrency7) AS AmountInFreeDefinedCurrency7,
  sum(AmountInFreeDefinedCurrency8) AS AmountInFreeDefinedCurrency8
FROM I_JournalEntryItem AS _item
;

Learn More