C_CashReceiptOutputManagement

DDL: C_CASHRECEIPTOUTPUTMANAGEMENT SQL: CCASHJNLRCPT Type: view CONSUMPTION
25 Fields 1 Data Sources

Consumption view for Cash Journal OM

C_CashReceiptOutputManagement is a Consumption CDS View that provides data about "Consumption view for Cash Journal OM" in SAP S/4HANA. It reads from 1 data source (I_CashJournalDocument) and exposes 25 fields with key fields CompanyCode, CashJournal, FiscalYear, CashJournalDocumentInternalID, Language.

Data Sources (1)

SourceAliasJoin Type
I_CashJournalDocument I_CashJournalDocument from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CCASHJNLRCPT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption view for Cash Journal OM view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

Fields (25)

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
DocumentDate DocumentDate Journal Entry Date
TaxAmountInTransCrcy TaxAmountInTransCrcy TaxAmt in Tran. Crcy
CashJournalDocumentNetAmount CashJournalDocumentNetAmount Net amount
CashJournalReceiptAmount CashJournalReceiptAmount Amount
CashJournalPaymentAmount CashJournalPaymentAmount Amount
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
CashJournalDocument CashJournalDocument Doc. Number
ReceiptRecipientName ReceiptRecipientName Recpt recipient
AuthorizationGroup _CashJournal AuthorizationGroup AuthorizGroup
ExtendedWhldgTaxIsActive _CompanyCode ExtendedWhldgTaxIsActive Extended WTax Active
CompanyCodeName _CompanyCode CompanyCodeName Company Name
WhldgTaxDeductedNetAmount
CurrentDate
_CashJournalPositionITEM _CashJournalPositionITEM
_CashJournalPositionSUM _CashJournalPositionSUM
_CashJournal I_CashJournalDocument _CashJournal
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_Currency _Currency

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_CashReceiptOutputManagement.
-- 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: CCASHJNLRCPT

CREATE VIEW C_CashReceiptOutputManagement AS
SELECT
  CompanyCode,
  CashJournal,
  FiscalYear,
  CashJournalDocumentInternalID,
  Language,
  Currency,
  DocumentDate,
  TaxAmountInTransCrcy,
  CashJournalDocumentNetAmount,
  CashJournalReceiptAmount,
  CashJournalPaymentAmount,
  AmountInTransactionCurrency,
  CashJournalDocument,
  ReceiptRecipientName,
  _CashJournal.AuthorizationGroup AS AuthorizationGroup,
  _CompanyCode.ExtendedWhldgTaxIsActive AS ExtendedWhldgTaxIsActive,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  ( CashJournalDocumentNetAmount + TaxAmountInTransCrcy - WhldgTaxDeductedNetPaymentAmt ) AS WhldgTaxDeductedNetAmount,
  $session.system_date AS CurrentDate,
  I_CashJournalDocument._CashJournal AS _CashJournal
FROM I_CashJournalDocument
;

Learn More