R_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 R_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 R_CreditDecisionDocumentTP AS
SELECT
  CaseUUID,
  CaseID,
  BusinessPartner,
  CreditSegment,
  CreditRiskClass,
  CaseProcessor,
  CaseResponsible,
  CaseExternalReference,
  CaseTitle,
  CaseCreatedBy,
  CaseCreatedOn AS CreditCaseCreationDateTime,
  CaseLastChangedBy,
  CaseLastChangedOn AS CreditCaseLastChangeDateTime,
  CaseClosedBy,
  CaseClosedTime AS CreditCaseCloseDateTime,
  CasePlannedCloseDate,
  CaseReason,
  CaseType,
  CaseStatusProfile,
  CaseStatus,
  CaseSystemStatus,
  CasePriority,
  CaseAuthorizationLevel,
  CaseEscalationReason,
  CaseCategory,
  CaseStatusObjectNumber,
  CaseSystemStatusName,
  CaseUserStatusName,
  CreditDecisionCurrency,
  OpenCreditAmount,
  CheckedCreditRiskAmount,
  CrdtMgmtBusinessPartnerGroup,
  cast( CreditCheckLog as ukm_dcd_checklog_id preserving type ) AS CreditCheckLog,
  CreditDecisionObjectType,
  CreditDecisionReferenceDoc,
  SourceLogicalSystem,
  SalesDocumentCreditStatus,
  cast( CreditDecisionReqUTCDateTime as ukm_create_time ) AS CreditDecisionReqUTCDateTime,
  CreditDecisionFirstApprover,
  CreditDecisionSecondApprover,
  CreditDecisionFirstApprvlSts,
  CreditDecisionSecondApprvlSts,
  CreditDecisionCompletedByUser,
  CrdtDcsnApprvlProcIsOverruled,
  cast( StaticLmtUtilznCrdtChkIsFailed as ukm_dcd_check_step_010 preserving type ) AS StaticLmtUtilznCrdtChkIsFailed,
  cast( MaxDocAmountCreditChkIsFailed as ukm_dcd_check_step_020 preserving type ) AS MaxDocAmountCreditChkIsFailed,
  cast( DynLimitUtilznCrdtChkIsFailed as ukm_dcd_check_step_030 preserving type ) AS DynLimitUtilznCrdtChkIsFailed,
  cast( MaxDunningLevelCrdtChkIsFailed as ukm_dcd_check_step_100 preserving type ) AS MaxDunningLevelCrdtChkIsFailed,
  cast( OldestOpenItemCrdtChkIsFailed as ukm_dcd_check_step_110 preserving type ) AS OldestOpenItemCrdtChkIsFailed,
  cast( DaysSlsOutStdgCrdtChkIsFailed as ukm_dcd_check_step_120 preserving type ) AS DaysSlsOutStdgCrdtChkIsFailed,
  cast( OverdueOpenItemCrdtChkIsFailed as ukm_dcd_check_step_130 preserving type ) AS OverdueOpenItemCrdtChkIsFailed,
  cast( OtherCreditCheckIsFailed as ukm_dcd_other_check_steps preserving type ) AS OtherCreditCheckIsFailed,
  cast( LimitValidityCrdtChkIsFailed as ukm_dcd_check_step_140 preserving type ) AS LimitValidityCrdtChkIsFailed,
  SalesEmployeeUserID,
  IsApprovalRelevant
