C_HCMTimeShtSubop

DDL: C_HCMTIMESHTSUBOP Type: view_entity CONSUMPTION
12 Fields 3 Data Sources

HCM Timesheet Suboperation

C_HCMTimeShtSubop is a Consumption CDS View that provides data about "HCM Timesheet Suboperation" in SAP S/4HANA. It reads from 3 data sources (I_LogisticsOrderBasic, I_OrderOperationBasic, I_OrderOperationBasic) and exposes 12 fields with key fields OrderID, StdNetworkActivity, SubOperation.

Data Sources (3)

SourceAliasJoin Type
I_LogisticsOrderBasic afko inner
I_OrderOperationBasic afvc from
I_OrderOperationBasic afvc_superior inner

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label HCM Timesheet Suboperation view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
Search.searchable true view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey SubOperation view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY OrderID I_LogisticsOrderBasic OrderID Network Number / Receiver Order
KEY StdNetworkActivity I_OrderOperationBasic Operation_2 Activity/Operation
KEY SubOperation I_OrderOperationBasic Operation_2 Sub Operation
HCMNetworkNumber I_LogisticsOrderBasic OrderID Network Number
ReceiverOrder I_LogisticsOrderBasic OrderID Receiver Order
OperationText I_OrderOperationBasic OperationText Description
CostCtrActivityType I_OrderOperationBasic CostCtrActivityType Activity Type
Plant I_OrderOperationBasic Plant Valuation Area
OrderInternalID I_OrderOperationBasic OrderInternalID Plan No.f.Oper.
_OrderInternalID I_OrderOperationBasic _OrderInternalID
_OrderID _OrderID
_StdNetworkActivity _StdNetworkActivity

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 C_HCMTimeShtSubop.
-- 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 C_HCMTimeShtSubop AS
SELECT
  afko.OrderID AS OrderID,
  afvc_superior.Operation_2 AS StdNetworkActivity,
  afvc.Operation_2 AS SubOperation,
  afko.OrderID AS HCMNetworkNumber,
  afko.OrderID AS ReceiverOrder,
  afvc.OperationText AS OperationText,
  afvc.CostCtrActivityType AS CostCtrActivityType,
  afvc.Plant AS Plant,
  afvc.OrderInternalID AS OrderInternalID,
  afvc._OrderInternalID AS _OrderInternalID
FROM I_OrderOperationBasic AS afvc
INNER JOIN I_OrderOperationBasic AS afvc_superior ON /* join condition not captured in parsed metadata */
INNER JOIN I_LogisticsOrderBasic AS afko ON /* join condition not captured in parsed metadata */
;

Learn More