I_DefaultBusinessPartner

DDL: I_DEFAULTBUSINESSPARTNER SQL: IDEFAULTABLEBP Type: view BASIC
11 Fields 1 Data Sources

Bank Netting Business Partner

I_DefaultBusinessPartner (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Financial Operations

I_DefaultBusinessPartner is a Basic CDS View that provides data about "Bank Netting Business Partner" in SAP S/4HANA. It reads from 1 data source (fclm_bnka_bp_fs) and exposes 11 fields with key fields BankCountry, BankInternalID, BusinessPartnerNumber, ValidTo.

SAP Help Documentation

CategoryCDS Views for Cash and Liquidity Management
Purpose
This CDS view provides you with access to the information of default business partners. This CDS view provides the data to answer the following business question: Which defaultable business partner is assigned to a certain bank? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: F_BNKA_MAO (activity 03) Configuration

Structure
Fields used for filtering The main filters are as follows: Bank Key and Bank Country used to filter out which default business partner is assigned to a bank for a certain validity period. Partner No. used to filter out for a certain validity period to which bank this partner is assigned.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-CLM-BAM
CapabilitiesData Source for Defining CDS Entities
PackageFinancial Operations for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides you with access to the information of default business partners.</p> This CDS view provides the data to answer the following business question:<ul> <li><p>Which defaultable business partner is assigned to a certain bank?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
fclm_bnka_bp_fs DefaultableBp from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IDEFAULTABLEBP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Bank Netting Business Partner view
Metadata.ignorePropagatedAnnotations true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY BankCountry fclm_bnka_bp_fs banks Bank Country/Region Key
KEY BankInternalID fclm_bnka_bp_fs bankl House Bank
KEY BusinessPartnerNumber fclm_bnka_bp_fs partner Business Partner Number
KEY ValidTo fclm_bnka_bp_fs valid_to Validity End Time
ValidFrom fclm_bnka_bp_fs valid_from Validity Start Time
CreatedByUser fclm_bnka_bp_fs created_by Version Created By
CreationDate fclm_bnka_bp_fs created_at_dat Created On
CreationTime fclm_bnka_bp_fs created_at_tim Created At
LastChangedByUser fclm_bnka_bp_fs last_changed_by Changed By
LastChangeDate fclm_bnka_bp_fs last_changed_at_dat Changed On
LastChangeTime fclm_bnka_bp_fs last_changed_at_tim Last Changed Time

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_DefaultBusinessPartner.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IDEFAULTABLEBP

CREATE VIEW I_DefaultBusinessPartner AS
SELECT
  DefaultableBp.banks AS BankCountry,
  DefaultableBp.bankl AS BankInternalID,
  DefaultableBp.partner AS BusinessPartnerNumber,
  DefaultableBp.valid_to AS ValidTo,
  DefaultableBp.valid_from AS ValidFrom,
  DefaultableBp.created_by AS CreatedByUser,
  DefaultableBp.created_at_dat AS CreationDate,
  DefaultableBp.created_at_tim AS CreationTime,
  DefaultableBp.last_changed_by AS LastChangedByUser,
  DefaultableBp.last_changed_at_dat AS LastChangeDate,
  DefaultableBp.last_changed_at_tim AS LastChangeTime
FROM fclm_bnka_bp_fs AS DefaultableBp
;

Learn More