I_PPS_PurOrdDoblgnGrpItm

DDL: I_PPS_PURORDDOBLGNGRPITM Type: view_entity COMPOSITE
27 Fields 1 Data Sources 3 Associations

Purchase order item deobligation group

I_PPS_PurOrdDoblgnGrpItm is a Composite CDS View that provides data about "Purchase order item deobligation group" in SAP S/4HANA. It reads from 1 data source (R_PPS_PurOrdItmForDoblgnHN) and exposes 27 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_PPS_PurOrdItmForDoblgnHN R_PPS_PurOrdItmForDoblgnHN from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_PPS_PurgDocCatVH _DocCategory $projection.PurchasingDocumentCategory = _DocCategory.PurchasingDocumentCategory
[0..1] I_PPS_GroupItemDetail _DeobligationGroup $projection.PurchaseOrder = _DeobligationGroup.PPSPurgDocNumber and $projection.PurchaseOrderItem = _DeobligationGroup.PurchasingDocumentItem and _DeobligationGroup.PPSOrigin = 'DO'
[0..1] I_PPSGroupItemStatusCodeVH _ItemStatus $projection.PPSGroupItemStatusCode = _ItemStatus.DomainValue

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Purchase order item deobligation group view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
Plant Plant Valuation Area
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
PurchaseOrderType PurchaseOrderType PO Type
PPSGroupUUID _DeobligationGroup PPSGroupUUID GUID
PurchasingDocumentCategory PurchaseOrderCategory Doc. Category
DocumentCategoryText _DocCategory DocumentCategoryText
PPSFrmtdPurOrdItm
PPSPurOrderItemStatus PPSPurOrderItemStatus Item Status
PPSGroupItemStatusCode _DeobligationGroup PPSGroupItemStatusCode
PPSGroupName _DeobligationGroup PPSGroupName
CreationDateTime _DeobligationGroup CreationDateTime Timestamp
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
DocumentCurrency DocumentCurrency Document Currency
PPSOpenGoodsReceiptQuantity _PurOrdOpnItmForDoblgnC PPSOpenGoodsReceiptQuantity
PPSOpenGoodsReceiptAmount _PurOrdOpnItmForDoblgnC PPSOpenGoodsReceiptAmount
PPSOpenInvoiceReceiptAmount _PurOrdOpnItmForDoblgnC PPSOpenInvoiceReceiptAmount
PPSOpenServiceEntrySheetAmount _PurOrdOpnItmForDoblgnC PPSOpenServiceEntrySheetAmount
NetAmount NetAmount Stated Amount
PPSSmartDocumentNumber _PurchaseOrderHeaderExtension PPSSmartDocumentNumber Smart Doc Number
PPSPurOrderItemStatusText
PPSOrigin _DeobligationGroup PPSOrigin
PPSGroupStatusCode _DeobligationGroup PPSGroupStatusCode
_DeobligationGroup _DeobligationGroup
_ItemStatus _ItemStatus

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_PurOrdDoblgnGrpItm.
-- 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_PurOrdDoblgnGrpItm AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  Plant,
  PurchasingOrganization,
  PurchasingGroup,
  PurchaseOrderType,
  _DeobligationGroup.PPSGroupUUID AS PPSGroupUUID,
  PurchaseOrderCategory AS PurchasingDocumentCategory,
  _DocCategory.DocumentCategoryText AS DocumentCategoryText,
  cast ( concat_with_space( concat( ltrim( PurchaseOrder, '0' ), ' /' ), ltrim( PurchaseOrderItem , '0' ), 1 ) as pps_po_frmtd_itm ) AS PPSFrmtdPurOrdItm,
  PPSPurOrderItemStatus,
  _DeobligationGroup.PPSGroupItemStatusCode AS PPSGroupItemStatusCode,
  _DeobligationGroup.PPSGroupName AS PPSGroupName,
  _DeobligationGroup.CreationDateTime AS CreationDateTime,
  PurchaseOrderQuantityUnit,
  DocumentCurrency,
  _PurOrdOpnItmForDoblgnC.PPSOpenGoodsReceiptQuantity AS PPSOpenGoodsReceiptQuantity,
  _PurOrdOpnItmForDoblgnC.PPSOpenGoodsReceiptAmount AS PPSOpenGoodsReceiptAmount,
  _PurOrdOpnItmForDoblgnC.PPSOpenInvoiceReceiptAmount AS PPSOpenInvoiceReceiptAmount,
  _PurOrdOpnItmForDoblgnC.PPSOpenServiceEntrySheetAmount AS PPSOpenServiceEntrySheetAmount,
  NetAmount,
  _PurchaseOrderHeaderExtension.PPSSmartDocumentNumber AS PPSSmartDocumentNumber,
  _PurOrderItemExtension._ItemStatusText[1: Language = $session.system_language].PPSPurgDocumentItemStatusText AS PPSPurOrderItemStatusText,
  _DeobligationGroup.PPSOrigin AS PPSOrigin,
  _DeobligationGroup.PPSGroupStatusCode AS PPSGroupStatusCode
FROM R_PPS_PurOrdItmForDoblgnHN
LEFT OUTER JOIN I_PPS_PurgDocCatVH AS _DocCategory ON PurchasingDocumentCategory = _DocCategory.PurchasingDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_PPS_GroupItemDetail AS _DeobligationGroup ON PurchaseOrder = _DeobligationGroup.PPSPurgDocNumber AND PurchaseOrderItem = _DeobligationGroup.PurchasingDocumentItem AND _DeobligationGroup.PPSOrigin = 'DO'  -- association [0..1]
LEFT OUTER JOIN I_PPSGroupItemStatusCodeVH AS _ItemStatus ON PPSGroupItemStatusCode = _ItemStatus.DomainValue  -- association [0..1]
;

Learn More