C_DspDocFlwEmrkdFndsDocumentVH

DDL: C_DSPDOCFLWEMRKDFNDSDOCUMENTVH Type: view_entity CONSUMPTION Package: ODATA_GL_DSP_DOC_FLW

Earmarked Funds VH for DDF

C_DspDocFlwEmrkdFndsDocumentVH is a Consumption CDS View that provides data about "Earmarked Funds VH for DDF" in SAP S/4HANA. It reads from 1 data source (R_DspDocFlwEmrkdFundsDocument) and exposes 10 fields with key field EarmarkedFundsDocument. It is exposed through 1 OData service (ASQL_F3665). Part of development package ODATA_GL_DSP_DOC_FLW.

Data Sources (1)

SourceAliasJoin Type
R_DspDocFlwEmrkdFundsDocument R_DspDocFlwEmrkdFundsDocument from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Earmarked Funds VH for DDF view
Search.searchable true view
Consumption.ranked true view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F3665 ASQL_F3665 C2 NOT_RELEASED

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
EarmarkedFundsDocTypeText
CompanyCode CompanyCode Receiver Company Code
EarmarkedFundsDocumentCategory EarmarkedFundsDocumentCategory Document Category
PostingDate PostingDate Posting Date for GR
AnchorDocument Earmarked Funds
BusinessObjectType
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
EarmarkedFundsDocumentType EarmarkedFundsDocumentType Document Type
_CompanyCode _CompanyCode

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_DspDocFlwEmrkdFndsDocumentVH.
-- 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_DspDocFlwEmrkdFndsDocumentVH AS
SELECT
  EarmarkedFundsDocument,
  _EarmarkedFundsDocType._Text[1:Language = $session.system_language].EarmarkedFundsDocTypeText AS EarmarkedFundsDocTypeText,
  CompanyCode,
  EarmarkedFundsDocumentCategory,
  PostingDate,
  cast( EarmarkedFundsDocument as fac_ddf_anchor_document ) AS AnchorDocument,
  cast( 'BUS2086' as swo_objtyp ) AS BusinessObjectType,
  IsEndOfPurposeBlocked,
  EarmarkedFundsDocumentType
FROM R_DspDocFlwEmrkdFundsDocument
;