C_TrdgContrOutputForm

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_TrdgContrOutputForm.
-- 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: CTCOUTPUTFORM

CREATE VIEW C_TrdgContrOutputForm AS
SELECT
  TradingContract,
  TradingContractType,
  TradingContractCategory,
  TrdgContrBusProcessCategory,
  TradingContractPurpose,
  TrdgContrApplicationStatus,
  SalesDocumentType,
  SalesDocumentCondition,
  CreatedByUser,
  LastChangedByUser,
  TrdgContrPersonResponsible,
  CreationDate,
  CreationTime,
  LastChangeDate,
  LastChangeTime,
  TrdgContrDate,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesGroup,
  SalesOffice,
  SoldToParty,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  CreditControlArea,
  SDDocumentCategory,
  SalesDocumentDate,
  SalesOrderReason,
  SDDocumentCollectiveNumber,
  CustomerPurchaseOrderType,
  CustomerPurchaseOrderSuplmnt,
  BindingPeriodValidityStartDate,
  BindingPeriodValidityEndDate,
  TrdgContrSlsValidityStartDate,
  TrdgContrSlsValidityEndDate,
  TrdgContrProdUsgeCat,
  ForeignTrade,
  TrdgContrSlsPersonName,
  PhoneNumber1,
  TrdgContrSlsNrOfFollowUps,
  DocumentReferenceID,
  TradingContractCurrency,
  TrdgContrTotalNetAmount,
  TradingContractExchangeRate,
  TrdgContrExchangeRateType,
  TrdgContrExchangeRateDate,
  TradingContractSalesCurrency,
  TrdgContrSalesExchangeRate,
  TrdgContrSalesExchangeRateType,
  TrdgContrSalesPricingDate,
  TrdgContrSalesPricingProcedure,
  CustomerTaxClassification1,
  CustomerTaxClassification2,
  CustomerTaxClassification3,
  CustomerTaxClassification4,
  CustomerTaxClassification5,
  CustomerTaxClassification6,
  CustomerTaxClassification7,
  CustomerTaxClassification8,
  CustomerTaxClassification9,
  TaxDepartureCountry,
  VATRegistrationCountry,
  ShippingCondition,
  CompleteDeliveryIsDefined,
  DeliveryBlockReason,
  CompanyCode,
  HeaderBillingBlockReason,
  ControllingArea,
  CustomerCreditAccount,
  CustomerCreditGroup,
  CreditRepresentativeGroup,
  CustomerRiskCategory,
  ControllingAreaCurrency,
  CreditBlockReleaseDate,
  NextCreditCheckDate,
  NextShippingDate,
  ReleasedCreditAmount,
  TrdgContrSuplrBillgBlkRsn,
  AccountingExchangeRate,
  TrdgContrSlsExternalReference,
  TradingContractIsComplete,
  LastCustomerContactDate,
  TrdgContrQuantityIsComplete,
  TradingContractReleaseStatus,
  TradingContractExtID,
  TrdgContrSrceDocType,
  TradingContractGoodsReceiver,
  IsEUTriangularDeal,
  TrdgContrHdrIsExtended,
  TrdgContrSuccessorArchived,
  TrdgContrHasCnsldtdItem,
  TrdgContrVarContrSettlmt,
  TrdgContrBatDetnProcedure,
  TrdgContrProcessingStatus,
  TrdgContrProcessingLastAction,
  TrdgContrProcgLastSequence,
  TradingProcessVariantType,
  WBSElementInternalID,
  TrdgContrPricingType,
  TrdgContrLastChangedCategory,
  Supplier,
  PurchasingOrganization,
  PurchasingGroup,
  PurchasingDocumentOrderDate,
  TrdgContrPurgReqdDeliveryDate,
  TrdgContrPurgDeliveryDateType,
  TrdgContrSlsReqdDeliveryDate,
  TrdgContrSlsDeliveryDateType,
  TrdgContrPurgCurrency,
  TrdgContrPurgExchangeRate,
  TrdgContrPurgExchangeRateType,
  TrdgContrPurgPaymentTerms,
  TrdgContrSalesPaymentTerms,
  TrdgContrSalesFixedValueDate,
  TrdgContrPurgFixedValueDate,
  TrdgContrPurgPricingDate,
  SupplyingPlant,
  TrdgContrPurgIncotermsVersion,
  TrdgContrPurgIncotermsLoc1Text,
  TrdgContrPurgIncotermsLoc2Text,
  TrdgContrSalesIncotermsVersion,
  TrdgContrSlsIncotermsLoc1Text,
  TrdgContrSlsIncotermsLoc2Text,
  QuotationSubmissionDate,
  TrdgContrSalesPaymentMethod,
  TrdgContrPurgValidityStartDate,
  TrdgContrPurgValidityEndDate,
  SupplierQuotationExternalID,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  CorrespncInternalReference,
  TrdgContrPurgDocExtReference,
  InternalFinancialDocument,
  DepreciationPercentage,
  FixedExchangeRateIsUsed,
  TrdgContrPurgDocCat,
  PurchasingDocumentType,
  ShippingType,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate,
  TrdgContrPurgPricingProcedure,
  DownPaymentType,
  DownPaymentPercentageOfTotAmt,
  DownPaymentAmount,
  DownPaymentDueDate,
  TrdgContrPurgDocCndn,
  SlsIncotermsClassification,
  PurgIncotermsClassification,
  TrdgContrPurgDelivAddrCat,
  PaymentGuaranteeProcedure,
  TrdgContrPOByCustomer,
  PaymentTermsName,
  PurgIncotermsTransferLocation,
  SlsIncotermsTransferLocation,
  PurchaseOrderByShipToParty,
  CreationDateTime,
  LastChangeDateTime,
  TrdgContrRelStsCritlty,
  CustomerName,
  TrdgContrPurgShipgInstrn,
  SupplierConfirmationControlKey,
  TrdgContrMnlPOSplit,
  UnderlyingPurchaseOrderItem
