R_CreditAccountSummaryTP

Credit Account Summary | view: RCRDTACCTSMMRYTP | Extraction: Not supported | Component: Fiori-UI for Credit Management
Column Name Description
BusinessPartner Business Partner Number
CreditSegment FK Credit Segment
Column Name Description
💲 Credit Segment Currency (CreditSegmentCurrency):
CreditLimitAmount Credit Limit
EffectiveTotalCreditLimitAmt Effective Credit Limit Amount
InsuredCreditLimitAmount Insured Credit Amount
SecuredCreditLimitAmount Secured Credit Amount
TemporaryIncreasedCreditLmtAmt Temporarily Increased Credit Amount
CreditLimitCalculatedAmount Calculated Credit Limit
CreditLimitRequestedAmount Credit Limit Requested
💲 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
CreditCommitmentDspEndDate Key Date
CrdtWrthnssScoreValdtyEndDate Valid To Date
CrdtWorthinessScoreLastChgDate Change Date for Score
CreditRiskClassLastChangeDate Risk Class Changed On
CreditAccountResubmissionDate Resubmission Date
CreditLimitValidityEndDate Valid To Date
CreditLimitLastChangeDate Change Date for Credit Limit
CreditLimitReqdValidityEndDate Valid To Date (Requested)
CreditLimitRequestDate Request Date
OldestOpenItemNetDueDate Net Due Date
LastPaymentDate Date of Last Payment
Column Name Description
BusinessPartnerIsCritical Special Attention Required Show values
CreditAccountIsBlocked Credit Checks Fail Due to Credit Block Show values
CreditLimitIsZero Limit Is Zero Show values
CreditLimitIsDefined Credit Limit Is Defined Show values
CrdtLmtIsReqdFrmAutomCalc Limit Request from Automatic Calculation Show values
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
CreditWorthinessScoreValue Score CHAR10
CalcdCrdtWorthinessScoreValue Calculated Score CHAR10
MainCreditSegment Main Credit Segment UKM_CREDIT_SGMNT
OrganizationBPName1 Name 1 of organization BU_NAME
OrganizationBPName2 Name 2 of organization BU_NAME
OrganizationBPName3 Name 3 of organization BU_NAME
OrganizationBPName4 Name 4 of organization BU_NAME
Customer Customer Number KUNNR
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
CreditAnalyst Credit Analyst BU_PARTNER
CreditCoordinatorName null
Master Data Relations Join Conditions
Calculated Risk Class
  • Client
  • Calculated Risk Class
  • R_CREDITACCOUNTSUMMARYTP.MANDT == UKM_RISK_CL.CLIENT
  • R_CREDITACCOUNTSUMMARYTP.CALCULATEDCREDITRISKCLASS == UKM_RISK_CL.RISK_CLASS
Customer Credit Group
  • Client
  • Customer Credit Group
  • R_CREDITACCOUNTSUMMARYTP.MANDT == UKM_CUST_GRP.CLIENT
  • R_CREDITACCOUNTSUMMARYTP.CRDTMGMTBUSINESSPARTNERGROUP == UKM_CUST_GRP.CRED_GROUP
Reason for Block in Credit Management
  • Client
  • Reason for Block in Credit Management
  • R_CREDITACCOUNTSUMMARYTP.MANDT == UKM_BL_REASON.CLIENT
  • R_CREDITACCOUNTSUMMARYTP.CREDITACCOUNTBLOCKREASON == UKM_BL_REASON.BLOCK_REASON
Rule for Credit Check
  • Client
  • Rule for Credit Check
Risk Class
  • Client
  • Risk Class
  • R_CREDITACCOUNTSUMMARYTP.MANDT == UKM_RISK_CL.CLIENT
  • R_CREDITACCOUNTSUMMARYTP.CREDITRISKCLASS == UKM_RISK_CL.RISK_CLASS
Rule for Scoring
  • Client
  • Rule for Calculating Score and Credit Limit
Credit Segment
  • Client
  • Credit Segment
  • Main Credit Segment
  • R_CREDITACCOUNTSUMMARYTP.MANDT == UKMCRED_SGM0C.CLIENT
  • R_CREDITACCOUNTSUMMARYTP.CREDITSEGMENT == UKMCRED_SGM0C.CREDIT_SGMNT
  • R_CREDITACCOUNTSUMMARYTP.MAINCREDITSEGMENT == UKMCRED_SGM0C.CREDIT_SGMNT
Currency key
  • Client
  • Credit Segment Currency
  • R_CREDITACCOUNTSUMMARYTP.MANDT == TCURC.MANDT
  • R_CREDITACCOUNTSUMMARYTP.CREDITSEGMENTCURRENCY == TCURC.WAERS
Currency
  • Client
  • Currency of Highest Dunned Item
  • R_CREDITACCOUNTSUMMARYTP.MANDT == TCURC.MANDT
  • R_CREDITACCOUNTSUMMARYTP.MAXIMUMDUNNEDOPENITEMCURRENCY == TCURC.WAERS
Currency
  • Client
  • Currency of Oldest Open Item
  • R_CREDITACCOUNTSUMMARYTP.MANDT == TCURC.MANDT
  • R_CREDITACCOUNTSUMMARYTP.OLDESTOPENITEMCURRENCY == TCURC.WAERS
Currency
  • Client
  • Currency of Key Figures
  • R_CREDITACCOUNTSUMMARYTP.MANDT == TCURC.MANDT
  • R_CREDITACCOUNTSUMMARYTP.SENDERCURRENCY == TCURC.WAERS