R_TrdgContr

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_TrdgContr.
-- 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_TrdgContr AS
SELECT
  TradingDocument AS TradingContract,
  TradingDocumentType AS TradingContractType,
  TrdgDocCategory AS TradingContractCategory,
  TradingDocument.TrdgDocBusProcessCategory AS TrdgContrBusProcessCategory,
  TrdgDocPurpose AS TradingContractPurpose,
  TrdgDocApplicationStatus AS TrdgContrApplicationStatus,
  SalesDocumentType,
  SalesDocumentCondition,
  CreatedByUser,
  LastChangedByUser,
  TrdgDocPersonResponsible AS TrdgContrPersonResponsible,
  CreationDate,
  CreationTime,
  LastChangeDate,
  LastChangeTime,
  TrdgDocDate AS TrdgContrDate,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesGroup,
  SalesOffice,
  SoldToParty,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  CreditControlArea,
  SDDocumentCategory,
  SalesDocumentDate,
  SalesOrderReason,
  SDDocumentCollectiveNumber,
  CustomerPurchaseOrderType,
  CustomerPurchaseOrderSuplmnt,
  BindingPeriodValidityStartDate,
  BindingPeriodValidityEndDate,
  TrdgDocSlsValidityStartDate AS TrdgContrSlsValidityStartDate,
  TrdgDocSlsValidityEndDate AS TrdgContrSlsValidityEndDate,
  TrdgDocProdUsgeCat AS TrdgContrProdUsgeCat,
  ForeignTrade,
  TrdgDocSlsPersonName AS TrdgContrSlsPersonName,
  PhoneNumber1,
  TrdgDocSlsNrOfFollowUps AS TrdgContrSlsNrOfFollowUps,
  DocumentReferenceID,
  TrdgDocCurrency AS TradingContractCurrency,
  TrdgDocTotalNetAmount AS TrdgContrTotalNetAmount,
  TrdgDocExchangeRate AS TradingContractExchangeRate,
  TrdgDocExchangeRateType AS TrdgContrExchangeRateType,
  TrdgDocExchangeRateDate AS TrdgContrExchangeRateDate,
  TrdgDocSalesCurrency AS TradingContractSalesCurrency,
  TrdgDocSalesExchangeRate AS TrdgContrSalesExchangeRate,
  TrdgDocSalesExchangeRateType AS TrdgContrSalesExchangeRateType,
  TrdgDocSalesPricingDate AS TrdgContrSalesPricingDate,
  TrdgDocSalesPricingProcedure AS 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,
  TrdgDocAddlExpnsBlkRsn AS TrdgContrAddlExpnsBlkRsn,
  TrdgDocSuplrBillgBlkRsn AS TrdgContrSuplrBillgBlkRsn,
  AccountingExchangeRate,
  TrdgDocSlsExternalReference AS TrdgContrSlsExternalReference,
  TrdgDocIsComplete AS TradingContractIsComplete,
  LastCustomerContactDate,
  TrdgDocQuantityIsComplete AS TrdgContrQuantityIsComplete,
  TrdgDocReleaseStatus AS TradingContractReleaseStatus,
  TrdgDocExternalIdentifier AS TradingContractExtID,
  TrdgDocSrceDocType AS TrdgContrSrceDocType,
  TradingDocumentGoodsReceiver AS TradingContractGoodsReceiver,
  IsEUTriangularDeal,
  TrdgDocHdrIsExtended AS TrdgContrHdrIsExtended,
  TrdgDocSuccessorArchived AS TrdgContrSuccessorArchived,
  TrdgDocHasCnsldtdItem AS TrdgContrHasCnsldtdItem,
  TrdgDocVarContrSettlmt AS TrdgContrVarContrSettlmt,
  TrdgDocIsInApproval AS TradingContractIsInApproval,
  TrdgDocBatDetnProcedure AS TrdgContrBatDetnProcedure,
  TrdgDocProcgStatus AS TrdgContrProcessingStatus,
  TrdgDocProcessingLastAction AS TrdgContrProcessingLastAction,
  TrdgDocProcgLastSequence AS TrdgContrProcgLastSequence,
  TradingProcessVariantType,
  WBSElementInternalID,
  TrdgDocPricingType AS TrdgContrPricingType,
  TrdgDocLastChangedCategory AS TrdgContrLastChangedCategory,
  Supplier,
  PurchasingOrganization,
  PurchasingGroup,
  PurchasingDocumentOrderDate,
  TrdgDocPurgReqdDeliveryDate AS TrdgContrPurgReqdDeliveryDate,
  TrdgDocPurgDeliveryDateType AS TrdgContrPurgDeliveryDateType,
  TrdgDocSlsReqdDeliveryDate AS TrdgContrSlsReqdDeliveryDate,
  TrdgDocSlsDeliveryDateType AS TrdgContrSlsDeliveryDateType,
  TrdgDocPurgCurrency AS TrdgContrPurgCurrency,
  TrdgDocPurgExchangeRate AS TrdgContrPurgExchangeRate,
  TrdgDocPurgExchangeRateType AS TrdgContrPurgExchangeRateType,
  TrdgDocPurgPaymentTerms AS TrdgContrPurgPaymentTerms,
  TrdgDocSalesPaymentTerms AS TrdgContrSalesPaymentTerms,
  TrdgDocSalesFixedValueDate AS TrdgContrSalesFixedValueDate,
  TrdgDocPurgFixedValueDate AS TrdgContrPurgFixedValueDate,
  TrdgDocPurgPricingDate AS TrdgContrPurgPricingDate,
  SupplyingPlant,
  TrdgDocPurgIncotermsVersion AS TrdgContrPurgIncotermsVersion,
  TrdgDocPurgIncotermsLoc1Text AS TrdgContrPurgIncotermsLoc1Text,
  TrdgDocPurgIncotermsLoc2Text AS TrdgContrPurgIncotermsLoc2Text,
  TrdgDocSalesIncotermsVersion AS TrdgContrSalesIncotermsVersion,
  TrdgDocSlsIncotermsLoc1Text AS TrdgContrSlsIncotermsLoc1Text,
  TrdgDocSlsIncotermsLoc2Text AS TrdgContrSlsIncotermsLoc2Text,
  QuotationSubmissionDate,
  TrdgDocSalesPaymentMethod AS TrdgContrSalesPaymentMethod,
  TrdgDocPurgValidityStartDate AS TrdgContrPurgValidityStartDate,
  TrdgDocPurgValidityEndDate AS TrdgContrPurgValidityEndDate,
  SupplierQuotationExternalID,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  CorrespncInternalReference,
  TrdgDocPurgDocExtReference AS TrdgContrPurgDocExtReference,
  InternalFinancialDocument,
  DepreciationPercentage,
  FixedExchangeRateIsUsed,
  TrdgDocPurgDocCat AS TrdgContrPurgDocCat,
  PurchasingDocumentType,
  ShippingType,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate,
  TrdgDocPurgPricingProcedure AS TrdgContrPurgPricingProcedure,
  DownPaymentType,
  DownPaymentPercentageOfTotAmt,
  DownPaymentAmount,
  DownPaymentDueDate,
  TrdgDocPurgDocCndn AS TrdgContrPurgDocCndn,
  SlsIncotermsClassification,
  PurgIncotermsClassification,
  TrdgDocPurgDelivAddrCat AS TrdgContrPurgDelivAddrCat,
  PaymentGuaranteeProcedure,
  TrdgDocPOByCustomer AS TrdgContrPOByCustomer,
  PaymentTermsName,
  PurgIncotermsTransferLocation,
  SlsIncotermsTransferLocation,
  PurchaseOrderByShipToParty,
  CreationDateTime,
  LastChangeDateTime,
  TrdgDocRelStsCritlty AS TrdgContrRelStsCritlty,
  TrdgDocPurgShipgInstrn AS TrdgContrPurgShipgInstrn,
  SupplierConfirmationControlKey,
  TrdgDocMnlPOSplit AS TrdgContrMnlPOSplit,
  UnderlyingPurchaseOrderItem
FROM R_TrdgDoc AS TradingDocument
LEFT OUTER JOIN R_TrdgContrPartner AS _TradingContractPartner ON TradingContract = _TradingContractPartner.TradingContract  -- association [0..*]
LEFT OUTER JOIN R_TrdgContrSlsPrcgElmnt AS _TrdgContrSlsPrcgElmnt ON TradingContract = _TrdgContrSlsPrcgElmnt.TradingContract  -- association [0..*]
LEFT OUTER JOIN R_TrdgContrPurgPrcgElmnt AS _TrdgContrPurgPrcgElmnt ON TradingContract = _TrdgContrPurgPrcgElmnt.TradingContract  -- association [0..*]
LEFT OUTER JOIN R_TrdgContrItem AS _TradingContractItem ON TradingContract = _TradingContractItem.TradingContract  -- association [0..*]
LEFT OUTER JOIN I_TrdgContrType AS _TradingContractType ON TradingContractType = _TradingContractType.TradingContractType  -- association [0..1]
;