C_GRC_ReldCrdtDcsnDocument

DDL: C_GRC_RELDCRDTDCSNDOCUMENT SQL: CUKMGRCDCDREL Type: view CONSUMPTION
42 Fields 1 Data Sources

GRC Control: released DCDs in Displ Crcy

C_GRC_ReldCrdtDcsnDocument is a Consumption CDS View that provides data about "GRC Control: released DCDs in Displ Crcy" in SAP S/4HANA. It reads from 1 data source (P_UKM_GRC_DCD_1) and exposes 42 fields with key fields CaseUUID, SalesDocument.

Data Sources (1)

SourceAliasJoin Type
P_UKM_GRC_DCD_1 P_UKM_GRC_DCD_1 from

Parameters (1)

NameTypeDefault
P_DisplayCurrency vdm_v_display_currency

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CUKMGRCDCDREL view
EndUserText.label GRC Control: released DCDs in Displ Crcy view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
OData.publish true view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY CaseUUID CaseUUID Credit Case UUID
KEY SalesDocument SalesDocument SD Document
CaseID CaseID Credit Case ID
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerName _BusinessPartner BusinessPartnerName Business Partner Name
CreditSegment CreditSegment Credit Segment
CaseProcessor CaseProcessor Case Processor
CaseResponsible CaseResponsible Case Responsible
CaseExternalReference CaseExternalReference Case External Reference
CreditCaseCreationDate CreditCaseCreationDate Case Creation Date
CreditCaseCloseDate CreditCaseCloseDate Case Close Date
CreditDecisionFirstApprover CreditDecisionFirstApprover Credit Case First Approver
CreditDecisionSecondApprover CreditDecisionSecondApprover Credit Case Second Approver
CreditDecisionFirstApprvlSts CreditDecisionFirstApprvlSts Credit Case First Approval Status
CreditDecisionSecondApprvlSts CreditDecisionSecondApprvlSts Credit Case Second Approval Status
CreditDecisionCompletedByUser CreditDecisionCompletedByUser Credit Decision Completed By User
StaticLmtUtilznCrdtChkIsFailed StaticLmtUtilznCrdtChkIsFailed Static Credit Limit Check Failed
CaseType CaseType Case Type
CrdtDcsnCompletedByUserName _CrdtDcsnCmpltdByUsrCntctCard UserDescription Credit Decision Completed By User Name
CrdtDcsnApprvlProcIsOverruled CrdtDcsnApprvlProcIsOverruled Approval Procedure was overruled
SalesEmployeeUserID SalesEmployeeUserID
DisplayCurrency DisplayCurrency Display Currency
CheckedCreditRiskAmount CheckedCrdtRiskAmountInDspCrcy Checked Credit Risk Amount
OpenCreditAmount OpenCreditAmountInDspCrcy Open Credit Amount
SalesDocumentType SalesDocumentType Sales Doc. Type
SalesDocumentTypeName _SalesDocumentType SalesDocumentTypeName Sales Document Type Name
CreationDate CreationDate Sales Document Creation Date
LastChangeDate LastChangeDate Sales Document Last Change Date
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
SoldToParty SoldToParty Sold-to Party
SalesDocumentDate SalesDocumentDate Sales Document Date
CustomerPurchaseOrderDate CustomerPurchaseOrderDate Customer Purchase Order Date
TotalNetAmount TotalNetAmountInDspCrcy Sales Document Total Net Amount
BillingCompanyCode BillingCompanyCode Billing Company Code
FiscalYear FiscalYear Fiscal Year
FiscalPeriod FiscalPeriod Fiscal Period
ReleasedCreditAmount ReleasedCreditAmountInDspCrcy Released Credit Amount
CreditBlockReleaseDate CreditBlockReleaseDate Credit Block Release Date
AccountingDocExternalReference AccountingDocExternalReference Accounting Document External Reference
_BusinessPartner _BusinessPartner

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_GRC_ReldCrdtDcsnDocument.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CUKMGRCDCDREL
-- Parameters: P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW C_GRC_ReldCrdtDcsnDocument AS
SELECT
  CaseUUID,
  SalesDocument,
  CaseID,
  BusinessPartner,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  CreditSegment,
  CaseProcessor,
  CaseResponsible,
  CaseExternalReference,
  CreditCaseCreationDate,
  CreditCaseCloseDate,
  CreditDecisionFirstApprover,
  CreditDecisionSecondApprover,
  CreditDecisionFirstApprvlSts,
  CreditDecisionSecondApprvlSts,
  CreditDecisionCompletedByUser,
  StaticLmtUtilznCrdtChkIsFailed,
  CaseType,
  _CrdtDcsnCmpltdByUsrCntctCard.UserDescription AS CrdtDcsnCompletedByUserName,
  CrdtDcsnApprvlProcIsOverruled,
  SalesEmployeeUserID,
  DisplayCurrency,
  CheckedCrdtRiskAmountInDspCrcy AS CheckedCreditRiskAmount,
  OpenCreditAmountInDspCrcy AS OpenCreditAmount,
  SalesDocumentType,
  _SalesDocumentType.SalesDocumentTypeName AS SalesDocumentTypeName,
  CreationDate,
  LastChangeDate,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldToParty,
  SalesDocumentDate,
  CustomerPurchaseOrderDate,
  TotalNetAmountInDspCrcy AS TotalNetAmount,
  BillingCompanyCode,
  FiscalYear,
  FiscalPeriod,
  ReleasedCreditAmountInDspCrcy AS ReleasedCreditAmount,
  CreditBlockReleaseDate,
  AccountingDocExternalReference
FROM P_UKM_GRC_DCD_1
;

Learn More