Fclm_Bm_BP

DDL: FCLM_BM_BP SQL: VFCLM_BM_BP Type: view
6 Fields 2 Data Sources

Bussiness Parterner for bank management

Fclm_Bm_BP is a CDS View that provides data about "Bussiness Parterner for bank management" in SAP S/4HANA. It reads from 2 data sources (but000, fclm_bnka_bp_fs) and exposes 6 fields with key fields BankCountry, BankInternalId, ValidTo, BusinessPartnerNo.

Data Sources (2)

SourceAliasJoin Type
but000 but000 inner
fclm_bnka_bp_fs DefaultableBp from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName VFCLM_BM_BP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Bussiness Parterner for bank management view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY BankCountry fclm_bnka_bp_fs banks Bank Ctry/Rgn. Key
KEY BankInternalId fclm_bnka_bp_fs bankl House Bank
KEY ValidTo fclm_bnka_bp_fs valid_to Validity End Time
KEY BusinessPartnerNo fclm_bnka_bp_fs partner With Partner
ValidFrom fclm_bnka_bp_fs valid_from Validity Start Time
BpGroup but000 bu_group Grouping

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 Fclm_Bm_BP.
-- 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: VFCLM_BM_BP

CREATE VIEW Fclm_Bm_BP AS
SELECT
  DefaultableBp.banks AS BankCountry,
  DefaultableBp.bankl AS BankInternalId,
  DefaultableBp.valid_to AS ValidTo,
  DefaultableBp.partner AS BusinessPartnerNo,
  DefaultableBp.valid_from AS ValidFrom,
  but000.bu_group AS BpGroup
FROM fclm_bnka_bp_fs AS DefaultableBp
INNER JOIN but000 ON /* join condition not captured in parsed metadata */
;

Learn More