I_CreditDecisionDocumentC

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 I_CreditDecisionDocumentC.
-- 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: ICRDTDCSNDOCC
-- Parameters: P_KeyDate : sydate, P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst_curr, P_ReadLineItem : read_fiar_lineitems

CREATE VIEW I_CreditDecisionDocumentC AS
SELECT
  CaseUUID,
  CaseID,
  BusinessPartner,
  CreditSegment,
  cast( _BusinessPartner._CurrentDefaultAddress._StandardAddress.Country as farp_country preserving type) AS Country,
  _BusinessPartner._CurrentDefaultAddress._StandardAddress.Region AS Region,
  CreditRiskClass,
  cast( CaseProcessor as ukm_coordinator preserving type ) AS CaseProcessor,
  cast( CaseResponsible as fis_responsible preserving type ) AS CaseResponsible,
  CaseCreatedBy,
  CaseLastChangedBy,
  CaseClosedBy,
  CaseReason,
  CaseType,
  CaseStatusProfile,
  CaseSystemStatus,
  CaseStatus,
  CasePriority,
  CaseEscalationReason,
  CaseCategory,
  CrdtMgmtBusinessPartnerGroup,
  cast( NumberOfCreditDecisionDocs as numberofcreditdecisiondocs ) AS NumberOfCreditDecisionDocs,
  cast( CaseCreationDate as scmg_create_date preserving type ) AS CaseCreationDate,
  cast( CaseLastChangeDate as scmg_change_date preserving type ) AS CaseLastChangeDate,
  cast( CaseClosingDate as scmg_closing_date preserving type ) AS CaseClosingDate,
  cast( CasePlannedCloseDate as scmg_plan_end_date preserving type ) AS CasePlannedCloseDate,
  cast ( CaseIsClosed as case_is_closed preserving type ) AS CaseIsClosed,
  cast( NmbrOfDaysPlndClsDateExceeded as numberofdaysafterplannedclose preserving type ) AS NmbrOfDaysPlndClsDateExceeded,
  CreditDecisionObjectType,
  cast( CreditDecisionSalesDocument as vbeln ) AS CreditDecisionSalesDocument,
  SalesDocumentCreditStatus,
  CreditDecisionReqUTCDateTime,
  CreditDecisionFirstApprover,
  CreditDecisionSecondApprover,
  cast( CreditDecisionFirstApprvlSts as fis_approval_status1 preserving type ) AS CreditDecisionFirstApprvlSts,
  cast( CreditDecisionSecondApprvlSts as fis_approval_status2 preserving type ) AS CreditDecisionSecondApprvlSts,
  CreditDecisionCompletedByUser,
  CrdtDcsnApprvlProcIsOverruled,
  StaticLmtUtilznCrdtChkIsFailed,
  MaxDocAmountCreditChkIsFailed,
  DynLimitUtilznCrdtChkIsFailed,
  MaxDunningLevelCrdtChkIsFailed,
  OldestOpenItemCrdtChkIsFailed,
  DaysSlsOutStdgCrdtChkIsFailed,
  OtherCreditCheckIsFailed,
  OverdueOpenItemCrdtChkIsFailed,
  DisplayCurrency,
  cast( OpenCreditAmount as ukm_open_credit_amount preserving type ) AS OpenCreditAmount,
  cast( CheckedCreditRiskAmount as ukm_checked_credit_risk_amount preserving type ) AS CheckedCreditRiskAmount
FROM P_DCD_2
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentBasic AS _SalesDocument ON CreditDecisionSalesDocument = _SalesDocument.SalesDocument AND CreditDecisionObjectType = 'VBAK'  -- association [1..1]
LEFT OUTER JOIN I_DeliveryDocument AS _DeliveryDocument ON CreditDecisionSalesDocument = _DeliveryDocument.DeliveryDocument AND CreditDecisionObjectType = 'LIKP'  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _DisplayCurrency ON DisplayCurrency = _DisplayCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_Region AS _Region ON Country = _Region.Country AND Region = _Region.Region  -- association [0..1]
LEFT OUTER JOIN I_CreditManagementSegment AS _CreditSegment ON CreditSegment = _CreditSegment.CreditSegment  -- association [1..1]
LEFT OUTER JOIN I_CreditRiskClass AS _CreditRiskClass ON CreditRiskClass = _CreditRiskClass.CreditRiskClass  -- association [0..1]
LEFT OUTER JOIN I_CreditCaseContact AS _Processor ON CaseProcessor = _Processor.UserID  -- association [0..1]
LEFT OUTER JOIN I_CreditCaseContact AS _Responsible ON CaseResponsible = _Responsible.UserID  -- association [0..1]
LEFT OUTER JOIN I_CaseReasons AS _Reasons ON CaseReason = _Reasons.CaseReason AND CaseType = _Reasons.CaseType  -- association [0..1]
LEFT OUTER JOIN I_Casetypes AS _CaseTypes ON CaseType = _CaseTypes.CaseType  -- association [0..1]
LEFT OUTER JOIN I_CaseStatusProfile AS _StatusProfile ON CaseStatusProfile = _StatusProfile.CaseStatusProfile  -- association [0..1]
LEFT OUTER JOIN I_CaseStatus AS _CaseSystemStatus ON CaseSystemStatus = _CaseSystemStatus.Status  -- association [0..1]
LEFT OUTER JOIN I_CasePriority AS _Priority ON CasePriority = _Priority.CasePriority  -- association [0..1]
LEFT OUTER JOIN I_CaseCategory AS _Category ON CaseType = _Category.CaseType AND CaseCategory = _Category.CaseCategory  -- association [0..1]
LEFT OUTER JOIN I_Caseindividualstatus AS _Individual ON CaseStatus = _Individual.CaseStatus AND CaseStatusProfile = _Individual.CaseStatusProfile  -- association [0..1]
LEFT OUTER JOIN I_CrdtMBusPartnerGroup AS _CrdtMBusPartnerGroup ON CrdtMgmtBusinessPartnerGroup = _CrdtMBusPartnerGroup.CrdtMgmtBusinessPartnerGroup  -- association [0..1]
LEFT OUTER JOIN I_CreditAccountExtended AS _CreditAccountExtended ON BusinessPartner = _CreditAccountExtended.BusinessPartner AND CreditSegment = _CreditAccountExtended.CreditSegment  -- association [0..1]
;