C_PPS_PurOrdDocumentHistoryC

DDL: C_PPS_PURORDDOCUMENTHISTORYC Type: view_entity CONSUMPTION
33 Fields 1 Data Sources

Purchase Order Document History - Cube

C_PPS_PurOrdDocumentHistoryC is a Consumption CDS View (Cube) that provides data about "Purchase Order Document History - Cube" in SAP S/4HANA. It reads from 1 data source (R_PPS_PurOrdDocumentHistory) and exposes 33 fields with key fields PurchaseOrder, PurchaseOrderItem, AccountAssignmentNumber, PurchasingHistoryDocumentType, PurchasingHistoryDocumentYear.

Data Sources (1)

SourceAliasJoin Type
R_PPS_PurOrdDocumentHistory R_PPS_PurOrdDocumentHistory from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Purchase Order Document History - Cube view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Analytics.internalName #LOCAL view
Analytics.dataCategory #CUBE view
Metadata.allowExtensions true view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
KEY AccountAssignmentNumber AccountAssignmentNumber Account Assgmt No.
KEY PurchasingHistoryDocumentType PurchasingHistoryDocumentType
KEY PurchasingHistoryDocumentYear PurchasingHistoryDocumentYear
KEY PurchasingHistoryDocument PurchasingHistoryDocument
KEY PurchasingHistoryDocumentItem PurchasingHistoryDocumentItem
PurchasingHistoryCategory PurchasingHistoryCategory
GoodsMovementType GoodsMovementType Movement Type
QuantityInDeliveryQtyUnit QuantityInDeliveryQtyUnit
DeliveryQuantityUnit DeliveryQuantityUnit Unit of measure
QtyInPurchaseOrderPriceUnit QtyInPurchaseOrderPriceUnit Qty in OPUn
OrderPriceUnit OrderPriceUnit Order Price Un.
PurchaseOrderAmount PurchaseOrderAmount
Currency Currency Valuation Crcy
DocumentReferenceID DocumentReferenceID Reference
Batch Batch Lot No.
GdsRcptBlkdStkQtyInOrdQtyUnit
PurchaseOrderHistCategName
PostingDate PostingDate Posting Date for GR
Quantity Quantity Value
PurOrdAmountInCompanyCodeCrcy PurOrdAmountInCompanyCodeCrcy
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
CompanyCodeCurrency CompanyCodeCurrency Local Currency
VltdGdsRcptBlkdQtyInOrdPrcUnit
GRIRAcctClrgAmtInCoCodeCrcy
GdsRcptBlkdStkQtyInOrdPrcUnit
InventoryValuationType InventoryValuationType Valuation Type
AccountingDocumentCreationDate AccountingDocumentCreationDate Journal Entry Date
PurgHistDocumentCreationTime PurgHistDocumentCreationTime
IsToBeAcceptedAtOrigin IsToBeAcceptedAtOrigin Origin Accept.
_PurchaseOrderItem _PurchaseOrderItem
_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_PurOrdDocumentHistoryC.
-- 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_PurOrdDocumentHistoryC AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  AccountAssignmentNumber,
  PurchasingHistoryDocumentType,
  PurchasingHistoryDocumentYear,
  PurchasingHistoryDocument,
  PurchasingHistoryDocumentItem,
  PurchasingHistoryCategory,
  GoodsMovementType,
  QuantityInDeliveryQtyUnit,
  DeliveryQuantityUnit,
  QtyInPurchaseOrderPriceUnit,
  OrderPriceUnit,
  PurchaseOrderAmount,
  Currency,
  DocumentReferenceID,
  Batch,
  cast ( GdsRcptBlkdStkQtyInOrdQtyUnit as pps_e_gr_blck_ord_unit preserving type ) AS GdsRcptBlkdStkQtyInOrdQtyUnit,
  cast ( PurchaseOrderHistCategName as pps_e_po_hist_categ_name preserving type ) AS PurchaseOrderHistCategName,
  PostingDate,
  Quantity,
  PurOrdAmountInCompanyCodeCrcy,
  PurchaseOrderQuantityUnit,
  CompanyCodeCurrency,
  cast( VltdGdsRcptBlkdQtyInOrdPrcUnit as pps_e_val_gr_blck_op_unit preserving type ) AS VltdGdsRcptBlkdQtyInOrdPrcUnit,
  cast( GRIRAcctClrgAmtInCoCodeCrcy as pps_e_gr_ir_clr_value preserving type ) AS GRIRAcctClrgAmtInCoCodeCrcy,
  cast( GdsRcptBlkdStkQtyInOrdPrcUnit as pps_e_gr_blck_op_unit preserving type ) AS GdsRcptBlkdStkQtyInOrdPrcUnit,
  InventoryValuationType,
  AccountingDocumentCreationDate,
  PurgHistDocumentCreationTime,
  IsToBeAcceptedAtOrigin
FROM R_PPS_PurOrdDocumentHistory
;

Learn More