C_PRASmmryAcctsRblQry

PRA Summary Accounts Receivable Query | view: CPVSUMARQ | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: /PRA/AR_REC_BALT001TKA02
Column Name Description
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
BalAmtInCompanyCodeCrcy Current Balance
ReceivableAmtInCoCodeCrcy Total Receivable Balance
CashAmtInCoCodeCrcy Total Cash Received
StatusAmtInCompanyCodeCrcy Status Amount
WriteOffAmtInCoCodeCrcy Auto Write Off Amount
Column Name Description
Column Name Description
SalesDate Sales Date / Month
AgingPeriod Aging Period (YYYYMM01)
Column Name Description
BalAmtAgeCode Accounts Receivable Age Show values
AcctsRblStatus Accounts Receivable Status Show values
GLAccountType Account Type Show values
Column Name Description Domain name
CompanyCode Company Code BUKRS
Remitter Remitter (Customer) KUNNR
AccountsReceivableJointVenture AR Venture JV_NAME
AcctsRblDivisionOfInterest AR DOI OIU_DOI_NO
AcctsRblMeasurementPt AR MP OIU_MP_NO
Product Full three char. product code (Major and Detail Products) OIU_FULL_PD_CD
StatusLastChangedByUser Accounts Receivable Status User OIUAR_RESP_ID
WriteOffResponsibleUser Accounts Receivable Writeoff User OIUAR_RESP_ID
Master Data Relations Join Conditions
Currency Key
  • Currency Key
  • Client
  • C_PRASMMRYACCTSRBLQRY.COMPANYCODECURRENCY == TCURC.WAERS
  • C_PRASMMRYACCTSRBLQRY.MANDT == TCURC.MANDT