C_CreditLimitRequestQuery

Credit Limit Request Query | view: CCRDTLIMITREQSTQ | Extraction: Not supported | Component: Information System
Column Name Description
CaseUUID UUID in character form
Column Name Description
CreditLimitAmount Customer's Credit Limit
CreditLimitRequestedAmount Requested Credit Limit
CreditLimitApprovedAmount Approved Credit Limit
ExpectedSalesAmount Expected Sales Revenue
CustomerCreditExposureAmount Credit Exposure Amount
Column Name Description
Column Name Description
CaseCreationDate Created On
CaseLastChangeDate Last Changed On
CaseClosingDate Closed On
CasePlannedCloseDate Planned Close Date
Column Name Description
CaseIsClosed Case is Closed Show values
CreditLimitIsApproved Credit Limit Is Approved Show values
CrdtLmtReqdIsEqualCrdtLmtAprvd Requested Limit Vs. Approved Limit Show values
CasePlannedCloseDateIsExceeded Planned Close Date is Exceeded Show values
Column Name Description Domain name
CaseID Case ID SCMG_EXT_KEY
BusinessPartner Business Partner Number BU_PARTNER
CreditLimitUtilizationPct Credit Limit Utilization in Percent UKM_PRZ32
BusinessPartnerRating Score CHAR10
NumberOfCreditLimitRequests Number of Credit Limit Requests INT4
NmbrOfDaysPlndClsDateExceeded Number of Days After Planned Closing Date INT4
Master Data Relations Join Conditions
Category
  • Case Type
  • Category
  • Client
Closed by User
  • Closed by User
  • Client
  • C_CREDITLIMITREQUESTQUERY.CASECLOSEDBY == USR02.BNAME
  • C_CREDITLIMITREQUESTQUERY.MANDT == USR02.MANDT
Created By
  • Created By
  • Client
  • C_CREDITLIMITREQUESTQUERY.CASECREATEDBY == USR02.BNAME
  • C_CREDITLIMITREQUESTQUERY.MANDT == USR02.MANDT
Reason for Escalation
  • Reason for Escalation
  • Client
Last Changed By
  • Last Changed By
  • Client
  • C_CREDITLIMITREQUESTQUERY.CASELASTCHANGEDBY == USR02.BNAME
  • C_CREDITLIMITREQUESTQUERY.MANDT == USR02.MANDT
Priority
  • Client
  • Priority
Processor
  • Client
  • Processor
  • C_CREDITLIMITREQUESTQUERY.MANDT == USR02.MANDT
  • C_CREDITLIMITREQUESTQUERY.CASEPROCESSOR == USR02.BNAME
Reason for Case
  • Case Type
  • Client
  • Reason for Case
Case: Status
  • Client
  • Case: Status
  • Case: Status Profile
  • C_CREDITLIMITREQUESTQUERY.MANDT == SCMGSTATPROFS.CLIENT
  • C_CREDITLIMITREQUESTQUERY.CASESTATUS == SCMGSTATPROFS.STAT_ORDERNO
  • C_CREDITLIMITREQUESTQUERY.CASESTATUSPROFILE == SCMGSTATPROFS.PROFILE_ID
Case: Status Profile
  • Client
  • Case: Status Profile
  • C_CREDITLIMITREQUESTQUERY.MANDT == SCMGSTATPROF.CLIENT
  • C_CREDITLIMITREQUESTQUERY.CASESTATUSPROFILE == SCMGSTATPROF.PROFILE_ID
Case: System Status C_CREDITLIMITREQUESTQUERY.CASESYSTEMSTATUS == SCMGSTAT.STAT_PARA
Case Type
  • Case Type
  • Client
Country key
  • Client
  • Country/Region
  • C_CREDITLIMITREQUESTQUERY.MANDT == T005.MANDT
  • C_CREDITLIMITREQUESTQUERY.COUNTRY == T005.LAND1
Customer Credit Group
  • Client
  • Customer Credit Group
  • C_CREDITLIMITREQUESTQUERY.MANDT == UKM_CUST_GRP.CLIENT
  • C_CREDITLIMITREQUESTQUERY.CRDTMGMTBUSINESSPARTNERGROUP == UKM_CUST_GRP.CRED_GROUP
Risk Class
  • Risk Class
  • Client
  • C_CREDITLIMITREQUESTQUERY.CREDITRISKCLASS == UKM_RISK_CL.RISK_CLASS
  • C_CREDITLIMITREQUESTQUERY.MANDT == UKM_RISK_CL.CLIENT
Credit Segment
  • Credit Segment
  • Client
Region code
  • Client
  • Country/Region
  • Region (State, Province, County)
  • C_CREDITLIMITREQUESTQUERY.MANDT == T005S.MANDT
  • C_CREDITLIMITREQUESTQUERY.COUNTRY == T005S.LAND1
  • C_CREDITLIMITREQUESTQUERY.REGION == T005S.BLAND