I_SalesOrderWithoutChargeItem

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_SalesOrderWithoutChargeItem.
-- 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_SalesOrderWithoutChargeItem AS
SELECT
  cast(SalesDocument as sales_order_without_charge preserving type) AS SalesOrderWithoutCharge,
  cast(SalesDocumentItem as sales_order_without_charge_itm preserving type) AS SalesOrderWithoutChargeItem,
  SalesDocumentItemCategory AS SlsOrdWthoutChrgItemCategory,
  SalesDocumentItemType AS SalesOrderWthoutChrgItemType,
  IsReturnsItem,
  CompletionRule,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  Division,
  Material,
  Product,
  OriginallyRequestedMaterial,
  MaterialByCustomer,
  InternationalArticleNumber,
  Batch,
  ProductHierarchyNode,
  ProductCatalog,
  MaterialSubstitutionReason,
  MaterialGroup,
  ProductGroup,
  MaterialPricingGroup,
  AdditionalMaterialGroup1,
  AdditionalMaterialGroup2,
  AdditionalMaterialGroup3,
  AdditionalMaterialGroup4,
  AdditionalMaterialGroup5,
  Plant,
  StorageLocation,
  DeliveryGroup,
  ProductConfiguration,
  MRPArea,
  BillOfMaterial,
  BOMExplosionDate,
  ProdAvailabilityCheckGroup,
  SalesDocumentItemText AS SalesOrderWthoutChrgItemText,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate,
  UnderlyingPurchaseOrderItem,
  OrderQuantity,
  ConfdDelivQtyInOrderQtyUnit,
  TargetDelivQtyInOrderQtyUnit,
  OrderQuantityUnit,
  ConfdDeliveryQtyInBaseUnit,
  BaseUnit,
  CommittedDelivQtyInOrdQtyUnit,
  CommittedDelivCreationDate,
  CommittedDeliveryDate,
  OrderToBaseQuantityDnmntr,
  OrderToBaseQuantityNmrtr,
  TargetQuantity,
  TargetQuantityUnit,
  TargetToBaseQuantityDnmntr,
  TargetToBaseQuantityNmrtr,
  RequestedQuantity,
  RequestedQuantityUnit,
  RequestedQuantityInBaseUnit,
  ItemGrossWeight,
  ItemNetWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  ServicesRenderedDate,
  SalesDistrict,
  SalesDeal,
  SalesPromotion,
  RetailPromotion,
  CustomerGroup,
  SalesDocumentRjcnReason,
  ItemOrderProbabilityInPercent,
  SalesDocItemSupplyBlockReason,
  NetAmount,
  TransactionCurrency,
  PricingDate,
  ExchangeRateDate,
  PriceDetnExchangeRate,
  NetPriceAmount,
  NetPriceQuantity,
  NetPriceQuantityUnit,
  StatisticalValueControl,
  TaxAmount,
  CostAmount,
  Subtotal1Amount,
  Subtotal2Amount,
  Subtotal3Amount,
  Subtotal4Amount,
  Subtotal5Amount,
  Subtotal6Amount,
  SalesDocumentCondition AS SalesOrderWthoutChrgCondition,
  CustomerPriceGroup,
  ShippingPoint,
  ShippingType,
  InventorySpecialStockType,
  DeliveryPriority,
  Route,
  DeliveryDateQuantityIsFixed,
  DeliveryDateTypeRule,
  PartialDeliveryIsAllowed,
  MaxNmbrOfPartialDelivery,
  UnlimitedOverdeliveryIsAllowed,
  OverdelivTolrtdLmtRatioInPct,
  UnderdelivTolrtdLmtRatioInPct,
  MinDeliveryQtyInBaseUnit,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  SalesDocumentItem.OrderCombinationIsAllowed AS OrderCombinationIsAllowed,
  OpenDeliveryLeadingUnitCode,
  ItemIsDeliveryRelevant,
  BillingDocumentDate,
  ItemIsBillingRelevant,
  ItemBillingBlockReason,
  BillingPlan,
  CustomerPaymentTerms,
  PaymentMethod,
  FixedValueDate,
  AdditionalValueDays,
  FiscalYear,
  FiscalPeriod,
  CustomerAccountAssignmentGroup,
  BusinessArea,
  ControllingArea,
  ProfitCenter,
  WBSElement,
  WBSElementInternalID,
  OrderID,
  ControllingObject,
  ProfitabilitySegment,
  ProfitabilitySegment_2,
  OriginSDDocument,
  OriginSDDocumentItem,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  ReferenceSDDocumentCategory,
  HigherLevelItem,
  SDProcessStatus,
  DeliveryConfirmationStatus,
  PurchaseConfirmationStatus,
  TotalDeliveryStatus,
  DeliveryStatus,
  DeliveryBlockStatus,
  SlsDocItmOvrlSupplyBlockStatus,
  OrderRelatedBillingStatus,
  BillingBlockStatus,
  ItemGeneralIncompletionStatus,
  ItemBillingIncompletionStatus,
  PricingIncompletionStatus,
  ItemDeliveryIncompletionStatus,
  SDDocumentRejectionStatus,
  TotalSDDocReferenceStatus,
  ChmlCmplncStatus,
  DangerousGoodsStatus,
  SafetyDataSheetStatus,
  TrdCmplncEmbargoSts,
  TrdCmplncSnctndListChkSts,
  OvrlTrdCmplncLegalCtrlChkSts,
  cast( SalesDocumentType as sd_slsord_without_charge_type preserving type ) AS SalesOrderWithoutChargeType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesOffice,
  SalesGroup,
  SoldToParty,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  SalesDocumentDate AS SalesOrderWithoutChargeDate,
  SDDocumentReason,
  RequestedDeliveryDate,
  ShippingCondition,
  ShipToParty,
  PayerParty,
  BillToParty,
  SalesEmployee,
  ResponsibleEmployee,
  SalesEmployeeWorkAgreement,
  ResponsibleEmployeeWorkAgrmt
