I_BUSINESSPARTNERBANK_2 is the Basic CDS view, which provides access to the Core View: Business Partner Bank 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_BUSINESSPARTNERBANK_2 |
|---|---|
| DDL SQL View | IBUPABANK2 |
| 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 |
|---|---|
| BNKA | Bank master record |
| BUT000 | BP: General data I |
| BUT0BK | BP: Bank Details |
| TIBAN | IBAN |
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 | BUT0BK | MANDT | CLNT | 3 |
| BUSINESSPARTNER | Business Partner Number | BUT0BK | PARTNER | CHAR | 10 |
| BANKIDENTIFICATION | Bank details ID | BUT0BK | BKVID | CHAR | 4 |
| BANKCOUNTRYKEY | Bank Country Key | BUT0BK | BANKS | CHAR | 3 |
| BANKNAME | Name of bank | IBANKFORBP | BANKNAME | CHAR | 60 |
| BANKNUMBER | Bank Key | BUT0BK | BANKL | CHAR | 15 |
| SWIFTCODE | SWIFT/BIC for International Payments | IBANKFORBP | SWIFTCODE | CHAR | 11 |
| BANKCONTROLKEY | Bank Control Key | BUT0BK | BKONT | CHAR | 2 |
| BANKACCOUNTHOLDERNAME | Account Holder Name | BUT0BK | KOINH | CHAR | 60 |
| BANKACCOUNTNAME | Name of Bank Account | BUT0BK | ACCNAME | CHAR | 40 |
| VALIDITYSTARTDATE | Validity Start of Business Partner Bank Details | BUT0BK | BK_VALID_FROM | DEC | 15 |
| VALIDITYENDDATE | Validity End of Business Partner Bank Details | BUT0BK | BK_VALID_TO | DEC | 15 |
| IBANVALIDITYSTARTDATE | Validity start of IBAN | IBPIBAN | IBANVALIDITYSTARTDATE | DATS | 8 |
| BANKACCOUNT | Bank Account Number | BUT0BK | BANKN | CHAR | 18 |
| BANKACCOUNTREFERENCETEXT | Reference Details for Bank Details | BUT0BK | BKREF | CHAR | 20 |
| COLLECTIONAUTHIND | Indicator: Collection Authorization | BUT0BK | XEZER | CHAR | 1 |
| BUSINESSPARTNEREXTERNALBANKID | Bank details ID in external system | BUT0BK | BKEXT | CHAR | 20 |
| BPBANKDETAILSCHANGEDATE | Date of Change to Bank Details (BP) | BUT0BK | BK_MOVE_DATE | DEC | 15 |
| BPBANKDETAILSCHANGETARGETID | ID of Target Details for Change of Bank Details (BP) | BUT0BK | MOVE_BKVID | CHAR | 4 |
| BPBANKISPROTECTED | BP: Sensitivity Indicator | BUT0BK | PROTECT | CHAR | 1 |
| CITYNAME | City | IBANKFORBP | CITYNAME | CHAR | 35 |
| AUTHORIZATIONGROUP | Authorization Group | IBUSINESSPARTNER | AUTHORIZATIONGROUP | CHAR | 4 |
CDS View Annotaions
The following are the CDS View Annotations used in this CDS view:
| CDS Annotation Name | CDS Annotation Value |
|---|---|
| ENDUSERTEXT.LABEL | ‘Core View: Business Partner Bank’ |
| OBJECTMODEL.USAGETYPE.SIZECATEGORY | #XXL |
| OBJECTMODEL.USAGETYPE.DATACLASS | #MASTER |
| ABAPCATALOG.SQLVIEWNAME | ‘IBUPABANK2’ |
| CLIENTHANDLING.ALGORITHM | #SESSION_VARIABLE |
| OBJECTMODEL.USAGETYPE.SERVICEQUALITY | #B |
| ABAPCATALOG.COMPILER.COMPAREFILTER | true |
| ACCESSCONTROL.PERSONALDATA.BLOCKING | #REQUIRED |
| ACCESSCONTROL.AUTHORIZATIONCHECK | #CHECK |
| ABAPCATALOG.PRESERVEKEY | true |
| VDM.VIEWTYPE | #BASIC |
Availability
The CDS view I_BUSINESSPARTNERBANK_2 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!!
