R_CrdtMAcctPaytBehavior

Credit Mgmt: Payment Behavior | view: RCRDTPAYTBEHAV | Extraction: Not supported | Component: Fiori-UI for Credit Management
Column Name Description
BusinessPartner Business Partner Number
CreditSegment FK Credit Segment
Column Name Description
💲 Currency of Highest Dunned Item (MaximumDunnedOpenItemCurrency):
MaximumDunnedOpenItemAmount Dunned Amount
💲 Currency of Oldest Open Item (OldestOpenItemCurrency):
OldestOpenItemAmount Amount of Oldest Open Item
💲 Currency of Last Payment (LastPaymentCurrency):
LastPaymentItemAmount Amount of Last Payment
💲 Currency of Key Figures (SenderCurrency):
TotalOutstandingAmtInSndrCrcy Total Outstanding Amount
PaytNoCshDiscTotAmtInSndrCrcy Gross Total of Cleared Items with Cash Discount Not Taken
PaytWthCshDiscTotAmtInSndrCrcy Gross Total of Cleared Items Without Cash Discount Loss
TotLast12MnthsSlsAmtInSndrCrcy Sales of Last 12 Months
Last12MnthsMaxSlsAmtInSndrCrcy Highest Monthly Sales in Last 12 Months
Column Name Description
Column Name Description
OldestOpenItemNetDueDate Net Due Date
LastPaymentDate Date of Last Payment
Column Name Description
CrdtMDunningInfoIsErroneous Dunning Data is Erroneous Show values
CrdtMOverdueItmInfoIsErroneous Open Item Data is Erroneous Show values
CrdtMPaymentInfoIsErroneous Last Payment Info is Erroneous Show values
CrdtMKeyFigureInfoIsErroneous Key Figures are Erroneous Show values
Column Name Description Domain name
MaximumDunnedOpenItem Open Item with Highest Dunning Level SWO_TYPEID
MaximumDunningLevel Highest Dunning Level of Business Partner UKM_DUNN_MAX_LV
NumberOfOpenItemsInMaxDunLevel Number of Dunning Notices INT4
DunnedItemInfoTransmnDateTime Date and Time of Transmission of Dunning Info TZNTSTMPS
OldestOpenItem Oldest Open Item SWO_TYPEID
OldestOpnItemNrOfDaysInArrears Oldest Open Item: Days in Arrears DEC3
OldestOpnItemInfoTransmnDteTme Date and Time of Transmission of Oldest Overdue Item Info TZNTSTMPS
LastPaymentItem Last Payment SWO_TYPEID
LastPaymentInfoTransmnDateTime Date and Time of Transmission of Last Payment Info TZNTSTMPS
DaysSalesOutstanding Key Figure: Days Sales Outstanding
CrdtMKeyFigureTransmnDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
NoCshDiscAvgNrOfDaysInArrears Average Arrears for Payments Where No Cash Discount Taken UKM_DEC3
CshDiscClmAvgNrOfDaysInArrears Average Arrears with Cash Discount Payments UKM_DEC3
Master Data Relations Join Conditions
Credit Segment
  • Client
  • Credit Segment
Currency
  • Client
  • Currency of Highest Dunned Item
  • R_CRDTMACCTPAYTBEHAVIOR.MANDT == TCURC.MANDT
  • R_CRDTMACCTPAYTBEHAVIOR.MAXIMUMDUNNEDOPENITEMCURRENCY == TCURC.WAERS
Currency
  • Currency of Oldest Open Item
  • Client
  • R_CRDTMACCTPAYTBEHAVIOR.OLDESTOPENITEMCURRENCY == TCURC.WAERS
  • R_CRDTMACCTPAYTBEHAVIOR.MANDT == TCURC.MANDT
Currency
  • Client
  • Currency of Key Figures
  • R_CRDTMACCTPAYTBEHAVIOR.MANDT == TCURC.MANDT
  • R_CRDTMACCTPAYTBEHAVIOR.SENDERCURRENCY == TCURC.WAERS