C_PPS_PurOrdItmDocTot

DDL: C_PPS_PURORDITMDOCTOT Type: view_entity CONSUMPTION
41 Fields 1 Data Sources

PPS Pur Ord Item Document Totals

C_PPS_PurOrdItmDocTot is a Consumption CDS View that provides data about "PPS Pur Ord Item Document Totals" in SAP S/4HANA. It reads from 1 data source (I_PPS_PurOrdItmDocTotC) and exposes 41 fields with key fields PurchaseOrder, PurchaseOrderItem.

Data Sources (1)

SourceAliasJoin Type
I_PPS_PurOrdItmDocTotC I_PPS_PurOrdItmDocTotC projection

Annotations (10)

NameValueLevelField
OData.applySupportedForAggregation #FULL view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label PPS Pur Ord Item Document Totals view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PurchasingParentItem PurchasingParentItem Parent Item No
PurchaseOrderItemText PurchaseOrderItemText Short Text
ActivePurchasingDocument ActivePurchasingDocument Active Purchase Doc
Material Material Vehicle Model
MaterialName MaterialName Material Description
OrderQuantity OrderQuantity Quantity
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
00elseNetAmountendasNetAmount
DocumentCurrency DocumentCurrency Document Currency
ProductTypeCode ProductTypeCode Product Type Group
ProductTypeName ProductTypeName Description
PPSPurOrderItemStatus PPSPurOrderItemStatus Item Status
PPSPurOrderItemStatusText PPSPurOrderItemStatusText Pur. Doc. Stat. Name
PPSPurOrdItemStatusCriticality PPSPurOrdItemStatusCriticality
PPSConfigurableLineItemNumber PPSConfigurableLineItemNumber Config. Itm. No.
MaterialGroup MaterialGroup Product Group
MaterialGroupName MaterialGroupName prod Grp Desc.
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
AcctAssignmentCategoryName AcctAssignmentCategoryName Description
Plant Plant Valuation Area
PlantName PlantName Plant Name
PPSOptionalItemStatus PPSOptionalItemStatus Optional Item Status
PPSOptionalItemStatusText PPSOptionalItemStatusText Short Description
PPSExercisableAmount PPSExercisableAmount
PPSExpiredAmount PPSExpiredAmount
00endendasPPSOpenGoodsReceiptAmount
00endendasPPSOpenInvoiceReceiptAmount
quan0endendasPPSOpenGoodsReceiptQuantity
PPSUnfundedAmount PPSUnfundedAmount
PPSFundedAmount
00endasPPSActualGoodsReceiptAmount
quan0endasPPSActualGoodsReceiptQuantity Quantity
00endasPPSActualInvoiceReceiptAmount
quan0endasPPSActlInvoiceReceiptQuantity
quan0endendasPPSOpenServiceEntrySheetQty
quan0endasPPSActualServiceEntrySheetQty Quantity
00endendasPPSOpenServiceEntrySheetAmount
00endasPPSActualServiceEntrySheetAmt
_PurchaseOrder _PurchaseOrder

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_PPS_PurOrdItmDocTot.
-- 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 C_PPS_PurOrdItmDocTot AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  PurchasingParentItem,
  PurchaseOrderItemText,
  ActivePurchasingDocument,
  Material,
  MaterialName,
  OrderQuantity,
  PurchaseOrderQuantityUnit,
  case when PPSPurOrderItemStatus = '03' then abap.curr'0.00' else NetAmount end as NetAmount AS 00elseNetAmountendasNetAmount,
  DocumentCurrency,
  ProductTypeCode,
  ProductTypeName,
  PPSPurOrderItemStatus,
  PPSPurOrderItemStatusText,
  PPSPurOrdItemStatusCriticality,
  PPSConfigurableLineItemNumber,
  MaterialGroup,
  MaterialGroupName,
  AccountAssignmentCategory,
  AcctAssignmentCategoryName,
  Plant,
  PlantName,
  PPSOptionalItemStatus,
  PPSOptionalItemStatusText,
  PPSExercisableAmount,
  PPSExpiredAmount,
  case when IsCompletelyDelivered = 'X' or PurchasingDocumentDeletionCode = 'L' then abap.curr'0.00' else case when ProductTypeCode = '1' then case when PPSOptionalItemStatus = '2' or PPSIsOptionalItem = '' then cast( NetAmount - GoodsReceiptAmount as pps_e_open_gr_amount_dsc ) else abap.curr'0.00' end else abap.curr'0.00' end end as PPSOpenGoodsReceiptAmount AS 00endendasPPSOpenGoodsReceiptAmount,
  case when IsFinallyInvoiced = 'X' or PurchasingDocumentDeletionCode = 'L' then abap.curr'0.00' else case when PPSOptionalItemStatus = '2' or PPSIsOptionalItem = '' then cast( NetAmount - InvoiceReceiptAmount as pps_e_open_ir_amount_dsc ) else abap.curr'0.00' end end as PPSOpenInvoiceReceiptAmount AS 00endendasPPSOpenInvoiceReceiptAmount,
  case when IsCompletelyDelivered = 'X' or PurchasingDocumentDeletionCode = 'L' then abap.quan'0' else case when ProductTypeCode = '1' then case when PPSOptionalItemStatus = '2' or PPSIsOptionalItem = '' then cast( OrderQuantity - GoodsReceiptQty as pps_e_open_gr_quantity ) else abap.quan'0' end else abap.quan'0' end end as PPSOpenGoodsReceiptQuantity AS quan0endendasPPSOpenGoodsReceiptQuantity,
  PPSUnfundedAmount,
  NetAmount - PPSUnfundedAmount AS PPSFundedAmount,
  case when ProductTypeCode = '1' then case when PPSOptionalItemStatus = '2' or PPSIsOptionalItem = '' then cast ( GoodsReceiptAmount as pps_e_actual_gr_amount ) else abap.curr'0.00' end else abap.curr'0.00' end as PPSActualGoodsReceiptAmount AS 00endasPPSActualGoodsReceiptAmount,
  case when ProductTypeCode = '1' then case when PPSOptionalItemStatus = '2' or PPSIsOptionalItem = '' then cast( GoodsReceiptQty as pps_e_actual_gr_quantity ) else abap.quan'0' end else abap.quan'0' end as PPSActualGoodsReceiptQuantity AS quan0endasPPSActualGoodsReceiptQuantity,
  case when PPSOptionalItemStatus = '2' or PPSIsOptionalItem = '' then cast( InvoiceReceiptAmount as pps_e_actual_ir_amount ) else abap.curr'0.00' end as PPSActualInvoiceReceiptAmount AS 00endasPPSActualInvoiceReceiptAmount,
  case when PPSOptionalItemStatus = '2' or PPSIsOptionalItem = '' then cast( InvoiceReceiptQty as pps_e_actual_ir_quantity ) else abap.quan'0' end as PPSActlInvoiceReceiptQuantity AS quan0endasPPSActlInvoiceReceiptQuantity,
  case when IsCompletelyDelivered = 'X' or PurchasingDocumentDeletionCode = 'L' then abap.quan'0' else case when ProductTypeCode = '2' then case when PPSOptionalItemStatus = '2' or PPSIsOptionalItem = '' then ( case when PurchaseOrderItemCategory = '0' then cast ( OrderQuantity - GoodsReceiptQty as pps_e_open_ses_quantity ) else abap.quan'0' end ) else abap.quan'0' end else abap.quan'0' end end as PPSOpenServiceEntrySheetQty AS quan0endendasPPSOpenServiceEntrySheetQty,
  case when ProductTypeCode = '2' then case when PPSOptionalItemStatus = '2' or PPSIsOptionalItem = '' then cast ( GoodsReceiptQty as pps_e_actual_ses_quantity ) else abap.quan'0' end else abap.quan'0' end as PPSActualServiceEntrySheetQty AS quan0endasPPSActualServiceEntrySheetQty,
  case when IsCompletelyDelivered = 'X' or PurchasingDocumentDeletionCode = 'L' then abap.curr'0.00' else case when ProductTypeCode = '2' then case when PPSOptionalItemStatus = '2' or PPSIsOptionalItem = '' then cast ( NetAmount - GoodsReceiptAmount as pps_e_open_ses_amount ) else abap.curr'0.00' end else abap.curr'0.00' end end as PPSOpenServiceEntrySheetAmount AS 00endendasPPSOpenServiceEntrySheetAmount,
  case when ProductTypeCode = '2' then case when PPSOptionalItemStatus = '2' or PPSIsOptionalItem = '' then cast ( GoodsReceiptAmount as pps_e_actual_ses_amount ) else abap.curr'0.00' end else abap.curr'0.00' end as PPSActualServiceEntrySheetAmt AS 00endasPPSActualServiceEntrySheetAmt
FROM I_PPS_PurOrdItmDocTotC
;

Learn More