R_CreditMgmtAccountTP

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_CreditMgmtAccountTP.
-- 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_CreditMgmtAccountTP AS
SELECT
  BusinessPartner,
  CreditSegment,
  BusinessPartnerIsCritical,
  CreditAccountIsBlocked,
  CreditAccountBlockReason,
  CreditAccountResubmissionDate,
  CreditLimitAmount,
  CreditLimitValidityEndDate,
  CreditLimitLastChangeDate,
  CreditLimitCalculatedAmount,
  CreditLimitIsDefined,
  CreditLimitIsZero,
  CreditLimitRequestedAmount,
  CrdtLmtIsReqdFrmAutomCalc,
  CreditLimitReqdValidityEndDate,
  CreditLimitRequestDate,
  CreditSegmentCurrency,
  cast( hextobin( '00000000000000000000000000000000' ) as sdraft_key ) AS CrdtMAccountNoteUUID
FROM R_CreditMgmtAccount
LEFT OUTER JOIN R_CreditDecisionDocumentTP AS _CreditDecisionDocument ON _CreditDecisionDocument.BusinessPartner = BusinessPartner AND _CreditDecisionDocument.CreditSegment = CreditSegment AND _CreditDecisionDocument.CaseSystemStatus != '009'  -- association [0..*]
LEFT OUTER JOIN R_CreditDecisionDocumentTP_2 AS _CreditDecisionDocument2 ON _CreditDecisionDocument2.BusinessPartner = BusinessPartner AND _CreditDecisionDocument2.CreditSegment = CreditSegment  -- association [0..*]
LEFT OUTER JOIN R_CreditLimitRequestTP AS _CreditLimitRequest ON _CreditLimitRequest.BusinessPartner = BusinessPartner AND _CreditLimitRequest.CreditSegment = CreditSegment AND _CreditLimitRequest.CaseSystemStatus != '009'  -- association [0..*]
LEFT OUTER JOIN R_CrdtMAcctRelationshipTP AS _CrdtMAcctRelationshipTP ON _CrdtMAcctRelationshipTP.BusinessPartner = BusinessPartner AND _CrdtMAcctRelationshipTP.CreditSegment = CreditSegment  -- association [0..*]
LEFT OUTER JOIN R_CrdtMAcctPaytBehaviorTP AS _CrdtMAcctPaytBehaviorTP ON _CrdtMAcctPaytBehaviorTP.BusinessPartner = BusinessPartner AND _CrdtMAcctPaytBehaviorTP.CreditSegment = CreditSegment  -- association [0..1]
LEFT OUTER JOIN I_CrdtMNrOfBrokenPromisesToPay AS _BrokenPromisesToPay ON BusinessPartner = _BrokenPromisesToPay.BusinessPartner AND CreditSegment = _BrokenPromisesToPay.CreditSegment  -- association [0..1]
LEFT OUTER JOIN E_CreditMgmtAccount AS _Extension ON BusinessPartner = _Extension.BusinessPartner AND CreditSegment = _Extension.CreditSegment  -- association [1]
LEFT OUTER JOIN I_CreditAccountPrediction AS _CreditAccountPrediction ON BusinessPartner = _CreditAccountPrediction.BusinessPartner AND CreditSegment = _CreditAccountPrediction.CreditSegment  -- association [0..1]
LEFT OUTER JOIN R_CrdtMAccountAnalystTP AS _CrdtMAccountAnalystTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CrdtMAcctCollateralTP AS _CrdtMAcctCollateralTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CrdtMAcctCrdtInsuranceTP AS _CrdtMAcctCrdtInsuranceTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CrdtMAcctTmpLimitIncrTP AS _CrdtMAcctTmpLimitIncrTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CrdtMAcctSpprsdChkStepTP AS _CrdtMAcctSpprsdChkStepTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CrdtMFmlaLimitEvalResultTP AS _CrdtMFmlaLimitEvalResultTP ON /* condition not available in parsed metadata */  -- association [0..*]
;