R_WorkAssignmentTP_2

DDL: R_WORKASSIGNMENTTP_2 Type: view_entity TRANSACTIONAL Package: ODATA_CA_BUM_WF

Work assignment TP

R_WorkAssignmentTP_2 is a Transactional CDS View that provides data about "Work assignment TP" in SAP S/4HANA. It reads from 1 data source (R_WorkAssignment_2) and exposes 50 fields with key field WorkAssignmentBusinessPartner. It has 7 associations to related views. Part of development package ODATA_CA_BUM_WF.

1 data source(s) 50 fields

Data Sources (1)

SourceAliasJoin Type
R_WorkAssignment_2 R_WorkAssignment_2 from

Associations (7)

CardinalityTargetAliasCondition
[1..*] R_WorkAssignmentDetailsTP_2 _WorkAssignmentDetails
[0..*] R_WorkAssgmtSrvcCostLvlTP_2 _WorkAssgmtSrvcCostLvl
[0..*] R_BPRltnShipSupplierTP_2 _BPRltnShipSupplier
[0..*] R_WorkAssgmtAltCostAssgmtTP_2 _WorkAssgmtAltCostAssgmt
[0..*] R_WrkAssignmentBankAccountTP_2 _WorkAssignmentBankAccount
[0..*] R_WrkAssgmtPaymentMethodTP_2 _WrkAssgmtPaymentMethod
[0..*] R_WorkAssgmtPrivateAddressTP_2 _WorkAssgmtPrivateAddress

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Work assignment TP view
Metadata.ignorePropagatedAnnotations true 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 #MASTER view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignmentBusinessPartner R_WorkAssignment_2 WorkAssignmentBusinessPartner
WorkAssignmentUUID R_WorkAssignment_2 WorkAssignmentUUID
StartDate R_WorkAssignment_2 StartDate
EndDate R_WorkAssignment_2 EndDate
WorkAssignment R_WorkAssignment_2 WorkAssignment
WorkAssignmentExternalID R_WorkAssignment_2 WorkAssignmentExternalID
WorkforcePersonID R_WorkAssignment_2 WorkforcePersonID
WorkforcePersonUserID R_WorkAssignment_2 WorkforcePersonUserID
WorkAssignmentDataSource R_WorkAssignment_2 WorkAssignmentDataSource
BusinessPartner R_WorkAssignment_2 BusinessPartner
CompanyCode R_WorkAssignment_2 CompanyCode
CompanyCodeCountry R_WorkAssignment_2 CompanyCodeCountry
Currency R_WorkAssignment_2 Currency
WorkAssignmentCountryISOCode R_WorkAssignment_2 WorkAssignmentCountryISOCode
RoleCategory R_WorkAssignment_2 RoleCategory
BasicRoleCategory R_WorkAssignment_2 BasicRoleCategory
BusinessPartnerRole R_WorkAssignment_2 BusinessPartnerRole
EmploymentSituation R_WorkAssignment_2 EmploymentSituation
BusPartRelshpSupplierIsVisible R_WorkAssignment_2 BusPartRelshpSupplierIsVisible
CreationDateTime R_WorkAssignment_2 CreationDateTime
BusinessPartnerRelshpSupplier R_WorkAssignment_2 BusinessPartnerRelshpSupplier
BusinessPartnerName R_WorkAssignment_2 BusinessPartnerName
IsBlocked R_WorkAssignment_2 IsBlocked
IsBusinessPurposeCompleted R_WorkAssignment_2 IsBusinessPurposeCompleted
AuthorizationGroup R_WorkAssignment_2 AuthorizationGroup
DataControllerSet R_WorkAssignment_2 DataControllerSet
DataController1 R_WorkAssignment_2 DataController1
DataController2 R_WorkAssignment_2 DataController2
DataController3 R_WorkAssignment_2 DataController3
DataController4 R_WorkAssignment_2 DataController4
DataController5 R_WorkAssignment_2 DataController5
DataController6 R_WorkAssignment_2 DataController6
DataController7 R_WorkAssignment_2 DataController7
DataController8 R_WorkAssignment_2 DataController8
DataController9 R_WorkAssignment_2 DataController9
DataController10 R_WorkAssignment_2 DataController10
_BPUsrRoleText R_WorkAssignment_2 _BPUsrRoleText
_CompanyCodeText R_WorkAssignment_2 _CompanyCodeText
_WorkforcePerson _WorkforcePerson
_WorkAssignmentBP _WorkAssignmentBP
_WorkAssignmentDetails _WorkAssignmentDetails
_WorkAssgmtSrvcCostLvl _WorkAssgmtSrvcCostLvl
_BPRltnShipSupplier _BPRltnShipSupplier
_WorkAssgmtAltCostAssgmt _WorkAssgmtAltCostAssgmt
_WorkAssignmentBankAccount _WorkAssignmentBankAccount
_WrkAssgmtPaymentMethod _WrkAssgmtPaymentMethod
_WorkAssgmtPrivateAddress _WorkAssgmtPrivateAddress
_CurrencyText _CurrencyText
_CountryText _CountryText
_EntrySourceText _EntrySourceText 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Work assignment TP'
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
//@AccessControl.privilegedAssociations: [ '_BPDataControllerUsage' ]


