I_PPSEmrkdFundsDocumentItem

DDL: I_PPSEMRKDFUNDSDOCUMENTITEM Type: view_entity BASIC
10 Fields 1 Data Sources 2 Associations

I_PPSEmrkdFundsDocumentItem is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (kblp) and exposes 10 fields with key fields PPSEarmarkedFund, PPSEarmarkedFundItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
kblp kblp from

Associations (2)

CardinalityTargetAliasCondition
[1] I_EarmarkedFundsDocument _EarmarkedFundsDocument $projection.PPSEarmarkedFund = _EarmarkedFundsDocument.EarmarkedFundsDocument
[1] I_EarmarkedFunds_MnlEditBlkTxt _EarmarkedFunds_MnlEditBlkTxt $projection.EmrkdFndsItmManualEditBlock = _EarmarkedFunds_MnlEditBlkTxt.EarmarkedFundsManualEditBlock

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey PPSEarmarkedFundItem view
VDM.viewType #BASIC view
VDM.private true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PPSEarmarkedFund belnr SD Document
KEY PPSEarmarkedFundItem blpos Ref. Doc. Item
DocumentItemText ptext Text for ItCat.
TransactionCurrency _EarmarkedFundsDocument TransactionCurrency Transaction Currency
EmrkdFndsAmountInTransCrcy wtges Total Amount
EmrkdFndsOpenAmtTransCrcyText Open Amount
EmrkdFndsItmIsCompleted erlkz Status
EmrkdFndsItmIsBlkdAgainstUsage blpkz Item Blocked
EmrkdFndsItmManualEditBlock poslock Item Block
EmrkdFundsManualEditBlockText _EarmarkedFunds_MnlEditBlkTxt EmrkdFundsManualEditBlockText

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_PPSEmrkdFundsDocumentItem.
-- 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_PPSEmrkdFundsDocumentItem AS
SELECT
  belnr AS PPSEarmarkedFund,
  blpos AS PPSEarmarkedFundItem,
  ptext AS DocumentItemText,
  _EarmarkedFundsDocument.TransactionCurrency AS TransactionCurrency,
  wtges AS EmrkdFndsAmountInTransCrcy,
  cast( wtfree as pps_e_emf_open_amount ) AS EmrkdFndsOpenAmtTransCrcyText,
  erlkz AS EmrkdFndsItmIsCompleted,
  blpkz AS EmrkdFndsItmIsBlkdAgainstUsage,
  poslock AS EmrkdFndsItmManualEditBlock,
  _EarmarkedFunds_MnlEditBlkTxt.EmrkdFundsManualEditBlockText AS EmrkdFundsManualEditBlockText
FROM kblp
LEFT OUTER JOIN I_EarmarkedFundsDocument AS _EarmarkedFundsDocument ON PPSEarmarkedFund = _EarmarkedFundsDocument.EarmarkedFundsDocument  -- association [1]
LEFT OUTER JOIN I_EarmarkedFunds_MnlEditBlkTxt AS _EarmarkedFunds_MnlEditBlkTxt ON EmrkdFndsItmManualEditBlock = _EarmarkedFunds_MnlEditBlkTxt.EarmarkedFundsManualEditBlock  -- association [1]
;

Learn More