I_HCMTimeShtAssgmtTP

DDL: I_HCMTIMESHTASSGMTTP Type: view_entity TRANSACTIONAL
152 Fields 1 Data Sources 2 OData Services 1 Fiori Apps

HCM Timesheet Assignment - TP

I_HCMTimeShtAssgmtTP is a Transactional CDS View that provides data about "HCM Timesheet Assignment - TP" in SAP S/4HANA. It reads from 1 data source (I_HCMTimeShtAssgmt) and exposes 152 fields with key field HCMTmeShtAssgmtUUID. It is exposed through 2 OData services (UI_HCMMYTIMESHEET, UI_HCMMYTIMESHEET). It is used in 1 Fiori application: My Timesheet (S/4HANA / Version 4).

Data Sources (1)

SourceAliasJoin Type
I_HCMTimeShtAssgmt I_HCMTimeShtAssgmt from

Annotations (7)

NameValueLevelField
EndUserText.label HCM Timesheet Assignment - TP view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey HCMTmeShtAssgmtUUID view
VDM.viewType #TRANSACTIONAL view

OData Services (2)

ServiceBindingVersionContractRelease
UI_HCMMYTIMESHEET API_HCMMYTIMESHEET V2 C2 NOT_RELEASED
UI_HCMMYTIMESHEET UI_HCMMYTIMESHEET V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F3074A My Timesheet (S/4HANA / Version 4) Transactional You, as an employee, can use this app to manage your time entries quickly and efficiently using a desktop or a mobile device.

My Timesheet (S/4HANA / Version 4)

Business Role: Employee - HR Info

You, as an employee, can use this app to manage your time entries quickly and efficiently using a desktop or a mobile device. You can use this app to do the following: enter time records for the chosen personnel assignment using form entry or assignments. create or import assignments and manage them. create and manage assignment groups. use horizontal or grid view for time entries. view the calendar for a chosen month on a desktop device, and for a given week on a mobile device. copy and paste time records. access the to-do list. switch between the allowed data entry profiles for a given time entry.

Fields (152)

