C_BkPowerOfAttorneyComparison

DDL: C_BKPOWEROFATTORNEYCOMPARISON Type: view_entity CONSUMPTION Package: FCLM_POA
21 Fields 1 Data Sources 1 Associations 2 OData Services 1 Fiori Apps

Comparison for POA header data

C_BkPowerOfAttorneyComparison is a Consumption CDS View that provides data about "Comparison for POA header data" in SAP S/4HANA. It reads from 1 data source (I_BankPowerOfAttorney) and exposes 21 fields with key field BankPowerOfAttorneyUUID. It has 1 association to related views. It is exposed through 2 OData services (ASQL_F5742, UI_BANKPOWEROFATTORNEY_MNG). It is used in 1 Fiori application: Manage Powers of Attorney for Banking Transactions. Part of development package FCLM_POA.

Data Sources (1)

SourceAliasJoin Type
I_BankPowerOfAttorney _BankPowerOfAttorney from

Parameters (3)

NameTypeDefault
P_BkPowerOfAttorneyOriginUUID fclm_poa_uuid
P_BankPowerOfAttorneyOtherUUID fclm_poa_uuid
P_BkPOAOriginIsSuccessor boolean

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_BkPOAComparisonSourceText _BkPOAComparisonSourceText $projection.BkPOAComparisonSource = _BkPOAComparisonSourceText.BkPOAComparisonSource

Annotations (8)

NameValueLevelField
Metadata.allowExtensions true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Comparison for POA header data view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F5742 ASQL_F5742 C2 NOT_RELEASED
UI_BANKPOWEROFATTORNEY_MNG UI_BANKPOWEROFATTORNEY_MNG V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App IDApp NameTypeDescription
F5742 Manage Powers of Attorney for Banking Transactions Transactional With this app, you can represent and manage the powers of attorney for banking transactions for your company codes. A power of attorney for banking transactions represents the legal power of attorney that a company has granted to one or more persons to carry out banking transactions on behalf of the company. In the power of attorney, you assign the principals, the authorized representatives, the bank accounts, and the permitted activities.

Manage Powers of Attorney for Banking Transactions

Business Role: Cash Manager

With is feature, you can represent and manage the powers of attorney for banking transactions for your company codes. A power of attorney for banking transactions represents the legal power of attorney that a company has granted to one or more persons to carry out banking transactions on behalf of the company. In the power of attorney, you assign the principals, the authorized representatives, the bank accounts, and the permitted activities.

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY BankPowerOfAttorneyUUID I_BankPowerOfAttorney BankPowerOfAttorneyUUID UUID
BankPowerOfAttorney I_BankPowerOfAttorney BankPowerOfAttorney Power of Attorney ID
ValidityStartDate I_BankPowerOfAttorney ValidityStartDate Validity Start Date
ValidityEndDate I_BankPowerOfAttorney ValidityEndDate ValidTo
BkPOABankAccountAssignmentType I_BankPowerOfAttorney BkPOABankAccountAssignmentType BA Assignment Type
BankPowerOfAttorneyName I_BankPowerOfAttorney BankPowerOfAttorneyName POA Description
BankPowerOfAttorneyStatus I_BankPowerOfAttorney BankPowerOfAttorneyStatus Status
BkPOAAuthorizationGroup I_BankPowerOfAttorney BkPOAAuthorizationGroup Authorization Group
PaymentApprovalRule I_BankPowerOfAttorney PaymentApprovalRule Payment Approval Rule
BankPowerOfAttorneyType I_BankPowerOfAttorney BankPowerOfAttorneyType
BankPowerOfAttorneyIsBlocked I_BankPowerOfAttorney BankPowerOfAttorneyIsBlocked POA Is Blocked
BankPowerOfAttorneyTypeName
BankPowerOfAttorneyStatusName
BkPOABkAcctAssignmentTypeName
BkPOAAuthorizationGroupName
_BkPOAAuthorizationGroupTxt I_BankPowerOfAttorney _BkPOAAuthorizationGroupTxt
_BkPOABkAcctAssignmentTypeTxt I_BankPowerOfAttorney _BkPOABkAcctAssignmentTypeTxt
_BkPOAStatusText I_BankPowerOfAttorney _BkPOAStatusText
_BkPOASuccessor I_BankPowerOfAttorney _BkPOASuccessor
_BkPOAType I_BankPowerOfAttorney _BkPOAType
_BkPOAComparisonSourceText _BkPOAComparisonSourceText

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_BkPowerOfAttorneyComparison.
-- 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.
-- Parameters: P_BkPowerOfAttorneyOriginUUID : fclm_poa_uuid, P_BankPowerOfAttorneyOtherUUID : fclm_poa_uuid, P_BkPOAOriginIsSuccessor : boolean

CREATE VIEW C_BkPowerOfAttorneyComparison AS
SELECT
  _BankPowerOfAttorney.BankPowerOfAttorneyUUID AS BankPowerOfAttorneyUUID,
  _BankPowerOfAttorney.BankPowerOfAttorney AS BankPowerOfAttorney,
  _BankPowerOfAttorney.ValidityStartDate AS ValidityStartDate,
  _BankPowerOfAttorney.ValidityEndDate AS ValidityEndDate,
  _BankPowerOfAttorney.BkPOABankAccountAssignmentType AS BkPOABankAccountAssignmentType,
  _BankPowerOfAttorney.BankPowerOfAttorneyName AS BankPowerOfAttorneyName,
  _BankPowerOfAttorney.BankPowerOfAttorneyStatus AS BankPowerOfAttorneyStatus,
  _BankPowerOfAttorney.BkPOAAuthorizationGroup AS BkPOAAuthorizationGroup,
  _BankPowerOfAttorney.PaymentApprovalRule AS PaymentApprovalRule,
  _BankPowerOfAttorney.BankPowerOfAttorneyType AS BankPowerOfAttorneyType,
  _BankPowerOfAttorney.BankPowerOfAttorneyIsBlocked AS BankPowerOfAttorneyIsBlocked,
  _BankPowerOfAttorney._BkPOAType._Text[1:Language = $session.system_language].BankPowerOfAttorneyTypeName AS BankPowerOfAttorneyTypeName,
  _BankPowerOfAttorney._BkPOAStatusText[1:Language = $session.system_language].BankPowerOfAttorneyStatusName AS BankPowerOfAttorneyStatusName,
  _BankPowerOfAttorney._BkPOABkAcctAssignmentTypeTxt[1:Language = $session.system_language].BkPOABkAcctAssignmentTypeName AS BkPOABkAcctAssignmentTypeName,
  _BankPowerOfAttorney._BkPOAAuthorizationGroupTxt[1:Language = $session.system_language].BkPOAAuthorizationGroupName AS BkPOAAuthorizationGroupName,
  _BankPowerOfAttorney._BkPOAAuthorizationGroupTxt AS _BkPOAAuthorizationGroupTxt,
  _BankPowerOfAttorney._BkPOABkAcctAssignmentTypeTxt AS _BkPOABkAcctAssignmentTypeTxt,
  _BankPowerOfAttorney._BkPOAStatusText AS _BkPOAStatusText,
  _BankPowerOfAttorney._BkPOASuccessor AS _BkPOASuccessor,
  _BankPowerOfAttorney._BkPOAType AS _BkPOAType
FROM I_BankPowerOfAttorney AS _BankPowerOfAttorney
LEFT OUTER JOIN I_BkPOAComparisonSourceText AS _BkPOAComparisonSourceText ON BkPOAComparisonSource = _BkPOAComparisonSourceText.BkPOAComparisonSource  -- association [0..*]
;

Learn More