P_CACollectionvolume

Analysis of Collections Volume | view: PCACOLLVOLUME | TRAN | Extraction: Not supported | Component: Contract Accounts Receivable and Payable
Column Name Description
Column Name Description
💲 Transaction Currency (TransactionCurrency):
CADunningBalance Dunning Balance
CADunningChargeAmount null
CADunningInterestAmount Dunning interest in transaction currency
CADunningAmount Dunned amount in transaction currency
Column Name Description
Column Name Description
CAMassRunDate Date ID
CAIssueDate Date of Issue
ExchangeRateDate null
Column Name Description
CAClearingStatus Clearing Status Show values
CAStatisticalItemCode Type of statistical item Show values
Column Name Description Domain name
CAMassRunID Run ID LAUFI_KK
ContractAccount Contract Account VKONT_KK
CADunningCounter Counter for several dunning notices to a business partner NUMC6
CAStandardCompanyCode Company Code BUKRS
CompanyCodeName Name of Company Code or Company TEXT25
BusinessArea Business Area GSBER
Division Division SPART
CACollectionStrategyName Name of Collection Strategy TXT50
CACollectionStepName Name of Collection Step TXT50
Segment Segment for Segmental Reporting FB_SEGMENT
SegmentName Segment Name TEXT50
CADocumentType Document Type BLART_KK
CAAccountDeterminationCode Account Determination ID KOFIZ_KK
CAMainTransaction Main Transaction for Line Item HVORG_KK
CASubTransaction Subtransaction for Document Item TVORG_KK
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
PostalCode City postal code CHAR10
Master Data Relations Join Conditions
Business Partner
  • Client
  • Business Partner Number
  • P_CACOLLECTIONVOLUME.MANDT == BUT000.CLIENT
  • P_CACOLLECTIONVOLUME.BUSINESSPARTNER == BUT000.PARTNER
Authorization Group
  • ?
  • Client
  • Authorization Group
  • P_CACOLLECTIONVOLUME.[column in domain "BGOBJ_KK"] == TFK_BEGRU.BGOBJ
  • P_CACOLLECTIONVOLUME.MANDT == TFK_BEGRU.CLIENT
  • P_CACOLLECTIONVOLUME.CAAUTHORIZATIONGROUP == TFK_BEGRU.BEGRU
Collection Step
  • Client
  • Collection Step
  • P_CACOLLECTIONVOLUME.MANDT == TFK047U.MANDT
  • P_CACOLLECTIONVOLUME.CACOLLECTIONSTEP == TFK047U.STEP
Collection Strategy
  • Client
  • Collection Strategy
  • P_CACOLLECTIONVOLUME.MANDT == TFK047X.MANDT
  • P_CACOLLECTIONVOLUME.CACOLLECTIONSTRATEGY == TFK047X.STRAT
Check table
  • Client
  • ?
  • Contract Account Category
  • P_CACOLLECTIONVOLUME.MANDT == TFK002A.MANDT
  • P_CACOLLECTIONVOLUME.[column in domain "APPLK_KK"] == TFK002A.APPLK
  • P_CACOLLECTIONVOLUME.CONTRACTACCOUNTCATEGORY == TFK002A.VKTYP
Currency key
  • Client
  • Transaction Currency
  • P_CACOLLECTIONVOLUME.MANDT == TCURC.MANDT
  • P_CACOLLECTIONVOLUME.TRANSACTIONCURRENCY == TCURC.WAERS