P_UnusedPurchaseContract2

DDL: P_UNUSEDPURCHASECONTRACT2 SQL: PMMUNUSEDPC2 Type: view CONSUMPTION
6 Fields 2 Data Sources

Unused Purchase Contract 2

P_UnusedPurchaseContract2 is a Consumption CDS View that provides data about "Unused Purchase Contract 2" in SAP S/4HANA. It reads from 2 data sources (I_CalendarDate, P_UnusedPurchaseContract1) and exposes 6 fields with key field PurchaseContract.

Data Sources (2)

SourceAliasJoin Type
I_CalendarDate _Calendar left_outer
P_UnusedPurchaseContract1 P_UnusedPurchaseContract1 from

Parameters (3)

NameTypeDefault
P_StartDate sydate
P_EndDate sydate
P_DisplayCurrency displaycurrency

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMMUNUSEDPC2 view
EndUserText.label Unused Purchase Contract 2 view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract Purchasing Doc.
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
CompanyCode CompanyCode Receiver Company Code
PurchaseContractType PurchaseContractType Order Type
PurchaseContractLastActvtDate PurchaseContractLastActvtDate

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

CREATE VIEW P_UnusedPurchaseContract2 AS
SELECT
  PurchaseContract,
  PurchasingOrganization,
  PurchasingGroup,
  CompanyCode,
  PurchaseContractType,
  PurchaseContractLastActvtDate
FROM P_UnusedPurchaseContract1
LEFT OUTER JOIN I_CalendarDate AS _Calendar ON /* join condition not captured in parsed metadata */
;

Learn More