I_BankPowerOfAttorney

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_BankPowerOfAttorney.
-- 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_BankPowerOfAttorney AS
SELECT
  poa_uuid AS BankPowerOfAttorneyUUID,
  poa_id AS BankPowerOfAttorney,
  valid_from AS ValidityStartDate,
  valid_to AS ValidityEndDate,
  ba_assignment AS BkPOABankAccountAssignmentType,
  description AS BankPowerOfAttorneyName,
  status AS BankPowerOfAttorneyStatus,
  auth_group AS BkPOAAuthorizationGroup,
  par_id AS PaymentApprovalRule,
  last_changed_tstmp_utc AS LastChangeDateTime,
  created_by AS CreatedByUser,
  creation_tstmp_utc AS CreationDateTime,
  last_changed_by AS LastChangedByUser,
  local_last_changed_tstmp_utc AS LocalLastChangeDateTime,
  ret_period_begin_tstmp AS BkPOARtntnPeriodStartDateTime,
  is_blocked AS BankPowerOfAttorneyIsBlocked,
  poa_type AS BankPowerOfAttorneyType
FROM fclmpoa_hd
LEFT OUTER JOIN I_BkPOAAuthzdRepresentative AS _BkPOAAuthzdRepresentative ON BankPowerOfAttorneyUUID = _BkPOAAuthzdRepresentative.BankPowerOfAttorneyUUID  -- association [0..*]
LEFT OUTER JOIN I_BkPOACompanyCode AS _BkPOACompanyCode ON BankPowerOfAttorneyUUID = _BkPOACompanyCode.BankPowerOfAttorneyUUID  -- association [0..*]
LEFT OUTER JOIN I_BkPOABankAccountSelection AS _BkPOABankAccountSelection ON BankPowerOfAttorneyUUID = _BkPOABankAccountSelection.BankPowerOfAttorneyUUID  -- association [0..*]
LEFT OUTER JOIN I_BkPOABankAccount AS _BkPOABankAccount ON BankPowerOfAttorneyUUID = _BkPOABankAccount.BankPowerOfAttorneyUUID  -- association [0..*]
LEFT OUTER JOIN I_BkPOAStatusText AS _BkPOAStatusText ON BankPowerOfAttorneyStatus = _BkPOAStatusText.BankPowerOfAttorneyStatus  -- association [0..*]
LEFT OUTER JOIN I_BkPOAActivityAssignment AS _BkPOAActivityAssignment ON BankPowerOfAttorneyUUID = _BkPOAActivityAssignment.BankPowerOfAttorneyUUID  -- association [0..*]
LEFT OUTER JOIN I_BkPOABkAcctAssignmentTypeTxt AS _BkPOABkAcctAssignmentTypeTxt ON BkPOABankAccountAssignmentType = _BkPOABkAcctAssignmentTypeTxt.BkPOABankAccountAssignmentType  -- association [0..*]
LEFT OUTER JOIN I_BkPOAAuthorizationGroupTxt AS _BkPOAAuthorizationGroupTxt ON BkPOAAuthorizationGroup = _BkPOAAuthorizationGroupTxt.BkPOAAuthorizationGroup  -- association [0..*]
LEFT OUTER JOIN I_BkPOAPredecessor AS _BkPOAPredecessor ON BankPowerOfAttorneyUUID = _BkPOAPredecessor.BankPowerOfAttorneyUUID  -- association [0..*]
LEFT OUTER JOIN I_BkPOAPredecessor AS _BkPOASuccessor ON BankPowerOfAttorney = _BkPOASuccessor.BankPowerOfAttorneyPredecessor  -- association [0..1]
LEFT OUTER JOIN I_BankPowerOfAttorneyType AS _BkPOAType ON BankPowerOfAttorneyType = _BkPOAType.BankPowerOfAttorneyType  -- association [0..1]
;