C_EmrkdFndsDocumentItemVH

DDL: C_EMRKDFNDSDOCUMENTITEMVH SQL: CEFDITMVH Type: view CONSUMPTION Package: PSM_S4C_EARMARKED_FUNDS
61 Fields 1 Data Sources 1 Associations 2 OData Services

Emrkd Fnds Itm Value Help for Manage App

C_EmrkdFndsDocumentItemVH is a Consumption CDS View that provides data about "Emrkd Fnds Itm Value Help for Manage App" in SAP S/4HANA. It reads from 1 data source (I_EmrkdFndsDocumentItemStdVH) and exposes 61 fields with key fields EarmarkedFundsDocument, EarmarkedFundsDocumentItem. It has 1 association to related views. It is exposed through 2 OData services (ASQL_F4657, ASQL_F7334). Part of development package PSM_S4C_EARMARKED_FUNDS.

Data Sources (1)

SourceAliasJoin Type
I_EmrkdFndsDocumentItemStdVH I_EmrkdFndsDocumentItemStdVH from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_WBSElementBasicData _WBSElementBasicData $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CEFDITMVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey EarmarkedFundsDocumentItem view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
Search.searchable true view
EndUserText.label Emrkd Fnds Itm Value Help for Manage App view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F4657 ASQL_F4657 C2 NOT_RELEASED
ASQL_F7334 ASQL_F7334 C2 NOT_RELEASED

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
KEY EarmarkedFundsDocumentItem EarmarkedFundsDocumentItem Document Item
EarmarkedFundsDocumentCategory _EarmarkedFundsDocument EarmarkedFundsDocumentCategory Document Category
EarmarkedFundsDocumentType _EarmarkedFundsDocument EarmarkedFundsDocumentType Document Type
CompanyCode CompanyCode Receiver Company Code
TransactionCurrency TransactionCurrency Transaction Currency
DocumentDate _EarmarkedFundsDocument DocumentDate Journal Entry Date
PostingDate _EarmarkedFundsDocument PostingDate Posting Date for GR
EmrkdFndsDocItmCreatedByUser EmrkdFndsDocItmCreatedByUser Entered By
EmrkdFndsDocItmCreationDate EmrkdFndsDocItmCreationDate Entered On
EmrkdFndsDocItmLastChgdByUsr EmrkdFndsDocItmLastChgdByUsr Last Changed By
EmrkdFndsDocItmLastChangeDate EmrkdFndsDocItmLastChangeDate Changed On
DocumentItemText DocumentItemText Text
DueDate DueDate Promised For
ControllingArea ControllingArea Controlling Area
GLAccount GLAccount General Ledger
CostCenter CostCenter Cost Center
InternalOrder InternalOrder Order
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElementExternalID _WBSElementBasicData WBSElementExternalID WBS Element External ID
WBSDescription _WBSElementBasicData WBSDescription WBS Element Name
ProjectNetwork ProjectNetwork Order
CostElement CostElement G/L Account
FinancialManagementArea FinancialManagementArea FM Area
CommitmentItem CommitmentItem Commitment item
FundsCenter FundsCenter Funds Center
Fund Fund Sender Fund
FundedProgram FundedProgram Funded Program
BudgetPeriod BudgetPeriod Budget Period
FunctionalArea FunctionalArea Sendr Fctl Area
GrantID GrantID Sender Grant
BusinessArea BusinessArea Business Area
Product Product Product Sold
Supplier Supplier Supplier
Customer Customer Sold-to Party
EmrkdFndsItmIsCompleted EmrkdFndsItmIsCompleted Item Completed
EmrkdFndsItmIsBlkdAgainstUsage EmrkdFndsItmIsBlkdAgainstUsage Item Blocked
EmrkdFndsItmIsApproved EmrkdFndsItmIsApproved Item Approved
EmrkdFndsOpenAmtInTransCrcy EmrkdFndsOpenAmtInTransCrcy Open Amount
_EarmarkedFundsDocument _EarmarkedFundsDocument
_TransactionCurrency _TransactionCurrency
_CompanyCode _CompanyCode
_ControllingArea _ControllingArea
_FinancialManagementArea _FinancialManagementArea
_CostCenter _CostCenter
_CurrentCostCenter _CurrentCostCenter
_InternalOrder _InternalOrder
_WBSElementBasicData _WBSElementBasicData
_GLAccountInCompanyCode _GLAccountInCompanyCode
_CostElement _CostElement
_ProjectNetwork _ProjectNetwork
_CommitmentItemByEmrkdFnds _CommitmentItemByEmrkdFnds
_Fund _Fund
_CurrentFundsCenter _CurrentFundsCenter
_FundsCenterByEarmarkedFunds _FundsCenterByEarmarkedFunds
_FundedProgram _FundedProgram
_BudgetPeriod _BudgetPeriod
_FundsMgmtFunctionalArea _FundsMgmtFunctionalArea
_FunctionalArea _FunctionalArea
_Grant _Grant
_BusinessArea _BusinessArea

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_EmrkdFndsDocumentItemVH.
-- 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: CEFDITMVH

CREATE VIEW C_EmrkdFndsDocumentItemVH AS
SELECT
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  _EarmarkedFundsDocument.EarmarkedFundsDocumentCategory AS EarmarkedFundsDocumentCategory,
  _EarmarkedFundsDocument.EarmarkedFundsDocumentType AS EarmarkedFundsDocumentType,
  CompanyCode,
  TransactionCurrency,
  _EarmarkedFundsDocument.DocumentDate AS DocumentDate,
  _EarmarkedFundsDocument.PostingDate AS PostingDate,
  EmrkdFndsDocItmCreatedByUser,
  EmrkdFndsDocItmCreationDate,
  EmrkdFndsDocItmLastChgdByUsr,
  EmrkdFndsDocItmLastChangeDate,
  DocumentItemText,
  DueDate,
  ControllingArea,
  GLAccount,
  CostCenter,
  InternalOrder,
  WBSElementInternalID,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  _WBSElementBasicData.WBSDescription AS WBSDescription,
  ProjectNetwork,
  CostElement,
  FinancialManagementArea,
  CommitmentItem,
  FundsCenter,
  Fund,
  FundedProgram,
  BudgetPeriod,
  FunctionalArea,
  GrantID,
  BusinessArea,
  Product,
  Supplier,
  Customer,
  EmrkdFndsItmIsCompleted,
  EmrkdFndsItmIsBlkdAgainstUsage,
  EmrkdFndsItmIsApproved,
  EmrkdFndsOpenAmtInTransCrcy
FROM I_EmrkdFndsDocumentItemStdVH
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
;

Learn More