R_RblsFinancingDocItemTP

DDL: R_RBLSFINANCINGDOCITEMTP Type: view_entity TRANSACTIONAL
15 Fields 1 Data Sources 1 Associations

Receivables Financing Document Item

R_RblsFinancingDocItemTP is a Transactional CDS View that provides data about "Receivables Financing Document Item" in SAP S/4HANA. It reads from 1 data source (I_RblsFinancingDocItem) and exposes 15 fields with key field RblsFinancingDocItemUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_RblsFinancingDocItem I_RblsFinancingDocItem from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_OperationalAcctgDocItem _OperationalAcctgDocItem $projection.CompanyCode = _OperationalAcctgDocItem.CompanyCode and $projection.FiscalYear = _OperationalAcctgDocItem.FiscalYear and $projection.AccountingDocument = _OperationalAcctgDocItem.AccountingDocument and $projection.AccountingDocumentItem = _OperationalAcctgDocItem.AccountingDocumentItem

Annotations (8)

NameValueLevelField
EndUserText.label Receivables Financing Document Item view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.sapObjectNodeType.name RblsFinancingDocumentItem view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY RblsFinancingDocItemUUID RblsFinancingDocItemUUID Document Item UUID
RblsFinancingDocumentUUID RblsFinancingDocumentUUID UUID
ReceivablePayableDocument ReceivablePayableDocument
ReceivablePayableDocumentItem ReceivablePayableDocumentItem
RblPyblDocumentSubitem RblPyblDocumentSubitem
CompanyCode CompanyCode Receiver Company Code
FiscalYear FiscalYear G/L Fiscal Year
AccountingDocument AccountingDocument Journal Entry
AccountingDocumentItem AccountingDocumentItem Posting View Item
TransactionCurrency TransactionCurrency Transaction Currency
OriglRblPyblItmAmtInOrigItmTC OriglRblPyblItmAmtInOrigItmTC Amount in Transaction Currency
ReceivablePayableApplication _FinancingDocument ReceivablePayableApplication
ClearingJournalEntry _OperationalAcctgDocItem ClearingJournalEntry Clrng doc.
_CompanyCode _CompanyCode
_FinancingDocument _FinancingDocument

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_RblsFinancingDocItemTP.
-- 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_RblsFinancingDocItemTP AS
SELECT
  RblsFinancingDocItemUUID,
  RblsFinancingDocumentUUID,
  ReceivablePayableDocument,
  ReceivablePayableDocumentItem,
  RblPyblDocumentSubitem,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentItem,
  TransactionCurrency,
  OriglRblPyblItmAmtInOrigItmTC,
  _FinancingDocument.ReceivablePayableApplication AS ReceivablePayableApplication,
  _OperationalAcctgDocItem.ClearingJournalEntry AS ClearingJournalEntry
FROM I_RblsFinancingDocItem
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _OperationalAcctgDocItem ON CompanyCode = _OperationalAcctgDocItem.CompanyCode AND FiscalYear = _OperationalAcctgDocItem.FiscalYear AND AccountingDocument = _OperationalAcctgDocItem.AccountingDocument AND AccountingDocumentItem = _OperationalAcctgDocItem.AccountingDocumentItem  -- association [1..1]
;

Learn More