P_PurchaseContractItem1

DDL: P_PURCHASECONTRACTITEM1 SQL: PPURCONT1 Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
17 Fields 3 Data Sources

Purchase Contract Changes

P_PurchaseContractItem1 is a Consumption CDS View that provides data about "Purchase Contract Changes" in SAP S/4HANA. It reads from 3 data sources (I_PurContractClassification, I_PurchaseContract, I_PurchaseContractItem) and exposes 17 fields with key fields PurchaseContract, PurchaseContractItem. Part of development package ODATA_MM_ANALYTICS.

Data Sources (3)

SourceAliasJoin Type
I_PurContractClassification _ContractClassification inner
I_PurchaseContract _PurchaseContract from
I_PurchaseContractItem _PurchaseContractItem inner

Parameters (2)

NameTypeDefault
P_StartDate badat
P_EndDate badat

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPURCONT1 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
VDM.private true view
VDM.viewType #CONSUMPTION view
EndUserText.label Purchase Contract Changes view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_PurchaseContractItem PurchaseContract Purchasing Doc.
KEY PurchaseContractItem I_PurchaseContractItem PurchaseContractItem Item
PurchaseContractType I_PurchaseContractItem PurchaseContractType Order Type
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
MaterialGroup MaterialGroup Product Group
Material Material Vehicle Model
Plant Plant Valuation Area
PurchasingCategory PurchasingCategory Purchasing Category
PurgCatName PurgCatName Purchasing Cat. Name
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
ReleaseCode ReleaseCode Release ind.
PurchasingGroup I_PurchaseContract PurchasingGroup Purchasing Group
PurchasingOrganization I_PurchaseContract PurchasingOrganization Purchasing Organization
CompanyCode I_PurchaseContract CompanyCode Receiver Company Code
Supplier Supplier Supplier

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 P_PurchaseContractItem1.
-- 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.
-- SQL view name: PPURCONT1
-- Parameters: P_StartDate : badat, P_EndDate : badat

CREATE VIEW P_PurchaseContractItem1 AS
SELECT
  _PurchaseContractItem.PurchaseContract AS PurchaseContract,
  _PurchaseContractItem.PurchaseContractItem AS PurchaseContractItem,
  _PurchaseContractItem.PurchaseContractType AS PurchaseContractType,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  MaterialGroup,
  Material,
  Plant,
  PurchasingCategory,
  PurgCatName,
  CreatedByUser,
  CreationDate,
  ReleaseCode,
  _PurchaseContract.PurchasingGroup AS PurchasingGroup,
  _PurchaseContract.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseContract.CompanyCode AS CompanyCode,
  Supplier
FROM I_PurchaseContract AS _PurchaseContract
INNER JOIN I_PurchaseContractItem AS _PurchaseContractItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurContractClassification AS _ContractClassification ON /* join condition not captured in parsed metadata */
;

Learn More