I_SalesOrderWithoutCharge

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_SalesOrderWithoutCharge.
-- 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_SalesOrderWithoutCharge AS
SELECT
  cast(SalesDocument as sales_order_without_charge preserving type) AS SalesOrderWithoutCharge,
  SalesDocumentType AS SalesOrderWithoutChargeType,
  SalesDocumentProcessingType AS SalesOrderWthoutChrgProcgType,
  CreatedByUser,
  LastChangedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  cast(LastChangeDateTime as vdm_lastchangedon) AS LastChangeDateTime,
  LastCustomerContactDate,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesGroup,
  SalesOffice,
  SoldToParty,
  CustomerGroup,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  CreditControlArea,
  CustomerRebateAgreement,
  SalesDocumentDate AS SalesOrderWithoutChargeDate,
  ServicesRenderedDate,
  SDDocumentReason,
  PurchaseOrderByCustomer,
  SDDocumentCollectiveNumber,
  CustomerPurchaseOrderType,
  CustomerPurchaseOrderDate,
  CustomerPurchaseOrderSuplmnt,
  SalesDistrict,
  ProductCatalog,
  SchedulingAgreementProfileCode,
  cast(AgrmtValdtyStartDate as sd_sowoc_valid_from) AS AgrmtValdtyStartDate,
  cast(AgrmtValdtyEndDate as sd_sowoc_valid_to) AS AgrmtValdtyEndDate,
  TotalNetAmount,
  TransactionCurrency,
  StatisticsCurrency,
  PricingDate,
  RetailPromotion,
  SalesDocumentCondition AS SalesOrderWthoutChrgCondition,
  RequestedDeliveryDate,
  ShippingType,
  ShippingCondition,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  IncotermsVersion,
  CompleteDeliveryIsDefined,
  DeliveryBlockReason,
  DeliveryDateTypeRule,
  cast(SalesDocApprovalReason as sd_sowoc_approval_reason) AS SlsOrdWthoutChrgApprvlReason,
  BillingCompanyCode,
  HeaderBillingBlockReason,
  CustomerPaymentTerms,
  PaymentMethod,
  FixedValueDate,
  AdditionalValueDays,
  FiscalYear,
  FiscalPeriod,
  ExchangeRateDate,
  ExchangeRateType,
  BusinessArea,
  CustomerAccountAssignmentGroup,
  CostCenterBusinessArea,
  CostCenter,
  ControllingArea,
  OrderID,
  ControllingObject,
  ReferenceSDDocument,
  AccountingDocExternalReference,
  ReferenceSDDocumentCategory,
  CorrespncExternalReference,
  OverallSDProcessStatus,
  OverallPurchaseConfStatus,
  OverallSDDocumentRejectionSts,
  TotalBlockStatus,
  OverallDelivConfStatus,
  OverallTotalDeliveryStatus,
  OverallDeliveryStatus,
  OverallDeliveryBlockStatus,
  OverallOrdReltdBillgStatus,
  OverallBillingBlockStatus,
  OverallTotalSDDocRefStatus,
  OverallSDDocReferenceStatus,
  TotalCreditCheckStatus,
  MaxDocValueCreditCheckStatus,
  PaymentTermCreditCheckStatus,
  FinDocCreditCheckStatus,
  ExprtInsurCreditCheckStatus,
  PaytAuthsnCreditCheckSts,
  CentralCreditCheckStatus,
  CentralCreditChkTechErrSts,
  HdrGeneralIncompletionStatus,
  OverallPricingIncompletionSts,
  HeaderDelivIncompletionStatus,
  HeaderBillgIncompletionStatus,
  OvrlItmGeneralIncompletionSts,
  OvrlItmBillingIncompletionSts,
  OvrlItmDelivIncompletionSts,
  OverallChmlCmplncStatus,
  OverallDangerousGoodsStatus,
  OverallSafetyDataSheetStatus,
  SalesDocApprovalStatus,
  OverallTrdCmplncEmbargoSts,
  OvrlTrdCmplncSnctndListChkSts,
  OvrlTrdCmplncLegalCtrlChkSts
FROM I_SalesDocument AS SalesDocument
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_BusinessAreaText AS _CostCenterBusinessAreaText ON CostCenterBusinessArea = _CostCenterBusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_CreditControlAreaText AS _CreditControlAreaText ON CreditControlArea = _CreditControlAreaText.CreditControlArea  -- association [0..*]
LEFT OUTER JOIN I_SalesOrderWithoutChargeItem AS _Item ON SalesOrderWithoutCharge = _Item.SalesOrderWithoutCharge  -- association [0..*]
LEFT OUTER JOIN I_SalesOrderWithoutChargeType AS _SalesOrderWithoutChargeType ON SalesOrderWithoutChargeType = _SalesOrderWithoutChargeType.SalesOrderWithoutChargeType  -- association [0..1]
LEFT OUTER JOIN I_SlsOrdWthoutChrgPartner AS _Partner ON SalesOrderWithoutCharge = _Partner.SalesOrderWithoutCharge  -- association [1..*]
LEFT OUTER JOIN I_SlsOrdWthoutChrgApprvlReason AS _SlsOrdWthoutChrgApprvlReason ON SlsOrdWthoutChrgApprvlReason = _SlsOrdWthoutChrgApprvlReason.SlsOrdWthoutChrgApprvlReason  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesOrderWithoutCharge = _Extension.SalesDocument  -- association [0..1]
;