I_SalesContractImport

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 I_SalesContractImport.
-- 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 I_SalesContractImport AS
SELECT
  SalesContract,
  SalesContractType,
  CreatedByUser,
  LastChangedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  LastChangeDateTime,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesGroup,
  SalesOffice,
  SoldToParty,
  CustomerGroup,
  SalesContractDate,
  SDDocumentReason,
  PurchaseOrderByCustomer,
  cast ( PurchaseOrderByShipToParty as sd_purchase_order_by_shipto preserving type ) AS PurchaseOrderByShipToParty,
  CustomerPurchaseOrderType,
  CustomerPurchaseOrderDate,
  CustomerPurchaseOrderSuplmnt,
  SalesDistrict,
  SalesContractValidityPerdCat,
  SalesContractValidityStartDate,
  SalesContractValidityEndDate,
  TotalNetAmount,
  TransactionCurrency,
  PricingDate,
  SDPricingProcedure,
  CustomerPriceGroup,
  ShippingCondition,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  IncotermsVersion,
  CompleteDeliveryIsDefined,
  BillingDocumentDate,
  BillingCompanyCode,
  FixedValueDate,
  TaxDepartureCountry,
  VATRegistrationCountry,
  CustomerAccountAssignmentGroup,
  AssignmentReference,
  ServicesRenderedDate,
  ShippingType,
  PriceListType,
  CustomerPaymentTerms,
  PaymentMethod,
  ControllingArea,
  ReferenceSDDocument,
  ReferenceSDDocumentCategory,
  AccountingDocExternalReference,
  OverallSDProcessStatus,
  OverallSDDocumentRejectionSts,
  TotalBlockStatus,
  OverallTotalSDDocRefStatus,
  OverallSDDocReferenceStatus,
  TotalCreditCheckStatus,
  MaxDocValueCreditCheckStatus,
  PaymentTermCreditCheckStatus,
  FinDocCreditCheckStatus,
  ExprtInsurCreditCheckStatus,
  PaytAuthsnCreditCheckSts,
  CentralCreditCheckStatus,
  CentralCreditChkTechErrSts,
  HdrGeneralIncompletionStatus,
  OverallPricingIncompletionSts,
  HeaderBillgIncompletionStatus,
  OvrlItmGeneralIncompletionSts,
  OvrlItmBillingIncompletionSts,
  ContractDownPaymentStatus,
  SalesDocApprovalStatus,
  SalesContractApprovalReason,
  ContractManualCompletion,
  OverallBillingBlockStatus,
  HeaderBillingBlockReason,
  OverallChmlCmplncStatus,
  OverallDangerousGoodsStatus,
  OverallSafetyDataSheetStatus,
  OverallTrdCmplncEmbargoSts,
  OvrlTrdCmplncSnctndListChkSts,
  OvrlTrdCmplncLegalCtrlChkSts,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5
FROM R_SalesContractTP AS SalesContract
LEFT OUTER JOIN I_SalesContractItemImport AS _Item ON SalesContract = _Item.SalesContract  -- association [0..*]
LEFT OUTER JOIN I_SalesContractPricingElement AS _PricingElement ON SalesContract = _PricingElement.SalesContract  -- association [0..*]
LEFT OUTER JOIN I_SalesContractPartner AS _Partner ON SalesContract = _Partner.SalesContract  -- association [0..*]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesContract.SalesContract = _Extension.SalesDocument  -- association [0..1]
;