I_BUSINESSPARTNERCERTIFICATE

CDS View
16 Fields 5 CDS Views

Business Partner Certificates

I_BUSINESSPARTNERCERTIFICATE is a CDS View in S/4HANA. Business Partner Certificates. It contains 16 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_BusinessPartnerCertificate view_entity projection CONSUMPTION Business Partner Certificates
I_BPCertWithBPInformation view_entity from COMPOSITE Business Partner Certificate Information
I_BPLtstValidityCertificate view_entity from COMPOSITE Latest Validity BP Certificate
I_BPRelevantCertificate view_entity left_outer COMPOSITE BP has Certificates Assigned to Country
I_BPRelevantCertificate view_entity union_all COMPOSITE BP has Certificates Assigned to Country

Fields (16)

KeyField CDS FieldsUsed in Views
KEY BPCertNumber BPCertNumber 1
KEY BPCertRegionCode BPCertRegionCode 1
BPCertAdditional1Date BPCertAdditional1Date 1
BPCertAdditional2Date BPCertAdditional2Date 1
BPCertCreationDate BPCertCreationDate 1
BPCertDescription1Text BPCertDescription1Text 1
BPCertDescription2Text BPCertDescription2Text 1
BPCertExemptionReasonText BPCertExemptionReasonText 1
BPCertExemptionType BPCertExemptionType 1
BPCertIsMainCertificate BPCertIsMainCertificate 1
BPCertLastChangedOnDate BPCertLastChangedOnDate 1
BPCertNumber1 BPCertNumber1 1
BPCertNumber2 BPCertNumber2 1
BPCertStatus BPCertStatus 1
BPCertUUID BPCertUUID 1
BPCertValidToDate BPCertValidToDate 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Business Partner Certificates
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUSINESSPARTNERCERTIFICATE (
    BPCERTNUMBER,
    BPCERTREGIONCODE,
    BPCERTADDITIONAL1DATE,
    BPCERTADDITIONAL2DATE,
    BPCERTCREATIONDATE,
    BPCERTDESCRIPTION1TEXT,
    BPCERTDESCRIPTION2TEXT,
    BPCERTEXEMPTIONREASONTEXT,
    BPCERTEXEMPTIONTYPE,
    BPCERTISMAINCERTIFICATE,
    BPCERTLASTCHANGEDONDATE,
    BPCERTNUMBER1,
    BPCERTNUMBER2,
    BPCERTSTATUS,
    BPCERTUUID,
    BPCERTVALIDTODATE,
    PRIMARY KEY (BPCERTNUMBER, BPCERTREGIONCODE)
);

Learn More