C_BusinessPartnerCertificate

DDL: C_BUSINESSPARTNERCERTIFICATE Type: view_entity CONSUMPTION
29 Fields 1 Data Sources

Business Partner Certificates

C_BusinessPartnerCertificate is a Consumption CDS View that provides data about "Business Partner Certificates" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerCertificate) and exposes 29 fields with key fields BusinessPartnerNumber, BPCertCountryCode, BPCertIdn, BPCertNumber, BPCertRegionCode.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerCertificate I_BusinessPartnerCertificate projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Business Partner Certificates view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerNumber BusinessPartnerNumber With Partner
KEY BPCertCountryCode BPCertCountryCode Trip Ctry/Reg
KEY BPCertIdn BPCertIdn Certificate ID
KEY BPCertNumber BPCertNumber Certification No.
KEY BPCertRegionCode BPCertRegionCode Registration City
KEY BPCertValidFromDate BPCertValidFromDate Validity Start Time
BPCertValidToDate BPCertValidToDate Validity End Time
BPCertStatus BPCertStatus Workflow Status
BPCertStatusText _BPCertStatus BPCertStatusText
BPCertIsMainCertificate BPCertIsMainCertificate Main Certificate
BPCertIsMainCertificateText _BPCertMain BPCertIsMainCertificateText
BPCertExemptionType BPCertExemptionType
BPCertExemptionTypeText _BPCertExempt BPCertExemptionTypeText
BPCertExemptionReasonText BPCertExemptionReasonText Tax Exemp.Reason
BPCertCreationDate BPCertCreationDate Time Stamp
BPCertDescription1Text BPCertDescription1Text LC 116 Service Type
BPCertDescription2Text BPCertDescription2Text LC 116 Service Type
BPCertAdditional1Date BPCertAdditional1Date Date 1
BPCertAdditional2Date BPCertAdditional2Date Date 2
BPCertNumber1 BPCertNumber1 Number 1
BPCertNumber2 BPCertNumber2 Number 2
BPCertLastChangedOnDate BPCertLastChangedOnDate Variant Changed on
BPCertUUID BPCertUUID
BPCertCountryText _CountryText CountryName Country
BPCertIdText _BPCertText BPCertIdText
BPCertRegionText _RegionText RegionName Description
DataControllerSet DataControllerSet Data Ctrlr. Set
_BPCertCountry _BPCertCountry
_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_BusinessPartnerCertificate.
-- 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_BusinessPartnerCertificate AS
SELECT
  BusinessPartnerNumber,
  BPCertCountryCode,
  BPCertIdn,
  BPCertNumber,
  BPCertRegionCode,
  BPCertValidFromDate,
  BPCertValidToDate,
  BPCertStatus,
  _BPCertStatus.BPCertStatusText AS BPCertStatusText,
  BPCertIsMainCertificate,
  _BPCertMain.BPCertIsMainCertificateText AS BPCertIsMainCertificateText,
  BPCertExemptionType,
  _BPCertExempt.BPCertExemptionTypeText AS BPCertExemptionTypeText,
  BPCertExemptionReasonText,
  BPCertCreationDate,
  BPCertDescription1Text,
  BPCertDescription2Text,
  BPCertAdditional1Date,
  BPCertAdditional2Date,
  BPCertNumber1,
  BPCertNumber2,
  BPCertLastChangedOnDate,
  BPCertUUID,
  _CountryText.CountryName AS BPCertCountryText,
  _BPCertText.BPCertIdText AS BPCertIdText,
  _RegionText.RegionName AS BPCertRegionText,
  DataControllerSet
FROM I_BusinessPartnerCertificate
;

Learn More