P_CmmdtyPrcFixationOptnPurgNew

DDL: P_CMMDTYPRCFIXATIONOPTNPURGNEW Type: view_entity COMPOSITE
44 Fields 4 Data Sources 1 Associations

Cmmdty Price Fix Option Purchasing New

P_CmmdtyPrcFixationOptnPurgNew is a Composite CDS View that provides data about "Cmmdty Price Fix Option Purchasing New" in SAP S/4HANA. It reads from 4 data sources (ekko, ekpo, I_CmmdtyPrcgConditionFormula, cped_knumvtoguid) and exposes 44 fields with key fields PurchasingDocument, PurchasingDocumentItem, ConditionType, PricingConditionTerm. It has 1 association to related views.

Data Sources (4)

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

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Supplier _Supplier $projection.ActiveSupplier = _Supplier.Supplier

Annotations (8)

NameValueLevelField
AbapCatalog.dataMaintenance #RESTRICTED view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Cmmdty Price Fix Option Purchasing 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 (44)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument ekko ebeln Source PurchDoc
KEY PurchasingDocumentItem ekpo ebelp Item pur. doc.
KEY ConditionType I_CmmdtyPrcgConditionFormula ConditionType Condition type
KEY PricingConditionTerm term PricingConditionTerm Term Number
CalcdPrcgConditionTermQuantity term CalcdPrcgConditionTermQuantity
CalcdPrcgCndnTermQuantityUnit term CalcdPrcgCndnTermQuantityUnit
ConditionTermRate
ConditionTermRateCurrency term ConditionTermRateCurrency
ConditionTermRateQuantity term ConditionTermRateQuantity
ConditionTermRateQuantityUnit term ConditionTermRateQuantityUnit
PrcgCndnTermFixationOptnStatus term PrcgCndnTermFixationOptnStatus
PrcgCndnTermCnvrsnSourceCrcy mm_fxrel PrcgCndnTermCnvrsnSourceCrcy
PrcgCndnTermCnvrsnTargetCrcy mm_fxrel PrcgCndnTermCnvrsnTargetCrcy
CndnTrmFixationOptnNonFixedQty term CndnTrmFixationOptnNonFixedQty
TrmFixationOptnNonFixedQtyUnit term TrmFixationOptnNonFixedQtyUnit
PurchasingDocumentCategory ekko bstyp Source doc.cat.
ActiveSupplier ekko lifnr Vendor no.
CompanyCode ekko bukrs Value
PurchasingOrganization ekko ekorg Purchasing Org.
PurchasingGroup ekko ekgrp Sub. purchasing grp
Plant ekpo werks Receiving Plant
Material ekpo matnr Vehicle Model
PrcgConditionFormulaInputUUID I_CmmdtyPrcgConditionFormula PrcgConditionFormulaInputUUID Doc. Form. GUID
LastChangeDateTime ekko lastchangedatetime Timestamp
CreatedByUser ekko ernam User Name
DocumentDate ekko bedat Start date
DerivativeContrSpecification term DerivativeContrSpecification DCS ID
BusinessPartner
BusinessPartnerName
DataControllerSet
DataController1
DataController2
DataController3
DataController4
DataController5
DataController6
DataController7
DataController8
DataController9
DataController10
AuthorizationGroup
IsBusinessPurposeCompleted
quotkey_term mm_basis quotkey_term
DocItmCmmdtyPrcgCndnUUID mm_fxrel DocItmCmmdtyPrcgCndnUUID Doc. Cond. Item GUID

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_CmmdtyPrcFixationOptnPurgNew.
-- 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_CmmdtyPrcFixationOptnPurgNew AS
SELECT
  ekko.ebeln AS PurchasingDocument,
  ekpo.ebelp AS PurchasingDocumentItem,
  formula.ConditionType AS ConditionType,
  term.PricingConditionTerm AS PricingConditionTerm,
  term.CalcdPrcgConditionTermQuantity AS CalcdPrcgConditionTermQuantity,
  term.CalcdPrcgCndnTermQuantityUnit AS CalcdPrcgCndnTermQuantityUnit,
  cast ( cast (term.ConditionTermRate as abap.decfloat34) as cpet_fixtermrate_dcs) AS ConditionTermRate,
  term.ConditionTermRateCurrency AS ConditionTermRateCurrency,
  term.ConditionTermRateQuantity AS ConditionTermRateQuantity,
  term.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
  term.PrcgCndnTermFixationOptnStatus AS PrcgCndnTermFixationOptnStatus,
  mm_fxrel.PrcgCndnTermCnvrsnSourceCrcy AS PrcgCndnTermCnvrsnSourceCrcy,
  mm_fxrel.PrcgCndnTermCnvrsnTargetCrcy AS PrcgCndnTermCnvrsnTargetCrcy,
  term.CndnTrmFixationOptnNonFixedQty AS CndnTrmFixationOptnNonFixedQty,
  term.TrmFixationOptnNonFixedQtyUnit AS TrmFixationOptnNonFixedQtyUnit,
  ekko.bstyp AS PurchasingDocumentCategory,
  ekko.lifnr AS ActiveSupplier,
  ekko.bukrs AS CompanyCode,
  ekko.ekorg AS PurchasingOrganization,
  ekko.ekgrp AS PurchasingGroup,
  ekpo.werks AS Plant,
  ekpo.matnr AS Material,
  formula.PrcgConditionFormulaInputUUID AS PrcgConditionFormulaInputUUID,
  ekko.lastchangedatetime AS LastChangeDateTime,
  ekko.ernam AS CreatedByUser,
  ekko.bedat AS DocumentDate,
  term.DerivativeContrSpecification AS DerivativeContrSpecification,
  _Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  _Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _Supplier._SupplierToBusinessPartner._BusinessPartner.DataControllerSet AS DataControllerSet,
  _Supplier._SupplierToBusinessPartner._BusinessPartner.DataController1 AS DataController1,
  _Supplier._SupplierToBusinessPartner._BusinessPartner.DataController2 AS DataController2,
  _Supplier._SupplierToBusinessPartner._BusinessPartner.DataController3 AS DataController3,
  _Supplier._SupplierToBusinessPartner._BusinessPartner.DataController4 AS DataController4,
  _Supplier._SupplierToBusinessPartner._BusinessPartner.DataController5 AS DataController5,
  _Supplier._SupplierToBusinessPartner._BusinessPartner.DataController6 AS DataController6,
  _Supplier._SupplierToBusinessPartner._BusinessPartner.DataController7 AS DataController7,
  _Supplier._SupplierToBusinessPartner._BusinessPartner.DataController8 AS DataController8,
  _Supplier._SupplierToBusinessPartner._BusinessPartner.DataController9 AS DataController9,
  _Supplier._SupplierToBusinessPartner._BusinessPartner.DataController10 AS DataController10,
  _Supplier._SupplierToBusinessPartner._BusinessPartner.AuthorizationGroup AS AuthorizationGroup,
  _Supplier._SupplierToBusinessPartner._BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  mm_basis.quotkey_term AS quotkey_term,
  mm_fxrel.DocItmCmmdtyPrcgCndnUUID AS DocItmCmmdtyPrcgCndnUUID
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 */
LEFT OUTER JOIN I_Supplier AS _Supplier ON ActiveSupplier = _Supplier.Supplier  -- association [1..1]
;

Learn More