I_SalesOrderItemImport

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_SalesOrderItemImport.
-- 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_SalesOrderItemImport AS
SELECT
  SalesOrder,
  SalesOrderItem,
  SalesOrderItemCategory,
  SalesOrderItemType,
  IsReturnsItem,
  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,
  BOMExplosionDate,
  SalesOrderItemText,
  PurchaseOrderByCustomer,
  PurchaseOrderByShipToParty,
  UnderlyingPurchaseOrderItem,
  ExternalItemID,
  OrderQuantity,
  OrderQuantityUnit,
  OrderToBaseQuantityDnmntr,
  OrderToBaseQuantityNmrtr,
  TargetQuantity,
  TargetQuantityUnit,
  TargetToBaseQuantityDnmntr,
  TargetToBaseQuantityNmrtr,
  ConfdDelivQtyInOrderQtyUnit,
  TargetDelivQtyInOrderQtyUnit,
  ConfdDeliveryQtyInBaseUnit,
  BaseUnit,
  CommittedDelivQtyInOrdQtyUnit,
  CommittedDelivCreationDate,
  CommittedDeliveryDate,
  RequestedQuantity,
  RequestedQuantityUnit,
  RequestedQuantityInBaseUnit,
  ItemGrossWeight,
  ItemNetWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  ServicesRenderedDate,
  SalesDistrict,
  SalesDeal,
  SalesPromotion,
  RetailPromotion,
  CustomerGroup,
  SalesDocumentRjcnReason,
  RequirementSegment,
  SlsDocIsRlvtForProofOfDeliv,
  NetAmount,
  TransactionCurrency,
  PricingDate,
  PricingReferenceMaterial,
  ExchangeRateDate,
  PriceDetnExchangeRate,
  NetPriceAmount,
  NetPriceQuantity,
  NetPriceQuantityUnit,
  StatisticalValueControl,
  SalesDocumentItemProcgCode,
  TaxAmount,
  ProductTaxClassification1,
  ProductTaxClassification2,
  ProductTaxClassification3,
  ProductTaxClassification4,
  ProductTaxClassification5,
  ProductTaxClassification6,
  ProductTaxClassification7,
  ProductTaxClassification8,
  ProductTaxClassification9,
  MatlAccountAssignmentGroup,
  CostAmount,
  Subtotal1Amount,
  Subtotal2Amount,
  Subtotal3Amount,
  Subtotal4Amount,
  Subtotal5Amount,
  Subtotal6Amount,
  SalesOrderCondition,
  CustomerPriceGroup,
  ShippingPoint,
  ShippingType,
  InventorySpecialStockType,
  DeliveryPriority,
  Route,
  DeliveryDateQuantityIsFixed,
  DeliveryDateTypeRule,
  PartialDeliveryIsAllowed,
  MaxNmbrOfPartialDelivery,
  UnlimitedOverdeliveryIsAllowed,
  OverdelivTolrtdLmtRatioInPct,
  UnderdelivTolrtdLmtRatioInPct,
  MinDeliveryQtyInBaseUnit,
  OpenDeliveryLeadingUnitCode,
  ItemIsDeliveryRelevant,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  CustomerPaymentTerms,
  PaymentMethod,
  FixedValueDate,
  AdditionalValueDays,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  FashionCancelDate,
  ProductCharacteristic1,
  ProductCharacteristic2,
  ProductCharacteristic3,
  ShippingGroupNumber,
  ShippingGroupRule,
  BillingDocumentDate,
  ItemIsBillingRelevant,
  ItemBillingBlockReason,
  BillingPlan,
  FiscalYear,
  FiscalPeriod,
  CustomerAccountAssignmentGroup,
  BusinessArea,
  ControllingArea,
  ProfitCenter,
  WBSElement,
  WBSElementInternalID,
  _WBSElementExternalID.WBSElementExternalID AS WBSElementExternalID,
  OrderID,
  ControllingObject,
  ProfitabilitySegment,
  ProfitabilitySegment_2,
  OriginSDDocument,
  OriginSDDocumentItem,
  AccountingExchangeRate,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  ReferenceSDDocumentCategory,
  HigherLevelItem,
  HigherLevelItemUsage,
  SDProcessStatus,
  DeliveryConfirmationStatus,
  PurchaseConfirmationStatus,
  TotalDeliveryStatus,
  DeliveryStatus,
  DeliveryBlockStatus,
  OrderRelatedBillingStatus,
  BillingBlockStatus,
  ItemGeneralIncompletionStatus,
  ItemBillingIncompletionStatus,
  PricingIncompletionStatus,
  ItemDeliveryIncompletionStatus,
  SDDocReferenceStatus,
  SDDocumentRejectionStatus,
  TotalSDDocReferenceStatus,
  ChmlCmplncStatus,
  DangerousGoodsStatus,
  SafetyDataSheetStatus,
  SlsOrderItemDownPaymentStatus,
  CappedNetAmount,
  CappedNetAmtAlertThldInPct,
  TotalStandAloneSellingPrice
FROM I_SalesOrderItem AS SalesOrderItem
LEFT OUTER JOIN I_SalesOrderImport AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [1..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementInternalID = _WBSElementExternalID.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON SalesOrderItem.SalesOrder = _Extension.SalesDocument AND SalesOrderItem.SalesOrderItem = _Extension.SalesDocumentItem  -- association [0..1]
;