A_EarmarkedFundsDocument

DDL: A_EARMARKEDFUNDSDOCUMENT Type: view_entity CONSUMPTION Package: ODATA_PSM_S4C_EARMARKED_FUNDS
26 Fields 1 Data Sources 4 OData Services

Remote Interface Earmarked Funds

A_EarmarkedFundsDocument is a Consumption CDS View that provides data about "Remote Interface Earmarked Funds" in SAP S/4HANA. It reads from 1 data source (R_EarmarkedFundsDocumentTP) and exposes 26 fields with key field EarmarkedFundsDocument. It is exposed through 4 OData services (API_EARMARKEDFUNDSDOC, API_EARMARKEDFUNDSDOCUMENT, ASQL_F7357, ...). Part of development package ODATA_PSM_S4C_EARMARKED_FUNDS.

Data Sources (1)

SourceAliasJoin Type
R_EarmarkedFundsDocumentTP R_EarmarkedFundsDocumentTP projection

Annotations (10)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.representativeKey EarmarkedFundsDocument view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
OData.entityType.name EarmarkedFundsDocument_Type view
EndUserText.label Remote Interface Earmarked Funds view

OData Services (4)

ServiceBindingVersionContractRelease
API_EARMARKEDFUNDSDOC API_EARMARKEDFUNDSDOC V4 C2 C1
API_EARMARKEDFUNDSDOCUMENT API_EARMARKEDFUNDSDOCUMENT V2 C2 C1
ASQL_F7357 ASQL_F7357 C2 NOT_RELEASED
ASQL_F7718 ASQL_F7718 C2 NOT_RELEASED

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
EmrkdFndsExtDocumentNumber 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
EarmarkedFundsHeaderText EarmarkedFundsHeaderText Document Text
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
ReferenceDocumentType ReferenceDocumentType Reference Document Type
ReferenceDocument ReferenceDocument Reference Document
ReferenceDocumentContext ReferenceDocumentContext Reference Document Context
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
EarmarkedFundsManualEditBlock EarmarkedFundsManualEditBlock Document Block

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 A_EarmarkedFundsDocument.
-- 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 A_EarmarkedFundsDocument AS
SELECT
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentForEdit AS EmrkdFndsExtDocumentNumber,
  EarmarkedFundsDocumentCategory,
  EarmarkedFundsDocumentType,
  CompanyCode,
  FinancialManagementArea,
  ControllingArea,
  TransactionCurrency,
  CompanyCodeCurrency,
  EarmarkedFundsDocReference,
  EarmarkedFundsHeaderText,
  PostingDate,
  DocumentDate,
  ExchangeRateDate,
  AbsoluteExchangeRate,
  ExchRateIsIndirectQuotation,
  EmrkdFndsDocCreatedByUser,
  EmrkdFndsDocCreationDate,
  EmrkdFndsDocLastChangedByUser,
  EmrkdFndsDocLastChangeDate,
  EmrkdFndsDocLastChangeDateTime,
  ReferenceDocumentType,
  ReferenceDocument,
  ReferenceDocumentContext,
  ReferenceDocumentLogicalSystem,
  EarmarkedFundsManualEditBlock
FROM R_EarmarkedFundsDocumentTP
;

Learn More