I_EngmntProjBillgAndRblsCube

Billg and Rbls of Engmnt Project - Cube | view: IEPBILLRBLSCUBE | TRAN | Extraction: Not supported | Component: S/4HANA Professional Services Cloud - CPM
Column Name Description
Column Name Description
💲 Currency Key (ProjectCurrency):
BilledAmountInProjectCurrency Amount in Company Code Currency
BillingPlanAmount Value to be billed/calc. on date in billing/invoice plan
SalesOrderNetAmount Net Value of Sales Order Item in Transaction Currency
DebitMemoRequestNetAmount Net Value of Sales Order Item in Transaction Currency
OpenBillingRequestAmount Amount in Company Code Currency
BillingRequestOverdueAmount Amount in Company Code Currency
WriteOffAmount Sum never
TotalReceivablesAmount Amount in Company Code Currency
Column Name Description
Column Name Description
BillingPlanBillingDate Billing Date
ProjectStartDate Commercial Project: Start Date
ProjectEndDate Commercial Project: End Date
Column Name Description
EngagementProjectCategory Project Type Show values
ProjectVisibility Confidential Indicator for Commercial Project Show values
Column Name Description Domain name
EngagementProject Engagement Project ID
SalesOrderItem Sales Order Item
EngagementProjectServiceOrg Service Organization /CPD/PWS_WS_ORG_UNIT_ID
ProfitCenter Profit Center PRCTR
CostCenter Organization Unit Key
ProjectManager null
ProjectManagerExternalID null
ProjectManagerName null
IsMyProject null
BillingReqTimeIntervalInDays null
BillingReqTimeIntervalValue null
ReceivablesTimeIntervalInDays null
ReceivablesTimeIntervalValue null
Master Data Relations Join Conditions
Company code
  • Client
  • Company code for the project
  • I_ENGMNTPROJBILLGANDRBLSCUBE.MANDT == T001.MANDT
  • I_ENGMNTPROJBILLGANDRBLSCUBE.COMPANYCODE == T001.BUKRS
Controlling area
  • Client
  • Controlling area for the project
  • I_ENGMNTPROJBILLGANDRBLSCUBE.MANDT == TKA01.MANDT
  • I_ENGMNTPROJBILLGANDRBLSCUBE.CONTROLLINGAREA == TKA01.KOKRS
Material: order item
  • Client
  • Material Number
  • I_ENGMNTPROJBILLGANDRBLSCUBE.MANDT == MARA.MANDT
  • I_ENGMNTPROJBILLGANDRBLSCUBE.PRODUCT == MARA.MATNR
Currency Key
  • Client
  • Currency Key
  • I_ENGMNTPROJBILLGANDRBLSCUBE.MANDT == TCURC.MANDT
  • I_ENGMNTPROJBILLGANDRBLSCUBE.PROJECTCURRENCY == TCURC.WAERS
Profile ID for project structure
  • Client
  • Project Profile
  • I_ENGMNTPROJBILLGANDRBLSCUBE.MANDT == TCJ41.MANDT
  • I_ENGMNTPROJBILLGANDRBLSCUBE.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
Sales document item category
  • Client
  • Sales document item category
  • I_ENGMNTPROJBILLGANDRBLSCUBE.MANDT == TVPT.MANDT
  • I_ENGMNTPROJBILLGANDRBLSCUBE.SALESORDERITEMCATEGORY == TVPT.PSTYV