I_EarmarkedFundsDocumentTP

DDL: I_EARMARKEDFUNDSDOCUMENTTP Type: view_entity TRANSACTIONAL Package: ODATA_PSM_S4C_EARMARKED_FUNDS
48 Fields 1 Data Sources

EarmarkedFundsDocument - TP

I_EarmarkedFundsDocumentTP is a Transactional CDS View that provides data about "EarmarkedFundsDocument - TP" in SAP S/4HANA. It reads from 1 data source (R_EarmarkedFundsDocumentTP) and exposes 48 fields with key field EarmarkedFundsDocument. Part of development package ODATA_PSM_S4C_EARMARKED_FUNDS.

Data Sources (1)

SourceAliasJoin Type
R_EarmarkedFundsDocumentTP R_EarmarkedFundsDocumentTP projection

Annotations (10)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.sapObjectNodeType.name EarmarkedFundsDocument view
EndUserText.label EarmarkedFundsDocument - TP view
Metadata.ignorePropagatedAnnotations true view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
EarmarkedFundsDocumentForEdit EarmarkedFundsDocumentForEdit External Document Number
EarmarkedFundsDocumentCategory EarmarkedFundsDocumentCategory Document Category
EarmarkedFundsDocumentType EarmarkedFundsDocumentType Document Type
CompanyCode CompanyCode Receiver Company Code
FinancialManagementArea FinancialManagementArea FM Area
ControllingArea ControllingArea Controlling Area
TransactionCurrency TransactionCurrency Transaction Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
EarmarkedFundsDocReference EarmarkedFundsDocReference Reference
EarmarkedFundsDocReference2 EarmarkedFundsDocReference2 Reference 2
EarmarkedFundsDocReference3 EarmarkedFundsDocReference3 Reference 3
EarmarkedFundsHeaderText EarmarkedFundsHeaderText Document Text
EarmarkedFundsHasLongText EarmarkedFundsHasLongText Long Txt Exists
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
ExchangeRateDate ExchangeRateDate Translatn Date
AbsoluteExchangeRate AbsoluteExchangeRate Absolute Exchange Rate
ExchRateIsIndirectQuotation ExchRateIsIndirectQuotation Exchange Rate Is Indirect Quotation
EmrkdFndsDocCreatedByUser EmrkdFndsDocCreatedByUser Entered By
EmrkdFndsDocCreationDate EmrkdFndsDocCreationDate Entered On
EmrkdFndsDocLastChangedByUser EmrkdFndsDocLastChangedByUser Last Changed By
EmrkdFndsDocLastChangeDate EmrkdFndsDocLastChangeDate Changed On
EmrkdFndsDocLastChangeDateTime EmrkdFndsDocLastChangeDateTime Last Changed On
OrgnlBusinessTransactionType OrgnlBusinessTransactionType Original BTran.
ReferenceDocumentType ReferenceDocumentType Reference Document Type
ReferenceDocument ReferenceDocument Reference Document
ReferenceDocumentContext ReferenceDocumentContext Reference Document Context
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
EmrkdFndsIsMarkedForArchiving EmrkdFndsIsMarkedForArchiving Can Be Archived
EmrkdFndsHasNegativeAmounts EmrkdFndsHasNegativeAmounts Neg.Values
EmrkdFndsIsBlockedAgainstUsage EmrkdFndsIsBlockedAgainstUsage Doc.Blocked
EarmarkedFundsIsCompleted EarmarkedFundsIsCompleted Doc.Completed
EarmarkedFundsIsApproved EarmarkedFundsIsApproved Doc. Approved
EmrkdFndsWasAlreadyAprvdOnce EmrkdFndsWasAlreadyAprvdOnce Already Apprvd
EmrkdFndsHasAddlCnsmpnLogic EmrkdFndsHasAddlCnsmpnLogic Add. Rdctn Logic
EarmarkedFundsDecisionReason EarmarkedFundsDecisionReason Decision Reason
EarmarkedFundsStartWorkflow EarmarkedFundsStartWorkflow Start Approval by Workflow
EarmarkedFundsManualEditBlock EarmarkedFundsManualEditBlock Document Block
EmrkdFndsMnlEditBlkForEdit EmrkdFndsMnlEditBlkForEdit Document Block
EmrkdFndsHasValueAdjustments EmrkdFndsHasValueAdjustments Value Adjustmts
EarmarkedFundsDocEntryStatus EarmarkedFundsDocEntryStatus Status
EmrkdFndsTotalInTransCrcy EmrkdFndsTotalInTransCrcy Total Amount
EmrkdFndsRelTotalInTransCrcy EmrkdFndsRelTotalInTransCrcy Release Amount
EmrkdFndsOpenTotalInTransCrcy EmrkdFndsOpenTotalInTransCrcy Open Amount
EmrkdFndsChgdTotalInTransCrcy EmrkdFndsChgdTotalInTransCrcy Amount Changed
EmrkdFndsCnsmdTotalInTransCrcy EmrkdFndsCnsmdTotalInTransCrcy Reduced Amount
EmrkdFndsOriglTotalInTransCrcy EmrkdFndsOriglTotalInTransCrcy Original Amount

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_EarmarkedFundsDocumentTP.
-- 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 I_EarmarkedFundsDocumentTP AS
SELECT
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentForEdit,
  EarmarkedFundsDocumentCategory,
  EarmarkedFundsDocumentType,
  CompanyCode,
  FinancialManagementArea,
  ControllingArea,
  TransactionCurrency,
  CompanyCodeCurrency,
  EarmarkedFundsDocReference,
  EarmarkedFundsDocReference2,
  EarmarkedFundsDocReference3,
  EarmarkedFundsHeaderText,
  EarmarkedFundsHasLongText,
  PostingDate,
  DocumentDate,
  ExchangeRateDate,
  AbsoluteExchangeRate,
  ExchRateIsIndirectQuotation,
  EmrkdFndsDocCreatedByUser,
  EmrkdFndsDocCreationDate,
  EmrkdFndsDocLastChangedByUser,
  EmrkdFndsDocLastChangeDate,
  EmrkdFndsDocLastChangeDateTime,
  OrgnlBusinessTransactionType,
  ReferenceDocumentType,
  ReferenceDocument,
  ReferenceDocumentContext,
  ReferenceDocumentLogicalSystem,
  EmrkdFndsIsMarkedForArchiving,
  EmrkdFndsHasNegativeAmounts,
  EmrkdFndsIsBlockedAgainstUsage,
  EarmarkedFundsIsCompleted,
  EarmarkedFundsIsApproved,
  EmrkdFndsWasAlreadyAprvdOnce,
  EmrkdFndsHasAddlCnsmpnLogic,
  EarmarkedFundsDecisionReason,
  EarmarkedFundsStartWorkflow,
  EarmarkedFundsManualEditBlock,
  EmrkdFndsMnlEditBlkForEdit,
  EmrkdFndsHasValueAdjustments,
  EarmarkedFundsDocEntryStatus,
  EmrkdFndsTotalInTransCrcy,
  EmrkdFndsRelTotalInTransCrcy,
  EmrkdFndsOpenTotalInTransCrcy,
  EmrkdFndsChgdTotalInTransCrcy,
  EmrkdFndsCnsmdTotalInTransCrcy,
  EmrkdFndsOriglTotalInTransCrcy
FROM R_EarmarkedFundsDocumentTP
;

Learn More