P_UnusedPurContrCurrConv

DDL: P_UNUSEDPURCONTRCURRCONV SQL: PUNUSEDPCCURCN Type: view CONSUMPTION
16 Fields 1 Data Sources

Unused Purchase Contract 3

P_UnusedPurContrCurrConv is a Consumption CDS View that provides data about "Unused Purchase Contract 3" in SAP S/4HANA. It reads from 1 data source (P_UnusedPurchaseContract4) and exposes 16 fields with key field PurchaseContract.

Data Sources (1)

SourceAliasJoin Type
P_UnusedPurchaseContract4 P_UnusedPurchaseContract4 from

Parameters (3)

NameTypeDefault
P_StartDate sydate
P_EndDate sydate
P_DisplayCurrency displaycurrency

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PUNUSEDPCCURCN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Unused Purchase Contract 3 view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract PurchaseContract Purchasing Doc.
PurchaseContractType PurchaseContract PurchaseContractType Order Type
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
ReleaseOrderDate ReleaseOrderDate PO Date
DisplayCurrency
ReleaseOrderItemNetAmount ReleaseOrderItemNetAmount Net Value
CompanyCode PurchaseContract CompanyCode Receiver Company Code
CreatedByUser PurchaseContract CreatedByUser User Name
Supplier PurchaseContract Supplier Supplier
PurchasingOrganization PurchaseContract PurchasingOrganization Purchasing Organization
PurchasingGroup PurchaseContract PurchasingGroup Purchasing Group
CreationDate PurchaseContract CreationDate Time Stamp
ValidityStartDate PurchaseContract ValidityStartDate Validity Start Date
ValidityEndDate PurchaseContract ValidityEndDate ValidTo
LastChangeDate LastChangeDate Time Stamp
ReleaseOrderItemLastChgDate ReleaseOrderItemLastChgDate Changed On

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_UnusedPurContrCurrConv.
-- 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: PUNUSEDPCCURCN
-- Parameters: P_StartDate : sydate, P_EndDate : sydate, P_DisplayCurrency : displaycurrency

CREATE VIEW P_UnusedPurContrCurrConv AS
SELECT
  PurchaseContract.PurchaseContract AS PurchaseContract,
  PurchaseContract.PurchaseContractType AS PurchaseContractType,
  PurchasingDocumentCategory,
  ReleaseOrderDate,
  cast(:P_DisplayCurrency as displaycurrency) AS DisplayCurrency,
  ReleaseOrderItemNetAmount,
  PurchaseContract.CompanyCode AS CompanyCode,
  PurchaseContract.CreatedByUser AS CreatedByUser,
  PurchaseContract.Supplier AS Supplier,
  PurchaseContract.PurchasingOrganization AS PurchasingOrganization,
  PurchaseContract.PurchasingGroup AS PurchasingGroup,
  PurchaseContract.CreationDate AS CreationDate,
  PurchaseContract.ValidityStartDate AS ValidityStartDate,
  PurchaseContract.ValidityEndDate AS ValidityEndDate,
  LastChangeDate,
  ReleaseOrderItemLastChgDate
FROM P_UnusedPurchaseContract4
;

Learn More