FROM R_TrdgContr
LEFT OUTER JOIN C_TrdgContrItemOutputForm AS _TrdgContrItemOutputForm ON TradingContract = _TrdgContrItemOutputForm.TradingContract  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _TrdgContrCurrency ON TradingContractCurrency = _TrdgContrCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CustomerPurchaseOrderType AS _CustomerPurchaseOrderType ON CustomerPurchaseOrderType = _CustomerPurchaseOrderType.CustomerPurchaseOrderType  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _TrdgContrSalesPaymentTerms ON TrdgContrSalesPaymentTerms = _TrdgContrSalesPaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _SlsIncotermsClassification ON SlsIncotermsClassification = _SlsIncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_IncotermsVersion AS _TrdgContrSlsIncotermsVersion ON TrdgContrSalesIncotermsVersion = _TrdgContrSlsIncotermsVersion.IncotermsVersion  -- association [0..1]
LEFT OUTER JOIN I_ShippingCondition AS _ShippingCondition ON ShippingCondition = _ShippingCondition.ShippingCondition  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentReason AS _SalesOrderReason ON SalesOrderReason = _SalesOrderReason.SDDocumentReason  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TrdgContrSalesCurrency ON TradingContractSalesCurrency = _TrdgContrSalesCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ExchangeRateType AS _TrdgContrExchangeRateType ON TrdgContrExchangeRateType = _TrdgContrExchangeRateType.ExchangeRateType  -- association [0..1]
LEFT OUTER JOIN I_DeliveryBlockReason AS _DeliveryBlockReason ON DeliveryBlockReason = _DeliveryBlockReason.DeliveryBlockReason  -- association [0..1]
LEFT OUTER JOIN I_BillingBlockReason AS _HeaderBillingBlockReason ON HeaderBillingBlockReason = _HeaderBillingBlockReason.BillingBlockReason  -- association [0..1]
LEFT OUTER JOIN I_SlsPricingProcedure AS _TrdgContrSlsPricingProcedure ON TrdgContrSalesPricingProcedure = _TrdgContrSlsPricingProcedure.PricingProcedure  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1 ON AdditionalCustomerGroup1 = _AdditionalCustomerGroup1.AdditionalCustomerGroup1  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2 ON AdditionalCustomerGroup2 = _AdditionalCustomerGroup2.AdditionalCustomerGroup2  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3 ON AdditionalCustomerGroup3 = _AdditionalCustomerGroup3.AdditionalCustomerGroup3  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4 ON AdditionalCustomerGroup4 = _AdditionalCustomerGroup4.AdditionalCustomerGroup4  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5 ON AdditionalCustomerGroup5 = _AdditionalCustomerGroup5.AdditionalCustomerGroup5  -- association [0..1]
LEFT OUTER JOIN I_CreditControlArea AS _CreditControlArea ON CreditControlArea = _CreditControlArea.CreditControlArea  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentType AS _SalesDocumentType ON SalesDocumentType = _SalesDocumentType.SalesDocumentType  -- association [0..1]
;