I_SADL_VOC_BUSINESSPARTNER

CDS View
15 Fields 2 CDS Views

Vocan Core View: Business Partner

I_SADL_VOC_BUSINESSPARTNER is a CDS View in S/4HANA. Vocan Core View: Business Partner. It contains 15 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_Sadl_Voc_Businesspartner view from CONSUMPTION Vocan View: Business Partner UI Anno
C_Sadl_Voc_So_DataPoint view from Sadl Vocan Test: Datapoint

Fields (15)

KeyField CDS FieldsUsed in Views
KEY BusinessPartnerKey BusinessPartnerKey 1
AddressGuid AddressGuid 1
BusinessPartnerId BusinessPartnerId 1
BusinessPartnerRole BusinessPartnerRole 1
ChangedAt ChangedAt 2
ChangedBy ChangedBy 2
CompanyName CompanyName 1
CreatedAt CreatedAt 2
CreatedBy CreatedBy 2
CurrencyCode CurrencyCode 2
EmailAddress EmailAddress 1
FaxNumber FaxNumber 1
LegalForm LegalForm 1
PhoneNumber PhoneNumber 1
WebAddress WebAddress 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.

-- Vocan Core View: Business Partner
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SADL_VOC_BUSINESSPARTNER (
    BUSINESSPARTNERKEY,
    ADDRESSGUID,
    BUSINESSPARTNERID,
    BUSINESSPARTNERROLE,
    CHANGEDAT,
    CHANGEDBY,
    COMPANYNAME,
    CREATEDAT,
    CREATEDBY,
    CURRENCYCODE,
    EMAILADDRESS,
    FAXNUMBER,
    LEGALFORM,
    PHONENUMBER,
    WEBADDRESS,
    PRIMARY KEY (BUSINESSPARTNERKEY)
);

Learn More