P_EBWIP_WIP1

DDL: P_EBWIP_WIP1 SQL: PEBWIPWIP1 Type: view COMPOSITE

P_EBWIP_WIP1 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_JournalEntryItemWIP) and exposes 13 fields with key fields CompanyCode, OrderID, SubLedgerAcctLineItemType.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_JournalEntryItemWIP I_JournalEntryItemWIP from

Parameters (2)

NameTypeDefault
P_KeyDate datum
P_Ledger fins_ledger

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PEBWIPWIP1 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 (13)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY OrderID OrderID
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType
AmountInCompanyCodeCurrency
AmountInGlobalCurrency
AmountInFreeDefinedCurrency1
AmountInFreeDefinedCurrency2
AmountInFreeDefinedCurrency3
AmountInFreeDefinedCurrency4
AmountInFreeDefinedCurrency5
AmountInFreeDefinedCurrency6
AmountInFreeDefinedCurrency7
AmountInFreeDefinedCurrency8 
@AbapCatalog.sqlViewName: 'PEBWIPWIP1'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

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

define view P_EBWIP_WIP1
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : datum,
    P_Ledger  : fins_ledger
  as select from I_JournalEntryItemWIP
{
  key CompanyCode,
  key OrderID,
  key SubLedgerAcctLineItemType,

      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
}
where
      Ledger      = :P_Ledger
  and PostingDate <= $parameters.P_KeyDate
group by
  CompanyCode,
  OrderID,
  SubLedgerAcctLineItemType
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRYITEMWIP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More