C_TrdgContrCustFDP

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 C_TrdgContrCustFDP.
-- 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 C_TrdgContrCustFDP AS
SELECT
  TradingContract,
  TradingContractExtID,
  TrdgContrDate,
  CompanyCode,
  SoldToParty,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate,
  TrdgContrSlsReqdDeliveryDate,
  TrdgContrSalesPaymentTerms,
  TradingContractSalesCurrency,
  TrdgContrSalesPricingProcedure,
  SlsIncotermsClassification,
  TrdgContrSalesIncotermsVersion,
  TrdgContrSlsIncotermsLoc1Text,
  TrdgContrSlsIncotermsLoc2Text,
  SalesDocumentCondition,
  SDDocumentCategory,
  TrdgContrSalesPricingDate,
  TrdgContrSalesExchangeRateType,
  TrdgContrSalesExchangeRate,
  TradingContractType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  PurchasingOrganization
FROM R_TrdgContr
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON TrdgContrSalesPaymentTerms = _PaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON SlsIncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_IncotermsVersion AS _IncotermsVersion ON TrdgContrSalesIncotermsVersion = _IncotermsVersion.IncotermsVersion  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _SalesCurrency ON TradingContractSalesCurrency = _SalesCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_SlsPricingProcedure AS _PricingProcedure ON TrdgContrSalesPricingProcedure = _PricingProcedure.PricingProcedure  -- association [0..1]
LEFT OUTER JOIN R_TrdgContrItemCustFDP AS _Item ON TradingContract = _Item.TradingContract  -- association [0..*]
LEFT OUTER JOIN R_TrdgContrPartner AS _ShipToPartner ON TradingContract = _ShipToPartner.TradingContract AND _ShipToPartner.PartnerCounter = '000' AND _ShipToPartner.PartnerFunction = 'WE'  -- association [0..1]
LEFT OUTER JOIN R_TrdgContrPartner AS _SoldToPartner ON TradingContract = _SoldToPartner.TradingContract AND _SoldToPartner.PartnerCounter = '000' AND _SoldToPartner.PartnerFunction = 'AG'  -- association [0..1]
LEFT OUTER JOIN R_TrdgContrPartner AS _ContactPartner ON TradingContract = _ContactPartner.TradingContract AND _ContactPartner.PartnerCounter = '000' AND _ContactPartner.PartnerFunction = 'AP'  -- association [0..1]
;