I_BUSINESSPARTNERADDRESS

CDS View
8 Fields 11 CDS Views

Core view for Business Partner Address

I_BUSINESSPARTNERADDRESS is a CDS View in S/4HANA. Core view for Business Partner Address. It contains 8 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
C_BPAddressValueHelp view from CONSUMPTION Value Help view for list of addresses of a BP
C_CustomerBPAddressVH view from CONSUMPTION Business Partner Addresses of Customers
C_EnvrmtWastePartDsplFcltyVH view from CONSUMPTION Waste Partner Disposal Fclty Value Help
C_EnvrmtWastePartFcltyParamVH view from CONSUMPTION Disposal Facility val help with Parametr
C_ProdCmplncBPAddrVH view from CONSUMPTION PC Business Partner Multi Address
CIC_CustBPAddress view_entity from Proj. View on BP Address
CIC_SupplierBPASsociation view_entity from Proj. View for Supplier-BP Assoc.
I_BPCompanyAddressVH view from BASIC Value Help for Company Address
P_CPBUPAEMAILALL view union CONSUMPTION Business Partner Emails from all sources
P_Cpbupafaxall view inner CONSUMPTION Business Partner Emails from all sources
P_SLSORDREQBPCONTACTS view from BASIC BP Contact Information

Fields (8)

KeyField CDS FieldsUsed in Views
KEY AddressNumber AddressID,AddressNumber 5
KEY BusinessPartner BusinessPartner,ContactPerson 3
_BusinessPartner _BusinessPartner 2
CityName CityName 2
Country Country 2
HouseNumber HouseNumber 2
PostalCode PostalCode 2
StreetName StreetName 2

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.

-- Core view for Business Partner Address
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUSINESSPARTNERADDRESS (
    ADDRESSNUMBER,
    BUSINESSPARTNER,
    _BUSINESSPARTNER,
    CITYNAME,
    COUNTRY,
    HOUSENUMBER,
    POSTALCODE,
    STREETNAME,
    PRIMARY KEY (ADDRESSNUMBER, BUSINESSPARTNER)
);

Learn More