A_SalesOrderItemSimulation

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 A_SalesOrderItemSimulation.
-- 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 A_SalesOrderItemSimulation AS
SELECT
  SalesOrder,
  SalesOrderItem,
  HigherLevelItem,
  HigherLevelItemUsage,
  SalesOrderItemCategory,
  SalesOrderItemText,
  PurchaseOrderByCustomer,
  Material,
  OriginallyRequestedMaterial,
  MaterialByCustomer,
  PricingDate,
  PricingReferenceMaterial,
  RequestedQuantity,
  RequestedQuantityUnit,
  cast(_RequestedQuantityUnit.UnitOfMeasureSAPCode as sd_reqd_qty_sapunit preserving type) AS RequestedQuantitySAPUnit,
  cast(_RequestedQuantityUnit.UnitOfMeasureISOCode as sd_reqd_qty_isounit preserving type) AS RequestedQuantityISOUnit,
  OrderQuantityUnit,
  cast(_OrderQuantityUnit.UnitOfMeasureSAPCode as sd_ord_qty_sapunit preserving type) AS OrderQuantitySAPUnit,
  cast(_OrderQuantityUnit.UnitOfMeasureISOCode as sd_ord_qty_isounit preserving type) AS OrderQuantityISOUnit,
  ConfdDelivQtyInOrderQtyUnit,
  ItemGrossWeight,
  ItemNetWeight,
  ItemWeightUnit,
  cast(_ItemWeightUnit.UnitOfMeasureSAPCode as sd_itm_wgt_sapunit preserving type) AS ItemWeightSAPUnit,
  cast(_ItemWeightUnit.UnitOfMeasureISOCode as sd_itm_wgt_isounit preserving type) AS ItemWeightISOUnit,
  ItemVolume,
  ItemVolumeUnit,
  cast(_ItemVolumeUnit.UnitOfMeasureSAPCode as sd_itm_vol_sapunit preserving type) AS ItemVolumeSAPUnit,
  cast(_ItemVolumeUnit.UnitOfMeasureISOCode as sd_itm_vol_isounit preserving type) AS ItemVolumeISOUnit,
  TransactionCurrency,
  NetAmount,
  TaxAmount,
  CostAmount,
  Subtotal1Amount,
  Subtotal2Amount,
  Subtotal3Amount,
  Subtotal4Amount,
  Subtotal5Amount,
  Subtotal6Amount,
  MaterialSubstitutionReason,
  MaterialGroup,
  MaterialPricingGroup,
  Batch,
  Plant,
  StorageLocation,
  DeliveryGroup,
  ShippingPoint,
  ShippingType,
  DeliveryPriority,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  ProductTaxClassification1,
  ProductTaxClassification2,
  ProductTaxClassification3,
  ProductTaxClassification4,
  ProductTaxClassification5,
  ProductTaxClassification6,
  ProductTaxClassification7,
  ProductTaxClassification8,
  ProductTaxClassification9,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  CustomerPaymentTerms,
  SalesDocumentRjcnReason,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  SeasonCompletenessStatus,
  FashionCancelDate,
  RequirementSegment,
  _SalesDocument.SalesDocumentType AS SalesOrderType,
  _SalesDocument.OrganizationDivision AS OrganizationDivision,
  _SalesDocument.SalesOrganization AS SalesOrganization,
  _SalesDocument.DistributionChannel AS DistributionChannel
FROM I_SalesOrderItem AS SalesOrderItem
LEFT OUTER JOIN I_SalesDocumentBasic AS _SalesDocument ON _SalesDocument.SalesDocument = SalesOrder  -- association [1..1]
LEFT OUTER JOIN A_SalesOrderSimulation AS _SalesOrder ON _SalesOrder.SalesOrder = SalesOrder  -- association [1..1]
LEFT OUTER JOIN A_SalesOrderScheduleLineSimln AS _ScheduleLine ON _ScheduleLine.SalesOrder = SalesOrder AND _ScheduleLine.SalesOrderItem = SalesOrderItem  -- association [0..*]
LEFT OUTER JOIN A_SalesOrderItemPartnerSimln AS _Partner ON _Partner.SalesOrder = SalesOrder AND _Partner.SalesOrderItem = SalesOrderItem  -- association [0..*]
LEFT OUTER JOIN A_SalesOrderItmPrcgElmntSimln AS _PricingElement ON _PricingElement.SalesOrder = SalesOrder AND _PricingElement.SalesOrderItem = SalesOrderItem  -- association [0..*]
LEFT OUTER JOIN A_SlsOrdSimlnValAddedSrvc AS _ValueAddedService ON _ValueAddedService.SalesOrder = SalesOrder AND _ValueAddedService.SalesOrderItem = SalesOrderItem  -- association [0..*]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON SalesOrder = _Extension.SalesDocument AND SalesOrderItem = _Extension.SalesDocumentItem  -- association [0..1]
;