C_CreditDecisionDocumentQ

Credit Decision Document Query | view: CCRDTDCSNDOCQ | Extraction: Not supported | Component: Information System
Column Name Description
CaseUUID UUID in character form
Column Name Description
💲 null (DisplayCurrency):
OpenCreditAmount Open Credit Amount
CheckedCreditRiskAmount Checked Credit Value
CustomerCreditLimitAmount Customer's Credit Limit
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
SalesDocumentCreditStatus Status of Document with Credit Block Show values
CreditDecisionFirstApprvlSts Status of First Approval Show values
CreditDecisionSecondApprvlSts Status of Second Approval Show values
CrdtDcsnApprvlProcIsOverruled Approval Process Not Adhered To Show values
StaticLmtUtilznCrdtChkIsFailed Static Check of Credit Limit Utilization Failed Show values
MaxDocAmountCreditChkIsFailed Check for Maximum Document Value Failed Show values
DynLimitUtilznCrdtChkIsFailed Dynamic Check of Credit Limit Utilization Failed Show values
MaxDunningLevelCrdtChkIsFailed Check of Maximum Dunning Level Failed Show values
OldestOpenItemCrdtChkIsFailed Check for Oldest Open Item Failed Show values
DaysSlsOutStdgCrdtChkIsFailed Check of Days Sales Outstanding (DSO) Failed Show values
OtherCreditCheckIsFailed Other Checks Failed Show values
OverdueOpenItemCrdtChkIsFailed Check for Overdue Open Items Failed Show values
Column Name Description Domain name
CaseID Case ID SCMG_EXT_KEY
BusinessPartner Business Partner Number BU_PARTNER
CreditRiskClass Risk Class at Time of Credit Decision UKM_RISK_CLASS
NumberOfCreditDecisionDocs Number of Documented Credit Decisions INT4
NmbrOfDaysPlndClsDateExceeded Number of Days After Planned Closing Date INT4
CreditDecisionObjectType Type of Document with Credit Block OJ_NAME
CreditDecisionSalesDocument Sales and Distribution Document Number VBELN
CreditDecisionReqUTCDateTime Timestamp TZNTSTMPS
CreditLimitUtilizationPct null
Master Data Relations Join Conditions
Category
  • Category
  • Case Type
  • Client
Closed by User
  • Closed by User
  • Client
  • C_CREDITDECISIONDOCUMENTQ.CASECLOSEDBY == USR02.BNAME
  • C_CREDITDECISIONDOCUMENTQ.MANDT == USR02.MANDT
Created By
  • Created By
  • Client
  • C_CREDITDECISIONDOCUMENTQ.CASECREATEDBY == USR02.BNAME
  • C_CREDITDECISIONDOCUMENTQ.MANDT == USR02.MANDT
Reason for Escalation
  • Reason for Escalation
  • Client
Last Changed By
  • Last Changed By
  • Client
  • C_CREDITDECISIONDOCUMENTQ.CASELASTCHANGEDBY == USR02.BNAME
  • C_CREDITDECISIONDOCUMENTQ.MANDT == USR02.MANDT
Priority
  • Priority
  • Client
Credit Analyst
  • Credit Analyst
  • Client
  • C_CREDITDECISIONDOCUMENTQ.CASEPROCESSOR == USR02.BNAME
  • C_CREDITDECISIONDOCUMENTQ.MANDT == USR02.MANDT
Reason for Case
  • Reason for Case
  • Case Type
  • Client
Person Responsible
  • Person Responsible
  • Client
  • C_CREDITDECISIONDOCUMENTQ.CASERESPONSIBLE == USR02.BNAME
  • C_CREDITDECISIONDOCUMENTQ.MANDT == USR02.MANDT
Case: Status
  • Case: Status
  • Client
  • Case: Status Profile
  • C_CREDITDECISIONDOCUMENTQ.CASESTATUS == SCMGSTATPROFS.STAT_ORDERNO
  • C_CREDITDECISIONDOCUMENTQ.MANDT == SCMGSTATPROFS.CLIENT
  • C_CREDITDECISIONDOCUMENTQ.CASESTATUSPROFILE == SCMGSTATPROFS.PROFILE_ID
Case: Status Profile
  • Client
  • Case: Status Profile
  • C_CREDITDECISIONDOCUMENTQ.MANDT == SCMGSTATPROF.CLIENT
  • C_CREDITDECISIONDOCUMENTQ.CASESTATUSPROFILE == SCMGSTATPROF.PROFILE_ID
Case: System Status C_CREDITDECISIONDOCUMENTQ.CASESYSTEMSTATUS == SCMGSTAT.STAT_PARA
Case Type
  • Case Type
  • Client
Country key
  • Client
  • Country/Region
  • C_CREDITDECISIONDOCUMENTQ.MANDT == T005.MANDT
  • C_CREDITDECISIONDOCUMENTQ.COUNTRY == T005.LAND1
Customer Credit Group
  • Customer Credit Group
  • Client
  • C_CREDITDECISIONDOCUMENTQ.CRDTMGMTBUSINESSPARTNERGROUP == UKM_CUST_GRP.CRED_GROUP
  • C_CREDITDECISIONDOCUMENTQ.MANDT == UKM_CUST_GRP.CLIENT
User Who Released/Rejected the Sales Document
  • User Who Released/Rejected the Sales Document
  • Client
  • C_CREDITDECISIONDOCUMENTQ.CREDITDECISIONCOMPLETEDBYUSER == USR02.BNAME
  • C_CREDITDECISIONDOCUMENTQ.MANDT == USR02.MANDT
Approver
  • Approver
  • Client
  • C_CREDITDECISIONDOCUMENTQ.CREDITDECISIONFIRSTAPPROVER == USR02.BNAME
  • C_CREDITDECISIONDOCUMENTQ.MANDT == USR02.MANDT
Second Approver
  • Second Approver
  • Client
  • C_CREDITDECISIONDOCUMENTQ.CREDITDECISIONSECONDAPPROVER == USR02.BNAME
  • C_CREDITDECISIONDOCUMENTQ.MANDT == USR02.MANDT
Credit Segment
  • Credit Segment
  • Client
Region code
  • Client
  • Country/Region
  • Region (State, Province, County)
  • C_CREDITDECISIONDOCUMENTQ.MANDT == T005S.MANDT
  • C_CREDITDECISIONDOCUMENTQ.COUNTRY == T005S.LAND1
  • C_CREDITDECISIONDOCUMENTQ.REGION == T005S.BLAND