C_DspDocFlwServiceOrderVH

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_DspDocFlwServiceOrderVH.
-- 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_DspDocFlwServiceOrderVH AS
SELECT
  ServiceOrder.ServiceDocument AS ServiceOrder,
  ServiceOrder.ServiceDocumentType AS ServiceDocumentType,
  ServiceOrder._ServiceDocumentType. _ServiceDocumentTypeText[1:Language = $session.system_language].ServiceDocumentTypeName AS ServiceDocumentTypeName,
  ServiceOrder.SalesOrganization AS SalesOrganization,
  ServiceOrder.DistributionChannel AS DistributionChannel,
  ServiceOrder.Division AS Division,
  ServiceOrder.SalesOffice AS SalesOffice,
  ServiceOrder.SalesGroup AS SalesGroup,
  ServiceOrder.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  ServiceOrder.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  ServiceOrder.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  cast( ServiceOrder.ServiceDocument as fac_ddf_anchor_document ) AS AnchorDocument,
  cast( 'CSVO' as fis_awtyp ) AS ReferenceDocumentType,
  ServiceOrder._SalesOrganization AS _SalesOrganization,
  ServiceOrder._DistributionChannel AS _DistributionChannel,
  ServiceOrder._Division AS _Division,
  ServiceOrder._SalesOffice AS _SalesOffice,
  ServiceOrder._SalesGroup AS _SalesGroup,
  ServiceOrder._SalesOrganizationOrgUnit_2 AS _SalesOrganizationOrgUnit_2,
  ServiceOrder._SalesOfficeOrgUnit_2 AS _SalesOfficeOrgUnit_2,
  ServiceOrder._SalesGroupOrgUnit_2 AS _SalesGroupOrgUnit_2
FROM I_ServiceOrderStdVH AS ServiceOrder
;