I_EmrkdFndsDocumentItemStdVH

DDL: I_EMRKDFNDSDOCUMENTITEMSTDVH SQL: IEFDITMSTDVH Type: view COMPOSITE Package: FMRE
63 Fields 1 Data Sources 2 Associations 4 OData Services

Earmarked Funds Doc. Item Std Value Help

I_EmrkdFndsDocumentItemStdVH is a Composite CDS View that provides data about "Earmarked Funds Doc. Item Std Value Help" in SAP S/4HANA. It reads from 1 data source (I_EarmarkedFundsDocumentItem) and exposes 63 fields with key fields EarmarkedFundsDocument, EarmarkedFundsDocumentItem. It has 2 associations to related views. It is exposed through 4 OData services (ASQL_F2422, ASQL_F3398, ASQL_F3555, ...). Part of development package FMRE.

Data Sources (1)

SourceAliasJoin Type
I_EarmarkedFundsDocumentItem I_EarmarkedFundsDocumentItem from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_WBSElementBasicData _WBSElementBasicData $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
[0..*] I_FundsCenter _FundsCenter $projection.FinancialManagementArea = _FundsCenter.FinancialManagementArea and $projection.FundsCenter = _FundsCenter.FundsCenter

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IEFDITMSTDVH 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 #COMPOSITE view
Search.searchable true view
EndUserText.label Earmarked Funds Doc. Item Std Value Help view

OData Services (4)

ServiceBindingVersionContractRelease
ASQL_F2422 ASQL_F2422 C2 NOT_RELEASED
ASQL_F3398 ASQL_F3398 C2 NOT_RELEASED
ASQL_F3555 ASQL_F3555 C2 NOT_RELEASED
ASQL_F8134 ASQL_F8134 C2 NOT_RELEASED

Fields (63)

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
EarmarkedFundsDocEntryStatus _EarmarkedFundsDocument EarmarkedFundsDocEntryStatus Status
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
_FundsCenter _FundsCenter
_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 I_EmrkdFndsDocumentItemStdVH.
-- 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: IEFDITMSTDVH

CREATE VIEW I_EmrkdFndsDocumentItemStdVH AS
SELECT
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  _EarmarkedFundsDocument.EarmarkedFundsDocumentCategory AS EarmarkedFundsDocumentCategory,
  _EarmarkedFundsDocument.EarmarkedFundsDocumentType AS EarmarkedFundsDocumentType,
  CompanyCode,
  TransactionCurrency,
  _EarmarkedFundsDocument.EarmarkedFundsDocEntryStatus AS EarmarkedFundsDocEntryStatus,
  _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_EarmarkedFundsDocumentItem
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND FundsCenter = _FundsCenter.FundsCenter  -- association [0..*]
;

Learn More