C_CreditDecisionDocumentTP

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_CreditDecisionDocumentTP.
-- 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.

CREATE VIEW C_CreditDecisionDocumentTP AS
SELECT
  CaseUUID,
  CaseID,
  BusinessPartner,
  CreditSegment,
  CreditRiskClass,
  CaseProcessor,
  CaseResponsible,
  CaseExternalReference,
  CaseTitle,
  CaseCreatedBy,
  CreditCaseCreationDateTime,
  CaseLastChangedBy,
  CreditCaseLastChangeDateTime,
  CaseClosedBy,
  CreditCaseCloseDateTime,
  CasePlannedCloseDate,
  CaseReason,
  CaseType,
  CaseStatusProfile,
  CaseStatus,
  CaseSystemStatus,
  CasePriority,
  CaseAuthorizationLevel,
  CaseEscalationReason,
  CaseCategory,
  CaseStatusObjectNumber,
  CaseSystemStatusName,
  CaseUserStatusName,
  CreditDecisionCurrency,
  OpenCreditAmount,
  CheckedCreditRiskAmount,
  CrdtMgmtBusinessPartnerGroup,
  CreditCheckLog,
  CreditDecisionObjectType,
  CreditDecisionReferenceDoc,
  SourceLogicalSystem,
  SalesDocumentCreditStatus,
  CreditDecisionReqUTCDateTime,
  CreditDecisionFirstApprover,
  CreditDecisionSecondApprover,
  CreditDecisionFirstApprvlSts,
  CreditDecisionSecondApprvlSts,
  CreditDecisionCompletedByUser,
  CrdtDcsnApprvlProcIsOverruled,
  StaticLmtUtilznCrdtChkIsFailed,
  MaxDocAmountCreditChkIsFailed,
  DynLimitUtilznCrdtChkIsFailed,
  MaxDunningLevelCrdtChkIsFailed,
  OldestOpenItemCrdtChkIsFailed,
  DaysSlsOutStdgCrdtChkIsFailed,
  OverdueOpenItemCrdtChkIsFailed,
  OtherCreditCheckIsFailed,
  LimitValidityCrdtChkIsFailed,
  SalesEmployeeUserID,
  IsApprovalRelevant,
  _CaseTypes.CaseAttributeProfile AS CaseAttributeProfile,
  _CreditManagementBP.CreditRiskClass AS CurrentCreditRiskClass,
  _CreditManagementAccount.CreditLimitAmount AS CreditLimitAmount,
  _CreditManagementAccount.CreditSegmentCurrency AS CreditSegmentCurrency,
  _BrokenPromisesToPay.NumberOfBrokenPromisesToPay AS NumberOfBrokenPromisesToPay,
  _CreatedByUserContactCard.UserDescription AS CaseCreatedByUserName,
  _LastChangeUserContactCard.UserDescription AS CaseLastChangedByUserName,
  _ClosedByUserContactCard.UserDescription AS CaseClosedByUserName,
  _CrdtDcsnCmpltdByUsrCntctCard.UserDescription AS CrdtDcsnCompletedByUserName,
  _CrdtDcsn1stApprvrContactCard.UserDescription AS CrdtDcsnFirstApproverName,
  _CrdtDcsn2ndApprvrContactCard.UserDescription AS CrdtDcsnSecondApproverName,
  _CaseResponsibleContactCard.UserDescription AS CaseResponsibleName,
  _CaseProcessorContactCard.UserDescription AS CaseProcessorName,
  _SalesEmployeeContactCard.UserDescription AS SalesEmployeeName,
  _SalesDocumentCreditStatus._Text.SalesDocumentCreditStatusName : localized AS SalesDocumentCreditStatusNamelocalized,
  _Priority._Text.CasePriorityName : localized AS CasePriorityNamelocalized,
  _Escalation._Text.CaseEscalationReasonName : localized AS CaseEscalationReasonNamelocalized,
  _Reasons._Text.CaseReasonName : localized AS CaseReasonNamelocalized,
  _CreditSegment._Text.CreditSegmentName : localized AS CreditSegmentNamelocalized,
  _Individual._Text.CaseStatusName : localized AS CaseStatusNamelocalized,
  _CaseCategory._Text.CaseCategoryName : localized AS CaseCategoryNamelocalized,
  _CreditRiskClass._Text.CreditRiskClassName : localized AS CreditRiskClassNamelocalized,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _BusinessPartner.OrganizationBPName1 AS OrganizationBPName1,
  _BusinessPartner.OrganizationBPName2 AS OrganizationBPName2,
  _CaseProcessorContactCard.FirstName AS UICT_ProcessorFirstName,
  _CaseProcessorContactCard.LastName AS UICT_ProcessorLastName,
  _CaseResponsibleContactCard.FirstName AS UICT_ResponsibleFirstName,
  _CaseResponsibleContactCard.LastName AS UICT_ResponsibleLastName,
  _CreatedByUserContactCard.FirstName AS UICT_CreatedByFirstName,
  _CreatedByUserContactCard.LastName AS UICT_CreatedByLastName,
  _LastChangeUserContactCard.FirstName AS UICT_ChangedByFirstName,
  _LastChangeUserContactCard.LastName AS UICT_ChangedByLastName,
  _ClosedByUserContactCard.FirstName AS UICT_ClosedByFirstName,
  _ClosedByUserContactCard.LastName AS UICT_ClosedByLastName,
  virtual NoteTypeListText : text200 AS virtualNoteTypeListTexttext200,
  virtual PlannedCloseDateIsExceeded : boolean AS virtualPlannedCloseDateIsExceededboolean,
  virtual PlannedCloseDateCriticality : char1 AS virtualPlannedCloseDateCriticalitychar1,
  virtual UICT_FirstApprover : boolean AS virtualUICT_FirstApproverboolean,
  virtual UICT_SecondApprover : boolean AS virtualUICT_SecondApproverboolean,
  virtual SemanticObject : text40 AS virtualSemanticObjecttext40,
  virtual UICT_IsApprovalRelevant : boolean AS virtualUICT_IsApprovalRelevantboolean
FROM R_CreditDecisionDocumentTP
LEFT OUTER JOIN C_CreditDecisionDocumentLog AS _CreditDecisionDocumentLog ON CaseUUID = _CreditDecisionDocumentLog.CaseUUID  -- association [0..*]
LEFT OUTER JOIN C_CreditDecisionDocLinkdObj AS _CreditDecisionDocLinkdObj ON CaseUUID = _CreditDecisionDocLinkdObj.CaseUUID  -- association [0..*]
LEFT OUTER JOIN C_CreditDecisionDocRjcnReason AS _CreditDecisionDocRjcnReason ON CaseID = _CreditDecisionDocRjcnReason.CaseID  -- association [0..*]
LEFT OUTER JOIN C_CreditWorthinessScoreTrend AS _CreditWorthinessScoreTrend ON BusinessPartner = _CreditWorthinessScoreTrend.ChangeDocObject  -- association [0..*]
LEFT OUTER JOIN C_CrdtMAcctAgingGrid AS _AgingGrid ON BusinessPartner = _AgingGrid.BusinessPartner AND CreditSegment = _AgingGrid.CreditSegment  -- association [0..*]
LEFT OUTER JOIN C_CreditLimitTrend AS _CreditLimitTrend ON BusinessPartner = _CreditLimitTrend.ChangeDocObject AND CreditSegment = _CreditLimitTrend.CreditSegment  -- association [0..*]
LEFT OUTER JOIN C_CreditDecisionDocumentSnpsht AS _Snapshot ON CaseUUID = _Snapshot.CaseUUID  -- association [0..*]
;