P_ACMTrdgContrPrcOvw

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_ACMTrdgContrPrcOvw.
-- 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: PACMTRDGPRC

CREATE VIEW P_ACMTrdgContrPrcOvw 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,
  PriceFixation.accgo_prc_fix_status AS PricingStatus,
  PriceFixation.CmmdtyOrderRequestStatus AS CmmdtyOrderRequestStatus,
  PriceFixation.CmmdtyOrderRequestStatusText AS CmmdtyOrderRequestStatusText,
  material.Commodity AS Commodity,
  Counterparty.Counterparty AS Counterparty,
  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,
  PriceFixation.TERMNO AS TERMNO,
  Header.company_code AS CompanyCode,
  DerivativeContrSpecification,
  ACMPricingMarketIdentifierCode,
  MaturityKeyDate,
  concat(concat(PriceFixation.CommodityProductSymbol, PriceFixation.DerivativeContractMaturityCode), PriceFixation.CmmdtyMaturityMonthYear) AS ContractMaturityCode,
  PricingAspect.ACMPrcgCndnFlatPrice AS PrcgCndnTradingContrCurrency,
  Comsub.TrdgContrCreditSalesFromDate AS CmmdtyDealDetEffectiveFromDate,
  Comsub.TrdgContractCreditSalesToDate AS CmmdtyDealDetEffectiveToDate,
  ItemAddl.ACMPrcgIntendedPrcType AS ACMPrcgIntendedPrcType,
  Business.ACMYourReference AS ACMYourReference,
  Business.ACMCustomerReference AS ACMCustomerReference
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 P_TradingContractCounterparty AS Counterparty 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 */
;