R_WorkAssignmentTP

DDL: R_WORKASSIGNMENTTP Type: view_entity TRANSACTIONAL Package: ODATA_CA_BUM_WF

Work assignment TP

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

1 data source(s) 52 fields

Data Sources (1)

SourceAliasJoin Type
R_WorkAssignmentBasic R_WorkAssignmentBasic from

Associations (7)

CardinalityTargetAliasCondition
[1..*] R_WorkAssignmentDetailsTP _WorkAssignmentDetails
[0..*] R_WorkAssgmtSrvcCostLvlTP _WorkAssgmtSrvcCostLvl
[0..*] R_BPRltnShipSupplierTP _BPRltnShipSupplier
[0..*] R_WorkAssgmtAltCostAssgmtTP _WorkAssgmtAltCostAssgmt
[0..*] R_WorkAssignmentBankAccountTP _WorkAssignmentBankAccount
[0..*] R_WorkAssgmtPrivateAddressTP _WorkAssgmtPrivateAddress
[0..*] R_WrkAssgmtPaymentMethodTP _WrkAssgmtPaymentMethod

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK 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 (52)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignmentUUID R_WorkAssignmentBasic WorkAssignmentUUID
StartDate R_WorkAssignmentBasic StartDate
EndDate R_WorkAssignmentBasic EndDate
WorkAssignment R_WorkAssignmentBasic WorkAssignment
WorkAssignmentExternalID R_WorkAssignmentBasic WorkAssignmentExternalID
WorkforcePersonID R_WorkAssignmentBasic WorkforcePersonID
WorkforcePersonUserID R_WorkAssignmentBasic WorkforcePersonUserID
WorkAssignmentDataSource R_WorkAssignmentBasic WorkAssignmentDataSource
WorkAssignmentBusinessPartner R_WorkAssignmentBasic WorkAssignmentBusinessPartner
Person R_WorkAssignmentBasic Person
PersonUUID R_WorkAssignmentBasic PersonUUID
CompanyCode R_WorkAssignmentBasic CompanyCode
CompanyCodeCountry R_WorkAssignmentBasic CompanyCodeCountry
Currency R_WorkAssignmentBasic Currency
WorkAssignmentCountryISOCode R_WorkAssignmentBasic WorkAssignmentCountryISOCode
RoleCategory R_WorkAssignmentBasic RoleCategory
BasicRoleCategory R_WorkAssignmentBasic BasicRoleCategory
BusinessPartnerRole R_WorkAssignmentBasic BusinessPartnerRole
EmploymentSituation R_WorkAssignmentBasic EmploymentSituation
BusPartRelshpSupplierIsVisible R_WorkAssignmentBasic BusPartRelshpSupplierIsVisible
CreationDateTime R_WorkAssignmentBasic CreationDateTime
BusinessPartnerRelshpSupplier R_WorkAssignmentBasic BusinessPartnerRelshpSupplier
BusinessPartnerName R_WorkAssignmentBasic BusinessPartnerName
IsBlocked R_WorkAssignmentBasic IsBlocked
IsBusinessPurposeCompleted R_WorkAssignmentBasic IsBusinessPurposeCompleted
AuthorizationGroup R_WorkAssignmentBasic AuthorizationGroup
DataControllerSet R_WorkAssignmentBasic DataControllerSet
DataController1 R_WorkAssignmentBasic DataController1
DataController2 R_WorkAssignmentBasic DataController2
DataController3 R_WorkAssignmentBasic DataController3
DataController4 R_WorkAssignmentBasic DataController4
DataController5 R_WorkAssignmentBasic DataController5
DataController6 R_WorkAssignmentBasic DataController6
DataController7 R_WorkAssignmentBasic DataController7
DataController8 R_WorkAssignmentBasic DataController8
DataController9 R_WorkAssignmentBasic DataController9
DataController10 R_WorkAssignmentBasic DataController10
_BPUsrRoleText R_WorkAssignmentBasic _BPUsrRoleText
_CompanyCodeText R_WorkAssignmentBasic _CompanyCodeText
_CurrencyText R_WorkAssignmentBasic _CurrencyText
_CountryText R_WorkAssignmentBasic _CountryText
_EntrySourceText R_WorkAssignmentBasic _EntrySourceText
_WorkAssignmentBP R_WorkAssignmentBasic _WorkAssignmentBP
_WorkforcePersonBP R_WorkAssignmentBasic _WorkforcePersonBP
_WorkAssgmtSrvcCostLvl _WorkAssgmtSrvcCostLvl
_BPRltnShipSupplier _BPRltnShipSupplier
_WorkAssgmtAltCostAssgmt _WorkAssgmtAltCostAssgmt
_WorkAssignmentBankAccount _WorkAssignmentBankAccount
_WorkAssgmtPrivateAddress _WorkAssgmtPrivateAddress
_WorkforcePerson _WorkforcePerson
_WorkAssignmentDetails _WorkAssignmentDetails
_WrkAssgmtPaymentMethod _WrkAssgmtPaymentMethod 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@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: [ '&PREFER_JOIN_WITH_FDA 0&', 'USE_HEX_PLAN' ]
define view entity R_WorkAssignmentTP

  as select from R_WorkAssignmentBasic

  composition [1..*] of R_WorkAssignmentDetailsTP     as _WorkAssignmentDetails
  composition [0..*] of R_WorkAssgmtSrvcCostLvlTP     as _WorkAssgmtSrvcCostLvl
  composition [0..*] of R_BPRltnShipSupplierTP        as _BPRltnShipSupplier
  composition [0..*] of R_WorkAssgmtAltCostAssgmtTP   as _WorkAssgmtAltCostAssgmt
  composition [0..*] of R_WorkAssignmentBankAccountTP as _WorkAssignmentBankAccount
  composition [0..*] of R_WorkAssgmtPrivateAddressTP  as _WorkAssgmtPrivateAddress
  composition [0..*] of R_WrkAssgmtPaymentMethodTP    as _WrkAssgmtPaymentMethod
  association to parent R_WorkforcePersonTP           as _WorkforcePerson on $projection.PersonUUID = _WorkforcePerson.PersonUUID
{
  key R_WorkAssignmentBasic.WorkAssignmentUUID,
      R_WorkAssignmentBasic.StartDate,
      R_WorkAssignmentBasic.EndDate,
      R_WorkAssignmentBasic.WorkAssignment,
      R_WorkAssignmentBasic.WorkAssignmentExternalID,
      R_WorkAssignmentBasic.WorkforcePersonID,
      R_WorkAssignmentBasic.WorkforcePersonUserID,
      R_WorkAssignmentBasic.WorkAssignmentDataSource,
      R_WorkAssignmentBasic.WorkAssignmentBusinessPartner,
      R_WorkAssignmentBasic.Person,
      R_WorkAssignmentBasic.PersonUUID,
      R_WorkAssignmentBasic.CompanyCode,
      R_WorkAssignmentBasic.CompanyCodeCountry,
      R_WorkAssignmentBasic.Currency, //Company Currency

      R_WorkAssignmentBasic.WorkAssignmentCountryISOCode,
      R_WorkAssignmentBasic.RoleCategory,
      R_WorkAssignmentBasic.BasicRoleCategory,
      R_WorkAssignmentBasic.BusinessPartnerRole,
      R_WorkAssignmentBasic.EmploymentSituation,
      R_WorkAssignmentBasic.BusPartRelshpSupplierIsVisible,
      R_WorkAssignmentBasic.CreationDateTime,
      R_WorkAssignmentBasic.BusinessPartnerRelshpSupplier,
      R_WorkAssignmentBasic.BusinessPartnerName,

      @Semantics.booleanIndicator
      R_WorkAssignmentBasic.IsBlocked,
      @Semantics.booleanIndicator
      R_WorkAssignmentBasic.IsBusinessPurposeCompleted,
      R_WorkAssignmentBasic.AuthorizationGroup,
      R_WorkAssignmentBasic.DataControllerSet,
      R_WorkAssignmentBasic.DataController1,
      R_WorkAssignmentBasic.DataController2,
      R_WorkAssignmentBasic.DataController3,
      R_WorkAssignmentBasic.DataController4,
      R_WorkAssignmentBasic.DataController5,
      R_WorkAssignmentBasic.DataController6,
      R_WorkAssignmentBasic.DataController7,
      R_WorkAssignmentBasic.DataController8,
      R_WorkAssignmentBasic.DataController9,
      R_WorkAssignmentBasic.DataController10,
      /* Associations */
      //      R_WorkAssignmentBasic._AssignmentDetailsForKeyDate,

      R_WorkAssignmentBasic._BPUsrRoleText,
      R_WorkAssignmentBasic._CompanyCodeText,
      R_WorkAssignmentBasic._CurrencyText,
      R_WorkAssignmentBasic._CountryText,
      R_WorkAssignmentBasic._EntrySourceText,
      R_WorkAssignmentBasic._WorkAssignmentBP,
      R_WorkAssignmentBasic._WorkforcePersonBP,
      _WorkAssgmtSrvcCostLvl,
      _BPRltnShipSupplier,
      _WorkAssgmtAltCostAssgmt,
      _WorkAssignmentBankAccount,
      _WorkAssgmtPrivateAddress,
      _WorkforcePerson,
      _WorkAssignmentDetails,
      _WrkAssgmtPaymentMethod

}

Learn More