KeyFieldSource TableSource FieldDescription
KEY HCMTmeShtAssgmtUUID HCMTmeShtAssgmtUUID WorklistID
HCMTimeShtUser HCMTimeShtUser User Name
HCMTmeShtAssgmtName HCMTmeShtAssgmtName Zone name
HCMTimeShtRecdApproverID HCMTimeShtRecdApproverID PPA Req Approver
HCMTmeShtRecdApprvrName HCMTmeShtRecdApprvrName
HCMTmeShtAssgmtIsAdminAssgmt HCMTmeShtAssgmtIsAdminAssgmt TRUE
HCMTmeShtAssgmtIsActv HCMTmeShtAssgmtIsActv TRUE
HCMTmeShtAssgmtIsFavorite HCMTmeShtAssgmtIsFavorite TRUE
HCMTimeShtEndDate HCMTimeShtEndDate
HCMTimeShtAssgmtStartDate HCMTimeShtAssgmtStartDate Valid From
HCMTimeShtAssgmtEndDate HCMTimeShtAssgmtEndDate Valid To
HCMShortTextComment HCMShortTextComment Short Text
HCMCommentIsLongText HCMCommentIsLongText Text Name
HCMTimeShtRecdIsForFullDay HCMTimeShtRecdIsForFullDay Full-day
HCMTimeShtRecdStartTime HCMTimeShtRecdStartTime Start time
HCMTimeShtRecdEndTime HCMTimeShtRecdEndTime End time
HCMTimeShtRecdTransCrcy HCMTimeShtRecdTransCrcy Trans. Currency
HCMTimeShtRecdDisplayUoM HCMTimeShtRecdDisplayUoM Unit of Measure
HCMTimeShtRecdUoM HCMTimeShtRecdUoM UoM
HCMTimeShtRecdRecordedHrs HCMTimeShtRecdRecordedHrs Hours
HCMTimeShtRecdRecordedQuantity HCMTimeShtRecdRecordedQuantity Number (unit)
HCMTimeShtRecdRecordedAmount HCMTimeShtRecdRecordedAmount
HCMTimeSheetRecordPriceInTC HCMTimeSheetRecordPriceInTC RVP f.PricePro.
Currency Currency Valuation Crcy
PersonnelNumber
HCMTimeShtDataEntryProfileID
HCMWorkDate
HCMAttendanceAbsenceType HCMAttendanceAbsenceType Att./abs. type
ControllingArea ControllingArea Controlling Area
HCMActivityType HCMActivityType Activity Type
HCMPremiumNumberCode HCMPremiumNumberCode Premium no.
HCMPremiumIndicatorCode HCMPremiumIndicatorCode Premium ID
HCMAccountingIndicatorCode HCMAccountingIndicatorCode AcctIndicator
HCMExternalProjectID HCMExternalProjectID Project
HCMProjectUUID HCMProjectUUID
HCMProjectSubObjectID HCMProjectSubObjectID Subobject
HCMProjectObjectUUID HCMProjectObjectUUID Subobject
HCMProjectObjectType HCMProjectObjectType Object Type
HCMExternalApplication HCMExternalApplication External appl.
HCMExternalDocument HCMExternalDocument Document no.
HCMExtraPayValuation HCMExtraPayValuation Qty Struct. Control
HCMLogicalSystemOfSourceDoc HCMLogicalSystemOfSourceDoc Logical system
HCMTmeShtRecdAutomConfPrpsl HCMTmeShtRecdAutomConfPrpsl Final Confirmtn
HCMReceivingFunctionalArea HCMReceivingFunctionalArea Receiving Func. Area
HCMReceiverFund HCMReceiverFund Sender Fund
HCMReceiverGrant HCMReceiverGrant Receiver Grant
HCMNetworkNumber HCMNetworkNumber Network
HCMOvertimeCompensationType HCMOvertimeCompensationType OT comp. type
HCMTimeShtRecdHasPrtlConfirm HCMTimeShtRecdHasPrtlConfirm Part. con.
PayScaleGroup PayScaleGroup Pay Scale Group
PayScaleLevel PayScaleLevel PS level
Plant Plant Valuation Area
HCMSendingPurchaseOrderItem HCMSendingPurchaseOrderItem Send. PO item
HCMSendingPurchaseOrder HCMSendingPurchaseOrder Sending order
HCMPosition HCMPosition Position
HCMTimeShtRecdIsForPrevDay HCMTimeShtRecdIsForPrevDay Previous day
ReceiverCostCenter ReceiverCostCenter Rec. CCtr
ReceiverOrder ReceiverOrder Rec. order
ReceiverBusinessProcess ReceiverBusinessProcess Rec.bus.process
ReceiverCostObject ReceiverCostObject Cost object
ReceiverSalesOrderItem ReceiverSalesOrderItem RecSalOrd. item
ReceiverSalesOrder ReceiverSalesOrder Rec. sales ord.
HCMRemainingWorkQuantity HCMRemainingWorkQuantity Remaining work
SenderBusinessProcess SenderBusinessProcess Send.Bus.Proc.
HCMSenderCostCenter HCMSenderCostCenter Send. CCtr
HCMSendingFunctionalArea HCMSendingFunctionalArea Sender Fnc.Area
HCMSenderFund HCMSenderFund Sender Fund
HCMSenderGrant HCMSenderGrant Sender Grant
ActivityNumber ActivityNumber Service number
HCMCapacitySplit HCMCapacitySplit Splitting
HCMStatisticalKeyFigure HCMStatisticalKeyFigure Stat. key fig.
TravelTripNumber TravelTripNumber Trip Number
HCMWageType HCMWageType Wage type
HCMTaxAreaWorkCenter HCMTaxAreaWorkCenter Tax area
HCMReceiverWBSElement HCMReceiverWBSElement
WorkCenter WorkCenter Work Center
TaskType TaskType Task Type
HCMTaskLevel HCMTaskLevel Task level
HCMTaskComponent HCMTaskComponent Task component
StdNetworkActivity StdNetworkActivity
SubOperation SubOperation
CapacityCategory CapacityCategory Capacity cat.
HCMValuationBasisAmount HCMValuationBasisAmount Valuation basis
HCMReceiverWBSElementExtID HCMReceiverWBSElementExtID
HCMOrderRoutingNumber HCMOrderRoutingNumber Plan No.f.Oper.
HCMOrderID HCMOrderID Counter
HCMProfitabilitySegment HCMProfitabilitySegment Profit. segment
HCMReceiverBudgetPeriod HCMReceiverBudgetPeriod Rec BudPer
HCMSenderBudgetPeriod HCMSenderBudgetPeriod Sender BudPer
HCMCapacityID HCMCapacityID Capacity ID
MaterialDocument MaterialDocument Material Doc.
HCMObjectType HCMObjectType Type of Val.
HCMObjectID HCMObjectID WorkCtrGp plan.
HCMOrderCategory HCMOrderCategory Order category
HCMMstrCostAcctgVariants HCMMstrCostAcctgVariants Cost acc. var.
HCMMasterCostCenter HCMMasterCostCenter Cost center
HCMMasterActivityType HCMMasterActivityType Activity type
HCMMasterFund HCMMasterFund Master Fund
HCMMasterFunctionalArea HCMMasterFunctionalArea MasterFunc.Area
HCMMasterGrant HCMMasterGrant Master Grant
CompanyCode CompanyCode Receiver Company Code
HCMMasterBudgetPeriod HCMMasterBudgetPeriod MasterBP
CapacityRequirement CapacityRequirement Id number
HCMTimeShtServiceDocType HCMTimeShtServiceDocType
HCMTimeShtServiceDocID HCMTimeShtServiceDocID
HCMTimeShtServiceDocItemID HCMTimeShtServiceDocItemID
HCMSuccssFctrsTimeTypeUUID HCMSuccssFctrsTimeTypeUUID SFSF Time Type UUID
HCMSuccssFctrsTimeTypeCode HCMSuccssFctrsTimeTypeCode SFSF Time Type ECode
HCMSuccssFctrsTimeTypeCat HCMSuccssFctrsTimeTypeCat
HCMSuccssFctrsAllwncTypeUUID HCMSuccssFctrsAllwncTypeUUID Allowance Type UUID
HCMSuccssFctrsAllwncTypeCode HCMSuccssFctrsAllwncTypeCode Allowance Type ECode
_ControllingArea _ControllingArea
_CompanyCode _CompanyCode
_MasterCostCenter _MasterCostCenter
_SenderCostCenter _SenderCostCenter
_ReceiverCostCenter _ReceiverCostCenter
_ReceiverSalesOrder _ReceiverSalesOrder
_ReceiverSalesOrderItem _ReceiverSalesOrderItem
_ReceiverBusinessProcess _ReceiverBusinessProcess
_ReceiverGrant _ReceiverGrant
_SendingFunctionalArea _SendingFunctionalArea
_SenderGrant _SenderGrant
_ReceiverBudgetPeriod _ReceiverBudgetPeriod
_SenderBudgetPeriod _SenderBudgetPeriod
_HCMCapacityID _HCMCapacityID
_Currency _Currency
_Plant _Plant
_OrderCategory _OrderCategory
_MasterFunctionalArea _MasterFunctionalArea
_MasterGrant _MasterGrant
_StatisticalKeyFigure _StatisticalKeyFigure
_UnitOfMeasure _UnitOfMeasure
_MasterBudgetPeriod _MasterBudgetPeriod
_AccountingIndicator _AccountingIndicator
_HCMSendingPurchaseOrderItem _HCMSendingPurchaseOrderItem
_HCMSendingPurchaseOrder _HCMSendingPurchaseOrder
_SenderBusinessProcess _SenderBusinessProcess
_CapacityCategory _CapacityCategory
_ActivityNumber _ActivityNumber
_HCMNetworkNumber _HCMNetworkNumber
_HCMObjectType _HCMObjectType
_HCMPosition _HCMPosition
_HCMReceivingFunctionalArea _HCMReceivingFunctionalArea
_HCMReceiverGrant _HCMReceiverGrant
_ReceiverOrder _ReceiverOrder
_HCMTimeShtRecdDisplayUoM _HCMTimeShtRecdDisplayUoM
_TaskType _TaskType
_HCMReceiverWBSElementExt _HCMReceiverWBSElementExt
_HCMOvertimeCompensationType _HCMOvertimeCompensationType
_HCMTaxAreaWorkCenter _HCMTaxAreaWorkCenter
_HCMTaskLevel _HCMTaskLevel
_HCMTaskComponent _HCMTaskComponent

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 I_HCMTimeShtAssgmtTP.
-- 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 I_HCMTimeShtAssgmtTP AS
SELECT
  HCMTmeShtAssgmtUUID,
  HCMTimeShtUser,
  HCMTmeShtAssgmtName,
  HCMTimeShtRecdApproverID,
  HCMTmeShtRecdApprvrName,
  HCMTmeShtAssgmtIsAdminAssgmt,
  HCMTmeShtAssgmtIsActv,
  HCMTmeShtAssgmtIsFavorite,
  HCMTimeShtEndDate,
  HCMTimeShtAssgmtStartDate,
  HCMTimeShtAssgmtEndDate,
  HCMShortTextComment,
  HCMCommentIsLongText,
  HCMTimeShtRecdIsForFullDay,
  HCMTimeShtRecdStartTime,
  HCMTimeShtRecdEndTime,
  HCMTimeShtRecdTransCrcy,
  HCMTimeShtRecdDisplayUoM,
  HCMTimeShtRecdUoM,
  HCMTimeShtRecdRecordedHrs,
  HCMTimeShtRecdRecordedQuantity,
  HCMTimeShtRecdRecordedAmount,
  HCMTimeSheetRecordPriceInTC,
  Currency,
  cast('' as pernr_d) AS PersonnelNumber,
  cast('' as catsvarian) AS HCMTimeShtDataEntryProfileID,
  cast('00000000' as datum) AS HCMWorkDate,
  HCMAttendanceAbsenceType,
  ControllingArea,
  HCMActivityType,
  HCMPremiumNumberCode,
  HCMPremiumIndicatorCode,
  HCMAccountingIndicatorCode,
  HCMExternalProjectID,
  HCMProjectUUID,
  HCMProjectSubObjectID,
  HCMProjectObjectUUID,
  HCMProjectObjectType,
  HCMExternalApplication,
  HCMExternalDocument,
  HCMExtraPayValuation,
  HCMLogicalSystemOfSourceDoc,
  HCMTmeShtRecdAutomConfPrpsl,
  HCMReceivingFunctionalArea,
  HCMReceiverFund,
  HCMReceiverGrant,
  HCMNetworkNumber,
  HCMOvertimeCompensationType,
  HCMTimeShtRecdHasPrtlConfirm,
  PayScaleGroup,
  PayScaleLevel,
  Plant,
  HCMSendingPurchaseOrderItem,
  HCMSendingPurchaseOrder,
  HCMPosition,
  HCMTimeShtRecdIsForPrevDay,
  ReceiverCostCenter,
  ReceiverOrder,
  ReceiverBusinessProcess,
  ReceiverCostObject,
  ReceiverSalesOrderItem,
  ReceiverSalesOrder,
  HCMRemainingWorkQuantity,
  SenderBusinessProcess,
  HCMSenderCostCenter,
  HCMSendingFunctionalArea,
  HCMSenderFund,
  HCMSenderGrant,
  ActivityNumber,
  HCMCapacitySplit,
  HCMStatisticalKeyFigure,
  TravelTripNumber,
  HCMWageType,
  HCMTaxAreaWorkCenter,
  HCMReceiverWBSElement,
  WorkCenter,
  TaskType,
  HCMTaskLevel,
  HCMTaskComponent,
  StdNetworkActivity,
  SubOperation,
  CapacityCategory,
  HCMValuationBasisAmount,
  HCMReceiverWBSElementExtID,
  HCMOrderRoutingNumber,
  HCMOrderID,
  HCMProfitabilitySegment,
  HCMReceiverBudgetPeriod,
  HCMSenderBudgetPeriod,
  HCMCapacityID,
  MaterialDocument,
  HCMObjectType,
  HCMObjectID,
  HCMOrderCategory,
  HCMMstrCostAcctgVariants,
  HCMMasterCostCenter,
  HCMMasterActivityType,
  HCMMasterFund,
  HCMMasterFunctionalArea,
  HCMMasterGrant,
  CompanyCode,
  HCMMasterBudgetPeriod,
  CapacityRequirement,
  HCMTimeShtServiceDocType,
  HCMTimeShtServiceDocID,
  HCMTimeShtServiceDocItemID,
  HCMSuccssFctrsTimeTypeUUID,
  HCMSuccssFctrsTimeTypeCode,
  HCMSuccssFctrsTimeTypeCat,
  HCMSuccssFctrsAllwncTypeUUID,
  HCMSuccssFctrsAllwncTypeCode
FROM I_HCMTimeShtAssgmt
;

Learn More