C_BankAcctTwoPersonRequestWlTP

DDL: C_BANKACCTTWOPERSONREQUESTWLTP Type: view_entity CONSUMPTION Package: FCLM_TWOPERSON
33 Fields 1 Data Sources 5 Associations 1 OData Services

Bank Account Two person request worklist

C_BankAcctTwoPersonRequestWlTP is a Consumption CDS View that provides data about "Bank Account Two person request worklist" in SAP S/4HANA. It reads from 1 data source (R_BankAcctTwoPersonRequestWlTP) and exposes 33 fields with key fields BankAccountChangeRequest, BankAccountInternalID, BankAccountRevision. It has 5 associations to related views. It is exposed through 1 OData service (C_BANKACCTTWOPERSONWORKLIST_SD). Part of development package FCLM_TWOPERSON.

Data Sources (1)

SourceAliasJoin Type
R_BankAcctTwoPersonRequestWlTP R_BankAcctTwoPersonRequestWlTP projection

Associations (5)

CardinalityTargetAliasCondition
[0..*] C_BankAcctModifiedFields _ModifiedFields $projection.BankAccountInternalID = _ModifiedFields.BankAccountInternalID and $projection.BankAccountRevision = _ModifiedFields.BankAccountRevision and $projection.BankAccountType = _ModifiedFields.BankAccountType and $projection.CompanyCode = _ModifiedFields.CompanyCode
[0..*] C_AcctDescForComparisonRslt _MultiDescriptionCR $projection.BankAccountInternalID = _MultiDescriptionCR.BankAccountInternalID and $projection.BankAccountRevision = _MultiDescriptionCR.BankAccountRevision and $projection.BankAccountType = _MultiDescriptionCR.BankAccountType and $projection.CompanyCode = _MultiDescriptionCR.CompanyCode
[0..*] C_AcctPaytApprvrForComprnRslt _PaymentApproverCR $projection.BankAccountInternalID = _PaymentApproverCR.BankAccountInternalID and $projection.BankAccountRevision = _PaymentApproverCR.BankAccountRevision and $projection.BankAccountType = _PaymentApproverCR.BankAccountType and $projection.CompanyCode = _PaymentApproverCR.CompanyCode
[0..*] C_AcctLinkageForComprnRslt _ConnectivityPathCR $projection.BankAccountInternalID = _ConnectivityPathCR.BankAccountInternalID and $projection.BankAccountRevision = _ConnectivityPathCR.BankAccountRevision and $projection.BankAccountType = _ConnectivityPathCR.BankAccountType and $projection.CompanyCode = _ConnectivityPathCR.CompanyCode
[0..*] C_AcctOvrdrftLmtForComprnRslt _OverdraftLimitCR $projection.BankAccountInternalID = _OverdraftLimitCR.BankAccountInternalID and $projection.BankAccountRevision = _OverdraftLimitCR.BankAccountRevision and $projection.BankAccountType = _OverdraftLimitCR.BankAccountType and $projection.CompanyCode = _OverdraftLimitCR.CompanyCode

Annotations (8)

