C_PPS_PurchasingHistoryTP

DDL: C_PPS_PURCHASINGHISTORYTP Type: view_entity CONSUMPTION
32 Fields 1 Data Sources

Consumption for XPO History

C_PPS_PurchasingHistoryTP is a Consumption CDS View that provides data about "Consumption for XPO History" in SAP S/4HANA. It reads from 1 data source (R_PPS_PurchasingHistoryTP) and exposes 32 fields with key fields PurchasingHistoryDocument, PurchasingHistoryDocumentItem, PPSPurgHistDocumentCategory, CompanyCode, FiscalYear.

Data Sources (1)

SourceAliasJoin Type
R_PPS_PurchasingHistoryTP R_PPS_PurchasingHistoryTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Consumption for XPO History view
AccessControl.authorizationCheck #MANDATORY view
Search.searchable true view
ObjectModel.representativeKey PPSPurgHistDocumentCategory view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY PurchasingHistoryDocument PurchasingHistoryDocument Document Number
KEY PurchasingHistoryDocumentItem PurchasingHistoryDocumentItem Document Item Number
KEY PPSPurgHistDocumentCategory PPSPurgHistDocumentCategory Document Category Code
KEY CompanyCode CompanyCode Company Code
KEY FiscalYear FiscalYear Fiscal Year
PurchasingDocument PurchasingDocument Purchasing Document Number
PurchasingDocumentItem PurchasingDocumentItem Purchasing Document Item
DocumentCategoryText _DocumentCategory DocumentCategoryText Document Category Description
PPSPurgHistDocumentType PPSPurgHistDocumentType Document Type
DocumentTypeDescription _DocumentType DocumentTypeDescription
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingDocumentType PurchasingDocumentType RFQ Type
PostingDate PostingDate Posting Date
Quantity Quantity Quantity
UnitOfMeasure UnitOfMeasure Unit Of Measure
PurchaseOrderQty PurchaseOrderQty Quantity In PO Unit
POUnitOfMeasure POUnitOfMeasure
AmountInLocalCurrency AmountInLocalCurrency Amount In PO Currency
LocalCurrency LocalCurrency Local Currency
NetValueAmountInDocCurrency NetValueAmountInDocCurrency Amount In DocumentCurrency
DocumentCurrency DocumentCurrency Document Currency
PPSReferenceDocument PPSReferenceDocument Reference Document Number
PPSReferenceDocumentItem PPSReferenceDocumentItem Reference Document Item
ReferenceDocumentFiscalYear ReferenceDocumentFiscalYear Reference Document FiscalYear
PPSReferenceDocumentType PPSReferenceDocumentType Reference Document Type
ReferenceDocumentCategory ReferenceDocumentCategory Reference Document Category
SemanticObject SemanticObject Semantic Object
ReferenceSemanticObject ReferenceSemanticObject Reference Semantic Object
PPSPurgHistDocCatIsHidn PPSPurgHistDocCatIsHidn
_DocumentType _DocumentType
_DocumentCategory _DocumentCategory

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_PurchasingHistoryTP.
-- 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_PurchasingHistoryTP AS
SELECT
  PurchasingHistoryDocument,
  PurchasingHistoryDocumentItem,
  PPSPurgHistDocumentCategory,
  CompanyCode,
  FiscalYear,
  PurchasingDocument,
  PurchasingDocumentItem,
  _DocumentCategory.DocumentCategoryText AS DocumentCategoryText,
  PPSPurgHistDocumentType,
  _DocumentType.DocumentTypeDescription AS DocumentTypeDescription,
  PurchasingOrganization,
  PurchasingGroup,
  PurchasingDocumentType,
  PostingDate,
  Quantity,
  UnitOfMeasure,
  PurchaseOrderQty,
  POUnitOfMeasure,
  AmountInLocalCurrency,
  LocalCurrency,
  NetValueAmountInDocCurrency,
  DocumentCurrency,
  PPSReferenceDocument,
  PPSReferenceDocumentItem,
  ReferenceDocumentFiscalYear,
  PPSReferenceDocumentType,
  ReferenceDocumentCategory,
  SemanticObject,
  ReferenceSemanticObject,
  PPSPurgHistDocCatIsHidn
FROM R_PPS_PurchasingHistoryTP
;

Learn More