C_WorkAssignmentBankAccount_2

DDL: C_WORKASSIGNMENTBANKACCOUNT_2 Type: view_entity CONSUMPTION Package: ODATA_CA_BUM_WF
17 Fields 1 Data Sources 2 OData Services

Bank Accounts

C_WorkAssignmentBankAccount_2 is a Consumption CDS View that provides data about "Bank Accounts" in SAP S/4HANA. It reads from 1 data source (R_WrkAssignmentBankAccountTP_2) and exposes 17 fields with key fields WorkAssignmentBusinessPartner, BankIdentification. It is exposed through 2 OData services (ASQL_F6097A, UI_WORKFORCE_MANAGE_2). Part of development package ODATA_CA_BUM_WF.

Data Sources (1)

SourceAliasJoin Type
R_WrkAssignmentBankAccountTP_2 R_WrkAssignmentBankAccountTP_2 projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Bank Accounts view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
AccessControl.personalData.blocking #NOT_REQUIRED view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F6097A ASQL_F6097A C2 NOT_RELEASED
UI_WORKFORCE_MANAGE_2 UI_WORKFORCE_MANAGE_2 V4 C1 NOT_RELEASED

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignmentBusinessPartner WorkAssignmentBusinessPartner Busn. Partner
KEY BankIdentification BankIdentification Bank Details
WorkforceAssignment WorkforceAssignment WorkForce Assgmt ID
BankAccountHolderName BankAccountHolderName Account Holder
BankAccountName BankAccountName Account Name
BankControlKey BankControlKey Control Key
BankCountryKey BankCountryKey Bank Ctry/Reg.
CountryName _CountryText CountryName Country
Bank Bank Bank Number
BankName BankName Bank Name
BankAccount BankAccount Bank acct
IBAN IBAN IBAN House Bank
SWIFTCode SWIFTCode SWIFT/BIC
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
BankReference BankReference Payment Reference
BusinessPartner BusinessPartner Issuing Authority

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_WorkAssignmentBankAccount_2.
-- 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_WorkAssignmentBankAccount_2 AS
SELECT
  WorkAssignmentBusinessPartner,
  BankIdentification,
  WorkforceAssignment,
  BankAccountHolderName,
  BankAccountName,
  BankControlKey,
  BankCountryKey,
  _CountryText.CountryName AS CountryName,
  Bank,
  BankName,
  BankAccount,
  IBAN,
  SWIFTCode,
  ValidityStartDate,
  ValidityEndDate,
  BankReference,
  BusinessPartner
FROM R_WrkAssignmentBankAccountTP_2
;

Learn More