C_CntrlPurReqnItmWrkflwAprvEml

DDL: C_CNTRLPURREQNITMWRKFLWAPRVEML SQL: CTRLPURREQIWFAEM Type: view CONSUMPTION
84 Fields 1 Data Sources

Central PurReq Item Wrkflw Aprov email notifi

C_CntrlPurReqnItmWrkflwAprvEml is a Consumption CDS View that provides data about "Central PurReq Item Wrkflw Aprov email notifi" in SAP S/4HANA. It reads from 1 data source (I_WorkflowTask) and exposes 84 fields with key field WorkflowTaskInternalID.

Data Sources (1)

SourceAliasJoin Type
I_WorkflowTask _Workflowtask from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CTRLPURREQIWFAEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Central PurReq Item Wrkflw Aprov 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
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #REQUIRED view

Fields (84)

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
WorkflowTaskResultReason
WorkflowTaskResultReasonText

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_CntrlPurReqnItmWrkflwAprvEml.
-- 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: CTRLPURREQIWFAEM

CREATE VIEW C_CntrlPurReqnItmWrkflwAprvEml 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,
  _Workflowtask._WorkflowTaskResult._WorkflowTaskResultReason._WorkflowTaskResultReasonText[1: Language = $session.system_language].WorkflowTaskResultReason AS WorkflowTaskResultReason,
  _Workflowtask._WorkflowTaskResult._WorkflowTaskResultReason._WorkflowTaskResultReasonText[1: Language = $session.system_language].WorkflowTaskResultReasonText AS WorkflowTaskResultReasonText
FROM I_WorkflowTask AS _Workflowtask
;

Learn More