I_BPCONTACTTOADDRESS is the Basic CDS view, which provides access to the Business Partner Contact To Address data in SAP S/HANA system. Core Data Services (CDS) views are semantically rich data models that provide efficient in-built functions such as aggregations, annotations, and conceptual associations.
This CDS view is found in the VDM Master Data BP: basic Views (VDM_MD_BP_BASE) package and is part of the SAP Business Partner (AP-MD-BP) module.
| CDS View | I_BPCONTACTTOADDRESS |
|---|---|
| DDL SQL View | IBPCNTCTADDRESS |
| Status | Released |
| CDS View Type | Basic |
| Package | VDM_MD_BP_BASE |
| Technical Component | AP-MD-BP |
You can create custom CDS views for released views and expose them as a read-only OData service that delivers data tailored to the needs of your external application.
Tables Used
The following are the SAP HANA table(s) used to develop this CDS view
| Table Name | Table Description |
|---|---|
| ADCP | Person/Address Assignment (Business Address Services) |
| ADR2 | Telephone Numbers (Business Address Services) |
| ADR3 | Fax Numbers (Business Address Services) |
| BUT000 | BP: General data I |
| BUT052 | BP Relationship: Addresses |
CDS View Fields
The following is the list of fields available in the CDS view and key fields are highlighted in color:
| CDS View Field | Text | SQL View/Table | Table Field | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | BUT052 | CLIENT | CLNT | 3 |
| RELATIONSHIPNUMBER | BP Relationship Number | BUT052 | RELNR | CHAR | 12 |
| BUSINESSPARTNERCOMPANY | Business Partner Number | BUT052 | PARTNER1 | CHAR | 10 |
| BUSINESSPARTNERPERSON | Business Partner Number | BUT052 | PARTNER2 | CHAR | 10 |
| VALIDITYENDDATE | Validity Date (Valid To) | BUT052 | DATE_TO | DATS | 8 |
| ADDRESSID | Address Number | BUT052 | ADDRNUMBER | CHAR | 10 |
| PERSONNUMBER | Person Number | BUT000 | PERSNUMBER | CHAR | 10 |
| ISDEFAULTADDRESS | Indicator: Address is standard address | BUT052 | XDFADR | CHAR | 1 |
| FLOOR | Floor in building | ADCP | FLOOR | CHAR | 10 |
| BUILDING | Building (number or code) | ADCP | BUILDING | CHAR | 10 |
| ROOMNUMBER | Room or Apartment Number | ADCP | ROOMNUMBER | CHAR | 10 |
| INTERNATIONALPHONENUMBER | Complete Number: Dialling Code+Number+Extension | IADDRPHONENUMBER | INTERNATIONALPHONENUMBER | CHAR | 30 |
| PHONENUMBERCOUNTRY | Country for telephone/fax number | IADDRPHONENUMBER | DESTINATIONLOCATIONCOUNTRY | CHAR | 3 |
| PHONENUMBER | Telephone no.: dialling code+number | IADDRPHONENUMBER | PHONENUMBER | CHAR | 30 |
| INTERNATIONALMOBILEPHONENUMBER | Complete Number: Dialling Code+Number+Extension | IADDRPHONENUMBER | INTERNATIONALPHONENUMBER | CHAR | 30 |
| MOBILEPHONECOUNTRY | Country for telephone/fax number | IADDRPHONENUMBER | DESTINATIONLOCATIONCOUNTRY | CHAR | 3 |
| MOBILEPHONENUMBER | Telephone no.: dialling code+number | IADDRPHONENUMBER | PHONENUMBER | CHAR | 30 |
| MOBILEPHONENUMBEREXTENSION | Telephone no.: Extension | IADDRPHONENUMBER | PHONENUMBEREXTENSION | CHAR | 10 |
| INTERNATIONALFAXNUMBER | Complete number: dialling code+number+extension | IADDRFAXNUMBER | INTERNATIONALFAXNUMBER | CHAR | 30 |
| FAXCOUNTRY | Country for telephone/fax number | IADDRFAXNUMBER | FAXCOUNTRY | CHAR | 3 |
| AUTHORIZATIONGROUP | Authorization Group | IBUSINESSPARTNER | AUTHORIZATIONGROUP | CHAR | 4 |
| ISBUSINESSPURPOSECOMPLETED | Business Purpose Completed Flag | IBUSINESSPARTNER | ISBUSINESSPURPOSECOMPLETED | CHAR | 1 |
CDS View Annotaions
The following are the CDS View Annotations used in this CDS view:
| CDS Annotation Name | CDS Annotation Value |
|---|---|
| ENDUSERTEXT.LABEL | ‘Business Partner Contact To Address’ |
| ACCESSCONTROL.PERSONALDATA.BLOCKING | #REQUIRED |
| VDM.VIEWTYPE | #BASIC |
| CLIENTHANDLING.ALGORITHM | #SESSION_VARIABLE |
| ABAPCATALOG.SQLVIEWNAME | ‘IBPCNTCTADDRESS’ |
| OBJECTMODEL.USAGETYPE.SERVICEQUALITY | #D |
| OBJECTMODEL.REPRESENTATIVEKEY | ‘RelationshipNumber’ |
| ACCESSCONTROL.AUTHORIZATIONCHECK | #CHECK |
| OBJECTMODEL.USAGETYPE.DATACLASS | #MASTER |
| OBJECTMODEL.USAGETYPE.SIZECATEGORY | #XXL |
| ABAPCATALOG.COMPILER.COMPAREFILTER | true |
Availability
The CDS view I_BPCONTACTTOADDRESS is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Released |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
Supported Capabilities
It is possible for a single CDS view to provide many capabilities such as a data source, association target, or analytical provider. Supported Capabilities indicates clear use cases for CDS views and provides an idea of the most efficient ways to use a CDS view. Each CDS view can have multiple supported capabilities.
Supported Capabilities are not defined for this CDS view.
Extensibility
Coming Soon!!
Related CDS Views
Coming Soon!!
