C_CntrlSuplrConfWrkflwDdlnEml

DDL: C_CNTRLSUPLRCONFWRKFLWDDLNEML SQL: CCSCWFLDLNEML Type: view CONSUMPTION
8 Fields 1 Data Sources

Deadline Notif of Cntrl Confirmation

C_CntrlSuplrConfWrkflwDdlnEml (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sourcing & Procurement

C_CntrlSuplrConfWrkflwDdlnEml is a Consumption CDS View that provides data about "Deadline Notif of Cntrl Confirmation" in SAP S/4HANA. It reads from 1 data source (I_WorkflowTask) and exposes 8 fields with key field WorkflowTaskInternalID.

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentMM-PUR-HUB-PO
CapabilitiesOutput: Email Data Provider
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_WorkflowTask _Workflowtask from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CCSCWFLDLNEML view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Deadline Notif of Cntrl Confirmation view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #OUTPUT_EMAIL_DATA_PROVIDER view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID I_WorkflowTask WorkflowTaskInternalID Work Item ID
CentralSupplierConfirmation Purchasing Document Number
PurchasingDocumentType _CntrlSupplierConfirmation PurchasingDocumentType Purchasing Document Type
ExtSourceSystem _CntrlSupplierConfirmation ProcurementHubSourceSystem Connected System ID
PrmtHbWrkflwTskCrtnUTCDte Latest Start Date for Work Item
PrmtHbWrkflwTskCrtnUTCTme Latest start time for work item
PrmtHbWrkflwTskDuUTCDte Latest End Date for Work Item
PrmtHbWrkflwTskDuUTCTme Latest end time for work item

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_CntrlSuplrConfWrkflwDdlnEml.
-- 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: CCSCWFLDLNEML

CREATE VIEW C_CntrlSuplrConfWrkflwDdlnEml AS
SELECT
  _Workflowtask.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  cast(substring(_WorkflowTaskApplObject.TechnicalWrkflwObject, 1 , 10 ) as ebeln ) AS CentralSupplierConfirmation,
  _CntrlSupplierConfirmation.PurchasingDocumentType AS PurchasingDocumentType,
  _CntrlSupplierConfirmation.ProcurementHubSourceSystem AS ExtSourceSystem,
  cast(tstmp_to_dats( _Workflowtask.WrkflwTskCreationUTCDateTime, 'UTC', $session.client, 'NULL' ) as sww_lsd ) AS PrmtHbWrkflwTskCrtnUTCDte,
  cast(tstmp_to_tims( _Workflowtask.WrkflwTskCreationUTCDateTime, 'UTC', $session.client, 'NULL' ) as sww_lst ) AS PrmtHbWrkflwTskCrtnUTCTme,
  cast(tstmp_to_dats( _TaskDueDate.WorkflowTaskDueUTCDateTime, 'UTC', $session.client, 'NULL' ) as sww_led ) AS PrmtHbWrkflwTskDuUTCDte,
  cast(tstmp_to_tims( _TaskDueDate.WorkflowTaskDueUTCDateTime, 'UTC', $session.client, 'NULL' ) as sww_let ) AS PrmtHbWrkflwTskDuUTCTme
FROM I_WorkflowTask AS _Workflowtask
;

Learn More