I_BUSPARTADDRESS

CDS View
11 Fields 14 CDS Views

Business Partner Address

I_BUSPARTADDRESS is a CDS View in S/4HANA. Business Partner Address. It contains 11 fields. 14 CDS views read from this table.

CDS Views using this table (14)

ViewTypeJoinVDMDescription
A_AddressEmailAddress view inner BASIC Email Address
A_AddressFaxNumber view inner BASIC Fax Number
A_AddressHomePageURL view inner BASIC Home Page URL
A_AddressPhoneNumber view inner BASIC Phone Number
A_BPIntlAddressVersion view from COMPOSITE BP International Address Version
A_BusinessPartnerAddress view from BASIC Address
C_PurgCustomerBPShipToAddrVH view inner CONSUMPTION Customer Ship to Addresses
I_BPCustomerGeneralAddressInfo view from COMPOSITE BP and Cust Addr Depdnt Info
I_BPCustomerMultiAddrVH view inner COMPOSITE Customers by Multiple Addresses
I_BPCustomerSalesAddressInfo view from BASIC BP and Cust sls Addr Depdnt Info
I_BPSuplrAddrDepdntPurgOrgInfo view from COMPOSITE Supplier addr depnt purch info
I_BPSupplierAddrDepdntGenInfo view from COMPOSITE BP Supp Add Dep Gen Info
I_BusinessPartnerAddressGov view union_all COMPOSITE Business Partner Address (Governance)
I_BusinessPartnerAddressTP view from TRANSACTIONAL Business Partner Address

Fields (11)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID,AddressNumber,AddressNumberForEdit 10
KEY BusinessPartner BusinessPartner,BusinessPartnerForEdit,MDChgProcessSrceObject 12
_BusinessPartner _BusinessPartner 4
AddressIDByExternalSystem AddressIDByExternalSystem 2
AddressUUID AddressUUID,BusinessPartnerAddressUUID 2
AuthorizationGroup AuthorizationGroup 5
BPAddressMoveDateTime BPAddressMoveDateTime 1
BPTargetAddressID BPTargetAddressID 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 4
ValidityEndDate ValidityEndDate 3
ValidityStartDate ValidityStartDate 3

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 Address
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUSPARTADDRESS (
    ADDRESSID,
    BUSINESSPARTNER,
    _BUSINESSPARTNER,
    ADDRESSIDBYEXTERNALSYSTEM,
    ADDRESSUUID,
    AUTHORIZATIONGROUP,
    BPADDRESSMOVEDATETIME,
    BPTARGETADDRESSID,
    ISBUSINESSPURPOSECOMPLETED,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (ADDRESSID, BUSINESSPARTNER)
);

Learn More