@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #MASTER
}
//@Consumption.dbHints: ['USE_HEX_PLAN']

@Consumption.dbHints: [ '&PREFER_JOIN_WITH_FDA 0&', 'USE_HEX_PLAN' ]
define view entity R_WorkAssignmentTP_2
  as select from R_WorkAssignment_2
  composition [1..*] of R_WorkAssignmentDetailsTP_2    as _WorkAssignmentDetails
  composition [0..*] of R_WorkAssgmtSrvcCostLvlTP_2    as _WorkAssgmtSrvcCostLvl
  composition [0..*] of R_BPRltnShipSupplierTP_2       as _BPRltnShipSupplier
  composition [0..*] of R_WorkAssgmtAltCostAssgmtTP_2  as _WorkAssgmtAltCostAssgmt
  composition [0..*] of R_WrkAssignmentBankAccountTP_2 as _WorkAssignmentBankAccount
  composition [0..*] of R_WrkAssgmtPaymentMethodTP_2   as _WrkAssgmtPaymentMethod
  composition [0..*] of R_WorkAssgmtPrivateAddressTP_2 as _WorkAssgmtPrivateAddress
  association to parent R_WorkforcePersonTP_2          as _WorkforcePerson on $projection.BusinessPartner = _WorkforcePerson.BusinessPartner
{
  key R_WorkAssignment_2.WorkAssignmentBusinessPartner,
      R_WorkAssignment_2.WorkAssignmentUUID,
      R_WorkAssignment_2.StartDate,
      R_WorkAssignment_2.EndDate,
      R_WorkAssignment_2.WorkAssignment,
      R_WorkAssignment_2.WorkAssignmentExternalID,
      R_WorkAssignment_2.WorkforcePersonID,
      R_WorkAssignment_2.WorkforcePersonUserID,
      R_WorkAssignment_2.WorkAssignmentDataSource,
      R_WorkAssignment_2.BusinessPartner,
      R_WorkAssignment_2.CompanyCode,
      R_WorkAssignment_2.CompanyCodeCountry,
      R_WorkAssignment_2.Currency, //Company Currency

      R_WorkAssignment_2.WorkAssignmentCountryISOCode,
      R_WorkAssignment_2.RoleCategory,
      R_WorkAssignment_2.BasicRoleCategory,
      R_WorkAssignment_2.BusinessPartnerRole,
      R_WorkAssignment_2.EmploymentSituation,
      R_WorkAssignment_2.BusPartRelshpSupplierIsVisible,
      R_WorkAssignment_2.CreationDateTime,
      R_WorkAssignment_2.BusinessPartnerRelshpSupplier,
      R_WorkAssignment_2.BusinessPartnerName,
      @Semantics.booleanIndicator
      R_WorkAssignment_2.IsBlocked,
      @Semantics.booleanIndicator
      R_WorkAssignment_2.IsBusinessPurposeCompleted,
      R_WorkAssignment_2.AuthorizationGroup,
      R_WorkAssignment_2.DataControllerSet,
      R_WorkAssignment_2.DataController1,
      R_WorkAssignment_2.DataController2,
      R_WorkAssignment_2.DataController3,
      R_WorkAssignment_2.DataController4,
      R_WorkAssignment_2.DataController5,
      R_WorkAssignment_2.DataController6,
      R_WorkAssignment_2.DataController7,
      R_WorkAssignment_2.DataController8,
      R_WorkAssignment_2.DataController9,
      R_WorkAssignment_2.DataController10,
      /* Associations */
      R_WorkAssignment_2._BPUsrRoleText,
      R_WorkAssignment_2._CompanyCodeText,
      _WorkforcePerson,
      _WorkAssignmentBP,
      _WorkAssignmentDetails,
      _WorkAssgmtSrvcCostLvl,
      _BPRltnShipSupplier,
      _WorkAssgmtAltCostAssgmt,
      _WorkAssignmentBankAccount,
      _WrkAssgmtPaymentMethod,
      _WorkAssgmtPrivateAddress,
      _CurrencyText,
      _CountryText,
      _EntrySourceText
}

Learn More