C_WorkAssignmentPayment

DDL: C_WORKASSIGNMENTPAYMENT Type: view_entity CONSUMPTION Package: WFD_WORKER_FACTSHEET_BL
28 Fields 1 Data Sources 1 OData Services

Payment for Workforce Person

C_WorkAssignmentPayment is a Consumption CDS View that provides data about "Payment for Workforce Person" in SAP S/4HANA. It reads from 1 data source (R_WorkAssignmentPayment) and exposes 28 fields with key fields WorkAssignmentUUID, BankIdentification. It is exposed through 1 OData service (UI_WORKER_FACTSHEET). Part of development package WFD_WORKER_FACTSHEET_BL.

Data Sources (1)

SourceAliasJoin Type
R_WorkAssignmentPayment R_WorkAssignmentPayment projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Payment for Workforce Person 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

OData Services (1)

ServiceBindingVersionContractRelease
UI_WORKER_FACTSHEET UI_WORKER_FACTSHEET V4 C1 NOT_RELEASED

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignmentUUID WorkAssignmentUUID BP GUID
KEY BankIdentification BankIdentification Bank Details
EmployeeInternalID EmployeeInternalID Busn. Partner
EmploymentInternalID EmploymentInternalID WorkForce Assgmt ID
WorkforcePersonExternalID WorkforcePersonExternalID External Person 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
PaymentMethodsList PaymentMethodsList Payment Methods
PaymentMethod PaymentMethod Pymt Meth.
PaymentMethodName _FinancePaymentMethodText PaymentMethodDescription
ValidityEndDate ValidityEndDate ValidTo
ValidityStartDate ValidityStartDate Validity Start Date
BankReference BankReference Payment Reference
CompanyCode CompanyCode Receiver Company Code
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
PaymentMethodInEmplCentral PaymentMethodInEmplCentral
PaymentMethodDescription _PaymentMethodText PaymentMethodDescription
Currency Currency Valuation Crcy
CurrencyName _CurrencyText CurrencyName
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_WorkAssignmentPayment.
-- 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_WorkAssignmentPayment AS
SELECT
  WorkAssignmentUUID,
  BankIdentification,
  EmployeeInternalID,
  EmploymentInternalID,
  WorkforcePersonExternalID,
  BankAccountHolderName,
  BankAccountName,
  BankControlKey,
  BankCountryKey,
  _CountryText.CountryName AS CountryName,
  Bank,
  BankName,
  BankAccount,
  IBAN,
  SWIFTCode,
  PaymentMethodsList,
  PaymentMethod,
  _FinancePaymentMethodText.PaymentMethodDescription AS PaymentMethodName,
  ValidityEndDate,
  ValidityStartDate,
  BankReference,
  CompanyCode,
  CompanyCodeCountry,
  PaymentMethodInEmplCentral,
  _PaymentMethodText.PaymentMethodDescription AS PaymentMethodDescription,
  Currency,
  _CurrencyText.CurrencyName AS CurrencyName,
  BusinessPartner
FROM R_WorkAssignmentPayment
;

Learn More