C_EmrkdFndsDocOutpParamDetn

DDL: C_EMRKDFNDSDOCOUTPPARAMDETN SQL: CSDEFNDSDOCOPRM Type: view_entity CONSUMPTION Package: ODATA_PSM_S4C_EARMARKED_FUNDS

Earmarked Funds Document OM Parameter Determination

C_EmrkdFndsDocOutpParamDetn is a Consumption CDS View that provides data about "Earmarked Funds Document OM Parameter Determination" in SAP S/4HANA. It reads from 1 data source (I_EarmarkedFundsDocument) and exposes 32 fields with key field EarmarkedFundsDocument. Part of development package ODATA_PSM_S4C_EARMARKED_FUNDS.

Data Sources (1)

SourceAliasJoin Type
I_EarmarkedFundsDocument EarmarkedFundsDocument from

Annotations (6)

NameValueLevelField
VDM.viewType #CONSUMPTION view
EndUserText.label Earmarked Funds Document OM Parameter Determination view
ObjectModel.compositionRoot false view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
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
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
OrgnlBusinessTransactionType OrgnlBusinessTransactionType Original BTran.
ReferenceDocumentType ReferenceDocumentType Reference Document Type
ReferenceDocument ReferenceDocument Reference Document
ReferenceDocumentContext ReferenceDocumentContext Reference Document Context
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
_CompanyCode _CompanyCode
_CompanyCodeCurrency _CompanyCodeCurrency
_ControllingArea _ControllingArea
_EarmarkedFundsDocCategory _EarmarkedFundsDocCategory
_EarmarkedFundsDocCatText _EarmarkedFundsDocCatText
_EarmarkedFundsDocTotals _EarmarkedFundsDocTotals
_EarmarkedFundsDocType _EarmarkedFundsDocType
_EarmarkedFundsDocTypeText _EarmarkedFundsDocTypeText
_EarmarkedFundsDocumentItem _EarmarkedFundsDocumentItem
_FinancialManagementArea _FinancialManagementArea
_FiscalCalDateForFinMgmtArea _FiscalCalDateForFinMgmtArea
_FiscalYearForCompanyCode _FiscalYearForCompanyCode
_FiscalYearForFinMgmtArea _FiscalYearForFinMgmtArea
_RefDocumentLogicalSystem _RefDocumentLogicalSystem
_ReferenceDocumentType _ReferenceDocumentType
_ReferenceDocumentTypeText _ReferenceDocumentTypeText
_TransactionCurrency _TransactionCurrency

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_EmrkdFndsDocOutpParamDetn.
-- 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: CSDEFNDSDOCOPRM

CREATE VIEW C_EmrkdFndsDocOutpParamDetn AS
SELECT
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentCategory,
  EarmarkedFundsDocumentType,
  CompanyCode,
  FinancialManagementArea,
  ControllingArea,
  TransactionCurrency,
  CompanyCodeCurrency,
  PostingDate,
  DocumentDate,
  OrgnlBusinessTransactionType,
  ReferenceDocumentType,
  ReferenceDocument,
  ReferenceDocumentContext,
  ReferenceDocumentLogicalSystem
FROM I_EarmarkedFundsDocument AS EarmarkedFundsDocument
;