P_PrFixationOptnBsHndlgPurgNew

DDL: P_PRFIXATIONOPTNBSHNDLGPURGNEW Type: view_entity COMPOSITE
5 Fields 4 Data Sources

Cmmdt Prc Fix Opt Basis Hndlg Purg New

P_PrFixationOptnBsHndlgPurgNew is a Composite CDS View that provides data about "Cmmdt Prc Fix Opt Basis Hndlg Purg New" in SAP S/4HANA. It reads from 4 data sources (ekko, ekpo, I_CmmdtyPrcgConditionFormula, cped_knumvtoguid) and exposes 5 fields with key fields PurchasingDocument, PurchasingDocumentItem, ConditionType, ConditionTermRateFixation.

Data Sources (4)

SourceAliasJoin Type
ekko ekko inner
ekpo ekpo inner
I_CmmdtyPrcgConditionFormula formula from
cped_knumvtoguid knumvtoguid inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Cmmdt Prc Fix Opt Basis Hndlg Purg New view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MIXED view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument ekko ebeln Source PurchDoc
KEY PurchasingDocumentItem ekpo ebelp Item pur. doc.
KEY ConditionType I_CmmdtyPrcgConditionFormula ConditionType Condition type
KEY ConditionTermRateFixation term PricingConditionTerm Term Number
quotkey_term term PricingConditionQuotationKey Quot. Key Type

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_PrFixationOptnBsHndlgPurgNew.
-- 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 P_PrFixationOptnBsHndlgPurgNew AS
SELECT
  ekko.ebeln AS PurchasingDocument,
  ekpo.ebelp AS PurchasingDocumentItem,
  formula.ConditionType AS ConditionType,
  term.PricingConditionTerm AS ConditionTermRateFixation,
  term.PricingConditionQuotationKey AS quotkey_term
FROM I_CmmdtyPrcgConditionFormula AS formula
INNER JOIN cped_knumvtoguid AS knumvtoguid ON /* join condition not captured in parsed metadata */
INNER JOIN ekko ON /* join condition not captured in parsed metadata */
INNER JOIN ekpo ON /* join condition not captured in parsed metadata */
;

Learn More