I_CreditManagementAccount

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_CreditManagementAccount.
-- 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: ICREDMGMNTACCNT

CREATE VIEW I_CreditManagementAccount AS
SELECT
  partner AS BusinessPartner,
  cast( credit_sgmnt as ukm_credit_sgmnt preserving type ) AS CreditSegment,
  _CreditSegment.CreditSegmentCurrency AS CreditSegmentCurrency,
  credit_limit AS CustomerCreditLimitAmount,
  cred_lim_calc AS CreditLimitCalculatedAmount,
  cred_lim_req AS CreditLimitRequestedAmount,
  xblocked AS CreditAccountIsBlocked,
  limit_valid_date AS CreditLimitValidityEndDate,
  limit_chg_date AS CreditLimitLastChangeDate,
  coordinator AS CreditCoordinator,
  follow_up_dt AS CreditAccountResubmissionDate,
  cast( xcritical as ukm_critical_account preserving type ) AS BusinessPartnerIsCritical,
  x_limit_zero AS CreditLimitIsZero,
  block_reason AS CreditAccountBlockReason,
  automatic_req AS CrdtLmtIsReqdFrmAutomCalc,
  lim_val_date_req AS CreditLimitReqdValidityEndDate,
  req_date AS CreditLimitRequestDate
FROM ukmbp_cms_sgm
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CreditManagementBP AS _CreditAccount ON BusinessPartner = _CreditAccount.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CreditManagementSegment AS _CreditSegment ON CreditSegment = _CreditSegment.CreditSegment  -- association [1..1]
LEFT OUTER JOIN I_CreditBlockReason AS _CreditBlockReason ON CreditAccountBlockReason = _CreditBlockReason.CreditAccountBlockReason  -- association [0..1]
;