I_SrvcPrvdrBankAccountVH

DDL: I_SRVCPRVDRBANKACCOUNTVH Type: view_entity COMPOSITE Package: FCLM_CASHPOOLING
20 Fields 1 Data Sources

Service provider based bank accounts

I_SrvcPrvdrBankAccountVH is a Composite CDS View that provides data about "Service provider based bank accounts" in SAP S/4HANA. It reads from 1 data source (I_BankAcctIdVH) and exposes 20 fields with key fields BankAccountInternalID, CashPoolSrvcPrvdr. Part of development package FCLM_CASHPOOLING.

Data Sources (1)

SourceAliasJoin Type
I_BankAcctIdVH bam from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Service provider based bank accounts view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey BankAccountInternalID view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
Search.searchable true view
Consumption.ranked true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY BankAccountInternalID I_BankAcctIdVH BankAccountInternalID Technical ID
KEY CashPoolSrvcPrvdr ServiceProviderContractType CashPoolSrvcPrvdr Service Provider
BankAccountContractType I_BankAcctIdVH BankAccountContractType
BankAccountNumber I_BankAcctIdVH BankAccountNumber Bank Account
BankAccountDescription I_BankAcctIdVH BankAccountDescription
BankAccountCurrency I_BankAcctIdVH BankAccountCurrency Currency
BankAccountType I_BankAcctIdVH BankAccountType Account Type
Bank I_BankAcctIdVH Bank Bank Number
BankCountry I_BankAcctIdVH BankCountry Bank Ctry/Rgn. Key
BankAccountStatus I_BankAcctIdVH BankAccountStatus Account Status
BankName I_BankAcctIdVH BankName Bank Name
IBAN I_BankAcctIdVH IBAN IBAN House Bank
SWIFTCode I_BankAcctIdVH SWIFTCode SWIFT/BIC
HouseBank I_BankAcctIdVH HouseBank House Bank
HouseBankAccount I_BankAcctIdVH HouseBankAccount House Bank Account
CompanyCode I_BankAcctIdVH CompanyCode Receiver Company Code
Segment I_BankAcctIdVH Segment Segment number
ProfitCenter I_BankAcctIdVH ProfitCenter Profit Center
CashToleranceGroup I_BankAcctIdVH CashToleranceGroup
IntradayIsReconciled I_BankAcctIdVH IntradayIsReconciled

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_SrvcPrvdrBankAccountVH.
-- 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 I_SrvcPrvdrBankAccountVH AS
SELECT
  bam.BankAccountInternalID AS BankAccountInternalID,
  ServiceProviderContractType.CashPoolSrvcPrvdr AS CashPoolSrvcPrvdr,
  bam.BankAccountContractType AS BankAccountContractType,
  bam.BankAccountNumber AS BankAccountNumber,
  bam.BankAccountDescription AS BankAccountDescription,
  bam.BankAccountCurrency AS BankAccountCurrency,
  bam.BankAccountType AS BankAccountType,
  bam.Bank AS Bank,
  bam.BankCountry AS BankCountry,
  bam.BankAccountStatus AS BankAccountStatus,
  bam.BankName AS BankName,
  bam.IBAN AS IBAN,
  bam.SWIFTCode AS SWIFTCode,
  bam.HouseBank AS HouseBank,
  bam.HouseBankAccount AS HouseBankAccount,
  bam.CompanyCode AS CompanyCode,
  bam.Segment AS Segment,
  bam.ProfitCenter AS ProfitCenter,
  bam.CashToleranceGroup AS CashToleranceGroup,
  bam.IntradayIsReconciled AS IntradayIsReconciled
FROM I_BankAcctIdVH AS bam
;

Learn More