C_CntrlPurReqnItmWrkflwDdlnEml

DDL: C_CNTRLPURREQNITMWRKFLWDDLNEML SQL: CTRLPURREQWFLEML Type: view CONSUMPTION
87 Fields 1 Data Sources 1 Associations

Central PurchaseRequsition Wrkflw deadline email notifi

C_CntrlPurReqnItmWrkflwDdlnEml is a Consumption CDS View that provides data about "Central PurchaseRequsition Wrkflw deadline email notifi" in SAP S/4HANA. It reads from 1 data source (I_WorkflowTask) and exposes 87 fields with key field WorkflowTaskInternalID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_WorkflowTask _Workflowtask from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_WorkflowTaskURL _WorkflowTaskURL $projection.WorkflowTaskInternalID = _WorkflowTaskURL.WorkflowTaskInternalID

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CTRLPURREQWFLEML view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Central PurchaseRequsition Wrkflw deadline email notifi view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.supportedCapabilities #OUTPUT_EMAIL_DATA_PROVIDER view
Metadata.ignorePropagatedAnnotations true view

Fields (87)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID I_WorkflowTask WorkflowTaskInternalID Work Item ID
PurchaseRequisition _PurchaseRequisitionItem PurchaseRequisition Requisition
PurchaseRequisitionItem _PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
PurchaseReqnItemUniqueID _PurchaseRequisitionItem PurchaseReqnItemUniqueID Purch. Doc. ID
PurchasingDocument _PurchaseRequisitionItem PurchasingDocument Purchasing Document
PurchasingDocumentItem _PurchaseRequisitionItem PurchasingDocumentItem Purchasing Doc. Item
PurReqnReleaseStatus _PurchaseRequisitionItem PurReqnReleaseStatus Proc.state
PurchaseRequisitionType _PurchaseRequisitionItem PurchaseRequisitionType Order Type
PurchasingDocumentSubtype _PurchaseRequisitionItem PurchasingDocumentSubtype Control
PurchasingDocumentItemCategory _PurchaseRequisitionItem PurchasingDocumentItemCategory Item Category
PurchaseRequisitionItemText _PurchaseRequisitionItem PurchaseRequisitionItemText Short Text
AccountAssignmentCategory _PurchaseRequisitionItem AccountAssignmentCategory Acct Assgmt Cat
MaterialGroup _PurchaseRequisitionItem MaterialGroup Product Group
PurchasingDocumentCategory _PurchaseRequisitionItem PurchasingDocumentCategory Doc. Category
RequestedQuantity _PurchaseRequisitionItem RequestedQuantity Requested Quantity
BaseUnit _PurchaseRequisitionItem BaseUnit Unit of Measure
PurchaseRequisitionPrice _PurchaseRequisitionItem PurchaseRequisitionPrice Valuation Price
PurReqnPriceQuantity _PurchaseRequisitionItem PurReqnPriceQuantity Price unit
MaterialGoodsReceiptDuration _PurchaseRequisitionItem MaterialGoodsReceiptDuration GR proc. time
PurchaseRequisitionReleaseDate _PurchaseRequisitionItem PurchaseRequisitionReleaseDate Release Date
SourceOfSupplyIsAssigned _PurchaseRequisitionItem SourceOfSupplyIsAssigned Assigned
SupplyingPlant _PurchaseRequisitionItem SupplyingPlant Supplying Plant
OrderedQuantity _PurchaseRequisitionItem OrderedQuantity Quantity
PurReqnLimitConsumptionAmt _PurchaseRequisitionItem PurReqnLimitConsumptionAmt Consumption Value
DeliveryDate _PurchaseRequisitionItem DeliveryDate Delivery Date
CreationDate _PurchaseRequisitionItem CreationDate Time Stamp
ProcessingStatus _PurchaseRequisitionItem ProcessingStatus Worklist Status
PurchasingInfoRecord _PurchaseRequisitionItem PurchasingInfoRecord Info Record
Supplier _PurchaseRequisitionItem Supplier Supplier
FixedSupplier _PurchaseRequisitionItem FixedSupplier Fixed Vendor
RequisitionerName _PurchaseRequisitionItem RequisitionerName Requisitioner
CreatedByUser _PurchaseRequisitionItem CreatedByUser User Name
PurReqCreationDate _PurchaseRequisitionItem PurReqCreationDate Requisn Date
DeliveryAddressID _PurchaseRequisitionItem DeliveryAddressID Address
ManualDeliveryAddressID _PurchaseRequisitionItem ManualDeliveryAddressID Address Number
PurReqnItemCurrency _PurchaseRequisitionItem PurReqnItemCurrency Currency
MaterialPlannedDeliveryDurn _PurchaseRequisitionItem MaterialPlannedDeliveryDurn Pl. Deliv. Time
DelivDateCategory _PurchaseRequisitionItem DelivDateCategory Delivery Date
MultipleAcctAssgmtDistribution _PurchaseRequisitionItem MultipleAcctAssgmtDistribution Distribution
StorageLocation _PurchaseRequisitionItem StorageLocation StorageLocation
PurReqnSSPRequestor _PurchaseRequisitionItem PurReqnSSPRequestor Requestor
PurReqnSSPAuthor _PurchaseRequisitionItem PurReqnSSPAuthor Author
PurchaseContract _PurchaseRequisitionItem PurchaseContract Purchasing Doc.
PurReqnSourceOfSupplyType _PurchaseRequisitionItem PurReqnSourceOfSupplyType Doc. Category
PurchaseContractItem _PurchaseRequisitionItem PurchaseContractItem Item
ConsumptionPosting _PurchaseRequisitionItem ConsumptionPosting Consumption Posting
PurReqnOrigin _PurchaseRequisitionItem PurReqnOrigin Creation ind.
PurReqnSSPCatalog _PurchaseRequisitionItem PurReqnSSPCatalog Web Service ID
PurReqnSSPCatalogItem _PurchaseRequisitionItem PurReqnSSPCatalogItem Catalog Item
PurReqnSSPCrossCatalogItem _PurchaseRequisitionItem PurReqnSSPCrossCatalogItem Catalog item key
IsPurReqnBlocked _PurchaseRequisitionItem IsPurReqnBlocked Blocking Ind.
ItemDeliveryAddressID _PurchaseRequisitionItem ItemDeliveryAddressID Address
Language _PurchaseRequisitionItem Language Report Text Language
IsClosed _PurchaseRequisitionItem IsClosed Closed
ReleaseIsNotCompleted _PurchaseRequisitionItem ReleaseIsNotCompleted Subj.to Release
ServicePerformer _PurchaseRequisitionItem ServicePerformer Service Performer
PurchaseRequisitionStatus _PurchaseRequisitionItem PurchaseRequisitionStatus Release State
PerformancePeriodStartDate _PurchaseRequisitionItem PerformancePeriodStartDate Start of Performance Period
PerformancePeriodEndDate _PurchaseRequisitionItem PerformancePeriodEndDate End of Performance Period
CompanyCode _PurchaseRequisitionItem CompanyCode Receiver Company Code
SupplierMaterialNumber _PurchaseRequisitionItem SupplierMaterialNumber Supp. Mat. No.
Batch _PurchaseRequisitionItem Batch Lot No.
MinRemainingShelfLife _PurchaseRequisitionItem MinRemainingShelfLife Rem. Shelf Life
ItemNetAmount _PurchaseRequisitionItem ItemNetAmount Tot. val. rel.
GoodsReceiptIsExpected _PurchaseRequisitionItem GoodsReceiptIsExpected Goods Receipt
InvoiceIsExpected _PurchaseRequisitionItem InvoiceIsExpected Invoice Receipt
GoodsReceiptIsNonValuated _PurchaseRequisitionItem GoodsReceiptIsNonValuated GR Non-Valuated
RequirementTracking _PurchaseRequisitionItem RequirementTracking Tracking Number
MRPController _PurchaseRequisitionItem MRPController MRP Controller
PurchaseRequisitionIsFixed _PurchaseRequisitionItem PurchaseRequisitionIsFixed "Fixed" ind.
AddressID _PurchaseRequisitionItem AddressID Ship-to address
LastChangeDateTime _PurchaseRequisitionItem LastChangeDateTime Timestamp
ProcurementHubSourceSystem _PurchaseRequisitionItem ProcurementHubSourceSystem Connected System ID
ExtPurgOrgForPurg _PurchaseRequisitionItem ExtPurgOrgForPurg Purch. Organization
ExtCompanyCodeForPurg _PurchaseRequisitionItem ExtCompanyCodeForPurg Company Code
ExtPlantForPurg _PurchaseRequisitionItem ExtPlantForPurg Plant
ExtInfoRecordForPurg _PurchaseRequisitionItem ExtInfoRecordForPurg Info Record
ExtContractItemForPurg _PurchaseRequisitionItem ExtContractItemForPurg Item
ExtContractForPurg _PurchaseRequisitionItem ExtContractForPurg Contract
ExtDesiredSupplierForPurg _PurchaseRequisitionItem ExtDesiredSupplierForPurg Desired Supplier
ExtFixedSupplierForPurg _PurchaseRequisitionItem ExtFixedSupplierForPurg Fixed Supplier
ExtMaterialForPurg _PurchaseRequisitionItem ExtMaterialForPurg Material
PurReqnWrkflwTskCrtnUTCDate
PurReqnWrkflwTskCrtnUTCTime
PurReqnWrkflwTaskDueUTCDate
PurReqnWrkflwTaskDueUTCTime
WorkflowTaskURL _WorkflowTaskURL WorkflowTaskURL

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_CntrlPurReqnItmWrkflwDdlnEml.
-- 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: CTRLPURREQWFLEML

