C_SalesQuotationWorkFlowVH

DDL: C_SALESQUOTATIONWORKFLOWVH SQL: CQUOTWFVH Type: view CONSUMPTION Package: ODATA_SD_QUOTATIONWRF

Sales Quotation Workflow Value Help

C_SalesQuotationWorkFlowVH is a Consumption CDS View that provides data about "Sales Quotation Workflow Value Help" in SAP S/4HANA. It reads from 1 data source (I_WorkflowFieldValueHelp) and exposes 14 fields with key field SalesQuotationWorkFlow. It has 1 association to related views. It is exposed through 1 OData service (ASQL_F3014). Part of development package ODATA_SD_QUOTATIONWRF.

Data Sources (1)

SourceAliasJoin Type
I_WorkflowFieldValueHelp Document from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_SlsDocWrkFlwRecipientVH _UserIDVH $projection.UserID = _UserIDVH.UserID

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CQUOTWFVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.createEnabled true view
OData.publish true view
EndUserText.label Sales Quotation Workflow Value Help view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F3014 ASQL_F3014 C2 NOT_RELEASED

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SalesQuotationWorkFlow
SalesQuotationApprovalReason
UserID
SoldToParty
SalesOrganization
SalesDocumentType
DistributionChannel
OrganizationDivision
SalesGroup
SalesOffice
CustomerGroup
SDDocumentReason
Currency
_UserIDVH _UserIDVH

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_SalesQuotationWorkFlowVH.
-- 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: CQUOTWFVH

CREATE VIEW C_SalesQuotationWorkFlowVH AS
SELECT
  '' AS SalesQuotationWorkFlow,
  cast( ' ' as sd_apm_approval_reason preserving type ) AS SalesQuotationApprovalReason,
  cast( ' ' as vdm_userid preserving type ) AS UserID,
  cast( ' ' as kunag preserving type ) AS SoldToParty,
  cast( ' ' as vkorg preserving type ) AS SalesOrganization,
  cast( ' ' as auart preserving type ) AS SalesDocumentType,
  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 _UserIDVH ON UserID = _UserIDVH.UserID  -- association [0..1]
;