C_CACreditWorthinessTP

DDL: C_CACREDITWORTHINESSTP Type: view_entity CONSUMPTION
37 Fields 1 Data Sources 1 Associations

Creditworthiness - TP

C_CACreditWorthinessTP is a Consumption CDS View that provides data about "Creditworthiness - TP" in SAP S/4HANA. It reads from 1 data source (R_CACreditWorthinessTP) and exposes 37 fields with key field BusinessPartner. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_CACreditWorthinessTP R_CACreditWorthinessTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_CACreditworthinessMonthlyTot _MonthlyTotals $projection.BusinessPartner = _MonthlyTotals.BusinessPartner

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Creditworthiness - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey BusinessPartner view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
Search.searchable true view
UI.headerInfo.title.label Business Partner Full Name view
UI.headerInfo.title.value BusinessPartnerFullName view
UI.headerInfo.typeName Manage Creditworthiness view
UI.headerInfo.typeNamePlural Business Partner view
VDM.viewType #CONSUMPTION view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerFullName _CACreditWorthinessUI BusinessPartnerFullName Name of Businesspartner
FirstName _CACreditWorthinessUI FirstName First Name
LastName _CACreditWorthinessUI LastName Last Name
GroupBusinessPartnerName1 _CACreditWorthinessUI GroupBusinessPartnerName1 Name 1
GroupBusinessPartnerName2 _CACreditWorthinessUI GroupBusinessPartnerName2 Name 2
OrganizationBPName1 _CACreditWorthinessUI OrganizationBPName1 Name 1
OrganizationBPName2 _CACreditWorthinessUI OrganizationBPName2 Name 2
PostalCode _CACreditWorthinessUI PostalCode Postal Code
CityName _CACreditWorthinessUI CityName Name
StreetName _CACreditWorthinessUI StreetName Text
HouseNumber _CACreditWorthinessUI HouseNumber House Number
CompleteAddress _CACreditWorthinessUI CompleteAddress
AddressLine1 _CACreditWorthinessUI AddressLine1
AddressLine2 _CACreditWorthinessUI AddressLine2
AddressLine3 _CACreditWorthinessUI AddressLine3
virtualCACreditWorthinessbonit_kk FI-CA Creditworthiness
CAExternalCreditWorthinessVal CAExternalCreditWorthinessVal External Creditworthiness
CAExternalCreditWorthinessDate CAExternalCreditWorthinessDate Last Replicated at
CreditRiskClass _CACreditWorthinessUI CreditRiskClass Credit Risk Class
CreditRiskClassName
CACreditWorthinessFactorInPct CACreditWorthinessFactorInPct Credit Factor in %
CAManualCreditWorthinessValue CAManualCreditWorthinessValue Manual Creditworthiness
CAManualCreditWorthinessDate CAManualCreditWorthinessDate Date of Manual Creditworthiness
CAFrozenCreditWorthinessValue CAFrozenCreditWorthinessValue Fixed Creditworthiness
CAFrozenCreditWorthinessDate CAFrozenCreditWorthinessDate
CAUnfrozenCreditWorthinessDate CAUnfrozenCreditWorthinessDate
CACreditWorthinessIsFrozen CACreditWorthinessIsFrozen Creditworthiness Frozen
BusinessPartnerForEdit BusinessPartnerForEdit Busn. Partner
LastChangeDateTime LastChangeDateTime Last Change On
CALastReplicatedCrdtWrthnssVal CALastReplicatedCrdtWrthnssVal
CreationDate CreationDate Time Stamp
CreationTime CreationTime Creation Time
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Last Change Time
_MonthlyTotals _MonthlyTotals
_BusinessPartner _BusinessPartner

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_CACreditWorthinessTP.
-- 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_CACreditWorthinessTP AS
SELECT
  BusinessPartner,
  _CACreditWorthinessUI.BusinessPartnerFullName AS BusinessPartnerFullName,
  _CACreditWorthinessUI.FirstName AS FirstName,
  _CACreditWorthinessUI.LastName AS LastName,
  _CACreditWorthinessUI.GroupBusinessPartnerName1 AS GroupBusinessPartnerName1,
  _CACreditWorthinessUI.GroupBusinessPartnerName2 AS GroupBusinessPartnerName2,
  _CACreditWorthinessUI.OrganizationBPName1 AS OrganizationBPName1,
  _CACreditWorthinessUI.OrganizationBPName2 AS OrganizationBPName2,
  _CACreditWorthinessUI.PostalCode AS PostalCode,
  _CACreditWorthinessUI.CityName AS CityName,
  _CACreditWorthinessUI.StreetName AS StreetName,
  _CACreditWorthinessUI.HouseNumber AS HouseNumber,
  _CACreditWorthinessUI.CompleteAddress AS CompleteAddress,
  _CACreditWorthinessUI.AddressLine1 AS AddressLine1,
  _CACreditWorthinessUI.AddressLine2 AS AddressLine2,
  _CACreditWorthinessUI.AddressLine3 AS AddressLine3,
  virtual CACreditWorthiness : bonit_kk AS virtualCACreditWorthinessbonit_kk,
  CAExternalCreditWorthinessVal,
  CAExternalCreditWorthinessDate,
  _CACreditWorthinessUI.CreditRiskClass AS CreditRiskClass,
  _CACreditWorthinessUI._CreditRiskClass._Text[1: Language=$session.system_language].CreditRiskClassName AS CreditRiskClassName,
  CACreditWorthinessFactorInPct,
  CAManualCreditWorthinessValue,
  CAManualCreditWorthinessDate,
  CAFrozenCreditWorthinessValue,
  CAFrozenCreditWorthinessDate,
  CAUnfrozenCreditWorthinessDate,
  CACreditWorthinessIsFrozen,
  BusinessPartnerForEdit,
  LastChangeDateTime,
  CALastReplicatedCrdtWrthnssVal,
  CreationDate,
  CreationTime,
  LastChangeDate,
  LastChangeTime
FROM R_CACreditWorthinessTP
LEFT OUTER JOIN C_CACreditworthinessMonthlyTot AS _MonthlyTotals ON BusinessPartner = _MonthlyTotals.BusinessPartner  -- association [0..*]
;

Learn More