C_ChgImpactPurOrdItem

DDL: C_CHGIMPACTPURORDITEM SQL: CCHGIMPPUOITEM Type: view CONSUMPTION Package: MPE_PLAN_CIMA
19 Fields 1 Data Sources 5 Associations

Purchase Order Item Details

C_ChgImpactPurOrdItem is a Consumption CDS View that provides data about "Purchase Order Item Details" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderItem) and exposes 19 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 5 associations to related views. Part of development package MPE_PLAN_CIMA.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderItem puoitem from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrder _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
[1..1] I_SupDmndPurOrderSchedLine _Delivery $projection.PurchaseOrder = _Delivery.PurchasingDocument and $projection.PurchaseOrderItem = _Delivery.PurchasingDocumentItem
[1..1] I_PurchasingObjectCategoryText _PurchaseCategory_Text $projection.PurchaseOrderCategory = _PurchaseCategory_Text.PurchasingDocumentCategory and _PurchaseCategory_Text.Language = $session.system_language
[1..1] I_MaterialText _MatDesc $projection.Material = _MatDesc.Material and _MatDesc.Language = $session.system_language
[1..*] I_ChgImpactPurDocAcctAssign _PuoAcct $projection.PurchaseOrder = _PuoAcct.PurchasingDocument and $projection.PurchaseOrderItem = _PuoAcct.PurchasingDocumentItem

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CCHGIMPPUOITEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Purchase Order Item Details view
VDM.viewType #CONSUMPTION view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrderItem PurchaseOrder Purchasing Document
KEY PurchaseOrderItem I_PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PurchaseOrderCategory I_PurchaseOrderItem PurchaseOrderCategory Doc. Category
Material I_PurchaseOrderItem Material Vehicle Model
MaterialName _MatDesc MaterialName Material Description
OrderQuantity I_PurchaseOrderItem OrderQuantity Quantity
ScheduleLineDeliveryDate _Delivery ScheduleLineDeliveryDate Delivery Date
PurchasingDocumentCategoryName _PurchaseCategory_Text PurchasingDocumentCategoryName Short Description
SalesDocument _PuoAcct SalesDocument SD Document
SalesDocumentItem _PuoAcct SalesDocumentItem Sales Document Item
ScheduleLine _PuoAcct ScheduleLine Schedule Line
ManufacturingOrder _PuoAcct ProductionOrder Order
WBSElement _PuoAcct WBSElement WBS Internal ID
WBSElementInternalID _PuoAcct WBSElementInternalID WBS Internal ID
PurchaseOrderType _PurchaseOrder PurchaseOrderType PO Type
NetChangeAnalysisPath
ProductionOrder
IsDefinite
IsChanged

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_ChgImpactPurOrdItem.
-- 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: CCHGIMPPUOITEM

CREATE VIEW C_ChgImpactPurOrdItem AS
SELECT
  puoitem.PurchaseOrder AS PurchaseOrder,
  puoitem.PurchaseOrderItem AS PurchaseOrderItem,
  puoitem.PurchaseOrderCategory AS PurchaseOrderCategory,
  puoitem.Material AS Material,
  _MatDesc.MaterialName AS MaterialName,
  puoitem.OrderQuantity AS OrderQuantity,
  _Delivery.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  _PurchaseCategory_Text.PurchasingDocumentCategoryName AS PurchasingDocumentCategoryName,
  _PuoAcct.SalesDocument AS SalesDocument,
  _PuoAcct.SalesDocumentItem AS SalesDocumentItem,
  _PuoAcct.ScheduleLine AS ScheduleLine,
  _PuoAcct.ProductionOrder AS ManufacturingOrder,
  _PuoAcct.WBSElement AS WBSElement,
  _PuoAcct.WBSElementInternalID AS WBSElementInternalID,
  _PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  cast( ' ' as abap.char( 255 ) ) AS NetChangeAnalysisPath,
  cast( ' ' as abap.char( 255 ) ) AS ProductionOrder,
  cast(' ' as mpe_mec_cima_isdefinite) AS IsDefinite,
  cast(' ' as mpe_mec_cima_ischanged ) AS IsChanged
FROM I_PurchaseOrderItem AS puoitem
LEFT OUTER JOIN I_PurchaseOrder AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_SupDmndPurOrderSchedLine AS _Delivery ON PurchaseOrder = _Delivery.PurchasingDocument AND PurchaseOrderItem = _Delivery.PurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_PurchasingObjectCategoryText AS _PurchaseCategory_Text ON PurchaseOrderCategory = _PurchaseCategory_Text.PurchasingDocumentCategory AND _PurchaseCategory_Text.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_MaterialText AS _MatDesc ON Material = _MatDesc.Material AND _MatDesc.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_ChgImpactPurDocAcctAssign AS _PuoAcct ON PurchaseOrder = _PuoAcct.PurchasingDocument AND PurchaseOrderItem = _PuoAcct.PurchasingDocumentItem  -- association [1..*]
;

Learn More