P_EPUnbilldRevnInLeadLdgr

DDL: P_EPUNBILLDREVNINLEADLDGR Type: view COMPOSITE

P_EPUnbilldRevnInLeadLdgr is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_EngmntProjUnbilledRevData, I_Ledger) and exposes 8 fields.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
P_EngmntProjUnbilledRevData A from
I_Ledger B inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PEPUNBLLDREVLDGR view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
VDM.private true view
VDM.lifecycle.contract.type #NONE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
EngagementProject P_EngmntProjUnbilledRevData EngagementProject
SalesOrder P_EngmntProjUnbilledRevData SalesOrder
SalesOrderItem P_EngmntProjUnbilledRevData SalesOrderItem
Ledger P_EngmntProjUnbilledRevData Ledger
FiscalYearPeriod P_EngmntProjUnbilledRevData FiscalYearPeriod
Currency P_EngmntProjUnbilledRevData Currency
UnbilldRevnAmountInProjCrcy P_EngmntProjUnbilledRevData UnbilldRevnAmountInProjCrcy
IsLeadingLedger I_Ledger IsLeadingLedger 
@AbapCatalog: {
  sqlViewName: 'PEPUNBLLDREVLDGR',
//  preserveKey: true,

  compiler.compareFilter: true
}
@VDM: {
  viewType: #COMPOSITE,
  private: true,
  lifecycle.contract.type: #NONE
}
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #NOT_REQUIRED
}
@ObjectModel.usageType: {
  sizeCategory: #XL,
  dataClass: #MIXED,
  serviceQuality: #D
}
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Engagement Project Unbilled Revenue in Leading Ledger'

define view P_EPUnbilldRevnInLeadLdgr as select from P_EngmntProjUnbilledRevData as A
    inner join I_Ledger as B
    on B.IsLeadingLedger = 'X'
    and A.Ledger = B.Ledger {

A.EngagementProject,
A.SalesOrder,
A.SalesOrderItem,
A.Ledger,
A.FiscalYearPeriod,
A.Currency,
A.UnbilldRevnAmountInProjCrcy,
B.IsLeadingLedger

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGER",
"P_ENGMNTPROJUNBILLEDREVDATA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More