P_TrdgContrPricingOverview

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_TrdgContrPricingOverview.
-- 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: PTRDGCTRPRC

CREATE VIEW P_TrdgContrPricingOverview AS
SELECT
  PricingAspect.TrdgContrPrcgAspectSrceLotID AS SourceLotId,
  Header.tkonn AS TradingContractNumber,
  Header.tctyp AS TradingContractType,
  Header.tctyp_descr AS TradingContractTypeName,
  Business.DocumentSide AS Side,
  Header.btbsta AS ContractStatus,
  Header.bezei AS TrdgContrApplStsName,
  Header.vkorg AS SalesOrganization,
  Header.SalesOrgDescr AS SalesOrgDescr,
  Header.vtweg AS DistributionChannel,
  Header.DistributionChannelDescr AS DistributionChannelDescr,
  Header.spart AS Division,
  Header.SalesDivisionDescr AS SalesDivisionDescr,
  Business.PurchasingOrganization AS PurchasingOrganization,
  Business.ekotx AS PurchasingOrgDescr,
  Business.PurchasingGroup AS PurchasingGroup,
  Business.eknam AS PurchasingGroupDescr,
  Header.tkonn_ex AS TradingContractExternalID,
  Item.ContractPlant AS ContractPlant,
  Item.ContractMaterial AS ContractMaterial,
  Item.TradingContractItem AS TradingContractItem,
  Header.erdat AS DocumentDate,
  Header.tksachb AS PersonResponsible,
  Header.PersonResponsible AS PersonResponsibleName,
  Header.ernam AS TradingContractCreatedBy,
  Header.CreatedBy AS TradingContractCreatedByName,
  Header.aenam AS TradingContractChangedBy,
  Header.ChangedBy AS TradingContractChangedByName,
  Business.IncotermsClassificationName AS IncotermsClassificationName,
  ItemAddl.PricingApproach AS PricingApproach,
  material.Commodity AS Commodity,
  case Business.DocumentSide when 'M' then Purchase_Counterparty.Counterparty else Sales_Counterparty.Counterparty end as Counterparty AS CounterpartyendasCounterparty,
  case Business.DocumentSide when 'M' then Purchase_Counterparty.CustomerName else Sales_Counterparty.CustomerName end as CustomerName AS CustomerNameendasCustomerName,
  case Business.DocumentSide when 'M' then Business.ACMPurgIncotermsPart1 else Business.ACMSlsIncotermsPart1 end as Incoterms AS ACMSlsIncotermsPart1endasIncoterms,
  Business.TrdgContrPurgIncotermsLoc1Text AS TrdgContrPurgIncotermsLoc1Text,
  Business.TrdgContrSlsIncotermsLoc1Text AS TrdgContrSlsIncotermsLoc1Text,
  PricingAspect.ContractTradeUnit AS UoM,
  PricingAspect.ContractTradeQuantity AS Quantity,
  case when PriceFixationF.PricingConditionTerm is null or PriceFixationF.PricingConditionTerm is initial then PriceFixationNH.PricingConditionTerm else PriceFixationF.PricingConditionTerm end as TERMNO AS PricingConditionTermendasTERMNO,
  Header.company_code AS CompanyCode,
  case when PriceFixationF.MaturityKeyDate is null then PriceFixationNH.MaturityKeyDate else PriceFixationF.MaturityKeyDate end as MaturityKeyDate AS MaturityKeyDateendasMaturityKeyDate,
  PricingAspect.ACMPrcgCndnFlatPrice AS PrcgCndnTradingContrCurrency,
  Comsub.TrdgContrCreditSalesFromDate AS CmmdtyDealDetEffectiveFromDate,
  Comsub.TrdgContractCreditSalesToDate AS CmmdtyDealDetEffectiveToDate,
  ItemAddl.ACMPrcgIntendedPrcType AS ACMPrcgIntendedPrcType,
  Business.ACMYourReference AS ACMYourReference,
  Business.ACMCustomerReference AS ACMCustomerReference
FROM I_ACMTrdgContrPrcAspectDets AS PricingAspect
INNER JOIN I_ACMTradingContractItemData AS Item ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMTradingContractItemAddl AS ItemAddl ON /* join condition not captured in parsed metadata */
INNER JOIN P_TradingContractHeader AS Header ON /* join condition not captured in parsed metadata */
INNER JOIN P_TradingContractBusinessDets AS Business ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMContractCommoditySubitem AS Comsub ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMMaterialMstrData AS material ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ACMMntnPrcgPrcFixDetFuture AS PriceFixationF ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ACMMntnPrcgPrcFixDetNonHedge AS PriceFixationNH ON /* join condition not captured in parsed metadata */
;