C_APProcFlwEmrkdFndsDocItemVH

DDL: C_APPROCFLWEMRKDFNDSDOCITEMVH SQL: CAPPFEFDOCITEMVH Type: view CONSUMPTION Package: ODATA_PROCESS_FLOW_AP
63 Fields 1 Data Sources 1 Associations 1 OData Services

Earmarked Funds Document Item

C_APProcFlwEmrkdFndsDocItemVH is a Consumption CDS View that provides data about "Earmarked Funds Document Item" in SAP S/4HANA. It reads from 1 data source (I_EmrkdFndsDocumentItemStdVH) and exposes 63 fields with key fields EarmarkedFundsDocument, EarmarkedFundsDocumentItem. It has 1 association to related views. It is exposed through 1 OData service (ASQL_F2691). Part of development package ODATA_PROCESS_FLOW_AP.

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 CAPPFEFDOCITEMVH 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 Earmarked Funds Document Item view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F2691 ASQL_F2691 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
CompanyCodeName
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
_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 C_APProcFlwEmrkdFndsDocItemVH.
-- 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: CAPPFEFDOCITEMVH

CREATE VIEW C_APProcFlwEmrkdFndsDocItemVH AS
SELECT
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  _EarmarkedFundsDocument.EarmarkedFundsDocumentCategory AS EarmarkedFundsDocumentCategory,
  _EarmarkedFundsDocument.EarmarkedFundsDocumentType AS EarmarkedFundsDocumentType,
  CompanyCode,
  I_EmrkdFndsDocumentItemStdVH._CompanyCode.CompanyCodeName AS CompanyCodeName,
  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