I_IntcoProjectBillingElement

DDL: I_INTCOPROJECTBILLINGELEMENT Type: view_entity BASIC Package: FIN_CO_ICO_BILLING_TRACKER

Intercompany Project Billing Element

I_IntcoProjectBillingElement is a Basic CDS View that provides data about "Intercompany Project Billing Element" in SAP S/4HANA. It reads from 3 data sources (I_PrjBlgElmEntrJrnlEntrLink, I_ProjectBillingElement, I_ProjectBillingElementEntry) and exposes 11 fields. Part of development package FIN_CO_ICO_BILLING_TRACKER.

3 data source(s) 11 fields

Data Sources (3)

SourceAliasJoin Type
I_PrjBlgElmEntrJrnlEntrLink _PrjBlgElmEntrJrnlEntrLink from
I_ProjectBillingElement _ProjectBillingElement inner
I_ProjectBillingElementEntry _ProjectBillingElementEntry inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Intercompany Project Billing Element view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
AccessControl.personalData.blocking #REQUIRED view

Fields (11)

KeyFieldSource TableSource FieldDescription
Ledger I_PrjBlgElmEntrJrnlEntrLink Ledger
CompanyCode I_PrjBlgElmEntrJrnlEntrLink CompanyCode
FiscalYear
AccountingDocument I_PrjBlgElmEntrJrnlEntrLink AccountingDocument
LedgerGLLineItem I_PrjBlgElmEntrJrnlEntrLink LedgerGLLineItem
ProjBillgElmntEntrItmUUID I_PrjBlgElmEntrJrnlEntrLink ProjBillgElmntEntrItmUUID
ProjectBillingCategory I_ProjectBillingElement ProjectBillingCategory
ProjBillingProfile I_ProjectBillingElement ProjBillingProfile
Material I_ProjectBillingElementEntry Material
ProjectBillingElementUUID I_ProjectBillingElementEntry ProjectBillingElementUUID
_ProjectBillingElement I_ProjectBillingElementEntry _ProjectBillingElement 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Intercompany Project Billing Element'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #BASIC
@AccessControl.personalData.blocking: #REQUIRED
define view entity I_IntcoProjectBillingElement
  as select from I_PrjBlgElmEntrJrnlEntrLink  as _PrjBlgElmEntrJrnlEntrLink
    inner join   I_ProjectBillingElementEntry as _ProjectBillingElementEntry on _PrjBlgElmEntrJrnlEntrLink.ProjBillgElmntEntrItmUUID = _ProjectBillingElementEntry.ProjBillgElmntEntrItmUUID
    inner join   I_ProjectBillingElement      as _ProjectBillingElement      on  _ProjectBillingElementEntry.ProjectBillingElementUUID = _ProjectBillingElement.ProjectBillingElementUUID
                                                                             and _ProjectBillingElement.ProjectBillingCategory         = 'ICBL'
                                                                             and _ProjectBillingElement.ProjBillingProfile             = 'ICOBLG001'
{
  _PrjBlgElmEntrJrnlEntrLink.Ledger,
  _PrjBlgElmEntrJrnlEntrLink.CompanyCode,
  cast ( _PrjBlgElmEntrJrnlEntrLink.FiscalYear as fis_gjahr_no_conv ) as FiscalYear,
  _PrjBlgElmEntrJrnlEntrLink.AccountingDocument,
  _PrjBlgElmEntrJrnlEntrLink.LedgerGLLineItem,

  _PrjBlgElmEntrJrnlEntrLink.ProjBillgElmntEntrItmUUID,
  _ProjectBillingElement.ProjectBillingCategory,
  _ProjectBillingElement.ProjBillingProfile,

  _ProjectBillingElementEntry.Material,

  _ProjectBillingElementEntry.ProjectBillingElementUUID,
  _ProjectBillingElementEntry._ProjectBillingElement
}

Learn More