I_CreditLimitRequestCube

Credit Limit Request - Cube | view: ICRDTLMTREQCUBE | TRAN | Extraction: Not supported | Component: Credit Management
Column Name Description
CaseUUID UUID in character form
Column Name Description
💲 null (DisplayCurrency):
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
CasePlannedCloseDateIsExceeded Planned Close Date is Exceeded Show values
CreditLimitIsApproved Credit Limit Is Approved Show values
CrdtLmtReqdIsEqualCrdtLmtAprvd Requested Limit Vs. Approved Limit 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
  • Category
  • Client
  • Case Type
Closed by User
  • Closed by User
  • Client
  • I_CREDITLIMITREQUESTCUBE.CASECLOSEDBY == USR02.BNAME
  • I_CREDITLIMITREQUESTCUBE.MANDT == USR02.MANDT
Created By
  • Client
  • Created By
  • I_CREDITLIMITREQUESTCUBE.MANDT == USR02.MANDT
  • I_CREDITLIMITREQUESTCUBE.CASECREATEDBY == USR02.BNAME
Reason for Escalation
  • Reason for Escalation
  • Client
Last Changed By
  • Last Changed By
  • Client
  • I_CREDITLIMITREQUESTCUBE.CASELASTCHANGEDBY == USR02.BNAME
  • I_CREDITLIMITREQUESTCUBE.MANDT == USR02.MANDT
Priority
  • Client
  • Priority
Processor
  • Client
  • Processor
  • I_CREDITLIMITREQUESTCUBE.MANDT == USR02.MANDT
  • I_CREDITLIMITREQUESTCUBE.CASEPROCESSOR == USR02.BNAME
Reason for Case
  • Client
  • Reason for Case
  • Case Type
Case: Status
  • Case: Status
  • Client
  • Case: Status Profile
Case: Status Profile
  • Client
  • Case: Status Profile
  • I_CREDITLIMITREQUESTCUBE.MANDT == SCMGSTATPROF.CLIENT
  • I_CREDITLIMITREQUESTCUBE.CASESTATUSPROFILE == SCMGSTATPROF.PROFILE_ID
Case: System Status I_CREDITLIMITREQUESTCUBE.CASESYSTEMSTATUS == SCMGSTAT.STAT_PARA
Case Type
  • Client
  • Case Type
Country key
  • Country/Region
  • Client
  • I_CREDITLIMITREQUESTCUBE.COUNTRY == T005.LAND1
  • I_CREDITLIMITREQUESTCUBE.MANDT == T005.MANDT
Customer Credit Group
  • Customer Credit Group
  • Client
  • I_CREDITLIMITREQUESTCUBE.CRDTMGMTBUSINESSPARTNERGROUP == UKM_CUST_GRP.CRED_GROUP
  • I_CREDITLIMITREQUESTCUBE.MANDT == UKM_CUST_GRP.CLIENT
Risk Class
  • Risk Class
  • Client
  • I_CREDITLIMITREQUESTCUBE.CREDITRISKCLASS == UKM_RISK_CL.RISK_CLASS
  • I_CREDITLIMITREQUESTCUBE.MANDT == UKM_RISK_CL.CLIENT
Credit Segment
  • Client
  • Credit Segment
Region code
  • Country/Region
  • Client
  • Region (State, Province, County)
  • I_CREDITLIMITREQUESTCUBE.COUNTRY == T005S.LAND1
  • I_CREDITLIMITREQUESTCUBE.MANDT == T005S.MANDT
  • I_CREDITLIMITREQUESTCUBE.REGION == T005S.BLAND