P_ActlHrsInLdgrForProjects

DDL: P_ACTLHRSINLDGRFORPROJECTS Type: view COMPOSITE Package: CPD_CDS

Staffing - Actual Hours In Leading Ledger For Projects

P_ActlHrsInLdgrForProjects is a Composite CDS View that provides data about "Staffing - Actual Hours In Leading Ledger For Projects" in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItemRawData) and exposes 19 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. Part of development package CPD_CDS.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_GLAccountLineItemRawData A from

Annotations (13)

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

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger I_GLAccountLineItemRawData SourceLedger
KEY CompanyCode I_GLAccountLineItemRawData CompanyCode
KEY FiscalYear I_GLAccountLineItemRawData FiscalYear
KEY AccountingDocument I_GLAccountLineItemRawData AccountingDocument
KEY LedgerGLLineItem I_GLAccountLineItemRawData LedgerGLLineItem
Project _ProjectBasicData Project
WorkPackage I_GLAccountLineItemRawData WorkPackage
WorkItem I_GLAccountLineItemRawData WorkItem
PersonnelNumber I_GLAccountLineItemRawData PersonnelNumber
PostingDate I_GLAccountLineItemRawData PostingDate
FiscalPeriod I_GLAccountLineItemRawData FiscalPeriod
AccountingDocumentCategory I_GLAccountLineItemRawData AccountingDocumentCategory
AccountAssignmentType I_GLAccountLineItemRawData AccountAssignmentType
ReversalReferenceDocument I_GLAccountLineItemRawData ReversalReferenceDocument
BusinessTransactionType I_GLAccountLineItemRawData BusinessTransactionType
IsLeadingLedger
BillableControl I_GLAccountLineItemRawData BillableControl
UnitOfMeasure I_GLAccountLineItemRawData BaseUnit
ActlEffortQty I_GLAccountLineItemRawData Quantity 
@AbapCatalog: {
  sqlViewName: 'PEPACTLHRSLDGR',
  preserveKey: true,
  compiler.compareFilter: true
}
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Staffing - Actual Hours In Leading Ledger For Projects'

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM: {
  private: true,
  lifecycle.contract.type: #NONE,
  viewType: #COMPOSITE
}
define view P_ActlHrsInLdgrForProjects as select from  I_GLAccountLineItemRawData as A
{
key A.SourceLedger,
key A.CompanyCode,
key A.FiscalYear,
key A.AccountingDocument,
key A.LedgerGLLineItem,
_ProjectBasicData.Project as Project,
A.WorkPackage,
A.WorkItem,
//case when A.BusinessTransactionType = 'RMWE' then A.Product

//else A.PartnerCostCtrActivityType end as EngagementProjectResource,

case when A.PartnerCostCtrActivityType = '' /* A.OriginCostCtrActivityType = '' */ then A.Product
else A.PartnerCostCtrActivityType /* A.OriginCostCtrActivityType */ end as EngagementProjectResource,
A.PersonnelNumber,
A.PostingDate,
A.FiscalPeriod,
A.AccountingDocumentCategory,
A.AccountAssignmentType,
A.ReversalReferenceDocument,
A.BusinessTransactionType,
A._Ledger.IsLeadingLedger,
A.BillableControl,

A.BaseUnit as UnitOfMeasure,

A.Quantity as ActlEffortQty

} where ( A.FiscalPeriod > '000'
    or ( A.FiscalPeriod = '000' and AccountingDocumentCategory = 'J') )
    and A.AccountAssignmentType = 'PR'
    and A.ReversalReferenceDocument = ''
    and A._Ledger.IsLeadingLedger = 'X'
    and A.BusinessTransactionType != 'TBRR' 
    and A.BusinessTransactionType != 'SD00'
    and A.BusinessTransactionType != 'RFCV'

Learn More