P_EBPC_WIP_30_1

DDL: P_EBPC_WIP_30_1 Type: view_entity COMPOSITE Package: ODATA_CO_RT_PRODUCTION_COSTS

Event-Based Order WIP

P_EBPC_WIP_30_1 is a Composite CDS View that provides data about "Event-Based Order WIP" in SAP S/4HANA. It reads from 1 data source (I_JournalEntryItem) and exposes 6 fields with key fields CompanyCode, OrderID, OrderItem, SubLedgerAcctLineItemType. Part of development package ODATA_CO_RT_PRODUCTION_COSTS.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_JournalEntryItem I_JournalEntryItem from

Parameters (3)

NameTypeDefault
P_Ledger fins_ledger
P_FromFiscalYearPeriod fins_fyearperiod
P_ToFiscalYearPeriod fins_fyearperiod

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY OrderID OrderID
KEY OrderItem OrderItem
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType
DisplayCurrency GlobalCurrency
AmountInDisplayCurrency 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

@VDM.private: true
@VDM.viewType: #COMPOSITE

define view entity P_EBPC_WIP_30_1
  with parameters
    P_Ledger               : fins_ledger,
    P_FromFiscalYearPeriod : fins_fyearperiod,
    P_ToFiscalYearPeriod   : fins_fyearperiod
  as select from I_JournalEntryItem
{
  key CompanyCode,
  key OrderID,
  key OrderItem,
  key SubLedgerAcctLineItemType,

      GlobalCurrency                                      as DisplayCurrency,

      sum(cast(AmountInGlobalCurrency as abap.dec(23,2))) as AmountInDisplayCurrency
}
where
  (
       SubLedgerAcctLineItemType   = '09100'
    or SubLedgerAcctLineItemType   = '09110'
  )
  and  BusinessTransactionCategory = 'EBWP'
  and  FiscalYearPeriod            >= $parameters.P_FromFiscalYearPeriod
  and  FiscalYearPeriod            <= $parameters.P_ToFiscalYearPeriod
  and  Ledger                      = $parameters.P_Ledger
group by
  CompanyCode,
  OrderID,
  OrderItem,
  SubLedgerAcctLineItemType,
  GlobalCurrency

Learn More