C_RAPostingItemQuery

Disaggregation of Revenue | view: CRAPOSTITEMQUERY | Extraction: Not supported | Component: Revenue Accounting
Column Name Description
Column Name Description
💲 Document Currency (SalesDocumentCurrency):
RevnAcctgPostgAmtInSlsDocCrcy Posting Revenue in Document Currency
RevnAcctgPostgAmtInCoCodeCrcy Posting Revenue in Company Code Currency
RevnAcctgPostgAmtInAddlCrcy1 Posting Revenue in Local Currency 2
RevnAcctgPostgAmtInAddlCrcy2 Posting Revenue in Local Currency 3
RAPostedCostInSlsDocCrcy Posting Cost in Document Currency
RAPostedCostAmountInCoCodeCrcy Posting Cost in Company Code Currency
RAPostedCostAmountInAddlCrcy1 Posting Cost in Local Currency 2
RAPostedCostAmountInAddlCrcy2 Posting Cost in Local Currency 3
Column Name Description
Column Name Description
RevnAcctgContractCreationDate Created On
Column Name Description
PerfOblgnFulfillmentType Fulfillment Type Show values
Column Name Description Domain name
PerformanceObligation Performance Obligation FARR_POB_ID
RevenueAccountingContract Revenue Contract FARR_CONTRACT_ID
CompanyCode Company Code BUKRS
CompanyCodeName Name of Company Code or Company TEXT25
AccountingPrinciple Accounting Principle ACCOUNTING_PRINCIPLE
AccountingPrincipleName Name of Accounting Principle TEXT70
FiscalYear Fiscal Year GJAHR
FiscalPeriod Fiscal Period POPER
GLAccount G/L Account Number SAKNR
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
BusinessPartner Business Partner Number BU_PARTNER
BusinessPartnerName null
Customer Customer Number KUNNR
CustomerName Name of Customer TEXT80
RAPerformanceObligationType Revenue Accounting Performance Obligation Type FARR_POB_TYPE
RevnAcctgSalesOrganization Sales Organization for Revenue Accounting FARR_SALES_ORG
Master Data Relations Join Conditions
Business Area
  • Business Area
  • Client
  • C_RAPOSTINGITEMQUERY.BUSINESSAREA == TGSB.GSBER
  • C_RAPOSTINGITEMQUERY.MANDT == TGSB.MANDT
Functional Area
  • Functional Area
  • Client
  • C_RAPOSTINGITEMQUERY.FUNCTIONALAREA == TFKB.FKBER
  • C_RAPOSTINGITEMQUERY.MANDT == TFKB.MANDT
Profit Center
  • Profit Center
  • ?
  • ?
  • Client
  • C_RAPOSTINGITEMQUERY.PROFITCENTER == CEPC.PRCTR
  • C_RAPOSTINGITEMQUERY.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_RAPOSTINGITEMQUERY.[column in domain "DATBI"] == CEPC.DATBI
  • C_RAPOSTINGITEMQUERY.MANDT == CEPC.MANDT
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • C_RAPOSTINGITEMQUERY.MANDT == FAGL_SEGM.MANDT
  • C_RAPOSTINGITEMQUERY.SEGMENT == FAGL_SEGM.SEGMENT