FROM I_CreditDecisionDocument
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _CreatedByUserContactCard ON CaseCreatedBy = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _LastChangeUserContactCard ON CaseLastChangedBy = _LastChangeUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _ClosedByUserContactCard ON CaseClosedBy = _ClosedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _CaseProcessorContactCard ON CaseProcessor = _CaseProcessorContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _CaseResponsibleContactCard ON CaseResponsible = _CaseResponsibleContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _CrdtDcsnCmpltdByUsrCntctCard ON CreditDecisionCompletedByUser = _CrdtDcsnCmpltdByUsrCntctCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _CrdtDcsn1stApprvrContactCard ON CreditDecisionFirstApprover = _CrdtDcsn1stApprvrContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _CrdtDcsn2ndApprvrContactCard ON CreditDecisionSecondApprover = _CrdtDcsn2ndApprvrContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _SalesEmployeeContactCard ON SalesEmployeeUserID = _SalesEmployeeContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_CrdtDcsnCheckStepResult AS _CreditCheckStep010 ON StaticLmtUtilznCrdtChkIsFailed = _CreditCheckStep010.CreditDecisionCheckStepResult  -- association [0..1]
LEFT OUTER JOIN I_CrdtDcsnCheckStepResult AS _CreditCheckStep020 ON MaxDocAmountCreditChkIsFailed = _CreditCheckStep020.CreditDecisionCheckStepResult  -- association [0..1]
LEFT OUTER JOIN I_CrdtDcsnCheckStepResult AS _CreditCheckStep030 ON DynLimitUtilznCrdtChkIsFailed = _CreditCheckStep030.CreditDecisionCheckStepResult  -- association [0..1]
LEFT OUTER JOIN I_CrdtDcsnCheckStepResult AS _CreditCheckStep100 ON MaxDunningLevelCrdtChkIsFailed = _CreditCheckStep100.CreditDecisionCheckStepResult  -- association [0..1]
LEFT OUTER JOIN I_CrdtDcsnCheckStepResult AS _CreditCheckStep110 ON OldestOpenItemCrdtChkIsFailed = _CreditCheckStep110.CreditDecisionCheckStepResult  -- association [0..1]
LEFT OUTER JOIN I_CrdtDcsnCheckStepResult AS _CreditCheckStep120 ON DaysSlsOutStdgCrdtChkIsFailed = _CreditCheckStep120.CreditDecisionCheckStepResult  -- association [0..1]
LEFT OUTER JOIN I_CrdtDcsnCheckStepResult AS _CreditCheckStep130 ON OverdueOpenItemCrdtChkIsFailed = _CreditCheckStep130.CreditDecisionCheckStepResult  -- association [0..1]
LEFT OUTER JOIN I_CrdtDcsnCheckStepResult AS _OtherCreditCheckSteps ON OtherCreditCheckIsFailed = _OtherCreditCheckSteps.CreditDecisionCheckStepResult  -- association [0..1]
LEFT OUTER JOIN I_CrdtDcsnCheckStepResult AS _CreditCheckStep140 ON LimitValidityCrdtChkIsFailed = _CreditCheckStep140.CreditDecisionCheckStepResult  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentCreditStatus AS _SalesDocumentCreditStatus ON SalesDocumentCreditStatus = _SalesDocumentCreditStatus.SalesDocumentCreditStatus  -- association [0..1]
LEFT OUTER JOIN R_CreditMgmtAccountTP AS _CreditManagementAccount ON BusinessPartner = _CreditManagementAccount.BusinessPartner AND CreditSegment = _CreditManagementAccount.CreditSegment  -- association [0..1]
LEFT OUTER JOIN R_CrdtMBusinessPartnerTP AS _CreditManagementBP ON BusinessPartner = _CreditManagementBP.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CrdtMNrOfBrokenPromisesToPay AS _BrokenPromisesToPay ON BusinessPartner = _BrokenPromisesToPay.BusinessPartner AND CreditSegment = _BrokenPromisesToPay.CreditSegment  -- association [0..1]
LEFT OUTER JOIN R_CrdtMgmtBPQuickViewTP AS _QuickView ON BusinessPartner = _QuickView.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN E_CreditDecisionDocument AS _Extension ON CaseUUID = _Extension.CaseUUID  -- association [1]
LEFT OUTER JOIN R_CrdtDcsnDocApprvlHierTP AS _ApprovalHierarchy ON /* condition not available in parsed metadata */  -- association [0..*]
;