I_RO_CashReceiptOutputMgmt

DDL: I_RO_CASHRECEIPTOUTPUTMGMT SQL: IROCASHRCPT Type: view BASIC
19 Fields 1 Data Sources 1 Associations

Cash Receipt output for Romania

I_RO_CashReceiptOutputMgmt is a Basic CDS View that provides data about "Cash Receipt output for Romania" in SAP S/4HANA. It reads from 1 data source (I_CashJournalDocument) and exposes 19 fields with key fields CompanyCode, CashJournal, FiscalYear, CashJournalDocumentInternalID, Language. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CashJournalDocument I_CashJournalDocument from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CashJournalPosition _CashJournalPosition $projection.CompanyCode = _CashJournalPosition.CompanyCode and $projection.CashJournal = _CashJournalPosition.CashJournal and $projection.FiscalYear = _CashJournalPosition.FiscalYear and $projection.CashJournalDocumentInternalID = _CashJournalPosition.CashJournalDocumentInternalID and $projection.Language = _CashJournalPosition.Language

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IROCASHRCPT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AbapCatalog.preserveKey true view
EndUserText.label Cash Receipt output for Romania view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY CashJournal CashJournal Cash Journal Number
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY CashJournalDocumentInternalID CashJournalDocumentInternalID Internal doc. number
KEY Language Language Report Text Language
Currency Currency Valuation Crcy
OriginalReferenceDocument
ReferenceDocumentType
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
CustomerNum _CashJournalPosition CustomerNum Customer
Supplier _CashJournalPosition Supplier Supplier
CashJournalDocumentTransType _CashJournalPosition CashJournalDocumentTransType
CashJournalDocumentItemText _CashJournalPosition CashJournalDocumentItemText
CashJournalDocumentItem _CashJournalPosition CashJournalDocumentItem
CashJournalDocumentText2 CashJournalDocumentText2 Vertikalization Text
CashJournalReceiptAmount CashJournalReceiptAmount Amount
CashJournalPaymentAmount CashJournalPaymentAmount Amount
_CompanyCode _CompanyCode
AuthorizationGroup _CashJournal AuthorizationGroup AuthorizGroup

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_RO_CashReceiptOutputMgmt.
-- 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: IROCASHRCPT

CREATE VIEW I_RO_CashReceiptOutputMgmt AS
SELECT
  CompanyCode,
  CashJournal,
  FiscalYear,
  CashJournalDocumentInternalID,
  Language,
  Currency,
  concat(concat(CashJournalDocumentInternalID, CashJournal),CompanyCode) AS OriginalReferenceDocument,
  cast ('CAJO' as awtyp) AS ReferenceDocumentType,
  AmountInTransactionCurrency,
  _CashJournalPosition.CustomerNum AS CustomerNum,
  _CashJournalPosition.Supplier AS Supplier,
  _CashJournalPosition.CashJournalDocumentTransType AS CashJournalDocumentTransType,
  _CashJournalPosition.CashJournalDocumentItemText AS CashJournalDocumentItemText,
  _CashJournalPosition.CashJournalDocumentItem AS CashJournalDocumentItem,
  CashJournalDocumentText2,
  CashJournalReceiptAmount,
  CashJournalPaymentAmount,
  _CashJournal.AuthorizationGroup AS AuthorizationGroup
FROM I_CashJournalDocument
LEFT OUTER JOIN I_CashJournalPosition AS _CashJournalPosition ON CompanyCode = _CashJournalPosition.CompanyCode AND CashJournal = _CashJournalPosition.CashJournal AND FiscalYear = _CashJournalPosition.FiscalYear AND CashJournalDocumentInternalID = _CashJournalPosition.CashJournalDocumentInternalID AND Language = _CashJournalPosition.Language  -- association [0..1]
;

Learn More