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,
  TrdgContrItemIsDeleted,
  TrdgContrItemText,
  TradingContractItemCategory,
  Product,
  Batch,
  TrdgContrSlsReqdDeliveryDate,
  TrdgContrSlsDeliveryDateType,
  TrdgContrHigherLevelItem,
  TrdgContrSalesPaymentTerms,
  TrdgContrSalesQuantity,
  TradingContractSalesCurrency,
  TrdgContrSlsQuantityUnit,
  TrdgContrSalesNetPriceAmount,
  TrdgContrSlsNetPriceQuantity,
  TrdgContrSlsPriceUnit,
  TrdgContrSlsItemNetAmount,
  TrdgContrSalesPricingDate,
  InternationalArticleNumber,
  TrdgContrSlsItmNetAmtInSlsCrcy,
  ProductUsedByCustomer,
  PurchaseOrderByCustomer,
  SalesDocumentRjcnReason,
  TrdgContrPrcDetnExchRate,
  SlsIncotermsClassification,
  TrdgContrSalesIncotermsVersion,
  TrdgContrSlsIncotermsLoc1Text,
  TrdgContrSlsIncotermsLoc2Text,
  _SlsIncotermsClassification._Text[1: Language = $session.system_language].IncotermsClassificationName AS IncotermsClassificationName,
  _TrdgContrSlsIncotermsVersion._Text[1: Language = $session.system_language].IncotermsVersionName AS IncotermsVersionName,
  _PaymentTerms._Text[1: Language = $session.system_language].PaymentTermsName AS PaymentTermsName
FROM R_TrdgContrItem
LEFT OUTER JOIN C_TrdgContrCustFDP 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 I_TrdgContrItemCompletePartner AS _ItemShipToPartner ON TradingContract = _ItemShipToPartner.TradingContract AND TradingContractItem = _ItemShipToPartner.TradingContractItem AND _ItemShipToPartner.PartnerCounter = '000' AND _ItemShipToPartner.PartnerFunction = 'WE'  -- association [0..1]
;