C_PurOrdWorkflowTaskCard

DDL: C_PURORDWORKFLOWTASKCARD Type: view_entity CONSUMPTION Package: APPL_MM_PUR_WFL_PO
19 Fields 1 Data Sources 6 Associations

Purchase Order Workflow Task Card

C_PurOrdWorkflowTaskCard is a Consumption CDS View that provides data about "Purchase Order Workflow Task Card" in SAP S/4HANA. It reads from 1 data source (R_PurchaseOrder) and exposes 19 fields with key field PurchaseOrder. It has 6 associations to related views. Part of development package APPL_MM_PUR_WFL_PO.

Data Sources (1)

SourceAliasJoin Type
R_PurchaseOrder R_PurchaseOrder from

Associations (6)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrderNetAmount _PurchaseOrderNetAmount _PurchaseOrderNetAmount.PurchaseOrder = $projection.PurchaseOrder
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_PurchasingOrganization _PurchasingOrganization $projection.PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization
[0..1] I_PurchasingGroup _PurchasingGroup $projection.PurchasingGroup = _PurchasingGroup.PurchasingGroup
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[0..1] I_User _User _User.UserID = $projection.CreatedByUser

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Purchase Order Workflow Task Card view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderNetAmount _PurchaseOrderNetAmount PurchaseOrderNetAmount Net Value
CompanyCode CompanyCode Receiver Company Code
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
Supplier Supplier Supplier
DocumentCurrency DocumentCurrency Document Currency
PurchaseOrderDate PurchaseOrderDate PO Date
CreatedByUser CreatedByUser User Name
CompanyCodeName _CompanyCode CompanyCodeName Company Name
PurchasingOrganizationName _PurchasingOrganization PurchasingOrganizationName Purch. Org. Name
PurchasingGroupName _PurchasingGroup PurchasingGroupName Purchasing Grp. Name
SupplierName _Supplier SupplierName Supplier Name
CreatedByUserFullName _User UserDescription Full Name
_CompanyCode _CompanyCode
_PurchasingOrganization _PurchasingOrganization
_PurchasingGroup _PurchasingGroup
_Supplier _Supplier
_User _User

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_PurOrdWorkflowTaskCard.
-- 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_PurOrdWorkflowTaskCard AS
SELECT
  PurchaseOrder,
  _PurchaseOrderNetAmount.PurchaseOrderNetAmount AS PurchaseOrderNetAmount,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  Supplier,
  DocumentCurrency,
  PurchaseOrderDate,
  CreatedByUser,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  _Supplier.SupplierName AS SupplierName,
  _User.UserDescription AS CreatedByUserFullName
FROM R_PurchaseOrder
LEFT OUTER JOIN I_PurchaseOrderNetAmount AS _PurchaseOrderNetAmount ON _PurchaseOrderNetAmount.PurchaseOrder = PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON _User.UserID = CreatedByUser  -- association [0..1]
;

Learn More