@AbapCatalog.sqlViewName: 'PPRJBYPMOCST'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_ProjCostAcctgLineItms
as select from I_ActualPlanJournalEntryItem as _ProjCstLineItm
inner join I_ControllingArea as _ContArea on _ProjCstLineItm.ControllingArea = _ContArea.ControllingArea
inner join R_ProjectSemTagGLAccount as _SemTagGL on _ContArea.CtrlgStdFinStatementVersion = _SemTagGL.GLAccountHierarchy
and _SemTagGL.HierarchyNodeVal = _ProjCstLineItm.GLAccount
and _ProjCstLineItm.ChartOfAccounts = _SemTagGL.HierarchyNodeClass
inner join P_SEMTAGVERMAP as _ChildTag on _SemTagGL.SemanticTag = _ChildTag.SemanticTag
association [0..1] to I_FiscalPeriodForVariant as _FiscalPeriod on _FiscalPeriod.FiscalYear = $projection.LedgerFiscalYear
and _FiscalPeriod.FiscalPeriod = $projection.FiscalPeriod
and _FiscalPeriod.FiscalYearVariant = $projection.FiscalYearVariant
{
key SourceLedger,
key Ledger,
key _ProjCstLineItm.CompanyCode,
key FiscalYear,
key AccountingDocument,
key FinancialPlanningReqTransSqnc,
key FinancialPlanningDataPacket,
key ActualPlanJournalEntryItem,
LedgerFiscalYear,
LedgerGLLineItem,
FinancialPlanningEntryItem,
_ProjCstLineItm.GLAccount,
_ProjCstLineItm.ChartOfAccounts,
AccountingDocCreatedByUser,
_SemTagGL.GLAccountHierarchy,
BusinessArea,
_ProjCstLineItm.CostCenter,
//Sending Partner fields
// S/4 Hana CE2302- Field Deprecation - Begin
//PartnerOrder,
_ProjCstLineItm.PartnerOrder_2 as PartnerOrder,
// S/4 Hana CE2302- Field Deprecation - Begin
PartnerOrderCategory,
// S/4 Hana CE2302- Field Deprecation - Begin
//PartnerWBSElement,
_ProjCstLineItm.PartnerWBSElementExternalID as PartnerWBSElement,
//PartnerProject,
_ProjCstLineItm.PartnerProjectExternalID as PartnerProject,
// S/4 Hana CE2302- Field Deprecation - End
BusinessTransactionType,
DebitCreditCode,
ControllingDebitCreditCode,
_ProjCstLineItm.ProfitCenter,
_SemTagGL.SemanticTag,
// S/4 Hana CE2302- Field Deprecation - Begin
//_ProjCstLineItm.WBSElement,
_ProjCstLineItm.WBSElementExternalID as WBSElement,
// S/4 Hana CE2302- Field Deprecation - end
_ProjCstLineItm.ControllingArea,
// S/4 Hana CE2302- Field Deprecation - Begin
//_ProjCstLineItm.Project,
_ProjCstLineItm.ProjectExternalID as Project,
// S/4 Hana CE2302- Field Deprecation - end
_ProjCstLineItm.ProjectInternalID,
_ProjCstLineItm.WBSElementInternalID, //CE1908
CreationDate,
_ProjCstLineItm.FunctionalArea,
CostCtrActivityType,
OrderID,
OrderOperation,
@Semantics.currencyCode: true
ControllingObjectCurrency,
@DefaultAggregation: #SUM
@Semantics.amount.currencyCode: 'ControllingObjectCurrency'
AmountInObjectCurrency,
@Semantics.currencyCode:true
TransactionCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
AmountInTransactionCurrency,
@Semantics.currencyCode:true
CompanyCodeCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
AmountInCompanyCodeCurrency,
@Semantics.currencyCode:true
GlobalCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
AmountInGlobalCurrency,
@Semantics.currencyCode:true
FreeDefinedCurrency1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
AmountInFreeDefinedCurrency1,
@Semantics.currencyCode:true
FreeDefinedCurrency2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
AmountInFreeDefinedCurrency2,
@Semantics.currencyCode:true
FreeDefinedCurrency3,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
AmountInFreeDefinedCurrency3,
@Semantics.currencyCode:true
FreeDefinedCurrency4,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
AmountInFreeDefinedCurrency4,
@Semantics.currencyCode:true
FreeDefinedCurrency5,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
AmountInFreeDefinedCurrency5,
@Semantics.currencyCode:true
FreeDefinedCurrency6,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
AmountInFreeDefinedCurrency6,
@Semantics.currencyCode:true
FreeDefinedCurrency7,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
AmountInFreeDefinedCurrency7,
@Semantics.currencyCode:true
FreeDefinedCurrency8,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
AmountInFreeDefinedCurrency8,
_ProjCstLineItm.PlanningCategory,
PostingDate,
DocumentDate,
FiscalPeriod,
FiscalYearPeriod,
_ProjCstLineItm.FiscalYearVariant,
PartnerSalesDocument,
PartnerProjectNetwork,
PartnerProjectNetworkActivity,
PartnerBusinessProcess,
PartnerCostObject,
SourceReferenceDocumentType,
SourceLogicalSystem,
SourceReferenceDocumentCntxt,
SourceReferenceDocument,
SourceReferenceDocumentItem,
SourceReferenceDocSubitem,
IsCommitment,
_ProjectBasicData,
_ContArea.CtrlgStdFinStatementVersion,
_FiscalPeriod,
_Ledger.IsLeadingLedger,
_Ledger,
_ProjCstLineItm._MaintenanceOrder,
_ProjCstLineItm._MaintenanceOrderOperation
}
where
_SemTagGL.GLAccountHierarchy = _ContArea.CtrlgStdFinStatementVersion
and _ContArea.CtrlgStdFinStatementVersion is not initial
and(
_ProjCstLineItm.Project != ''
)
and(
_SemTagGL.ValidityStartDate <= $session.system_date
and _SemTagGL.ValidityEndDate >= $session.system_date
)
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACTUALPLANJOURNALENTRYITEM",
"I_CONTROLLINGAREA",
"I_LEDGER",
"P_SEMTAGVERMAP",
"R_PROJECTSEMTAGGLACCOUNT"
],
"ASSOCIATED":
[
"I_FISCALPERIODFORVARIANT",
"I_LEDGER",
"I_MAINTENANCEORDER",
"I_MAINTENANCEORDEROPERATION",
"I_PROJECTBASICDATA"
],
"BASE":
[
"I_ACTUALPLANJOURNALENTRYITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/