C_ServiceOrderAdvanceShipment

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 C_ServiceOrderAdvanceShipment.
-- 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 C_ServiceOrderAdvanceShipment AS
SELECT
  ServiceDocument AS ServiceOrder,
  Material,
  Plant,
  _Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  _Plant.PlantName AS PlantName,
  SalesOrganization,
  _SalesOrganization._Text[1: Language=$session.system_language].SalesOrganizationName AS SalesOrganizationName,
  ServiceOrganization,
  _ServiceOrganizationOrgUnit._Text[1: Language=$session.system_language].OrganizationalUnitName AS ServiceOrganizationName,
  _SrvcOrdAdvncShptSalesOrder.OrderQuantityUnit AS OrderQuantityUnit,
  _SrvcOrdAdvncShptSalesOrder.OrderedQuantity AS OrderedQuantity,
  _SrvcOrdAdvanceShippedStock.DeliveredQuantityUnit AS DeliveredQuantityUnit,
  _SrvcOrdAdvanceShippedStock.DeliveredQuantity AS DeliveredQuantity,
  _SrvcOrdAdvncShpdStkConsumed.AdvncShpdConsumedQuantityUnit AS AdvncShpdConsumedQuantityUnit,
  cast(_SrvcOrdAdvncShpdStkConsumed.AdvanceShippedConsumedQuantity as abap.quan( 13,0 )) AS AdvanceShippedConsumedQuantity,
  _SrvcOrdAdvanceShippedStock.DeliveredQuantityUnit AS OpenAdvncShippedQuantityUnit,
  ServiceDocumentDescription,
  Customer AS SoldToParty,
  _SoldToParty.BusinessPartnerName AS SoldToPartyName,
  ServiceDocumentType,
  _ServiceDocumentType._ServiceDocumentTypeText[1: Language=$session.system_language].ServiceDocumentTypeName AS ServiceDocumentTypeName,
  ServiceDocumentStatus AS ServiceOrderStatus,
  _SrvcDocLifecycleStatus._ServiceDocumentStatusText[1: Language=$session.system_language].ServiceDocumentStatusName AS ServiceDocumentStatusName,
  ServiceDocCreationDateTime,
  RespEmployeeBusinessPartnerId,
  SalesOffice,
  SalesGroup,
  Division,
  DistributionChannel,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceObjectType
FROM R_SrvcOrdAdvanceShippedStock AS _SrvcOrdAdvanceShippedStock
LEFT OUTER JOIN R_SrvcOrdAdvncShpdStkConsumed AS _SrvcOrdAdvncShpdStkConsumed ON ServiceOrder = _SrvcOrdAdvncShpdStkConsumed.ServiceDocument AND _SrvcOrdAdvanceShippedStock.Material = _SrvcOrdAdvncShpdStkConsumed.Material AND _SrvcOrdAdvanceShippedStock.Plant = _SrvcOrdAdvncShpdStkConsumed.Plant  -- association [0..1]
LEFT OUTER JOIN R_SrvcOrdAdvncShptSalesOrder AS _SrvcOrdAdvncShptSalesOrder ON ServiceOrder = _SrvcOrdAdvncShptSalesOrder.ServiceDocument AND _SrvcOrdAdvanceShippedStock.Material = _SrvcOrdAdvncShptSalesOrder.Material AND _SrvcOrdAdvanceShippedStock.Plant = _SrvcOrdAdvncShptSalesOrder.Plant  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocLifecycleStatus AS _SrvcDocLifecycleStatus ON ServiceOrderStatus = _SrvcDocLifecycleStatus.ServiceDocumentStatus  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _SoldToParty ON SoldToParty = _SoldToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceDocumentType ON ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType  -- association [1..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtOrganizationUnit AS _ServiceOrganizationOrgUnit ON ServiceOrganization = _ServiceOrganizationOrgUnit.OrgUnitTypeIDConcatenated  -- association [0..1]
LEFT OUTER JOIN C_SrvcMgmtSoldToPartyQuickVw AS _SrvcMgmtSoldToPartyQuickVw ON SoldToParty = _SrvcMgmtSoldToPartyQuickVw.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
;