I_PPS_PurReqnItmForDoblgn

DDL: I_PPS_PURREQNITMFORDOBLGN Type: view_entity COMPOSITE
11 Fields 1 Data Sources 1 Associations

Purchase Reqn Item for deobligation

I_PPS_PurReqnItmForDoblgn is a Composite CDS View that provides data about "Purchase Reqn Item for deobligation" in SAP S/4HANA. It reads from 1 data source (I_PPS_PurReqnDoblgnGrpItm) and exposes 11 fields with key fields PurchaseRequisition, PurchaseRequisitionItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PPS_PurReqnDoblgnGrpItm I_PPS_PurReqnDoblgnGrpItm from

Associations (1)

CardinalityTargetAliasCondition
[0..1] R_PPS_PurReqnItmForDoblgnHN _HierarchyParent $projection.PurchaseRequisition = _HierarchyParent.PurchaseRequisition and $projection.PurchaseRequisitionItem = _HierarchyParent.PurchaseRequisitionItem

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Purchase Reqn Item for deobligation view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition PurchaseRequisition Requisition
KEY PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PPSOrigin PPSOrigin
Plant Plant Valuation Area
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
PurchaseRequisitionType PurchaseRequisitionType Order Type
PPSGroupUUID PPSGroupUUID GUID
_DeobligationGroup _DeobligationGroup
_HierarchyParent _HierarchyParent

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_PPS_PurReqnItmForDoblgn.
-- 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.

CREATE VIEW I_PPS_PurReqnItmForDoblgn AS
SELECT
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurchasingDocumentCategory,
  PPSOrigin,
  Plant,
  PurchasingOrganization,
  PurchasingGroup,
  PurchaseRequisitionType,
  PPSGroupUUID
FROM I_PPS_PurReqnDoblgnGrpItm
LEFT OUTER JOIN R_PPS_PurReqnItmForDoblgnHN AS _HierarchyParent ON PurchaseRequisition = _HierarchyParent.PurchaseRequisition AND PurchaseRequisitionItem = _HierarchyParent.PurchaseRequisitionItem  -- association [0..1]
;

Learn More