I_CreditAccountExtended

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

CREATE VIEW I_CreditAccountExtended AS
SELECT
  BusinessPartner,
  cast( CreditSegment as farp_credit_segment preserving type ) AS CreditSegment,
  cast( _Partner.CreditRiskClass as farp_risk_class preserving type ) AS CreditRiskClass,
  cast( _BusinessPartner._CurrentDefaultAddress._StandardAddress.Country as farp_country preserving type) AS Country,
  _BusinessPartner._CurrentDefaultAddress._StandardAddress.Region AS Region,
  DisplayCurrency,
  cast( CustomerCreditExposureAmount as farp_credit_exposure preserving type ) AS CustomerCreditExposureAmount,
  cast( CustomerCreditLimitAmount as farp_creditlimit_amt preserving type ) AS CustomerCreditLimitAmount,
  cast( CreditLimitCalculatedAmount as farp_credlimit_calculated_amt preserving type ) AS CreditLimitCalculatedAmount,
  cast( CreditLimitRequestedAmount as farp_credlimit_requested_amt preserving type ) AS CreditLimitRequestedAmount,
  cast( NumberOfBusinessPartners as farp_number_of_bp ) AS NumberOfBusinessPartners,
  cast( CrdtLimitIsEqualCrdtLimitCalcd as farp_crdtlmtisequalcrdtlmtcalc preserving type ) AS CrdtLimitIsEqualCrdtLimitCalcd,
  cast( CrdtLimitIsEqualCrdtLimitReqd as farp_crdtlmt_eq_rdtlmtreqd ) AS CrdtLimitIsEqualCrdtLimitReqd,
  cast( CreditAccountIsBlocked as farp_crdtacct_is_blocked preserving type ) AS CreditAccountIsBlocked,
  cast( CreditLimitValidityEndDate as farp_crdtlmt_validity_enddate preserving type ) AS CreditLimitValidityEndDate,
  cast( CreditLimitLastChangeDate as farp_crdt_lmt_last_change_date preserving type ) AS CreditLimitLastChangeDate,
  cast( _Partner.CreditAccountGroup as ukm_cred_group ) AS CreditAccountGroup,
  cast(_Partner.CrdtMgmtBusinessPartnerGroup as ukm_cred_group preserving type) AS CrdtMgmtBusinessPartnerGroup,
  cast( CreditAccountResubmissionDate as ukm_follow_up_dt preserving type ) AS CreditAccountResubmissionDate,
  cast( BusinessPartnerIsCritical as farp_critical_account preserving type ) AS BusinessPartnerIsCritical,
  cast( CreditLimitIsZero as farp_crdtlmt_is_zero preserving type ) AS CreditLimitIsZero,
  cast( CreditAccountBlockReason as farp_crdtacct_block_reason preserving type ) AS CreditAccountBlockReason,
  cast( CrdtLmtIsReqdFrmAutomCalc as farp_crdtlmt_reqdfrm_automcalc preserving type ) AS CrdtLmtIsReqdFrmAutomCalc,
  cast( CreditLimitReqdValidityEndDate as farp_crdtlmt_reqd_enddate preserving type ) AS CreditLimitReqdValidityEndDate,
  cast( CreditLimitRequestDate as farp_crdtlmt_reqd_date preserving type ) AS CreditLimitRequestDate,
  cast( CrdtLimitValidityRemainingDays as farp_crdtlmt_remaining_days preserving type ) AS CrdtLimitValidityRemainingDays,
  cast( CreditLimitLastChangeDays as farp_crdtlmt_last_change_days preserving type ) AS CreditLimitLastChangeDays,
  :P_ExchangeRateType AS ExchangeRateType
FROM P_CreditAccountData
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CreditManagementBP AS _Partner ON BusinessPartner = _Partner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DisplayCurrency ON DisplayCurrency = _DisplayCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_CreditRiskClass AS _CreditRiskClass ON CreditRiskClass = _CreditRiskClass.CreditRiskClass  -- 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 [0..1]
LEFT OUTER JOIN I_CustomerCreditGroup AS _CustomerCreditGroup ON CreditAccountGroup = _CustomerCreditGroup.CreditAccountGroup  -- association [0..1]
LEFT OUTER JOIN I_CrdtMBusPartnerGroup AS _CrdtMBusPartnerGroup ON CrdtMgmtBusinessPartnerGroup = _CrdtMBusPartnerGroup.CrdtMgmtBusinessPartnerGroup  -- association [0..1]
LEFT OUTER JOIN I_CreditBlockReason AS _BlockReason ON CreditAccountBlockReason = _BlockReason.CreditAccountBlockReason  -- association [0..1]
;