C_BankGroupRootNodeValueHelp

DDL: C_BANKGROUPROOTNODEVALUEHELP Type: view_entity CONSUMPTION Package: FCLM_BAM

Bank Group

C_BankGroupRootNodeValueHelp is a Consumption CDS View that provides data about "Bank Group" in SAP S/4HANA. It reads from 1 data source (but000) and exposes 17 fields with key field BusinessPartnerNumber. It has 1 association to related views. It is exposed through 1 OData service (UI_BANKRELATIONSHIPDOC). Part of development package FCLM_BAM.

Data Sources (1)

SourceAliasJoin Type
but000 but000 inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartnerVH _BusinessPartnerVH $projection.BusinessPartnerNumber = _BusinessPartnerVH.BusinessPartner

Annotations (15)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Bank Group view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
UI.headerInfo.typeName Business Partner view
UI.headerInfo.typeNamePlural Business Partners view
UI.headerInfo.typeImageUrl sap-icon: title: { value: view
ObjectModel.dataCategory #VALUE_HELP view
Consumption.ranked true view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey BusinessPartnerNumber view

OData Services (1)

ServiceBindingVersionContractRelease
UI_BANKRELATIONSHIPDOC UI_BANKRELATIONSHIPDOC_O4 V4 C1 NOT_RELEASED

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerNumber BP BusinessPartner Issuing Authority
BusinessPartnerName Business Partner Name
BusinessPartner2 _BPRelationship BusinessPartner2 Partner
AuthorizationGroup BP AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted
DataControllerSet
DataController1
DataController2
DataController3
DataController4
DataController5
DataController6
DataController7
DataController8
DataController9
DataController10
_BusinessPartnerVH _BusinessPartnerVH

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 C_BankGroupRootNodeValueHelp.
-- 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.

CREATE VIEW C_BankGroupRootNodeValueHelp AS
SELECT
  BP.BusinessPartner AS BusinessPartnerNumber,
  BP._BusinessPartner.OrganizationBPName1 AS BusinessPartnerName,
  _BPRelationship.BusinessPartner2 AS BusinessPartner2,
  BP.AuthorizationGroup AS AuthorizationGroup,
  BP._BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  BP._BusinessPartner.DataControllerSet AS DataControllerSet,
  BP._BusinessPartner.DataController1 AS DataController1,
  BP._BusinessPartner.DataController2 AS DataController2,
  BP._BusinessPartner.DataController3 AS DataController3,
  BP._BusinessPartner.DataController4 AS DataController4,
  BP._BusinessPartner.DataController5 AS DataController5,
  BP._BusinessPartner.DataController6 AS DataController6,
  BP._BusinessPartner.DataController7 AS DataController7,
  BP._BusinessPartner.DataController8 AS DataController8,
  BP._BusinessPartner.DataController9 AS DataController9,
  BP._BusinessPartner.DataController10 AS DataController10
INNER JOIN but000 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartnerVH AS _BusinessPartnerVH ON BusinessPartnerNumber = _BusinessPartnerVH.BusinessPartner  -- association [0..1]
;