I_ProjectCostLineItemsByPeriod

DDL: I_PROJECTCOSTLINEITEMSBYPERIOD SQL: IPROCSTLITMPERD Type: view COMPOSITE Package: ODATA_PS_COS_PROJCOSTLINEITEM

Project Cost Line Items by Period

I_ProjectCostLineItemsByPeriod is a Composite CDS View that provides data about "Project Cost Line Items by Period" in SAP S/4HANA. It reads from 1 data source (I_ProjectCostLineItems) and exposes 142 fields with key fields SourceLedger, Ledger, CompanyCode, FiscalYear, AccountingDocument. It has 16 associations to related views. Part of development package ODATA_PS_COS_PROJCOSTLINEITEM.

1 data source(s) 142 fields

Data Sources (1)

SourceAliasJoin Type
I_ProjectCostLineItems _ProjCostSpclPerdTR from

Associations (16)

CardinalityTargetAliasCondition
[0..1] I_Ledger _SourceLedger $projection.SourceLedger = _SourceLedger.Ledger
[1..1] I_JournalEntry _JournalEntry $projection.CompanyCode = _JournalEntry.CompanyCode and $projection.FiscalYear = _JournalEntry.FiscalYear and $projection.AccountingDocument = _JournalEntry.AccountingDocument
[0..1] I_ControllingArea _ControllingArea $projection.ControllingArea = _ControllingArea.ControllingArea
[0..1] I_Ledger _Ledger $projection.Ledger = _Ledger.Ledger
[1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts and $projection.GLAccount = _GLAccountInChartOfAccounts.GLAccount
[1] I_ChartOfAccounts _ChartOfAccounts $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
[0..1] I_FiscalYearForCompanyCode _FiscalYear $projection.FiscalYear = _FiscalYear.FiscalYear and $projection.CompanyCode = _FiscalYear.CompanyCode
[0..*] I_ProfitCenter _ProfitCenter $projection.ControllingArea = _ProfitCenter.ControllingArea and $projection.ProfitCenter = _ProfitCenter.ProfitCenter
[0..1] I_ProjectBasicData _Project $projection.ProjectInternalID = _Project.ProjectInternalID
[0..1] I_WBSElementBasicData _WBSElement $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID
[1] I_FiscalYearVariant _FiscalYearVariant $projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant
[1..1] I_User _UserName $projection.AccountingDocCreatedByUser = _UserName.UserID
[0..1] I_PlanningCategory _PlanningCategory $projection.PlanningCategory = _PlanningCategory.PlanningCategory
[1..1] R_EnterpriseProjectElement _ProjectElement $projection.WBSElementInternalID = _ProjectElement.WBSElementInternalID
[0..*] I_FiscalYearPeriodText _FiscalYearPeriodText $projection.FiscalYearVariant = _FiscalYearPeriodText.FiscalYearVariant and $projection.FiscalYear = _FiscalYearPeriodText.FiscalYear and $projection.FiscalPeriod = _FiscalYearPeriodText.FiscalPeriod

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPROCSTLITMPERD view
VDM.viewType #COMPOSITE view
EndUserText.label Project Cost Line Items by Period view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (142)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger SourceLedger
KEY Ledger Ledger
KEY CompanyCode I_ProjectCostLineItems CompanyCode
KEY FiscalYear I_ProjectCostLineItems OriginalFiscalYear
KEY AccountingDocument AccountingDocument
KEY LedgerGLLineItem LedgerGLLineItem
KEY FinancialPlanningReqTransSqnc FinancialPlanningReqTransSqnc
KEY FinancialPlanningDataPacket FinancialPlanningDataPacket
KEY FinancialPlanningEntryItem FinancialPlanningEntryItem
BusinessArea I_ProjectCostLineItems BusinessArea
FunctionalArea I_ProjectCostLineItems FunctionalArea
ProjectInternalID ProjectInternalID
ControllingArea ControllingArea
ChartOfAccounts ChartOfAccounts
OrderID OrderID
ProjectObjectType ProjectObjectType
MaintenanceOrderIsSelected
PlanningCategory1 PlanningCategory1
PlanningCategory2 PlanningCategory2
ProjectObjectNode ProjectObjectNode
Project Project
ProjectDescription ProjectDescription
ProjectProfileCode ProjectProfileCode
ProjectSummaryTaskUUID ProjectSummaryTaskUUID
ProjectCategory ProjectCategory
ProfitCenter ProfitCenter
WBSElement WBSElement
WBSDescription WBSDescription
WBSElementProfitCenter WBSElementProfitCenter
ResponsibleCostCenter ResponsibleCostCenter
AccountingDocCreatedByUser AccountingDocCreatedByUser
AvailyCtrlTimeRangeType AvailyCtrlTimeRangeType
UserDescription _UserName UserDescription Created By
FiscalPeriod I_ProjectCostLineItems OriginalFiscalPeriod
FiscalYearPeriod I_ProjectCostLineItems NextFiscalYearPeriod
FiscalYearVariant I_ProjectCostLineItems FiscalYearVariant
PlanningCategory I_ProjectCostLineItems PlanningCategory
TransactionCurrency TransactionCurrency
CompanyCodeCurrency CompanyCodeCurrency
GlobalCurrency GlobalCurrency
FunctionalCurrency FunctionalCurrency
ControllingObjectCurrency ControllingObjectCurrency
FreeDefinedCurrency1 FreeDefinedCurrency1
FreeDefinedCurrency2 FreeDefinedCurrency2
FreeDefinedCurrency3 FreeDefinedCurrency3
FreeDefinedCurrency4 FreeDefinedCurrency4
FreeDefinedCurrency5 FreeDefinedCurrency5
FreeDefinedCurrency6 FreeDefinedCurrency6
FreeDefinedCurrency7 FreeDefinedCurrency7
FreeDefinedCurrency8 FreeDefinedCurrency8
AmountInTransactionCurrency AmountInTransactionCurrency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency
AmountInGlobalCurrency AmountInGlobalCurrency
ActualAmountInFunctionalCrcy ActualAmountInFunctionalCrcy
CmtmtAmountInFunctionalCrcy CmtmtAmountInFunctionalCrcy
PlanAmountInFunctionalCurrency PlanAmountInFunctionalCurrency
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8
ActualAmountInGlobalCurrency ActualAmountInGlobalCurrency
PlanAmountInGlobalCurrency PlanAmountInGlobalCurrency
CmtmtCostInGlobalCurrency CmtmtCostInGlobalCurrency
ActlCostInProjCrcy ActlCostInProjCrcy
PlndCostAmtInProjCrcy PlndCostAmtInProjCrcy
CmtmtCostInProjCrcy CmtmtCostInProjCrcy
ActualAmountInFreeDfndCrcy1 ActualAmountInFreeDfndCrcy1
ActualAmountInFreeDfndCrcy2 ActualAmountInFreeDfndCrcy2
ActualAmountInFreeDfndCrcy3 ActualAmountInFreeDfndCrcy3
ActualAmountInFreeDfndCrcy4 ActualAmountInFreeDfndCrcy4
ActualAmountInFreeDfndCrcy5 ActualAmountInFreeDfndCrcy5
ActualAmountInFreeDfndCrcy6 ActualAmountInFreeDfndCrcy6
ActualAmountInFreeDfndCrcy7 ActualAmountInFreeDfndCrcy7
ActualAmountInFreeDfndCrcy8 ActualAmountInFreeDfndCrcy8
PrjStockAmountInFunctionalCrcy PrjStockAmountInFunctionalCrcy
PrjStockAmountInGlobalCurrency PrjStockAmountInGlobalCurrency
ProjectStockAmtInProjCrcy ProjectStockAmtInProjCrcy
PrjStockAmtInCompanyCodeCrcy PrjStockAmtInCompanyCodeCrcy
PrjStockAmtInTransactionCrcy PrjStockAmtInTransactionCrcy
ActualAmountInCompanyCodeCrcy ActualAmountInCompanyCodeCrcy
ActualAmountInTransactionCrcy ActualAmountInTransactionCrcy
ActualCumltvAmtInCoCodeCrcy ActualCumltvAmtInCoCodeCrcy
ActlCmtmtCumltvAmtInGlobCrcy ActlCmtmtCumltvAmtInGlobCrcy
CmtmtCostInCCCrcy CmtmtCostInCCCrcy
CmtmtCostInTransacCrcy CmtmtCostInTransacCrcy
CmtmtCumltvAmtInGlobCrcy CmtmtCumltvAmtInGlobCrcy
PlanAmountInFreeDefinedCrcy1 PlanAmountInFreeDefinedCrcy1
PlanAmountInFreeDefinedCrcy2 PlanAmountInFreeDefinedCrcy2
PlanAmountInFreeDefinedCrcy3 PlanAmountInFreeDefinedCrcy3
PlanAmountInFreeDefinedCrcy4 PlanAmountInFreeDefinedCrcy4
PlanAmountInFreeDefinedCrcy5 PlanAmountInFreeDefinedCrcy5
PlanAmountInFreeDefinedCrcy6 PlanAmountInFreeDefinedCrcy6
PlanAmountInFreeDefinedCrcy7 PlanAmountInFreeDefinedCrcy7
PlanAmountInFreeDefinedCrcy8 PlanAmountInFreeDefinedCrcy8
CmtmtCostInFreeDefinedCrcy1 CmtmtCostInFreeDefinedCrcy1
CmtmtCostInFreeDefinedCrcy2 CmtmtCostInFreeDefinedCrcy2
CmtmtCostInFreeDefinedCrcy3 CmtmtCostInFreeDefinedCrcy3
CmtmtCostInFreeDefinedCrcy4 CmtmtCostInFreeDefinedCrcy4
CmtmtCostInFreeDefinedCrcy5 CmtmtCostInFreeDefinedCrcy5
CmtmtCostInFreeDefinedCrcy6 CmtmtCostInFreeDefinedCrcy6
CmtmtCostInFreeDefinedCrcy7 CmtmtCostInFreeDefinedCrcy7
CmtmtCostInFreeDefinedCrcy8 CmtmtCostInFreeDefinedCrcy8
BudgetInProjCrcy BudgetInProjCrcy
BudgetCurrencyRole BudgetCurrencyRole
PartnerOrder PartnerOrder
PartnerOrderCategory PartnerOrderCategory
PartnerWBSElement PartnerWBSElement
PartnerProject PartnerProject
BusinessTransactionType BusinessTransactionType
DebitCreditCode DebitCreditCode
PostingDate PostingDate
SourceReferenceDocumentType SourceReferenceDocumentType
SourceLogicalSystem SourceLogicalSystem
SourceReferenceDocumentCntxt SourceReferenceDocumentCntxt
SourceReferenceDocument SourceReferenceDocument
SourceReferenceDocumentItem SourceReferenceDocumentItem
SourceReferenceDocSubitem SourceReferenceDocSubitem
IsCommitment IsCommitment
AmountInObjectCurrency AmountInObjectCurrency
WBSElementInternalID WBSElementInternalID
ProjectUUID ProjectUUID
Plant I_ProjectCostLineItems Plant
ProjectType I_ProjectCostLineItems ProjectType
TaskUUID _ProjectElement ProjectElementUUID
_SourceLedger _SourceLedger
_JournalEntry _JournalEntry
_ControllingArea _ControllingArea
_Ledger _Ledger
_CompanyCode _CompanyCode
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_ChartOfAccounts _ChartOfAccounts
_FiscalYear _FiscalYear
_ProfitCenter _ProfitCenter
_Project _Project
_WBSElement _WBSElement
_FiscalYearVariant _FiscalYearVariant
_PlanningCategory _PlanningCategory
_UserName _UserName 
@AbapCatalog.sqlViewName: 'IPROCSTLITMPERD'
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Project Cost Line Items by Period'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API


define view I_ProjectCostLineItemsByPeriod
  //2502 Performance improvement for PCR app - Begin - association pushed down

  as select from I_ProjectCostLineItems as _ProjCostSpclPerdTR
  // as select distinct from I_ProjectCostLineItems as _ProjCostSpclPerdTR

  //  left outer join I_ProjectBudgetPlngCategory as _BudgetPlnCat on _BudgetPlnCat.PlanningCatIsForAvailyCtrl = 'X'

  //2502 Performance improvement for PCR app-End


  association [0..1] to I_Ledger                     as _SourceLedger               on  $projection.SourceLedger = _SourceLedger.Ledger
  association [1..1] to I_JournalEntry               as _JournalEntry               on  $projection.CompanyCode        = _JournalEntry.CompanyCode
                                                                                    and $projection.FiscalYear         = _JournalEntry.FiscalYear
                                                                                    and $projection.AccountingDocument = _JournalEntry.AccountingDocument
  association [0..1] to I_ControllingArea            as _ControllingArea            on  $projection.ControllingArea = _ControllingArea.ControllingArea
  association [0..1] to I_Ledger                     as _Ledger                     on  $projection.Ledger = _Ledger.Ledger
  association [1]    to I_CompanyCode                as _CompanyCode                on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_GLAccountInChartOfAccounts as _GLAccountInChartOfAccounts on  $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts
                                                                                    and $projection.GLAccount       = _GLAccountInChartOfAccounts.GLAccount
  association [1]    to I_ChartOfAccounts            as _ChartOfAccounts            on  $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
  association [0..1] to I_FiscalYearForCompanyCode   as _FiscalYear                 on  $projection.FiscalYear  = _FiscalYear.FiscalYear
                                                                                    and $projection.CompanyCode = _FiscalYear.CompanyCode
  association [0..*] to I_ProfitCenter               as _ProfitCenter               on  $projection.ControllingArea = _ProfitCenter.ControllingArea
                                                                                    and $projection.ProfitCenter    = _ProfitCenter.ProfitCenter
  association [0..1] to I_ProjectBasicData           as _Project                    on  $projection.ProjectInternalID = _Project.ProjectInternalID
  association [0..1] to I_WBSElementBasicData        as _WBSElement                 on  $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID
  association [1]    to I_FiscalYearVariant          as _FiscalYearVariant          on  $projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant
  association [1..1] to I_User                       as _UserName                   on  $projection.AccountingDocCreatedByUser = _UserName.UserID
  association [0..1] to I_PlanningCategory           as _PlanningCategory           on  $projection.PlanningCategory = _PlanningCategory.PlanningCategory
  association [1..1] to R_EnterpriseProjectElement   as _ProjectElement             on  $projection.WBSElementInternalID = _ProjectElement.WBSElementInternalID
  association [0..*] to I_FiscalYearPeriodText       as _FiscalYearPeriodText       on  $projection.FiscalYearVariant = _FiscalYearPeriodText.FiscalYearVariant
                                                                                    and $projection.FiscalYear        = _FiscalYearPeriodText.FiscalYear
                                                                                    and $projection.FiscalPeriod      = _FiscalYearPeriodText.FiscalPeriod


{

       @ObjectModel.foreignKey.association: '_SourceLedger'
  key  SourceLedger,
       @ObjectModel.foreignKey.association: '_Ledger'
  key  Ledger,
       @ObjectModel.foreignKey.association: '_CompanyCode'
  key  _ProjCostSpclPerdTR.CompanyCode,
       @ObjectModel.foreignKey.association: '_FiscalYear'
  key  _ProjCostSpclPerdTR.OriginalFiscalYear        as FiscalYear,
       @ObjectModel.foreignKey.association: '_JournalEntry'
  key  AccountingDocument,
  key  LedgerGLLineItem,
  key  FinancialPlanningReqTransSqnc,
  key  FinancialPlanningDataPacket,
       @DefaultAggregation: #NONE
  key  FinancialPlanningEntryItem,

       _ProjCostSpclPerdTR.BusinessArea,
       _ProjCostSpclPerdTR.FunctionalArea,
       @ObjectModel.foreignKey.association: '_Project'
       ProjectInternalID,
       @ObjectModel.foreignKey.association: '_ControllingArea'
       ControllingArea,

       case
       //2502 Performance improvement for PCR app-Begin

       //when  _ProjCostSpclPerdTR.PlanningCategory =  _BudgetPlnCat.PlanningCategory //'BUDGET01'

        when  _ProjCostSpclPerdTR.PlanningCategory =  BudgetPlanningCategory
       //2502 Performance improvement for PCR app-End

                then ''
            else GLAccount
        end                                          as GLAccount,

       @ObjectModel.foreignKey.association: '_ChartOfAccounts'
       ChartOfAccounts,

       OrderID,
       //2408 Performance improvement for Project Cost Report Overview and Line Items-Begin

       ProjectObjectType,
       //2408 Performance improvement for Project Cost Report Overview and Line Items-End

       cast(MaintenanceOrderIsSelected as boolean  ) as MaintenanceOrderIsSelected,
       PlanningCategory1,
       PlanningCategory2,
       ProjectObjectNode,
       Project,
       ProjectDescription,
       ProjectProfileCode,
       ProjectSummaryTaskUUID,
       ProjectCategory,
       @ObjectModel.foreignKey.association: '_ProfitCenter'
       ProfitCenter,
       @ObjectModel.foreignKey.association: '_WBSElement'
       WBSElement,
       WBSDescription,
       WBSElementProfitCenter,
       ResponsibleCostCenter,
       AccountingDocCreatedByUser,
       AvailyCtrlTimeRangeType,
       @EndUserText.label: 'Created By'
       _UserName.UserDescription,

       _ProjCostSpclPerdTR.OriginalFiscalPeriod      as FiscalPeriod,
       _ProjCostSpclPerdTR.NextFiscalYearPeriod      as FiscalYearPeriod,
       @ObjectModel.foreignKey.association: '_FiscalYearVariant'
       _ProjCostSpclPerdTR.FiscalYearVariant,
       @ObjectModel.foreignKey.association: '_PlanningCategory'
       _ProjCostSpclPerdTR.PlanningCategory,

       @Semantics.currencyCode:true
       TransactionCurrency,
       @Semantics.currencyCode:true
       CompanyCodeCurrency,
       @Semantics.currencyCode:true
       GlobalCurrency,
       @Semantics.currencyCode: true
       FunctionalCurrency,

       @Semantics.currencyCode:true
       ControllingObjectCurrency,
       @Semantics.currencyCode:true
       FreeDefinedCurrency1,
       @Semantics.currencyCode:true
       FreeDefinedCurrency2,
       @Semantics.currencyCode:true
       FreeDefinedCurrency3,
       @Semantics.currencyCode:true
       FreeDefinedCurrency4,
       @Semantics.currencyCode:true
       FreeDefinedCurrency5,
       @Semantics.currencyCode:true
       FreeDefinedCurrency6,
       @Semantics.currencyCode:true
       FreeDefinedCurrency7,
       @Semantics.currencyCode:true
       FreeDefinedCurrency8,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
       AmountInTransactionCurrency,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
       AmountInCompanyCodeCurrency,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
       AmountInGlobalCurrency,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FunctionalCurrency '} }
       ActualAmountInFunctionalCrcy,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FunctionalCurrency '} }
       CmtmtAmountInFunctionalCrcy,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FunctionalCurrency '} }
       PlanAmountInFunctionalCurrency,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
       AmountInFreeDefinedCurrency1,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
       AmountInFreeDefinedCurrency2,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
       AmountInFreeDefinedCurrency3,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
       AmountInFreeDefinedCurrency4,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
       AmountInFreeDefinedCurrency5,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
       AmountInFreeDefinedCurrency6,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
       AmountInFreeDefinedCurrency7,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
       AmountInFreeDefinedCurrency8,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
       ActualAmountInGlobalCurrency,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
       PlanAmountInGlobalCurrency,

       @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
       @DefaultAggregation: #SUM
       CmtmtCostInGlobalCurrency,
       // Project currency fields

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'ControllingObjectCurrency'} }
       ActlCostInProjCrcy,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'ControllingObjectCurrency'} }
       PlndCostAmtInProjCrcy,

       @Semantics: { amount : {currencyCode: 'ControllingObjectCurrency'} }
       @DefaultAggregation: #SUM
       CmtmtCostInProjCrcy,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
       ActualAmountInFreeDfndCrcy1,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
       ActualAmountInFreeDfndCrcy2,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
       ActualAmountInFreeDfndCrcy3,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
       ActualAmountInFreeDfndCrcy4,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
       ActualAmountInFreeDfndCrcy5,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
       ActualAmountInFreeDfndCrcy6,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
       ActualAmountInFreeDfndCrcy7,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
       ActualAmountInFreeDfndCrcy8,

       //2502 Include Project Stock costs in Project Cost Report - Begin

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FunctionalCurrency '} }
       PrjStockAmountInFunctionalCrcy,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
       PrjStockAmountInGlobalCurrency,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'ControllingObjectCurrency'} }
       ProjectStockAmtInProjCrcy,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
       PrjStockAmtInCompanyCodeCrcy,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
       PrjStockAmtInTransactionCrcy,

       //2502 - Fields are pushed down from C_Projectcostlineitems

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
       ActualAmountInCompanyCodeCrcy,
       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
       ActualAmountInTransactionCrcy,
       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
       ActualCumltvAmtInCoCodeCrcy,
       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
       @Consumption.filter: {hidden: true}
       ActlCmtmtCumltvAmtInGlobCrcy,
       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
       CmtmtCostInCCCrcy,
       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
       CmtmtCostInTransacCrcy,
       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
       CmtmtCumltvAmtInGlobCrcy,
       //2502 Include Project Stock costs in Project Cost Report - End


       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
       PlanAmountInFreeDefinedCrcy1,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
       PlanAmountInFreeDefinedCrcy2,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
       PlanAmountInFreeDefinedCrcy3,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
       PlanAmountInFreeDefinedCrcy4,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
       PlanAmountInFreeDefinedCrcy5,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
       PlanAmountInFreeDefinedCrcy6,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
       PlanAmountInFreeDefinedCrcy7,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
       PlanAmountInFreeDefinedCrcy8,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
       CmtmtCostInFreeDefinedCrcy1,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
       CmtmtCostInFreeDefinedCrcy2,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
       CmtmtCostInFreeDefinedCrcy3,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
       CmtmtCostInFreeDefinedCrcy4,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
       CmtmtCostInFreeDefinedCrcy5,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
       CmtmtCostInFreeDefinedCrcy6,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
       CmtmtCostInFreeDefinedCrcy7,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
       CmtmtCostInFreeDefinedCrcy8,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'ControllingObjectCurrency'} }
       BudgetInProjCrcy,

       BudgetCurrencyRole,

       //Sending Partner fields

       PartnerOrder,
       PartnerOrderCategory,
       PartnerWBSElement,
       PartnerProject,
       BusinessTransactionType,
       DebitCreditCode,

       case
       //2502 Performance improvement for PCR app-Begin

       //when  _ProjCostSpclPerdTR.PlanningCategory = _BudgetPlnCat.PlanningCategory // BUDGET01

       when  _ProjCostSpclPerdTR.PlanningCategory = BudgetPlanningCategory
       //2502 Performance improvement for PCR app-End

       then ''
       else  SemanticTag
       end                                           as SemanticTag,


       @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
       @DefaultAggregation: #SUM
       @UI.lineItem.position: 70
       case
       //2502 Performance improvement for PCR app-Begin

       //when  _ProjCostSpclPerdTR.PlanningCategory = _BudgetPlnCat.PlanningCategory //'BUDGET01'

          when  _ProjCostSpclPerdTR.PlanningCategory = BudgetPlanningCategory
       //2502 Performance improvement for PCR app-End

               then AmountInGlobalCurrency
           else 0
       end                                           as BudgetInGlobalCrcy,

       @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
       @DefaultAggregation: #SUM
       case
       //2502 Performance improvement for PCR app-Begin

       //  when  _ProjCostSpclPerdTR.PlanningCategory =_BudgetPlnCat.PlanningCategory // 'BUDGET01'

         when  _ProjCostSpclPerdTR.PlanningCategory = BudgetPlanningCategory
       //2502 Performance improvement for PCR app-End

               then AmountInCompanyCodeCurrency
         else 0
       end                                           as BudgetAmountInCompanyCodeCrcy,

       @Semantics.amount.currencyCode: 'TransactionCurrency'
       @DefaultAggregation: #SUM
       case
       //2502 Performance improvement for PCR app-Begin

       // when  _ProjCostSpclPerdTR.PlanningCategory =_BudgetPlnCat.PlanningCategory // 'BUDGET01'

        when  _ProjCostSpclPerdTR.PlanningCategory = BudgetPlanningCategory
       //2502 Performance improvement for PCR app-End

               then AmountInTransactionCurrency
         else 0
       end                                           as BudgetAmountInTransactionCrcy,


       @Semantics.amount.currencyCode: 'GlobalCurrency'
       @DefaultAggregation: #SUM
       case
       //2502 Performance improvement for PCR app-Begin

       //  when  _ProjCostSpclPerdTR.PlanningCategory = _BudgetPlnCat.PlanningCategory //'BUDGET01'

        when  _ProjCostSpclPerdTR.PlanningCategory = BudgetPlanningCategory
       //2502 Performance improvement for PCR app-End

              then AmountInGlobalCurrency
          else 0
       end                                           as AccmltdAvailBdgtInGlobalCrcy,

       PostingDate,

       cast(case
        when Ledger is null
           then  'X'
        else
            IsSettled
        end  as ps_s4_considersettlement)            as IsSettled,

       SourceReferenceDocumentType,
       SourceLogicalSystem,
       SourceReferenceDocumentCntxt,
       SourceReferenceDocument,
       SourceReferenceDocumentItem,
       SourceReferenceDocSubitem,
       IsCommitment,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'ControllingObjectCurrency'}}
       AmountInObjectCurrency,
       WBSElementInternalID,
       ProjectUUID,
       // CE2402: Changes for AO /s4ppm/pr1 - Begin

       _ProjCostSpclPerdTR.Plant,
       _ProjCostSpclPerdTR.ProjectType,
       // CE2402: Changes for AO /s4ppm/pr1 - End

       _ProjectElement.ProjectElementUUID            as TaskUUID,


       _SourceLedger,
       _JournalEntry,
       _ControllingArea,
       _Ledger,
       _CompanyCode,
       _GLAccountInChartOfAccounts,
       _ChartOfAccounts,
       _FiscalYear,
       _ProfitCenter,
       _Project,
       _WBSElement,
       _FiscalYearVariant,
       _PlanningCategory,
       _UserName



}

Learn More