C_BkPOABankAccountFDP

DDL: C_BKPOABANKACCOUNTFDP Type: view_entity CONSUMPTION
20 Fields 1 Data Sources

Form Data Provider for POA Bank Account

C_BkPOABankAccountFDP is a Consumption CDS View that provides data about "Form Data Provider for POA Bank Account" in SAP S/4HANA. It reads from 1 data source (I_BkPOABankAccount) and exposes 20 fields with key fields BankPowerOfAttorneyUUID, BkPOABankAccountUUID.

SAP Help Documentation

CategoryCDS Views for Cash and Liquidity Management
Purpose
This CDS view is used during the creation of a PDF for powers of attorney and provides the bank accounts assigned to a power of attorney, including some basic information about the bank accounts, as well as the timestamps of the assignment and removal of a bank account to the power of attorney. 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 a role with the following restriction types set to read access: POA_AUTHGR ( Authorization Group for Powers of Attorney for Banking Transactions ) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Important Fields Important fields in this view include the following: Field Name Is Key Data Element Comment BankPowerOfAttorneyUUID X FCLM_POA_UUID Power of Attorney UUID BkPOABankAccountUUID X FCLM_POA_BANK_ACCOUNT_UUID UUID of Bank Account in POA for Banking Transactions BkPOAAuthorizationGroup FCLM_POA_AUTH_GROUP Authorization Group for Powers of Attorney BankAccountInternalID FCLM_BAM_ACC_ID Bank Account Technical ID BkPOABkAcctAssignmentDateTime FCLM_POA_BA_ASSIGNMENT_TSTMP Bank Account Assignment Timestamp BkPOABkAcctRemovalDateTime FCLM_POA_BA_REMOVAL_TSTMP Bank Account Removal Timestamp BankAccountNumber FCLM_BAM_ACC_NUM Bank Account Number Bank FCLM_BAM_BANK_KEY Bank Key BankAccountCurrency WAERS_CURC Currency Key BankAccountDescription FCLM_BAM_DESCRIPTION Account Description BankCountry FCLM_POA_BANK_COUNTRY_KEY Bank Country/Region Key BankCountryName LANDX50 Country/Region Name BankControlKey BKONT Bank Control Key BankAccountContractType FCLM_BAM_CONTRACT_TYPE Bank Account Contract Type BankAccountContractTypeName FCLM_BAM_CONTRACTTYPETEXT Bank Account Contract Type Description BankAccountType FCLM_BAM_BK_ACC_TYPE_ID Bank Account Type ID BankAccountTypeText FCLM_BAM_BK_ACC_TYPE_DESC Bank Account Type Description CompanyCode BUKRS Company Code CompanyCodeName BUTXT Name of Company Code or Company BankName BANKA Name of Financial Institution

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_BkPOABankAccount I_BkPOABankAccount from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Form Data Provider for POA Bank Account view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.modelingPattern #OUTPUT_FORM_DATA_PROVIDER view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY BankPowerOfAttorneyUUID BankPowerOfAttorneyUUID UUID
KEY BkPOABankAccountUUID BkPOABankAccountUUID Bank Account UUID
BkPOAAuthorizationGroup _BankPowerOfAttorney BkPOAAuthorizationGroup Authorization Group
BankAccountInternalID BankAccountInternalID Technical ID
BkPOABkAcctAssignmentDateTime BkPOABkAcctAssignmentDateTime BA Assigned At
BkPOABkAcctRemovalDateTime BkPOABkAcctRemovalDateTime BA Removed At
BankAccountNumber _BankAccountBasicData BankAccountNumber Bank Account
Bank _BankAccountBasicData Bank Bank Number
BankAccountCurrency _BankAccountBasicData BankAccountCurrency Currency
BankAccountDescription
BankCountry
BankCountryName
BankControlKey _BankAccountBasicData BankControlKey Control Key
BankAccountContractType _BankAccountBasicData BankAccountContractType
BankAccountContractTypeName
BankAccountType _BankAccountBasicData BankAccountType Account Type
BankAccountTypeText
CompanyCode _BankAccountBasicData CompanyCode Receiver Company Code
CompanyCodeName
BankName

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_BkPOABankAccountFDP.
-- 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_BkPOABankAccountFDP AS
SELECT
  BankPowerOfAttorneyUUID,
  BkPOABankAccountUUID,
  _BankPowerOfAttorney.BkPOAAuthorizationGroup AS BkPOAAuthorizationGroup,
  BankAccountInternalID,
  BkPOABkAcctAssignmentDateTime,
  BkPOABkAcctRemovalDateTime,
  _BankAccountBasicData.BankAccountNumber AS BankAccountNumber,
  _BankAccountBasicData.Bank AS Bank,
  _BankAccountBasicData.BankAccountCurrency AS BankAccountCurrency,
  _BankAccountText[1:Language = $session.system_language].BankAccountDescription AS BankAccountDescription,
  cast (_BankAccountBasicData.BankCountry as fclm_poa_bank_country_key preserving type) AS BankCountry,
  _BankAccountBasicData._BankCountry._Text[1:Language = $session.system_language].CountryName AS BankCountryName,
  _BankAccountBasicData.BankControlKey AS BankControlKey,
  _BankAccountBasicData.BankAccountContractType AS BankAccountContractType,
  _BankAccountBasicData._ContractType.BankAccountContractTypeName AS BankAccountContractTypeName,
  _BankAccountBasicData.BankAccountType AS BankAccountType,
  _BankAccountBasicData._BankAccountType[1:Language = $session.system_language].BankAccountTypeText AS BankAccountTypeText,
  _BankAccountBasicData.CompanyCode AS CompanyCode,
  _BankAccountBasicData._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _BankAccount._Bank.BankName AS BankName
FROM I_BkPOABankAccount
;

Learn More