I_WorkItemPurReqnItemDetail

DDL: I_WORKITEMPURREQNITEMDETAIL SQL: IWIPURREQNITMDET Type: view COMPOSITE
52 Fields 1 Data Sources 1 Associations

Interface View for Purchase Reqn Item Workitem Details

I_WorkItemPurReqnItemDetail is a Composite CDS View that provides data about "Interface View for Purchase Reqn Item Workitem Details" in SAP S/4HANA. It reads from 1 data source (I_PurchaseReqnItemWorkItem) and exposes 52 fields with key fields WorkflowTaskInternalID, PurchaseRequisition, PurchaseRequisitionItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseReqnItemWorkItem _PurchaseReqnItemWorkItem from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Purchaserequisitionitem _PurReqnDet _PurReqnDet.PurchaseRequisition = $projection.PurchaseRequisition and _PurReqnDet.PurchaseRequisitionItem = $projection.PurchaseRequisitionItem

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IWIPURREQNITMDET view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey PurchaseRequisition view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Interface View for Purchase Reqn Item Workitem Details view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID WorkflowTaskInternalID Work Item ID
KEY PurchaseRequisition PurchaseRequisition Requisition
KEY PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
PurReqnReleaseStatus _PurReqnDet PurReqnReleaseStatus Proc.state
PurchaseRequisitionItemText _PurReqnDet PurchaseRequisitionItemText Short Text
AccountAssignmentCategory _PurReqnDet AccountAssignmentCategory Acct Assgmt Cat
Material _PurReqnDet Material Vehicle Model
RequestedQuantity _PurReqnDet RequestedQuantity Requested Quantity
BaseUnit _PurReqnDet BaseUnit Unit of Measure
ItemUoM _PurReqnDet BaseUnit Unit of Measure
PurchaseContract _PurReqnDet PurchaseContract Purchasing Doc.
PurchaseContractItem _PurReqnDet PurchaseContractItem Item
PurchasingInfoRecord _PurReqnDet PurchasingInfoRecord Info Record
PurchaseRequisitionPrice _PurReqnDet PurchaseRequisitionPrice Valuation Price
PurReqnPriceQuantity _PurReqnDet PurReqnPriceQuantity Price unit
PurReqnSSPCatalog _PurReqnDet PurReqnSSPCatalog Web Service ID
ItemNetAmount _PurReqnDet ItemNetAmount Tot. val. rel.
PurReqnItemCurrency _PurReqnDet PurReqnItemCurrency Currency
CreatedByUser _PurReqnDet CreatedByUser User Name
PurchaseRequisitionType _PurReqnDet PurchaseRequisitionType Order Type
ConsumptionPosting _PurReqnDet ConsumptionPosting Consumption Posting
PurchasingDocumentItemCategory _PurReqnDet PurchasingDocumentItemCategory Item Category
DeliveryDate _PurReqnDet DeliveryDate Delivery Date
MaterialGroup _PurReqnDet MaterialGroup Product Group
PurchasingOrganization _PurReqnDet PurchasingOrganization Purchasing Organization
PurchasingGroup _PurReqnDet PurchasingGroup Purchasing Group
Plant _PurReqnDet Plant Valuation Area
CompanyCode _PurReqnDet CompanyCode Receiver Company Code
SupplierName
ExtPlantForPurg _PurReqnDet ExtPlantForPurg Plant
ExtPurgOrgForPurg _PurReqnDet ExtPurgOrgForPurg Purch. Organization
ExtCompanyCodeForPurg _PurReqnDet ExtCompanyCodeForPurg Company Code
MaterialendasCnsldtnMaterialText
ExtMaterialForPurg _PurReqnDet ExtMaterialForPurg Material
PurchaseContractendasSourceOfSupply
ProcurementHubSourceSystem _PurReqnDet ProcurementHubSourceSystem Connected System ID
LastChangeDateTime _PurReqnDet LastChangeDateTime Timestamp
RequisitionerName _PurReqnDet RequisitionerName Requisitioner
StorageLocation _PurReqnDet StorageLocation StorageLocation
ProductTypeCode _PurReqnDet ProductType Product Type Group
ExpectedOverallLimitAmount _PurReqnDet ExpectedOverallLimitAmount Expected Value
OverallLimitAmount _PurReqnDet OverallLimitAmount Overall Limit
PurReqCreationDate _PurReqnDet PurReqCreationDate Requisn Date
PerformancePeriodStartDate _PurReqnDet PerformancePeriodStartDate Start of Performance Period
PerformancePeriodEndDate _PurReqnDet PerformancePeriodEndDate End of Performance Period
PurchaseRequisitionReleaseDate _PurReqnDet PurchaseRequisitionReleaseDate Release Date
TechnicalWrkflwObjectType TechnicalWrkflwObjectType
TechnicalWrkflwObject TechnicalWrkflwObject
WorkflowTaskRecipient WorkflowTaskRecipient
PurReqnSSPRequestor _PurReqnDet PurReqnSSPRequestor Requestor
_TaskRecipient _TaskRecipient
PurchaseReqnItemUniqueID _PurReqnDet PurchaseReqnItemUniqueID Purch. Doc. ID

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 I_WorkItemPurReqnItemDetail.
-- 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: IWIPURREQNITMDET

