I_MMTimeRecording

DDL: I_MMTIMERECORDING SQL: IMMTMERECG Type: view BASIC Package: APPL_MM_PUR_SES_TR

Time Sheet (CATS): Transfer to MM

I_MMTimeRecording is a Basic CDS View that provides data about "Time Sheet (CATS): Transfer to MM" in SAP S/4HANA. It reads from 3 data sources (catsmm, I_PurchaseOrder, R_PurchaseOrderItem) and exposes 21 fields. Part of development package APPL_MM_PUR_SES_TR.

3 data source(s) 21 fields

Data Sources (3)

SourceAliasJoin Type
catsmm catsmm from
I_PurchaseOrder I_PurchaseOrder inner
R_PurchaseOrderItem R_PurchaseOrderItem inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMMTMERECG view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Time Sheet (CATS): Transfer to MM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (21)

KeyFieldSource TableSource FieldDescription
ReferenceDocument catsmm counter
IsDeleted catsmm stokz
TimeSheetNote catsmm ltxa1
PersonnelNumber catsmm pernr
ServicePerformanceDate catsmm workdate
CostCenter catsmm rkostl
WBSElementInternalID catsmm rproj
WBSElementInternalID_2
OrderID catsmm raufnr
SalesOrder catsmm rkdauf
SalesOrderItem catsmm rkdpos
PurchaseOrder catsmm sebeln
PurchaseOrderItem catsmm sebelp
IsSettled catsmm transfer
Quantity catsmm catsquantity
UnitOfMeasure catsmm unit
WorkItem catsmm work_item_id
IsEndOfPurposeBlocked I_PurchaseOrder IsEndOfPurposeBlocked
PurchasingOrganization I_PurchaseOrder PurchasingOrganization
PurchasingGroup I_PurchaseOrder PurchasingGroup
Plant R_PurchaseOrderItem Plant 
@AbapCatalog.sqlViewName: 'IMMTMERECG'
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Time Sheet (CATS): Transfer to MM'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED

@VDM.viewType: #BASIC

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view I_MMTimeRecording as select from catsmm
inner join I_PurchaseOrder on I_PurchaseOrder.PurchaseOrder = catsmm.sebeln
inner join R_PurchaseOrderItem on R_PurchaseOrderItem.PurchaseOrder = catsmm.sebeln and
                                  R_PurchaseOrderItem.PurchaseOrderItem = catsmm.sebelp

{
  catsmm.counter       as ReferenceDocument,
  catsmm.stokz         as IsDeleted,
  catsmm.ltxa1         as TimeSheetNote,
  catsmm.pernr         as PersonnelNumber,
  catsmm.workdate      as ServicePerformanceDate,
  catsmm.rkostl        as CostCenter,
  @VDM.lifecycle.status: #DEPRECATED
  @VDM.lifecycle.successor: 'WBSElementInternalID_2'
  catsmm.rproj         as WBSElementInternalID,
  cast( catsmm.rproj as ps_s4_pspnr preserving type ) as WBSElementInternalID_2, //no conv. exit

  catsmm.raufnr        as OrderID,
  catsmm.rkdauf        as SalesOrder,
  catsmm.rkdpos        as SalesOrderItem,
  catsmm.sebeln        as PurchaseOrder,
  catsmm.sebelp        as PurchaseOrderItem,
  catsmm.transfer      as IsSettled,
  catsmm.catsquantity  as Quantity,
  catsmm.unit          as UnitOfMeasure,
  catsmm.work_item_id  as WorkItem,


// Authorization fields

   @Consumption.hidden: true
   I_PurchaseOrder.IsEndOfPurposeBlocked,
   @Consumption.hidden: true
   I_PurchaseOrder.PurchasingOrganization,
   @Consumption.hidden: true
   I_PurchaseOrder.PurchasingGroup,
   @Consumption.hidden: true
   R_PurchaseOrderItem.Plant
}

Learn More