R_WrkAssgmtPaymentTP_3

DDL: R_WRKASSGMTPAYMENTTP_3 Type: view_entity TRANSACTIONAL Package: WFD_INT_RAP_ODATA
22 Fields 1 Data Sources 1 Associations

Work Assignment Payment details

R_WrkAssgmtPaymentTP_3 is a Transactional CDS View that provides data about "Work Assignment Payment details" in SAP S/4HANA. It reads from 1 data source (R_WorkAssignmentPayment_1) and exposes 22 fields with key fields WorkforcePersonExternalID, WorkAssignmentExternalID, Country2DigitISOCode, BankIdentification. It has 1 association to related views. Part of development package WFD_INT_RAP_ODATA.

Data Sources (1)

SourceAliasJoin Type
R_WorkAssignmentPayment_1 R_WorkAssignmentPayment_1 from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_WorkforcePersonTP_3 _WorkforcePerson _WorkforcePerson.WorkforcePersonExternalID = $projection.WorkforcePersonExternalID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Work Assignment Payment details view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #REQUIRED view

Fields (22)

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)
_WorkAssignment _WorkAssignment
_WorkforcePerson _WorkforcePerson

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 R_WrkAssgmtPaymentTP_3.
-- 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 R_WrkAssgmtPaymentTP_3 AS
SELECT
  WorkforcePersonExternalID,
  WorkAssignmentExternalID,
  Country2DigitISOCode,
  BankIdentification,
  BusinessPartner,
  BankAccountHolderName,
  BankAccountName,
  BankControlKey,
  BankCountryKey,
  BankNumber,
  BankName,
  BankAccount,
  IBAN,
  SWIFTCode,
  WorkAssignmentStartDate,
  WorkAssignmentEndDate,
  BankAccountReferenceText,
  WorkerPaymentMethod,
  WrkFrcPaymentCurrency,
  IsBlocked
FROM R_WorkAssignmentPayment_1
LEFT OUTER JOIN R_WorkforcePersonTP_3 AS _WorkforcePerson ON _WorkforcePerson.WorkforcePersonExternalID = WorkforcePersonExternalID  -- association [1..1]
;

Learn More