R_TrdgContrItemCustFDP

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 R_TrdgContrItemCustFDP.
-- 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 R_TrdgContrItemCustFDP AS
SELECT
  TradingContract,
  TradingContractItem,
  TrdgContrItemText,
  Product,
  Batch,
  TrdgContrSlsReqdDeliveryDate,
  TrdgContrHigherLevelItem,
  TrdgContrSalesPaymentTerms,
  TrdgContrSalesQuantity,
  TradingContractSalesCurrency,
  TrdgContrSlsQuantityUnit,
  TrdgContrSalesNetPriceAmount,
  TrdgContrSlsNetPriceQuantity,
  TrdgContrSlsPriceUnit,
  TrdgContrSlsItemNetAmount,
  TrdgContrSalesPricingDate,
  InternationalArticleNumber,
  TrdgContrSlsItmNetAmtInSlsCrcy,
  ProductUsedByCustomer,
  PurchaseOrderByCustomer,
  TrdgContrPrcDetnExchRate,
  SlsIncotermsClassification,
  TrdgContrSalesIncotermsVersion,
  TrdgContrSlsIncotermsLoc1Text,
  TrdgContrSlsIncotermsLoc2Text
FROM R_TrdgContrItem
LEFT OUTER JOIN R_TrdgContr AS _TrdgContr ON TradingContract = _TrdgContr.TradingContract  -- association [1..1]
LEFT OUTER JOIN C_TrdgContrItemSchdLnCustFDP AS _ItemScheduleLine ON TradingContract = _ItemScheduleLine.TradingContract AND TradingContractItem = _ItemScheduleLine.TradingContractItem  -- association [0..*]
LEFT OUTER JOIN I_IncotermsClassification AS _ItemIncotermsClassification ON SlsIncotermsClassification = _ItemIncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_IncotermsVersion AS _ItemIncotermsVersion ON TrdgContrSalesIncotermsVersion = _ItemIncotermsVersion.IncotermsVersion  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON TrdgContrSalesPaymentTerms = _PaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN R_TrdgContrItemPartner AS _ItemShipToPartner ON TradingContract = _ItemShipToPartner.TradingContract AND TradingContractItem = _ItemShipToPartner.TradingContractItem AND _ItemShipToPartner.PartnerCounter = '000' AND _ItemShipToPartner.PartnerFunction = 'WE'  -- association [0..1]
;