C_PurOrdWorkflowTaskCard
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)
| Source | Alias | Join Type |
|---|---|---|
| R_PurchaseOrder | R_PurchaseOrder | from |
Associations (6)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PurchaseOrder | PurchaseOrder | ||
| PurchaseOrderNetAmount | _PurchaseOrderNetAmount | PurchaseOrderNetAmount | ||
| CompanyCode | CompanyCode | |||
| PurchasingOrganization | PurchasingOrganization | |||
| PurchasingGroup | PurchasingGroup | |||
| Supplier | Supplier | |||
| DocumentCurrency | DocumentCurrency | |||
| PurchaseOrderDate | PurchaseOrderDate | |||
| CreatedByUser | CreatedByUser | |||
| CompanyCodeName | _CompanyCode | CompanyCodeName | ||
| PurchasingOrganizationName | _PurchasingOrganization | PurchasingOrganizationName | ||
| PurchasingGroupName | _PurchasingGroup | PurchasingGroupName | ||
| SupplierName | _Supplier | SupplierName | ||
| CreatedByUserFullName | _User | UserDescription | ||
| _CompanyCode | _CompanyCode | |||
| _PurchasingOrganization | _PurchasingOrganization | |||
| _PurchasingGroup | _PurchasingGroup | |||
| _Supplier | _Supplier | |||
| _User | _User |
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Purchase Order Workflow Task Card'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #CONSUMPTION
@Workflow: { enabledFor: [ #CUSTOM_TASK_ATTRIBUTES ] }
define view entity C_PurOrdWorkflowTaskCard
as select from R_PurchaseOrder
association [1..1] to I_PurchaseOrderNetAmount as _PurchaseOrderNetAmount on _PurchaseOrderNetAmount.PurchaseOrder = $projection.PurchaseOrder
association [0..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
association [0..1] to I_PurchasingOrganization as _PurchasingOrganization on $projection.PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization
association [0..1] to I_PurchasingGroup as _PurchasingGroup on $projection.PurchasingGroup = _PurchasingGroup.PurchasingGroup
association [0..1] to I_Supplier as _Supplier on $projection.Supplier = _Supplier.Supplier
association [0..1] to I_User as _User on _User.UserID = $projection.CreatedByUser
{
key PurchaseOrder,
@Semantics.amount.currencyCode: 'DocumentCurrency'
_PurchaseOrderNetAmount.PurchaseOrderNetAmount as PurchaseOrderNetAmount,
/* start suppress warning shlporigin_not_inherited */
@ObjectModel.text.element: ['CompanyCodeName']
CompanyCode,
@ObjectModel.text.element: ['PurchasingOrganizationName']
PurchasingOrganization,
@ObjectModel.text.element: ['PurchasingGroupName']
PurchasingGroup,
@ObjectModel.text.element: ['SupplierName']
Supplier,
DocumentCurrency,
/* end suppress warning shlporigin_not_inherited */
PurchaseOrderDate,
@ObjectModel.text.element: ['CreatedByUserFullName']
CreatedByUser,
_CompanyCode.CompanyCodeName as CompanyCodeName,
_PurchasingOrganization.PurchasingOrganizationName as PurchasingOrganizationName,
_PurchasingGroup.PurchasingGroupName as PurchasingGroupName,
_Supplier.SupplierName as SupplierName,
_User.UserDescription as CreatedByUserFullName,
_CompanyCode,
_PurchasingOrganization,
_PurchasingGroup,
_Supplier,
_User
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA