C_EmrkdFundsWorkflowTaskCard

DDL: C_EMRKDFUNDSWORKFLOWTASKCARD Type: view_entity CONSUMPTION Package: PSM_S4CO_ODATA_EF_WF
11 Fields 1 Data Sources 1 Associations

Earmarked Funds Workflow Task Card

C_EmrkdFundsWorkflowTaskCard is a Consumption CDS View that provides data about "Earmarked Funds Workflow Task Card" in SAP S/4HANA. It reads from 1 data source (I_EarmarkedFundsDocument) and exposes 11 fields with key field EarmarkedFundsDocument. It has 1 association to related views. Part of development package PSM_S4CO_ODATA_EF_WF.

Data Sources (1)

SourceAliasJoin Type
I_EarmarkedFundsDocument I_EarmarkedFundsDocument from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_EarmarkedFunds_DocCatText _EarmarkedFundsDocCatText $projection.EarmarkedFundsDocumentCategory = _EarmarkedFundsDocCatText.EarmarkedFundsDocumentCategory and _EarmarkedFundsDocCatText.Language = $session.system_language

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Earmarked Funds Workflow Task Card view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
EarmarkedFundsDocumentCategory EarmarkedFundsDocumentCategory Document Category
EarmarkedFundsDocCategoryText _EarmarkedFundsDocCatText EarmarkedFundsDocCategoryText
EarmarkedFundsDocReference EarmarkedFundsDocReference Reference
EarmarkedFundsHeaderText EarmarkedFundsHeaderText Document Text
EmrkdFndsTotalInTransCrcy _EarmarkedFundsDocTotals EmrkdFndsTotalInTransCrcy Total Amount
EmrkdFndsChgdTotalInTransCrcy _EarmarkedFundsDocTotals EmrkdFndsChgdTotalInTransCrcy Amount Changed
TransactionCurrency TransactionCurrency Transaction Currency
CompanyCode CompanyCode Receiver Company Code
EarmarkedFundsDocumentType EarmarkedFundsDocumentType Document Type
_EarmarkedFundsDocumentItem _EarmarkedFundsDocumentItem

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_EmrkdFundsWorkflowTaskCard.
-- 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_EmrkdFundsWorkflowTaskCard AS
SELECT
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentCategory,
  _EarmarkedFundsDocCatText.EarmarkedFundsDocCategoryText AS EarmarkedFundsDocCategoryText,
  EarmarkedFundsDocReference,
  EarmarkedFundsHeaderText,
  _EarmarkedFundsDocTotals.EmrkdFndsTotalInTransCrcy AS EmrkdFndsTotalInTransCrcy,
  _EarmarkedFundsDocTotals.EmrkdFndsChgdTotalInTransCrcy AS EmrkdFndsChgdTotalInTransCrcy,
  TransactionCurrency,
  CompanyCode,
  EarmarkedFundsDocumentType
FROM I_EarmarkedFundsDocument
LEFT OUTER JOIN I_EarmarkedFunds_DocCatText AS _EarmarkedFundsDocCatText ON EarmarkedFundsDocumentCategory = _EarmarkedFundsDocCatText.EarmarkedFundsDocumentCategory AND _EarmarkedFundsDocCatText.Language = $session.system_language  -- association [0..1]
;

Learn More