P_UKM_GRC_DCD_1

Data source for GRC Control: DCDs | view: PUKMGRCDCD_1 | Extraction: Not supported | Component: Credit Management
Tables used: SCMG_T_CASE_ATTR, VBKD, VEDA, VBAK, BUT000, UKM_DCD_ATTR, UKMBP_CMS
Column Name Description
CaseUUID UUID in character form
SalesDocument Sales Document
Column Name Description
💲 Currency of the Amount To Be Approved (CreditDecisionCurrency):
OpenCreditAmount Open Credit Amount
CheckedCreditRiskAmount Checked Credit Value
💲 null (DisplayCurrency):
CheckedCrdtRiskAmountInDspCrcy null
OpenCreditAmountInDspCrcy null
TotalNetAmountInDspCrcy null
ReleasedCreditAmountInDspCrcy null
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
💲 Currency key of credit control area (ControllingAreaCurrency):
ReleasedCreditAmount Released credit value of the document
Column Name Description
Column Name Description
CreditCaseCreationDate null
CreditCaseCloseDate null
CasePlannedCloseDate Planned Close Date
CreationDate Date on which the record was created
LastChangeDate Last Changed On
SalesDocumentDate Document Date (Date Received/Sent)
CustomerPurchaseOrderDate Customer Reference Date
CreditBlockReleaseDate Release date of the document determined by credit management
Column Name Description
SalesDocumentCreditStatus Status of Document with Credit Block Show values
CreditDecisionFirstApprvlSts Status of 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
SDDocumentCategory SD Document Category Show values
SalesDocumentProcessingType SD document indicator 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
CaseExternalReference External Reference CHAR30
CaseTitle Case Title TEXT80
CreditCaseCreationDateTime Created On TZNTSTMPS
CaseLastChangedOn Last Changed On TZNTSTMPS
CreditCaseCloseDateTime Closed On TZNTSTMPS
CaseStatusObjectNumber Case: Status Object Number (GUID), (Central Status Managmnt) SYSUUID_C
CaseSystemStatusName Case: System Status Description (Central Status Management) SCMGSTATLINE
CaseUserStatusName Case: User Status Description (Central Status Management) SCMGSTATLINE
CreditDecisionObjectType Type of Document with Credit Block OJ_NAME
CreditDecisionSalesDocument null
SalesEmployeeUserID Sales Employee XUBNAME
ExternalDocumentID External Document ID CHAR40
ExternalDocLastChangeDateTime Timestamp for Revision of External Calls TZNTSTMPL
CustomerPurchaseOrderSuplmnt Purchase order number supplement BSTZD
CustomerPaymentTerms Terms of payment key ZTERM
FiscalYear Fiscal Year GJAHR
FiscalPeriod Posting period POPER
AccountingDocExternalReference Reference Document Number XBLNR1
Master Data Relations Join Conditions
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • P_UKM_GRC_DCD_1.BILLINGCOMPANYCODE == T001.BUKRS
  • P_UKM_GRC_DCD_1.MANDT == T001.MANDT
Category
  • Case Type
  • Category
  • Client
Closed by User
  • Closed by User
  • Client
  • P_UKM_GRC_DCD_1.CASECLOSEDBY == USR02.BNAME
  • P_UKM_GRC_DCD_1.MANDT == USR02.MANDT
Created By
  • Client
  • Created By
  • P_UKM_GRC_DCD_1.MANDT == USR02.MANDT
  • P_UKM_GRC_DCD_1.CASECREATEDBY == USR02.BNAME
Reason for Escalation
  • Reason for Escalation
  • Client
Last Changed By
  • Last Changed By
  • Client
  • P_UKM_GRC_DCD_1.CASELASTCHANGEDBY == USR02.BNAME
  • P_UKM_GRC_DCD_1.MANDT == USR02.MANDT
Priority
  • Priority
  • Client
Processor
  • Client
  • Processor
  • P_UKM_GRC_DCD_1.MANDT == USR02.MANDT
  • P_UKM_GRC_DCD_1.CASEPROCESSOR == USR02.BNAME
Reason for Case
  • Reason for Case
  • Case Type
  • Client
Person Responsible
  • Client
  • Person Responsible
  • P_UKM_GRC_DCD_1.MANDT == USR02.MANDT
  • P_UKM_GRC_DCD_1.CASERESPONSIBLE == USR02.BNAME
Case: Status
  • Case: Status Profile
  • Client
  • Case: Status
Case: Status Profile
  • Case: Status Profile
  • Client
Case: System Status P_UKM_GRC_DCD_1.CASESYSTEMSTATUS == SCMGSTAT.STAT_PARA
Case Type
  • Case Type
  • Client
