R_WorkAssignmentPayment_1

DDL: R_WORKASSIGNMENTPAYMENT_1 Type: view_entity TRANSACTIONAL Package: WFD_INT_RAP

Work assignment Payment details

R_WorkAssignmentPayment_1 is a Transactional CDS View that provides data about "Work assignment Payment details" in SAP S/4HANA. It reads from 4 data sources (I_BusinessPartnerSuplrCo, R_WorkAssignmentBP, R_WorkAssignment_1, I_BusinessPartnerBank) and exposes 21 fields with key fields WorkAssignmentExternalID, Country2DigitISOCode, WorkAssignmentStartDate, BankIdentification. Part of development package WFD_INT_RAP.

4 data source(s) 21 fields

Data Sources (4)

SourceAliasJoin Type
I_BusinessPartnerSuplrCo _BPSupplier inner
R_WorkAssignmentBP _EmploymentBP inner
R_WorkAssignment_1 _Workassignment from
I_BusinessPartnerBank PaymentDetails inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Work assignment Payment details view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignmentExternalID R_WorkAssignment_1 WorkAssignmentExternalID
KEY Country2DigitISOCode R_WorkAssignment_1 Country2DigitISOCode
KEY WorkAssignmentStartDate R_WorkAssignment_1 WorkAssignmentStartDate
KEY BankIdentification I_BusinessPartnerBank BankIdentification
BusinessPartner R_WorkAssignmentBP BusinessPartner
WorkforcePersonExternalID R_WorkAssignmentBP WorkforcePersonExternalID
WorkAssignmentEndDate R_WorkAssignment_1 WorkAssignmentEndDate
BankAccountHolderName I_BusinessPartnerBank BankAccountHolderName
BankAccountName I_BusinessPartnerBank BankAccountName
BankControlKey I_BusinessPartnerBank BankControlKey
BankCountryKey I_BusinessPartnerBank BankCountryKey
BankNumber I_BusinessPartnerBank BankNumber
BankName I_BusinessPartnerBank BankName
BankAccount I_BusinessPartnerBank BankAccount
IBAN I_BusinessPartnerBank IBAN
SWIFTCode I_BusinessPartnerBank SWIFTCode
IBANValidityStartDate I_BusinessPartnerBank IBANValidityStartDate
BankAccountReferenceText I_BusinessPartnerBank BankAccountReferenceText
IsBlocked R_WorkAssignment_1 IsBlocked
WrkFrcPaymentCurrency
WorkerPaymentMethod 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #TRANSACTIONAL
@EndUserText.label: 'Work assignment Payment details'
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}
define view entity R_WorkAssignmentPayment_1
  as select from R_WorkAssignment_1    as _Workassignment
    inner join   R_WorkAssignmentBP    as _EmploymentBP  on  _EmploymentBP.WorkforceAssignment  =  _Workassignment.WorkAssignment
                                                         and _Workassignment.IsContingentWorker <> 'X'
    inner join   I_BusinessPartnerBank as PaymentDetails on _EmploymentBP.WorkAssignmentBusinessPartner = PaymentDetails.BusinessPartner
    inner join I_BusinessPartnerSuplrCo as _BPSupplier on _BPSupplier.BusinessPartner = _EmploymentBP.WorkAssignmentBusinessPartner
{

  key    _Workassignment.WorkAssignmentExternalID                                          as WorkAssignmentExternalID,
  key    _Workassignment.Country2DigitISOCode,
  key    _Workassignment.WorkAssignmentStartDate,
  key    PaymentDetails.BankIdentification,
         _EmploymentBP.BusinessPartner,
         _EmploymentBP.WorkforcePersonExternalID                                           as WorkforcePersonExternalID,
         _Workassignment.WorkAssignmentEndDate,
         PaymentDetails.BankAccountHolderName,
         PaymentDetails.BankAccountName,
         PaymentDetails.BankControlKey,
         PaymentDetails.BankCountryKey,
         PaymentDetails.BankNumber,
         PaymentDetails.BankName,
         PaymentDetails.BankAccount,
         PaymentDetails.IBAN,
         PaymentDetails.SWIFTCode,
         PaymentDetails.IBANValidityStartDate,
         PaymentDetails.BankAccountReferenceText,
         _Workassignment.IsBlocked,
         //         ,

         //         _BPSupplier.Supplier

         //         ,

         //         _BPSupplier.,

         //         _BPSupplier.Country,

         //         _BPSupplier.PaymentTerms

         //                  ,

         cast( _BPSupplier.Currency as /shcm/pay_currency) as WrkFrcPaymentCurrency,
         cast( _BPSupplier.PaymentMethodsList as wfd_payment_method ) as WorkerPaymentMethod
}
where
  (
       PaymentDetails.BankNumber  is not null
    or PaymentDetails.BankAccount is not null
    or PaymentDetails.IBAN        is not null
  )

Learn More