CREATE VIEW I_WorkItemPurReqnItemDetail AS
SELECT
  WorkflowTaskInternalID,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  _PurReqnDet.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  _PurReqnDet.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  _PurReqnDet.AccountAssignmentCategory AS AccountAssignmentCategory,
  _PurReqnDet.Material AS Material,
  _PurReqnDet.RequestedQuantity AS RequestedQuantity,
  _PurReqnDet.BaseUnit AS BaseUnit,
  _PurReqnDet.BaseUnit AS ItemUoM,
  _PurReqnDet.PurchaseContract AS PurchaseContract,
  _PurReqnDet.PurchaseContractItem AS PurchaseContractItem,
  _PurReqnDet.PurchasingInfoRecord AS PurchasingInfoRecord,
  _PurReqnDet.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  _PurReqnDet.PurReqnPriceQuantity AS PurReqnPriceQuantity,
  _PurReqnDet.PurReqnSSPCatalog AS PurReqnSSPCatalog,
  _PurReqnDet.ItemNetAmount AS ItemNetAmount,
  _PurReqnDet.PurReqnItemCurrency AS PurReqnItemCurrency,
  _PurReqnDet.CreatedByUser AS CreatedByUser,
  _PurReqnDet.PurchaseRequisitionType AS PurchaseRequisitionType,
  _PurReqnDet.ConsumptionPosting AS ConsumptionPosting,
  _PurReqnDet.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  _PurReqnDet.DeliveryDate AS DeliveryDate,
  _PurReqnDet.MaterialGroup AS MaterialGroup,
  _PurReqnDet.PurchasingOrganization AS PurchasingOrganization,
  _PurReqnDet.PurchasingGroup AS PurchasingGroup,
  _PurReqnDet.Plant AS Plant,
  _PurReqnDet.CompanyCode AS CompanyCode,
  _PurReqnDet._Supplier.SupplierName AS SupplierName,
  _PurReqnDet.ExtPlantForPurg AS ExtPlantForPurg,
  _PurReqnDet.ExtPurgOrgForPurg AS ExtPurgOrgForPurg,
  _PurReqnDet.ExtCompanyCodeForPurg AS ExtCompanyCodeForPurg,
  case _PurReqnDet.Material when '' then _PurReqnDet.ExtMaterialForPurg else _PurReqnDet.Material end as CnsldtnMaterialText AS MaterialendasCnsldtnMaterialText,
  _PurReqnDet.ExtMaterialForPurg AS ExtMaterialForPurg,
  case when _PurReqnDet.ExtContractForPurg <> '' then _PurReqnDet.ExtContractForPurg when _PurReqnDet.ExtInfoRecordForPurg <> '' then _PurReqnDet.ExtInfoRecordForPurg when _PurReqnDet.PurchasingInfoRecord <> '' then _PurReqnDet.PurchasingInfoRecord when _PurReqnDet.PurchaseContract <> '' then _PurReqnDet.PurchaseContract end as SourceOfSupply AS PurchaseContractendasSourceOfSupply,
  _PurReqnDet.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  _PurReqnDet.LastChangeDateTime AS LastChangeDateTime,
  _PurReqnDet.RequisitionerName AS RequisitionerName,
  _PurReqnDet.StorageLocation AS StorageLocation,
  _PurReqnDet.ProductType AS ProductTypeCode,
  _PurReqnDet.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  _PurReqnDet.OverallLimitAmount AS OverallLimitAmount,
  _PurReqnDet.PurReqCreationDate AS PurReqCreationDate,
  _PurReqnDet.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  _PurReqnDet.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  _PurReqnDet.PurchaseRequisitionReleaseDate AS PurchaseRequisitionReleaseDate,
  TechnicalWrkflwObjectType,
  TechnicalWrkflwObject,
  WorkflowTaskRecipient,
  _PurReqnDet.PurReqnSSPRequestor AS PurReqnSSPRequestor,
  _PurReqnDet.PurchaseReqnItemUniqueID AS PurchaseReqnItemUniqueID
FROM I_PurchaseReqnItemWorkItem AS _PurchaseReqnItemWorkItem
LEFT OUTER JOIN I_Purchaserequisitionitem AS _PurReqnDet ON _PurReqnDet.PurchaseRequisition = PurchaseRequisition AND _PurReqnDet.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [1..1]
;

Learn More