A_BusSolnOrdItemSimulation

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_BusSolnOrdItemSimulation.
-- 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_BusSolnOrdItemSimulation AS
SELECT
  ServiceDocument AS BusinessSolutionOrder,
  ServiceDocumentItem AS BusinessSolutionOrderItem,
  _ParentServiceDocItem_2.ServiceDocumentItem AS ParentBusSolnOrdItem,
  Product,
  SrvcDocItemCumulatedNetAmount,
  ServiceDocumentItemObjectType,
  ServiceDocItemCategory AS BusSolnOrdItmCategory,
  ServiceDocumentItemDescription AS BusSolnOrdItmDescription,
  ServiceDocumentItemCharUUID,
  ServiceContrItemStartDateTime,
  ServiceContrItemEndDateTime,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  ServiceDocumentItemQuantity AS Quantity,
  ServiceDocItemQuantityUnit AS QuantityUnit,
  _QuantityUnit.UnitOfMeasureSAPCode AS BusSolnOrdItmQtyUnitSAPCode,
  _QuantityUnit.UnitOfMeasureISOCode AS BusSolnOrdItmQtyUnitISOCode,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ContactPerson AS ContactPersonBusinessPartnerId,
  ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  TransactionCurrency,
  ServiceDocumentItemNetAmount,
  ItemGrossWeight,
  ItemNetWeight,
  ItemVolume,
  ItemVolumeUnit,
  _VolumeUnit.UnitOfMeasureSAPCode AS UnitOfMeasureSAPCode,
  _VolumeUnit.UnitOfMeasureISOCode AS UnitOfMeasureISOCode,
  ItemWeightUnit,
  Plant,
  cast( ConfigurationNumber as cuobj preserving type ) AS ConfigurationNumber,
  _ReferenceSrvcContract._ServiceDocItm.ServiceDocument AS ReferenceServiceContract,
  _ReferenceSrvcContract._ServiceDocItm.ServiceDocumentItem AS ReferenceServiceContractItem,
  _BillPlanDateRule.CustMgmtDateRuleName AS SrvcMgmtBillgPlanBillgDateRule,
  SettlementPeriodRuleUUID,
  _SettlementPeriodRule.CustMgmtDateRuleName AS SettlementPeriodRule,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  PaymentTerms,
  ServiceDocumentType AS BusSolnOrdType,
  ServiceObjectType,
  ServiceDocumentItemUUID AS BusinessSolutionOrderItemUUID
FROM I_ServiceDocumentItemEnhcd
LEFT OUTER JOIN I_UnitOfMeasure AS _QuantityUnit ON QuantityUnit = _QuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtObjectStatus AS _ServiceContractDetn ON BusinessSolutionOrderItemUUID = _ServiceContractDetn.SrvcMgmtObjectUUID AND _ServiceContractDetn.SrvcMgmtObjectStatus = 'I0994' AND _ServiceContractDetn.SrvcMgmtObjectStatusIsInactive = ''  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentItemPrdcssr_3 AS _ReferenceSrvcContract ON ServiceDocumentItemCharUUID = _ReferenceSrvcContract.ServiceDocumentItemCharUUID AND _ReferenceSrvcContract.ServiceDocItmPrdcssrBusObjType = 'BUS2000137'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtDateRule AS _SettlementPeriodRule ON SettlementPeriodRuleUUID = _SettlementPeriodRule.CustMgmtDateRuleUUID  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocumentItem AS _Extension ON _Extension.ServiceCategory = 'BUS2000172' AND BusinessSolutionOrder = _Extension.ServiceOrderItem AND BusinessSolutionOrderItem = _Extension.ServiceLineExternalID  -- association [0..1]
LEFT OUTER JOIN A_VarCnfContextSimulation AS _VariantConfiguration ON VarConfigurationBusObjectType = _VariantConfiguration.VarConfigurationBusObjectType AND VarConfigurationBusObjectKey = _VariantConfiguration.VarConfigurationBusObjectKey  -- association [0..1]
LEFT OUTER JOIN A_BusSolnOrdItmPriceElmntSimln AS _PriceElement ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_BSOrdItmPrcElementEnhcdSimln AS _PriceElementEnhcd ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_BusSolOrdItmBlgReqItmSimln AS _BillingRequestItem ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_BusSolnOrdItemPartnerSimln AS _Partner ON /* condition not available in parsed metadata */  -- association [0..*]
;