C_BkPOABankAccountTP

DDL: C_BKPOABANKACCOUNTTP Type: view_entity CONSUMPTION
23 Fields 1 Data Sources

Bank Accounts of POA

C_BkPOABankAccountTP is a Consumption CDS View that provides data about "Bank Accounts of POA" in SAP S/4HANA. It reads from 1 data source (R_BkPOABankAccountTP) and exposes 23 fields with key fields BankPowerOfAttorneyUUID, BkPOABankAccountUUID.

Data Sources (1)

SourceAliasJoin Type
R_BkPOABankAccountTP R_BkPOABankAccountTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Bank Accounts of POA view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view
Search.searchable true view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY BankPowerOfAttorneyUUID BankPowerOfAttorneyUUID UUID
KEY BkPOABankAccountUUID BkPOABankAccountUUID Bank Account UUID
BankAccountInternalID BankAccountInternalID Technical ID
BkPOABkAcctAssignmentDateTime BkPOABkAcctAssignmentDateTime Bank Account Assigned At
BkPOABkAcctRemovalDateTime BkPOABkAcctRemovalDateTime Bank Account Removed At
Bank _BankAccountBasicData Bank Bank Number
BankAccountNumber _BankAccountBasicData BankAccountNumber Bank Account
BankCountry
CountryNameasBankCountryNamelocalized Bank Country/Region Name
BankAccountCurrency _BankAccountBasicData BankAccountCurrency Currency
BankControlKey _BankAccountBasicData BankControlKey Control Key
BankAccountContractType _BankAccountBasicData BankAccountContractType
BankAccountType _BankAccountBasicData BankAccountType Account Type
BankAccountContractTypeName
CompanyCode _BankAccountBasicData CompanyCode Receiver Company Code
CompanyCodeName
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LocalLastChangeDateTime LocalLastChangeDateTime Time Stamp
_BankAccount _BankAccount
_BankAccountBasicData _BankAccountBasicData
_BankAccountText _BankAccountText

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_BkPOABankAccountTP.
-- 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_BkPOABankAccountTP AS
SELECT
  BankPowerOfAttorneyUUID,
  BkPOABankAccountUUID,
  BankAccountInternalID,
  BkPOABkAcctAssignmentDateTime,
  BkPOABkAcctRemovalDateTime,
  _BankAccountBasicData.Bank AS Bank,
  _BankAccountBasicData.BankAccountNumber AS BankAccountNumber,
  cast (_BankAccountBasicData.BankCountry as fclm_poa_bank_country_key preserving type) AS BankCountry,
  _BankAccountBasicData._BankCountry._Text.CountryName as BankCountryName : localized AS CountryNameasBankCountryNamelocalized,
  _BankAccountBasicData.BankAccountCurrency AS BankAccountCurrency,
  _BankAccountBasicData.BankControlKey AS BankControlKey,
  _BankAccountBasicData.BankAccountContractType AS BankAccountContractType,
  _BankAccountBasicData.BankAccountType AS BankAccountType,
  _BankAccountBasicData._ContractType.BankAccountContractTypeName AS BankAccountContractTypeName,
  _BankAccountBasicData.CompanyCode AS CompanyCode,
  _BankAccountBasicData._CompanyCode.CompanyCodeName AS CompanyCodeName,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LocalLastChangeDateTime
FROM R_BkPOABankAccountTP
;

Learn More