A_WorkAssignmentPayment

DDL: A_WORKASSIGNMENTPAYMENT Type: view_entity CONSUMPTION Package: WFD_INT_RAP_ODATA
20 Fields 1 Data Sources 1 OData Services

Workforce Person Assignment Payment Consumption CDS View

A_WorkAssignmentPayment is a Consumption CDS View that provides data about "Workforce Person Assignment Payment Consumption CDS View" in SAP S/4HANA. It reads from 1 data source (R_WrkAssgmtPaymentTP_3) and exposes 20 fields with key fields WorkforcePersonExternalID, WorkAssignmentExternalID, Country2DigitISOCode, BankIdentification. It is exposed through 1 OData service (API_WORKFORCEPERSON). Part of development package WFD_INT_RAP_ODATA.

Data Sources (1)

SourceAliasJoin Type
R_WrkAssgmtPaymentTP_3 R_WrkAssgmtPaymentTP_3 projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Workforce Person Assignment Payment Consumption CDS View view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name WorkAssignmentPayment_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_WORKFORCEPERSON API_WORKFORCEPERSON V4 C2 NOT_RELEASED

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY WorkforcePersonExternalID WorkforcePersonExternalID External Person ID
KEY WorkAssignmentExternalID WorkAssignmentExternalID WFA Ext. ID
KEY Country2DigitISOCode Country2DigitISOCode Country/Region
KEY BankIdentification BankIdentification Bank Details
BusinessPartner BusinessPartner Issuing Authority
BankAccountHolderName BankAccountHolderName Account Holder
BankAccountName BankAccountName Account Name
BankControlKey BankControlKey Control Key
BankCountryKey BankCountryKey Bank Ctry/Reg.
BankNumber BankNumber Bank Key
BankName BankName Bank Name
BankAccount BankAccount Bank acct
IBAN IBAN IBAN House Bank
SWIFTCode SWIFTCode SWIFT/BIC
WorkAssignmentStartDate WorkAssignmentStartDate Start Date
WorkAssignmentEndDate WorkAssignmentEndDate End Date
BankAccountReferenceText BankAccountReferenceText Reference
WorkerPaymentMethod WorkerPaymentMethod Payment Method
WrkFrcPaymentCurrency WrkFrcPaymentCurrency
IsBlocked IsBlocked Boolean Variable (X = True, - = False, Space = Unknown)

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 A_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 A_WorkAssignmentPayment AS
SELECT
  WorkforcePersonExternalID,
  WorkAssignmentExternalID,
  Country2DigitISOCode,
  BankIdentification,
  BusinessPartner,
  BankAccountHolderName,
  BankAccountName,
  BankControlKey,
  BankCountryKey,
  BankNumber,
  BankName,
  BankAccount,
  IBAN,
  SWIFTCode,
  WorkAssignmentStartDate,
  WorkAssignmentEndDate,
  BankAccountReferenceText,
  WorkerPaymentMethod,
  WrkFrcPaymentCurrency,
  IsBlocked
FROM R_WrkAssgmtPaymentTP_3
;

Learn More