Currency key of credit control area
  • Client
  • Currency key of credit control area
  • P_UKM_GRC_DCD_1.MANDT == TCURC.MANDT
  • P_UKM_GRC_DCD_1.CONTROLLINGAREACURRENCY == TCURC.WAERS
Customer Credit Group
  • Customer Credit Group
  • Client
Credit control area
  • Client
  • Credit control area
  • P_UKM_GRC_DCD_1.MANDT == T014.MANDT
  • P_UKM_GRC_DCD_1.CREDITCONTROLAREA == T014.KKBER
User Who Released/Rejected the Sales Document
  • Client
  • User Who Released/Rejected the Sales Document
  • P_UKM_GRC_DCD_1.MANDT == USR02.MANDT
  • P_UKM_GRC_DCD_1.CREDITDECISIONCOMPLETEDBYUSER == USR02.BNAME
Currency of the Amount To Be Approved
  • Client
  • Currency of the Amount To Be Approved
  • P_UKM_GRC_DCD_1.MANDT == TCURC.MANDT
  • P_UKM_GRC_DCD_1.CREDITDECISIONCURRENCY == TCURC.WAERS
Approver
  • Client
  • Approver
  • P_UKM_GRC_DCD_1.MANDT == USR02.MANDT
  • P_UKM_GRC_DCD_1.CREDITDECISIONFIRSTAPPROVER == USR02.BNAME
Second Approver
  • Second Approver
  • Client
  • P_UKM_GRC_DCD_1.CREDITDECISIONSECONDAPPROVER == USR02.BNAME
  • P_UKM_GRC_DCD_1.MANDT == USR02.MANDT
Credit Segment
  • Client
  • Credit Segment
Customer's Account Number with Credit Limit Reference
  • Customer's Account Number with Credit Limit Reference
  • Client
  • P_UKM_GRC_DCD_1.CUSTOMERCREDITACCOUNT == KNA1.KUNNR
  • P_UKM_GRC_DCD_1.MANDT == KNA1.MANDT
Customer Purchase Order Type
  • Client
  • Customer Purchase Order Type
  • P_UKM_GRC_DCD_1.MANDT == T176.MANDT
  • P_UKM_GRC_DCD_1.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • P_UKM_GRC_DCD_1.SALESORGANIZATION == TVKOV.VKORG
  • P_UKM_GRC_DCD_1.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • P_UKM_GRC_DCD_1.MANDT == TVKOV.MANDT
Order Number
  • Order Number
  • Client
  • P_UKM_GRC_DCD_1.ORDERID == AUFK.AUFNR
  • P_UKM_GRC_DCD_1.MANDT == AUFK.MANDT
Division in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • Division
  • P_UKM_GRC_DCD_1.SALESORGANIZATION == TVTA.VKORG
  • P_UKM_GRC_DCD_1.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_UKM_GRC_DCD_1.MANDT == TVTA.MANDT
  • P_UKM_GRC_DCD_1.ORGANIZATIONDIVISION == TVTA.SPART
Payment Method
  • ?
  • Client
  • Payment Method
  • P_UKM_GRC_DCD_1.[column in domain "LAND1"] == T042Z.LAND1
  • P_UKM_GRC_DCD_1.MANDT == T042Z.MANDT
  • P_UKM_GRC_DCD_1.PAYMENTMETHOD == T042Z.ZLSCH
Sales District
  • Client
  • Sales District
  • P_UKM_GRC_DCD_1.MANDT == T171.MANDT
  • P_UKM_GRC_DCD_1.SALESDISTRICT == T171.BZIRK
Approval Request Reason ID
  • Client
  • Approval Request Reason ID
  • P_UKM_GRC_DCD_1.MANDT == SDAPMAPRR.CLIENT
  • P_UKM_GRC_DCD_1.SALESDOCAPPROVALREASON == SDAPMAPRR.APM_APPROVAL_REASON
Order type in order header
  • Client
  • Sales Document Type
  • P_UKM_GRC_DCD_1.MANDT == TVAK.MANDT
  • P_UKM_GRC_DCD_1.SALESDOCUMENTTYPE == TVAK.AUART
Sales organization in order header
  • Sales Organization
  • Client
  • P_UKM_GRC_DCD_1.SALESORGANIZATION == TVKO.VKORG
  • P_UKM_GRC_DCD_1.MANDT == TVKO.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • P_UKM_GRC_DCD_1.SOLDTOPARTY == KNA1.KUNNR
  • P_UKM_GRC_DCD_1.MANDT == KNA1.MANDT
Currency in order header
  • Client
  • SD Document Currency
  • P_UKM_GRC_DCD_1.MANDT == TCURC.MANDT
  • P_UKM_GRC_DCD_1.TRANSACTIONCURRENCY == TCURC.WAERS