SAP Knowledge Base Article - Public

3794776 - I_ADDRESS_2 does not return business partner Address Id

Symptom

  • Address ID is missing when extracting addresses via CDS view I_ADDRESS_2.
  • The same Address ID is available when extracting via I_BusPartAddress.

Environment

SAP S/4HANA Cloud Public Edition

Reproducing the Issue

  1. Extract address data using the provider/view I_BusPartAddress and verify that a Business Partner is linked to a specific Address ID.
  2. Extract address data using the provider/view I_ADDRESS_2 and observe that the same Address ID is not returned.

Cause

This is as per the Standard SAP functionality.

Resolution

    • I_ADDRESS_2 reads from the central address pool and returns addresses for any organization or person in the system. It does not join back to the Business Partner relationship, which is why certain BP addresses may not appear.
    • I_BusPartAddress is specifically designed to return addresses that are explicitly assigned to a Business Partner. It reads through the BP assignment tables and correctly resolves which address belongs to which BP.

    See Also

    • SAP Knowledge Base Article 3219389 - Custom requirement: remove auto filter on language field for text datasource.
    • SAP Knowledge Base Article 3387665 - CDS Views I_ADDRESS_2 and I_AddressEmailAddress_2 do not display the data of the Business Partner

    API Documentation:

    Keywords

    I_ADDRESS_2, I_BusPartAddress, I_BusPartAddress, cds view, business partner address, missing addressid, central address pool, bp address assignment, extraction, s/4hana cloud, bw/4hana integration, address data, business partner cds, address lookup, data replication , KBA , LO-MD-BP-2CL , Business Partners for Public Cloud , Problem

    Product

    SAP S/4HANA Cloud Public Edition all versions