NameValueLevelField
EndUserText.label Bank Account Two person request worklist view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #M view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
C_BANKACCTTWOPERSONWORKLIST_SD C_BKACCTTWOPERSONWL_SRV V2 C1 NOT_RELEASED

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY BankAccountChangeRequest BankAccountChangeRequest
KEY BankAccountInternalID BankAccountInternalID Technical ID
KEY BankAccountRevision BankAccountRevision
CompanyCode CompanyCode Receiver Company Code
BankAccountType BankAccountType Account Type
BankAcctChangeReqHeadingText BankAcctChangeReqHeadingText
BankAccountAction BankAccountAction
BankAccountActionTextlocalized
CreatedByUser CreatedByUser User Name
FullName _ContactCard FullName Name
BankAccountReqCreatedDateTime BankAccountReqCreatedDateTime
BankCountry BankCountry Bank Ctry/Rgn. Key
CountryNameasCountryNamelocalized
Bank Bank Bank Number
BankName _Bank BankName Bank Name
CompanyCodeName _Company CompanyCodeName Company Name
BankAccountCurrency BankAccountCurrency Currency
BankAccountStatus BankAccountStatus Account Status
BankAccountStatusNamelocalized
BankAccountNumber BankAccountNumber Bank Account
BankAccountDescription BankAccountDescription
BankAccountActivatedRevision BankAccountActivatedRevision
BankControlKey BankControlKey Control Key
BankAccountTypeTextlocalized
virtualModifiedFieldsSecIsHiddenboolean
virtualPaymentApproverSecIsHiddenboolean
virtualOverdraftLimitSecIsHiddenboolean
virtualBankAccountAttachmentKeyobjky
_ModifiedFields _ModifiedFields
_MultiDescriptionCR _MultiDescriptionCR
_PaymentApproverCR _PaymentApproverCR
_ConnectivityPathCR _ConnectivityPathCR
_OverdraftLimitCR _OverdraftLimitCR

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_BankAcctTwoPersonRequestWlTP.
-- 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_BankAcctTwoPersonRequestWlTP AS
SELECT
  BankAccountChangeRequest,
  BankAccountInternalID,
  BankAccountRevision,
  CompanyCode,
  BankAccountType,
  BankAcctChangeReqHeadingText,
  BankAccountAction,
  _BankAcctActionText.BankAccountActionText:localized AS BankAccountActionTextlocalized,
  CreatedByUser,
  _ContactCard.FullName AS FullName,
  BankAccountReqCreatedDateTime,
  BankCountry,
  _CountryText.CountryName as CountryName : localized AS CountryNameasCountryNamelocalized,
  Bank,
  _Bank.BankName AS BankName,
  _Company.CompanyCodeName AS CompanyCodeName,
  BankAccountCurrency,
  BankAccountStatus,
  _BankAcctStatus.BankAccountStatusName:localized AS BankAccountStatusNamelocalized,
  BankAccountNumber,
  BankAccountDescription,
  BankAccountActivatedRevision,
  BankControlKey,
  _AcctTypeText.BankAccountTypeText:localized AS BankAccountTypeTextlocalized,
  virtual ModifiedFieldsSecIsHidden:boolean AS virtualModifiedFieldsSecIsHiddenboolean,
  virtual PaymentApproverSecIsHidden:boolean AS virtualPaymentApproverSecIsHiddenboolean,
  virtual OverdraftLimitSecIsHidden:boolean AS virtualOverdraftLimitSecIsHiddenboolean,
  virtual BankAccountAttachmentKey:objky AS virtualBankAccountAttachmentKeyobjky
FROM R_BankAcctTwoPersonRequestWlTP
LEFT OUTER JOIN C_BankAcctModifiedFields AS _ModifiedFields ON BankAccountInternalID = _ModifiedFields.BankAccountInternalID AND BankAccountRevision = _ModifiedFields.BankAccountRevision AND BankAccountType = _ModifiedFields.BankAccountType AND CompanyCode = _ModifiedFields.CompanyCode  -- association [0..*]
LEFT OUTER JOIN C_AcctDescForComparisonRslt AS _MultiDescriptionCR ON BankAccountInternalID = _MultiDescriptionCR.BankAccountInternalID AND BankAccountRevision = _MultiDescriptionCR.BankAccountRevision AND BankAccountType = _MultiDescriptionCR.BankAccountType AND CompanyCode = _MultiDescriptionCR.CompanyCode  -- association [0..*]
LEFT OUTER JOIN C_AcctPaytApprvrForComprnRslt AS _PaymentApproverCR ON BankAccountInternalID = _PaymentApproverCR.BankAccountInternalID AND BankAccountRevision = _PaymentApproverCR.BankAccountRevision AND BankAccountType = _PaymentApproverCR.BankAccountType AND CompanyCode = _PaymentApproverCR.CompanyCode  -- association [0..*]
LEFT OUTER JOIN C_AcctLinkageForComprnRslt AS _ConnectivityPathCR ON BankAccountInternalID = _ConnectivityPathCR.BankAccountInternalID AND BankAccountRevision = _ConnectivityPathCR.BankAccountRevision AND BankAccountType = _ConnectivityPathCR.BankAccountType AND CompanyCode = _ConnectivityPathCR.CompanyCode  -- association [0..*]
LEFT OUTER JOIN C_AcctOvrdrftLmtForComprnRslt AS _OverdraftLimitCR ON BankAccountInternalID = _OverdraftLimitCR.BankAccountInternalID AND BankAccountRevision = _OverdraftLimitCR.BankAccountRevision AND BankAccountType = _OverdraftLimitCR.BankAccountType AND CompanyCode = _OverdraftLimitCR.CompanyCode  -- association [0..*]
;

Learn More