FROM I_SalesDocumentItem AS SalesDocumentItem
LEFT OUTER JOIN I_SalesOrderWithoutChargeType AS _SalesOrderWithoutChargeType ON SalesOrderWithoutChargeType = _SalesOrderWithoutChargeType.SalesOrderWithoutChargeType  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderWithoutCharge AS _SalesOrderWithoutCharge ON SalesOrderWithoutCharge = _SalesOrderWithoutCharge.SalesOrderWithoutCharge  -- association [1..1]
LEFT OUTER JOIN I_SlsOrdWthoutChrgSchedLine AS _ScheduleLine ON SalesOrderWithoutCharge = _ScheduleLine.SalesOrderWithoutCharge AND SalesOrderWithoutChargeItem = _ScheduleLine.SalesOrderWithoutChargeItem  -- association [0..*]
LEFT OUTER JOIN I_SlsOrdWthoutChrgItmPartner AS _Partner ON SalesOrderWithoutCharge = _Partner.SalesOrderWithoutCharge AND SalesOrderWithoutChargeItem = _Partner.SalesOrderWithoutChargeItem  -- association [0..*]
LEFT OUTER JOIN I_SlsOrdWthoutChrgItmPrcgElmnt AS _PricingElement ON SalesOrderWithoutCharge = _PricingElement.SalesOrderWithoutCharge AND SalesOrderWithoutChargeItem = _PricingElement.SalesOrderWithoutChargeItem  -- association [0..*]
LEFT OUTER JOIN I_SalesOrderWithoutChargeItem AS _HigherLevelItem ON SalesOrderWithoutCharge = _HigherLevelItem.SalesOrderWithoutCharge AND HigherLevelItem = _HigherLevelItem.SalesOrderWithoutChargeItem  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON SalesOrderWithoutCharge = _Extension.SalesDocument AND SalesOrderWithoutChargeItem = _Extension.SalesDocumentItem  -- association [0..1]
;