C_SalesDocumentWorkflowVH

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_SalesDocumentWorkflowVH.
-- 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.
-- SQL view name: CSLSDOCWFVH

CREATE VIEW C_SalesDocumentWorkflowVH AS
SELECT
  '' AS WorkflowFieldValueHelpValue,
  cast( ' ' as sd_apm_approval_reason preserving type ) AS SalesOrderApprovalReason,
  cast( ' ' as sd_apm_approval_reason preserving type ) AS CreditMemoReqApprovalReason,
  cast( ' ' as sd_apm_approval_reason preserving type ) AS CustomerReturnApprovalReason,
  cast( ' ' as sd_apm_approval_reason preserving type ) AS SalesContractApprovalReason,
  cast( ' ' as sd_sowoc_approval_reason preserving type ) AS SlsOrdWthoutChrgApprvlReason,
  cast( ' ' as sd_dmr_approval_reason preserving type ) AS DebitMemoReqApprovalReason,
  cast( ' ' as vdm_userid preserving type ) AS UserID,
  cast( ' ' as kunag preserving type ) AS SoldToParty,
  cast( ' ' as vkorg preserving type ) AS SalesOrganization,
  cast( ' ' as sales_order_type preserving type ) AS SalesOrderType,
  cast( ' ' as auart preserving type ) AS CreditMemoRequestType,
  cast( ' ' as vdm_customer_return_type preserving type ) AS CustomerReturnType,
  cast( ' ' as auart preserving type ) AS SalesContractType,
  cast( ' ' as auart preserving type ) AS SalesOrderWithoutChargeType,
  cast( ' ' as sd_debit_memo_req_type preserving type ) AS DebitMemoRequestType,
  cast( ' ' as vtweg preserving type ) AS DistributionChannel,
  cast( ' ' as spart preserving type ) AS OrganizationDivision,
  cast( ' ' as vkgrp preserving type ) AS SalesGroup,
  cast( ' ' as vkbur preserving type ) AS SalesOffice,
  cast( ' ' as kdgrp preserving type ) AS CustomerGroup,
  cast( ' ' as augru preserving type ) AS SDDocumentReason,
  cast(cast( ' ' as abap.cuky(5)) as waers preserving type ) AS Currency
FROM I_WorkflowFieldValueHelp AS Document
LEFT OUTER JOIN C_SlsDocWrkFlwRecipientVH AS _SlsDocWrkFlwRecipientVH ON UserID = _SlsDocWrkFlwRecipientVH.UserID  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderApprovalReason AS _SalesOrderApprovalReason ON SalesOrderApprovalReason = _SalesOrderApprovalReason.SalesOrderApprovalReason  -- association [0..1]
LEFT OUTER JOIN I_CreditMemoReqApprovalReason AS _CreditMemoReqApprovalReason ON CreditMemoReqApprovalReason = _CreditMemoReqApprovalReason.CreditMemoReqApprovalReason  -- association [0..1]
LEFT OUTER JOIN I_CustomerReturnApprovalReason AS _CustomerReturnApprovalReason ON CustomerReturnApprovalReason = _CustomerReturnApprovalReason.CustomerReturnApprovalReason  -- association [0..1]
LEFT OUTER JOIN I_SalesContractApprovalReason AS _SalesContractApprovalReason ON SalesContractApprovalReason = _SalesContractApprovalReason.SalesContractApprovalReason  -- association [0..1]
;