R_EarmarkedFundsDocumentDraft

DDL: R_EARMARKEDFUNDSDOCUMENTDRAFT Type: view_entity BASIC
62 Fields 1 Data Sources 2 Associations

Earmarked Funds Document - Draft

R_EarmarkedFundsDocumentDraft is a Basic CDS View that provides data about "Earmarked Funds Document - Draft" in SAP S/4HANA. It reads from 1 data source (kblk_draft2) and exposes 62 fields with key fields EarmarkedFundsDocument, DraftUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
kblk_draft2 efdoc_draft from

Associations (2)

CardinalityTargetAliasCondition
[0..*] R_EarmarkedFundsDocItemDraft _EarmarkedFundsDocItemDraft $projection.EarmarkedFundsDocument = _EarmarkedFundsDocItemDraft.EarmarkedFundsDocument and $projection.DraftUUID = _EarmarkedFundsDocItemDraft.ParentDraftUUID
[1] E_EarmarkedFundsDocumentDraft _ExtensionDraft $projection.EarmarkedFundsDocument = _ExtensionDraft.EarmarkedFundsDocument

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
AbapCatalog.extensibility.elementSuffix EFD view
AbapCatalog.extensibility.quota.maximumFields 200 view
AbapCatalog.extensibility.quota.maximumBytes 20000 view
EndUserText.label Earmarked Funds Document - Draft view

Fields (62)

KeyFieldSource TableSource FieldDescription
KEY EarmarkedFundsDocument earmarkedfundsdocument Earmarked Funds
KEY DraftUUID draftuuid UUID
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
EmrkdFndsTotalInCCCrcy emrkdfndstotalincccrcy Total Amount in Local Currency
EmrkdFndsRelTotalInCCCrcy emrkdfndsreltotalincccrcy Amt for Release
EmrkdFndsOpenTotalInCCCrcy emrkdfndsopentotalincccrcy Open Amount in Local Currency
EmrkdFndsChgdTotalInCCCrcy emrkdfndschgdtotalincccrcy Amount Changed in Local Currency
EmrkdFndsCnsmdTotalInCCCrcy emrkdfndscnsmdtotalincccrcy Reduced Amount
EmrkdFndsOriglTotalInCCCrcy emrkdfndsorigltotalincccrcy Original Amount
HasActiveEntity hasactiveentity TRUE
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
DraftFieldChanges draftfieldchanges Field Changes
_EarmarkedFundsDocItemDraft _EarmarkedFundsDocItemDraft

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 R_EarmarkedFundsDocumentDraft.
-- 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 R_EarmarkedFundsDocumentDraft AS
SELECT
  EarmarkedFundsDocument,
  DraftUUID,
  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,
  EmrkdFndsTotalInCCCrcy,
  EmrkdFndsRelTotalInCCCrcy,
  EmrkdFndsOpenTotalInCCCrcy,
  EmrkdFndsChgdTotalInCCCrcy,
  EmrkdFndsCnsmdTotalInCCCrcy,
  EmrkdFndsOriglTotalInCCCrcy,
  HasActiveEntity,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  DraftFieldChanges
FROM kblk_draft2 AS efdoc_draft
LEFT OUTER JOIN R_EarmarkedFundsDocItemDraft AS _EarmarkedFundsDocItemDraft ON EarmarkedFundsDocument = _EarmarkedFundsDocItemDraft.EarmarkedFundsDocument AND DraftUUID = _EarmarkedFundsDocItemDraft.ParentDraftUUID  -- association [0..*]
LEFT OUTER JOIN E_EarmarkedFundsDocumentDraft AS _ExtensionDraft ON EarmarkedFundsDocument = _ExtensionDraft.EarmarkedFundsDocument  -- association [1]
;

Learn More