C_PurgDataForTimeSheet

DDL: C_PURGDATAFORTIMESHEET SQL: CMMTIMESHEETDATA Type: view CONSUMPTION
20 Fields 2 Data Sources 1 Associations

Purchasing Data for Time Sheet

C_PurgDataForTimeSheet is a Consumption CDS View that provides data about "Purchasing Data for Time Sheet" in SAP S/4HANA. It reads from 2 data sources (I_PurchaseOrder, I_PurchaseOrderItem) and exposes 20 fields with key fields PurchaseOrder, PurchaseOrderItem, AccountAssignmentNumber. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_PurchaseOrder _header left_outer
I_PurchaseOrderItem _Item from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_PurOrdAccountAssignment _AccountAssignment $projection.PurchaseOrder = _AccountAssignment.PurchaseOrder and $projection.PurchaseOrderItem = _AccountAssignment.PurchaseOrderItem

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CMMTIMESHEETDATA view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
OData.publish true view
EndUserText.label Purchasing Data for Time Sheet view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrderItem PurchaseOrder Purchasing Document
KEY PurchaseOrderItem I_PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
KEY AccountAssignmentNumber _AccountAssignment AccountAssignmentNumber Account Assgmt No.
Supplier I_PurchaseOrder Supplier Supplier
SupplierFullName
PurchaseOrderType I_PurchaseOrder PurchaseOrderType PO Type
PurchasingOrganization I_PurchaseOrder PurchasingOrganization Purchasing Organization
PurchasingGroup I_PurchaseOrder PurchasingGroup Purchasing Group
Material I_PurchaseOrderItem Material Vehicle Model
Plant I_PurchaseOrderItem Plant Valuation Area
PlantName
OrderQuantity I_PurchaseOrderItem OrderQuantity Quantity
PurchaseOrderQuantityUnit I_PurchaseOrderItem PurchaseOrderQuantityUnit Order Unit
IsCompletelyDelivered I_PurchaseOrderItem IsCompletelyDelivered Is completely delivered
OverdelivTolrtdLmtRatioInPct I_PurchaseOrderItem OverdelivTolrtdLmtRatioInPct Overdeliv. Tol.
UnlimitedOverdeliveryIsAllowed I_PurchaseOrderItem UnlimitedOverdeliveryIsAllowed Unlimited Tol.
ServicePerformer I_PurchaseOrderItem ServicePerformer Service Performer
AccountAssignmentCategory I_PurchaseOrderItem AccountAssignmentCategory Acct Assgmt Cat
WBSElementInternalID _AccountAssignment WBSElementInternalID WBS Internal ID
GLAccount _AccountAssignment GLAccount General Ledger

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_PurgDataForTimeSheet.
-- 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.
-- SQL view name: CMMTIMESHEETDATA

CREATE VIEW C_PurgDataForTimeSheet AS
SELECT
  _Item.PurchaseOrder AS PurchaseOrder,
  _Item.PurchaseOrderItem AS PurchaseOrderItem,
  _AccountAssignment.AccountAssignmentNumber AS AccountAssignmentNumber,
  _header.Supplier AS Supplier,
  _header._Supplier.SupplierFullName AS SupplierFullName,
  _header.PurchaseOrderType AS PurchaseOrderType,
  _header.PurchasingOrganization AS PurchasingOrganization,
  _header.PurchasingGroup AS PurchasingGroup,
  _Item.Material AS Material,
  _Item.Plant AS Plant,
  _Item._Plant.PlantName AS PlantName,
  _Item.OrderQuantity AS OrderQuantity,
  _Item.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  _Item.IsCompletelyDelivered AS IsCompletelyDelivered,
  _Item.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  _Item.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  _Item.ServicePerformer AS ServicePerformer,
  _Item.AccountAssignmentCategory AS AccountAssignmentCategory,
  _AccountAssignment.WBSElementInternalID AS WBSElementInternalID,
  _AccountAssignment.GLAccount AS GLAccount
FROM I_PurchaseOrderItem AS _Item
LEFT OUTER JOIN I_PurchaseOrder AS _header ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurOrdAccountAssignment AS _AccountAssignment ON PurchaseOrder = _AccountAssignment.PurchaseOrder AND PurchaseOrderItem = _AccountAssignment.PurchaseOrderItem  -- association [1..*]
;

Learn More