R_CrdtMAccountMainAnalyst

DDL: R_CRDTMACCOUNTMAINANALYST Type: view_entity TRANSACTIONAL
9 Fields 1 Data Sources 1 Associations

Main Credit Analyst

R_CrdtMAccountMainAnalyst is a Transactional CDS View that provides data about "Main Credit Analyst" in SAP S/4HANA. It reads from 1 data source (P_CrdtMAccountMainAnalyst) and exposes 9 fields with key fields RelationshipNumber, BusinessPartner, CreditSegment. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_CrdtMAccountMainAnalyst P_CrdtMAccountMainAnalyst from

Associations (1)

CardinalityTargetAliasCondition
[0..1] R_CrdtMAccountAnalystTP _CreditAnalyst $projection.RelationshipNumber = _CreditAnalyst.RelationshipNumber and $projection.BusinessPartner = _CreditAnalyst.BusinessPartner and $projection.CreditSegment = _CreditAnalyst.CreditSegment

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Main Credit Analyst view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey RelationshipNumber view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY RelationshipNumber RelationshipNumber BP Rel. Number
KEY BusinessPartner BusinessPartner Issuing Authority
KEY CreditSegment CreditSegment Credit Segment
CreditAnalyst _CreditAnalyst CreditAnalyst Credit Analyst
ValidityEndDate _CreditAnalyst ValidityEndDate ValidTo
UserID _CreditAnalyst UserID User Name
_CreditAnalyst _CreditAnalyst
_CreditAnalystContactCard _CreditAnalyst _CreditAnalystContactCard
_BusinessUser _CreditAnalyst _BusinessUser

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_CrdtMAccountMainAnalyst.
-- 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_CrdtMAccountMainAnalyst AS
SELECT
  RelationshipNumber,
  BusinessPartner,
  CreditSegment,
  _CreditAnalyst.CreditAnalyst AS CreditAnalyst,
  _CreditAnalyst.ValidityEndDate AS ValidityEndDate,
  _CreditAnalyst.UserID AS UserID,
  _CreditAnalyst._CreditAnalystContactCard AS _CreditAnalystContactCard,
  _CreditAnalyst._BusinessUser AS _BusinessUser
FROM P_CrdtMAccountMainAnalyst
LEFT OUTER JOIN R_CrdtMAccountAnalystTP AS _CreditAnalyst ON RelationshipNumber = _CreditAnalyst.RelationshipNumber AND BusinessPartner = _CreditAnalyst.BusinessPartner AND CreditSegment = _CreditAnalyst.CreditSegment  -- association [0..1]
;

Learn More