C_BankAccReview

DDL: C_BANKACCREVIEW Type: view_entity CONSUMPTION Package: FCLM_BAM
9 Fields 1 Data Sources 1 Associations 1 OData Services

Bank Account Review Request

C_BankAccReview is a Consumption CDS View that provides data about "Bank Account Review Request" in SAP S/4HANA. It reads from 1 data source (I_BankAcctReview) and exposes 9 fields with key field BankAccountChangeRequest. It has 1 association to related views. It is exposed through 1 OData service (ASQL_F1370A). Part of development package FCLM_BAM.

Data Sources (1)

SourceAliasJoin Type
I_BankAcctReview req from

Associations (1)

CardinalityTargetAliasCondition
[1..*] C_BankAccReviewLog _ReviewLog $projection.BankAccountChangeRequest = _ReviewLog.BankAccountChangeRequest

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Bank Account Review Request view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
Search.searchable true view
UI.headerInfo.typeName Review Bank Accounts view
UI.headerInfo.typeNamePlural Review Bank Accounts view
UI.headerInfo.title.label Review ID view
UI.headerInfo.title.value BankAccountChangeRequest view
UI.headerInfo.description.label Review Title view
UI.headerInfo.description.value BankAcctChangeReqHeadingText view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F1370A ASQL_F1370A C2 NOT_RELEASED

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY BankAccountChangeRequest I_BankAcctReview BankAccountChangeRequest Review ID
BankAcctChangeReqHeadingText I_BankAcctReview BankAcctChangeReqHeadingText
BankAccountReqStatusText I_BankAcctReview BankAccountReqStatusText
BankAccountChangeRequestStatus I_BankAcctReview BankAccountChangeRequestStatus Overall Review Status
BankAcctChangeRequestDueDate I_BankAcctReview BankAcctChangeRequestDueDate
CreatedByUser I_BankAcctReview CreatedByUser User Name
FullName I_BankAcctReview FullName Name
BankAccountReqCreatedDateTime I_BankAcctReview BankAccountReqCreatedDateTime Initiated On/At
_ReviewLog _ReviewLog

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_BankAccReview.
-- 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_BankAccReview AS
SELECT
  req.BankAccountChangeRequest AS BankAccountChangeRequest,
  req.BankAcctChangeReqHeadingText AS BankAcctChangeReqHeadingText,
  req.BankAccountReqStatusText AS BankAccountReqStatusText,
  req.BankAccountChangeRequestStatus AS BankAccountChangeRequestStatus,
  req.BankAcctChangeRequestDueDate AS BankAcctChangeRequestDueDate,
  req.CreatedByUser AS CreatedByUser,
  req.FullName AS FullName,
  req.BankAccountReqCreatedDateTime AS BankAccountReqCreatedDateTime
FROM I_BankAcctReview AS req
LEFT OUTER JOIN C_BankAccReviewLog AS _ReviewLog ON BankAccountChangeRequest = _ReviewLog.BankAccountChangeRequest  -- association [1..*]
;

Learn More