C_CrdtMAccountAnalystTP

DDL: C_CRDTMACCOUNTANALYSTTP Type: view_entity CONSUMPTION
21 Fields 1 Data Sources

Credit Analyst

C_CrdtMAccountAnalystTP is a Consumption CDS View that provides data about "Credit Analyst" in SAP S/4HANA. It reads from 1 data source (R_CrdtMAccountAnalystTP) and exposes 21 fields with key fields RelationshipNumber, CreditAnalyst, BusinessPartner, CreditSegment, ValidityEndDate.

Data Sources (1)

SourceAliasJoin Type
R_CrdtMAccountAnalystTP R_CrdtMAccountAnalystTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Credit Analyst view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #X view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.allowExtensions true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY RelationshipNumber RelationshipNumber BP Rel. Number
KEY CreditAnalyst CreditAnalyst Credit Analyst
KEY BusinessPartner BusinessPartner Issuing Authority
KEY CreditSegment CreditSegment Credit Segment
KEY ValidityEndDate ValidityEndDate ValidTo
BusinessPartnerName _CreditAnalyst BusinessPartnerName Extracted Customer Name
Country
CityName
PostalCode
StreetName
HouseNumber
AddressID AddressID Ship-to address
UserID UserID User Name
UserDescription _CreditAnalystContactCard UserDescription Full Name
CreatedByUser CreatedByUser User Name
CreatedByUserName _CreatedByContactCard UserDescription Full Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
_BusinessPartner _BusinessPartner
_CreditAnalyst _CreditAnalyst
_BusinessUser _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 C_CrdtMAccountAnalystTP.
-- 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 C_CrdtMAccountAnalystTP AS
SELECT
  RelationshipNumber,
  CreditAnalyst,
  BusinessPartner,
  CreditSegment,
  ValidityEndDate,
  _CreditAnalyst.BusinessPartnerName AS BusinessPartnerName,
  cast (_CreditAnalyst._CurrentDefaultAddress._Address.Country as land1 preserving type) AS Country,
  cast (_CreditAnalyst._CurrentDefaultAddress._Address.CityName as ad_city1 preserving type ) AS CityName,
  cast (_CreditAnalyst._CurrentDefaultAddress._Address.PostalCode as ad_pstcd1 preserving type) AS PostalCode,
  cast (_CreditAnalyst._CurrentDefaultAddress._Address.StreetName as ad_street preserving type) AS StreetName,
  cast (_CreditAnalyst._CurrentDefaultAddress._Address.HouseNumber as ad_hsnm1 preserving type) AS HouseNumber,
  AddressID,
  UserID,
  _CreditAnalystContactCard.UserDescription AS UserDescription,
  CreatedByUser,
  _CreatedByContactCard.UserDescription AS CreatedByUserName,
  CreationDate,
  CreationTime
FROM R_CrdtMAccountAnalystTP
;

Learn More