C_RATotalOpenRevenueQuery

Remaining Performance Obligations | view: CRATTOPNRVNQRY | Extraction: Not supported | Component: Revenue Accounting
Column Name Description
CompanyCode Company Code
AccountingPrinciple Accounting Principle
PerformanceObligation Performance Obligation
Column Name Description
💲 Display Currency (DisplayCurrency):
RATotalOpenRevenueInDspCrcy null
RAEventBasedOpenRevnInDspCrcy null
RATimeBasedOpenRevnInDspCrcy null
RAOpenCostInDspCrcy null
RAEventBasedOpenCostInDspCrcy null
RATimeBasedOpenCostInDspCrcy null
💲 Document Currency (SalesDocumentCurrency):
RATotalOpenRevnInSlsDocCrcy Open Revenue up to the Current Period
RAEventBsdOpenRevnInSlsDocCrcy Open Revenue up to the Current Period
RATimeBsdOpenRevnInSlsDocCrcy Open Revenue up to the Current Period
RAOpenCostInCoCodeCrcy Open Revenue up to the Current Period
RAEventBsdOpenCostInSlsDocCrcy Open Revenue up to the Current Period
RATimeBsdOpenCostInSlsDocCrcy Open Revenue up to the Current Period
Column Name Description
Column Name Description
RevnAcctgContractCreationDate Created On
RAInitialEffectiveDate Initial effect. date when POB is created & becomes effective
Column Name Description
RevnAcctgPerfOblgnStatus Performance Obligation Status Show values
Column Name Description Domain name
RAPerformanceObligationType Revenue Accounting Performance Obligation Type FARR_POB_TYPE
PerformanceObligationClass Performance Obligation Name FARR_POB_NAME
RevenueAccountingContract Revenue Contract FARR_CONTRACT_ID
BusinessPartner Business Partner Number BU_PARTNER
BusinessPartnerName null
Customer Customer Number KUNNR
CustomerName Name of Customer TEXT80
RevnAcctgSalesOrganization Sales Organization for Revenue Accounting FARR_SALES_ORG
FunctionalAreaName Name of the Functional Area TEXT25
BusinessAreaName Business Area Description TEXT30
SegmentName Segment Name TEXT50
ProfitCenterName Description of Profit Center TEXT20
CostCenter Cost Center KOSTL
CostCenterName Cost Center Name TEXT20
OrderID Order Number AUFNR
SalesOrder Sales Order Number VBELN
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
Master Data Relations Join Conditions
Business Area
  • Client
  • Business Area
  • C_RATOTALOPENREVENUEQUERY.MANDT == TGSB.MANDT
  • C_RATOTALOPENREVENUEQUERY.BUSINESSAREA == TGSB.GSBER
Functional Area
  • Client
  • Functional Area
  • C_RATOTALOPENREVENUEQUERY.MANDT == TFKB.MANDT
  • C_RATOTALOPENREVENUEQUERY.FUNCTIONALAREA == TFKB.FKBER
Profit Center
  • Client
  • ?
  • ?
  • Profit Center
  • C_RATOTALOPENREVENUEQUERY.MANDT == CEPC.MANDT
  • C_RATOTALOPENREVENUEQUERY.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_RATOTALOPENREVENUEQUERY.[column in domain "DATBI"] == CEPC.DATBI
  • C_RATOTALOPENREVENUEQUERY.PROFITCENTER == CEPC.PRCTR
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • C_RATOTALOPENREVENUEQUERY.MANDT == FAGL_SEGM.MANDT
  • C_RATOTALOPENREVENUEQUERY.SEGMENT == FAGL_SEGM.SEGMENT