C_RAOpenRevenuePerPeriodQuery

Remaining Performance Obligations with Time Bands - Query | view: CRAOPNRVNPRDQRY | Extraction: Not supported | Component: Revenue Accounting
Column Name Description
PerformanceObligation Performance Obligation
PerformanceObligationClass Performance Obligation Name
Column Name Description
💲 Display Currency (DisplayCurrency):
RAPerPeriodOpenRevnInDspCrcy null
RAOpenCostInDspCrcy null
💲 Document Currency (SalesDocumentCurrency):
RAPerPerdOpenRevnInSlsDocCrcy Open Revenue up to the Current Period
RAOpenCostInCoCodeCrcy Open Cost
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
CompanyCode Company Code BUKRS
CompanyCodeName Name of Company Code or Company TEXT25
AccountingPrinciple Accounting Principle ACCOUNTING_PRINCIPLE
AccountingPrincipleName Name of Accounting Principle TEXT70
RAPerformanceObligationType Revenue Accounting Performance Obligation Type FARR_POB_TYPE
BandFiscalYearText FiscalYear for reporting disclosure 120
BandFiscalQuarterText FiscalQuarter for reporting Disclosure 120
BandFiscalYearQuarterText FiscalYearQuarter for reporting Disclosure 120
BandFiscalPeriodText FiscalPeriod for reporting Disclosure 120
BandFiscalYearPeriodText FiscalYearPeriod for reporting Disclosure 120
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_RAOPENREVENUEPERPERIODQUERY.MANDT == TGSB.MANDT
  • C_RAOPENREVENUEPERPERIODQUERY.BUSINESSAREA == TGSB.GSBER
Functional Area
  • Client
  • Functional Area
  • C_RAOPENREVENUEPERPERIODQUERY.MANDT == TFKB.MANDT
  • C_RAOPENREVENUEPERPERIODQUERY.FUNCTIONALAREA == TFKB.FKBER
Profit Center
  • Client
  • Profit Center
  • ?
  • ?
  • C_RAOPENREVENUEPERPERIODQUERY.MANDT == CEPC.MANDT
  • C_RAOPENREVENUEPERPERIODQUERY.PROFITCENTER == CEPC.PRCTR
  • C_RAOPENREVENUEPERPERIODQUERY.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_RAOPENREVENUEPERPERIODQUERY.[column in domain "DATBI"] == CEPC.DATBI
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • C_RAOPENREVENUEPERPERIODQUERY.SEGMENT == FAGL_SEGM.SEGMENT
  • C_RAOPENREVENUEPERPERIODQUERY.MANDT == FAGL_SEGM.MANDT