A_CrdtMBusinessPartner

DDL: A_CRDTMBUSINESSPARTNER Type: view_entity CONSUMPTION

Business Partners

A_CrdtMBusinessPartner is a Consumption CDS View that provides data about "Business Partners" in SAP S/4HANA. It reads from 1 data source (R_CrdtMBusinessPartnerTP) and exposes 13 fields with key field BusinessPartner. It is exposed through 1 OData service (API_CRDTMBUSINESSPARTNER).

Data Sources (1)

SourceAliasJoin Type
R_CrdtMBusinessPartnerTP R_CrdtMBusinessPartnerTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Business Partners view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
API_CRDTMBUSINESSPARTNER API_CRDTMBUSINESSPARTNER V2 C2 C1

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner Issuing Authority
CrdtMgmtBusinessPartnerGroup CrdtMgmtBusinessPartnerGroup
CreditWorthinessScoreValue CreditWorthinessScoreValue
CrdtWrthnssScoreValdtyEndDate CrdtWrthnssScoreValdtyEndDate
CrdtWorthinessScoreLastChgDate CrdtWorthinessScoreLastChgDate
CalcdCrdtWorthinessScoreValue CalcdCrdtWorthinessScoreValue
CreditRiskClass CreditRiskClass Credit Risk Class
CalculatedCreditRiskClass CalculatedCreditRiskClass
CreditRiskClassLastChangeDate CreditRiskClassLastChangeDate
CreditCheckRule CreditCheckRule
CreditScoreAndLimitCalcRule CreditScoreAndLimitCalcRule
CustBusinessRelshpStartYear CustBusinessRelshpStartYear
_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 A_CrdtMBusinessPartner.
-- 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 A_CrdtMBusinessPartner AS
SELECT
  BusinessPartner,
  CrdtMgmtBusinessPartnerGroup,
  CreditWorthinessScoreValue,
  CrdtWrthnssScoreValdtyEndDate,
  CrdtWorthinessScoreLastChgDate,
  CalcdCrdtWorthinessScoreValue,
  CreditRiskClass,
  CalculatedCreditRiskClass,
  CreditRiskClassLastChangeDate,
  CreditCheckRule,
  CreditScoreAndLimitCalcRule,
  CustBusinessRelshpStartYear
FROM R_CrdtMBusinessPartnerTP
;