I_Order2CashSalesOrder

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_Order2CashSalesOrder.
-- 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_Order2CashSalesOrder AS
SELECT
  cast(SalesDocument as vdm_sales_order preserving type) AS SalesOrder,
  cast( SalesDocumentType as sales_order_type preserving type ) AS SalesOrderType,
  SalesDocumentProcessingType AS SalesOrderProcessingType,
  CreatedByUser,
  LastChangedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  LastChangeDateTime,
  SenderBusinessSystemName,
  ExternalDocumentID,
  ExternalDocLastChangeDateTime,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesGroup,
  SalesOffice,
  CustomerGroup,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  SlsDocIsRlvtForProofOfDeliv,
  CreditControlArea,
  CustomerRebateAgreement,
  SalesDocumentDate AS SalesOrderDate,
  ServicesRenderedDate,
  SDDocumentReason,
  PurchaseOrderByCustomer,
  SDDocumentCollectiveNumber,
  CustomerPurchaseOrderType,
  CustomerPurchaseOrderDate,
  CustomerPurchaseOrderSuplmnt,
  SalesDistrict,
  StatisticsCurrency,
  ProductCatalog,
  NextCreditCheckDate,
  LastCustomerContactDate,
  TotalNetAmount,
  TransactionCurrency,
  PricingDate,
  PriceDetnExchangeRate,
  RetailPromotion,
  SalesDocumentCondition AS SalesOrderCondition,
  SDPricingProcedure,
  CustomerPriceGroup,
  PriceListType,
  CustomerTaxClassification1,
  CustomerTaxClassification2,
  CustomerTaxClassification3,
  CustomerTaxClassification4,
  CustomerTaxClassification5,
  CustomerTaxClassification6,
  CustomerTaxClassification7,
  CustomerTaxClassification8,
  CustomerTaxClassification9,
  TaxDepartureCountry,
  VATRegistrationCountry,
  RequestedDeliveryDate,
  DeliveryDateTypeRule,
  ShippingType,
  ShippingCondition,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  IncotermsVersion,
  CompleteDeliveryIsDefined,
  DeliveryBlockReason,
  FashionCancelDate,
  BillingDocumentDate,
  BillingCompanyCode,
  HeaderBillingBlockReason,
  CustomerPaymentTerms,
  PaymentMethod,
  FixedValueDate,
  FiscalYear,
  FiscalPeriod,
  ExchangeRateDate,
  ExchangeRateType,
  BusinessArea,
  CustomerAccountAssignmentGroup,
  CostCenter,
  ControllingArea,
  OrderID,
  ControllingObject,
  AssignmentReference,
  PaymentPlan,
  ContractAccount,
  AdditionalValueDays,
  CustomerCreditAccount,
  ReferenceSDDocument,
  ReferenceSDDocumentCategory,
  CorrespncExternalReference,
  AccountingDocExternalReference,
  BusinessSolutionOrder,
  OverallSDProcessStatus,
  OverallPurchaseConfStatus,
  OverallSDDocumentRejectionSts,
  TotalBlockStatus,
  OverallDelivConfStatus,
  OverallTotalDeliveryStatus,
  OverallDeliveryStatus,
  OverallDeliveryBlockStatus,
  OverallOrdReltdBillgStatus,
  OverallBillingBlockStatus,
  OverallTotalSDDocRefStatus,
  OverallSDDocReferenceStatus,
  TotalCreditCheckStatus,
  MaxDocValueCreditCheckStatus,
  FinDocCreditCheckStatus,
  ExprtInsurCreditCheckStatus,
  PaytAuthsnCreditCheckSts,
  CentralCreditCheckStatus,
  CentralCreditChkTechErrSts,
  HdrGeneralIncompletionStatus,
  OverallPricingIncompletionSts,
  HeaderDelivIncompletionStatus,
  HeaderBillgIncompletionStatus,
  OvrlItmGeneralIncompletionSts,
  OvrlItmBillingIncompletionSts,
  OvrlItmDelivIncompletionSts,
  OverallChmlCmplncStatus,
  OverallDangerousGoodsStatus,
  OverallSafetyDataSheetStatus,
  SalesDocApprovalStatus,
  OverallTrdCmplncEmbargoSts,
  OvrlTrdCmplncSnctndListChkSts,
  OvrlTrdCmplncLegalCtrlChkSts,
  ContractDownPaymentStatus AS SalesOrderDownPaymentStatus,
  OmniChnlSalesPromotionStatus,
  AlternativePricingDate
FROM I_SalesDocument AS SalesDocument
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_CreditControlAreaText AS _CreditControlAreaText ON CreditControlArea = _CreditControlAreaText.CreditControlArea  -- association [0..*]
LEFT OUTER JOIN I_SalesOrderType AS _SalesOrderType ON SalesOrderType = _SalesOrderType.SalesOrderType  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderPricingElement AS _PricingElement ON SalesOrder = _PricingElement.SalesOrder  -- association [0..*]
LEFT OUTER JOIN I_Order2CashSalesOrderItem AS _Salesorderitemfs ON SalesOrder = SalesDocument.SalesDocument  -- association [0..*]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesDocument.SalesDocument = _Extension.SalesDocument  -- association [0..1]
;