CREATE VIEW C_CntrlPurReqnItmWrkflwDdlnEml AS
SELECT
  _Workflowtask.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  _PurchaseRequisitionItem.PurchaseRequisition AS PurchaseRequisition,
  _PurchaseRequisitionItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _PurchaseRequisitionItem.PurchaseReqnItemUniqueID AS PurchaseReqnItemUniqueID,
  _PurchaseRequisitionItem.PurchasingDocument AS PurchasingDocument,
  _PurchaseRequisitionItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  _PurchaseRequisitionItem.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  _PurchaseRequisitionItem.PurchaseRequisitionType AS PurchaseRequisitionType,
  _PurchaseRequisitionItem.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  _PurchaseRequisitionItem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  _PurchaseRequisitionItem.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  _PurchaseRequisitionItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  _PurchaseRequisitionItem.MaterialGroup AS MaterialGroup,
  _PurchaseRequisitionItem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _PurchaseRequisitionItem.RequestedQuantity AS RequestedQuantity,
  _PurchaseRequisitionItem.BaseUnit AS BaseUnit,
  _PurchaseRequisitionItem.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  _PurchaseRequisitionItem.PurReqnPriceQuantity AS PurReqnPriceQuantity,
  _PurchaseRequisitionItem.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  _PurchaseRequisitionItem.PurchaseRequisitionReleaseDate AS PurchaseRequisitionReleaseDate,
  _PurchaseRequisitionItem.SourceOfSupplyIsAssigned AS SourceOfSupplyIsAssigned,
  _PurchaseRequisitionItem.SupplyingPlant AS SupplyingPlant,
  _PurchaseRequisitionItem.OrderedQuantity AS OrderedQuantity,
  _PurchaseRequisitionItem.PurReqnLimitConsumptionAmt AS PurReqnLimitConsumptionAmt,
  _PurchaseRequisitionItem.DeliveryDate AS DeliveryDate,
  _PurchaseRequisitionItem.CreationDate AS CreationDate,
  _PurchaseRequisitionItem.ProcessingStatus AS ProcessingStatus,
  _PurchaseRequisitionItem.PurchasingInfoRecord AS PurchasingInfoRecord,
  _PurchaseRequisitionItem.Supplier AS Supplier,
  _PurchaseRequisitionItem.FixedSupplier AS FixedSupplier,
  _PurchaseRequisitionItem.RequisitionerName AS RequisitionerName,
  _PurchaseRequisitionItem.CreatedByUser AS CreatedByUser,
  _PurchaseRequisitionItem.PurReqCreationDate AS PurReqCreationDate,
  _PurchaseRequisitionItem.DeliveryAddressID AS DeliveryAddressID,
  _PurchaseRequisitionItem.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  _PurchaseRequisitionItem.PurReqnItemCurrency AS PurReqnItemCurrency,
  _PurchaseRequisitionItem.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  _PurchaseRequisitionItem.DelivDateCategory AS DelivDateCategory,
  _PurchaseRequisitionItem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  _PurchaseRequisitionItem.StorageLocation AS StorageLocation,
  _PurchaseRequisitionItem.PurReqnSSPRequestor AS PurReqnSSPRequestor,
  _PurchaseRequisitionItem.PurReqnSSPAuthor AS PurReqnSSPAuthor,
  _PurchaseRequisitionItem.PurchaseContract AS PurchaseContract,
  _PurchaseRequisitionItem.PurReqnSourceOfSupplyType AS PurReqnSourceOfSupplyType,
  _PurchaseRequisitionItem.PurchaseContractItem AS PurchaseContractItem,
  _PurchaseRequisitionItem.ConsumptionPosting AS ConsumptionPosting,
  _PurchaseRequisitionItem.PurReqnOrigin AS PurReqnOrigin,
  _PurchaseRequisitionItem.PurReqnSSPCatalog AS PurReqnSSPCatalog,
  _PurchaseRequisitionItem.PurReqnSSPCatalogItem AS PurReqnSSPCatalogItem,
  _PurchaseRequisitionItem.PurReqnSSPCrossCatalogItem AS PurReqnSSPCrossCatalogItem,
  _PurchaseRequisitionItem.IsPurReqnBlocked AS IsPurReqnBlocked,
  _PurchaseRequisitionItem.ItemDeliveryAddressID AS ItemDeliveryAddressID,
  _PurchaseRequisitionItem.Language AS Language,
  _PurchaseRequisitionItem.IsClosed AS IsClosed,
  _PurchaseRequisitionItem.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  _PurchaseRequisitionItem.ServicePerformer AS ServicePerformer,
  _PurchaseRequisitionItem.PurchaseRequisitionStatus AS PurchaseRequisitionStatus,
  _PurchaseRequisitionItem.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  _PurchaseRequisitionItem.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  _PurchaseRequisitionItem.CompanyCode AS CompanyCode,
  _PurchaseRequisitionItem.SupplierMaterialNumber AS SupplierMaterialNumber,
  _PurchaseRequisitionItem.Batch AS Batch,
  _PurchaseRequisitionItem.MinRemainingShelfLife AS MinRemainingShelfLife,
  _PurchaseRequisitionItem.ItemNetAmount AS ItemNetAmount,
  _PurchaseRequisitionItem.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  _PurchaseRequisitionItem.InvoiceIsExpected AS InvoiceIsExpected,
  _PurchaseRequisitionItem.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  _PurchaseRequisitionItem.RequirementTracking AS RequirementTracking,
  _PurchaseRequisitionItem.MRPController AS MRPController,
  _PurchaseRequisitionItem.PurchaseRequisitionIsFixed AS PurchaseRequisitionIsFixed,
  _PurchaseRequisitionItem.AddressID AS AddressID,
  _PurchaseRequisitionItem.LastChangeDateTime AS LastChangeDateTime,
  _PurchaseRequisitionItem.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  _PurchaseRequisitionItem.ExtPurgOrgForPurg AS ExtPurgOrgForPurg,
  _PurchaseRequisitionItem.ExtCompanyCodeForPurg AS ExtCompanyCodeForPurg,
  _PurchaseRequisitionItem.ExtPlantForPurg AS ExtPlantForPurg,
  _PurchaseRequisitionItem.ExtInfoRecordForPurg AS ExtInfoRecordForPurg,
  _PurchaseRequisitionItem.ExtContractItemForPurg AS ExtContractItemForPurg,
  _PurchaseRequisitionItem.ExtContractForPurg AS ExtContractForPurg,
  _PurchaseRequisitionItem.ExtDesiredSupplierForPurg AS ExtDesiredSupplierForPurg,
  _PurchaseRequisitionItem.ExtFixedSupplierForPurg AS ExtFixedSupplierForPurg,
  _PurchaseRequisitionItem.ExtMaterialForPurg AS ExtMaterialForPurg,
  cast(tstmp_to_dats( _Workflowtask.WrkflwTskCreationUTCDateTime, 'UTC', $session.client, 'NULL' ) as sww_lsd ) AS PurReqnWrkflwTskCrtnUTCDate,
  cast(tstmp_to_tims( _Workflowtask.WrkflwTskCreationUTCDateTime, 'UTC', $session.client, 'NULL' ) as sww_lst ) AS PurReqnWrkflwTskCrtnUTCTime,
  cast(tstmp_to_dats( _TaskDueDate.WorkflowTaskDueUTCDateTime, 'UTC', $session.client, 'NULL' ) as sww_led ) AS PurReqnWrkflwTaskDueUTCDate,
  cast(tstmp_to_tims( _TaskDueDate.WorkflowTaskDueUTCDateTime, 'UTC', $session.client, 'NULL' ) as sww_let ) AS PurReqnWrkflwTaskDueUTCTime,
  _WorkflowTaskURL.WorkflowTaskURL AS WorkflowTaskURL
FROM I_WorkflowTask AS _Workflowtask
LEFT OUTER JOIN I_WorkflowTaskURL AS _WorkflowTaskURL ON WorkflowTaskInternalID = _WorkflowTaskURL.WorkflowTaskInternalID  -- association [0..1]
;

Learn More