What is I_OutgoingCheck in SAP S/4HANA?

I_OutgoingCheck is a basic CDS view in SAP S/4HANA. Outgoing Cheque It contains 49 fields.

Which tables does I_OutgoingCheck read from?

I_OutgoingCheck reads data from: P_OutgoingCheck.

What VDM layer is I_OutgoingCheck?

I_OutgoingCheck is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_OutgoingCheck

DDL: I_OUTGOINGCHECK SQL: IOUTGOINGCHECK Type: view BASIC Package: ODATA_OUTGOING_CHECKS

49 Fields 1 Data Sources 5 Associations

Outgoing Cheque

I_OutgoingCheck (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Financial Operations

I_OutgoingCheck is a Basic CDS View that provides data about "Outgoing Cheque" in SAP S/4HANA. It reads from 1 data source (P_OutgoingCheck) and exposes 49 fields with key fields PaymentCompanyCode, HouseBank, HouseBankAccount, PaymentMethod, OutgoingCheque. It has 5 associations to related views. Part of development package ODATA_OUTGOING_CHECKS.

SAP Help Documentation

Category	CDS Views for Invoice Management
Status	Released

Purpose
This CDS view helps to retrieve the detailed information of outgoing cheques. The Cheque Status Description can be one of the following: 30 : Cashed Cheque 20 : Voided Cheque 10 : New Cheque The Voided Check Usage Description can be one of the following: 00 : Blank Voided Cheque 01 : Issued Voided Cheque You can compare the Check Number with the Check Number From and Check Number To in CDS View I_APCheckbook to get the respective Checkbook ID and Checkbook Name . This CDS view provides the data to answer the following business questions: What is the status of an outgoing cheque? What are the payment details of an outgoing cheque? Is an outgoing cheque valid or voided? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations The following business catalog needs to be assigned to a user to be able to use this CDS view: Accounts Payable - Checks ( SAP_FIN_BC_AP_CHECK_PC )

Structure
Fields used for filtering The main filters are as follows: Payment Company Code used to filter by company codes Supplier used to filter by supplier IDs Payment Document used to filter by payment document IDs Outgoing Cheque used to filter by outgoing cheque numbers

View on SAP Help Portal →

SAP API Hub

Category	Basic
State	C1
Line of Business	Financial Operations
Application Component	FI-FIO-AP-2CL
Capabilities	Association Target for Defining CDS Entities,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Financial Operations for SAP S/4HANA Cloud Public Edition
Description	<p>This CDS view helps to retrieve the detailed information of outgoing cheques.</p> The Cheque Status Description can be one of the following:<ul> <li> <p>30: Cashed Cheque</p> </li> <li> <p>20: Voided Cheque</p> </li> <li> <p>10: New Cheque</p> </li> </ul> The Voided Check Usage Description can be one of the following:<ul> <li> <p>00: Blank Voided Cheque</p> </li> <li> <p>01: Issued Voided Cheque</p> </li> </ul> <p>You can compare the Check Number with the Check Number From and Check Number To in CDS View I_APCheckbook to get the respective Checkbook ID and Checkbook Name.</p> This CDS view provides the data to answer the following business questions:<ul> <li> <p>What is the status of an outgoing cheque?</p> </li> <li> <p>What are the payment details of an outgoing cheque?</p> </li> <li> <p>Is an outgoing cheque valid or voided?</p> </li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
P_OutgoingCheck	P_OutgoingCheck	from

Associations (5)

Cardinality	Target	Alias	Condition
[0..1]	I_CompanyCode	_Company	`_Company.CompanyCode = $projection.PaymentCompanyCode`
[0..1]	I_Housebank	_HouseBank	`_HouseBank.CompanyCode = $projection.PaymentCompanyCode and _HouseBank.HouseBank = $projection.HouseBank`
[1..*]	I_APVoidReasonText	_VoidReason	`_VoidReason.ChequeVoidReason = $projection.ChequeVoidReason`
[0..1]	I_Country	_Country	`_Country.Country = $projection.Country`
[0..1]	I_Supplier	_Supplier	`$projection.Supplier = _Supplier.Supplier`

Annotations (12)

Name	Value	Level
EndUserText.label	Outgoing Cheque	view
VDM.viewType	#BASIC	view
AbapCatalog.sqlViewName	IOUTGOINGCHECK	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.personalData.blocking	#REQUIRED	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (49)

Key	Field	Source Table	Source Field	Description
KEY	PaymentCompanyCode		PaymentCompanyCode	Paying Company Code
KEY	HouseBank		HouseBank	Short Key for a House Bank
KEY	HouseBankAccount		HouseBankAccount	ID for Account Details
KEY	PaymentMethod		PaymentMethod	Payment Method
KEY	OutgoingCheque		OutgoingCheque	Check number
	IsIntercompanyPayment		IsIntercompanyPayment	X - Intercompany Payment
	ChequeIsManuallyIssued		ChequeIsManuallyIssued	Valuate Manually
	ChequebookFirstCheque		ChequebookFirstCheque	Check Number From
	PaymentDocument		PaymentDocument	Document Number of the Payment Document
	ChequePaymentDate		ChequePaymentDate	Probable Payment Date (Cash Discount 1 Due)
	PaymentCurrency		PaymentCurrency	Payment Currency
	PaidAmountInPaytCurrency		PaidAmountInPaytCurrency	Payment Amount
	Supplier		Supplier	Customer Number
	PaymentDocPrintDate		PaymentDocPrintDate	Print Date
	PaymentDocPrintTime		PaymentDocPrintTime	Print Time
	ChequePrintDateTime		ChequePrintDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	PaymentDocPrintedByUser		PaymentDocPrintedByUser	Print User
	ChequeEncashmentDate		ChequeEncashmentDate	Check encashment date
	ChequeLastExtractDate		ChequeLastExtractDate	Date of Extract Creation
	ChequeLastExtractDateTime		ChequeLastExtractDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	PayeeTitle		PayeeTitle	Title of the payee
	PayeeName		PayeeName	Name of the payee
	PayeeAdditionalName		PayeeAdditionalName	Name of the payee
	PayeePostalCode		PayeePostalCode	Postal Code of the Payee
	PayeeCityName		PayeeCityName	City of the payee
	PayeeStreet		PayeeStreet	Street and house number of the payee
	PayeePOBox		PayeePOBox	P.O. box of the payee
	PayeePOBoxPostalCode		PayeePOBoxPostalCode	P.O. box postal code of the payee
	PayeePOBoxCityName		PayeePOBoxCityName	City of payee's PO box
	Country		Country	Country/Region Key
	Region		Region	Regional code of the payee
	ChequeVoidReason		ChequeVoidReason	Check void reason code
	ChequeVoidedDate		ChequeVoidedDate	Voided Check Date
	ChequeVoidedByUser		ChequeVoidedByUser	Voided check user
	ChequeIsCashed		ChequeIsCashed	X - Paid Check
	CashDiscountAmount		CashDiscountAmount	Total Cash Discount for the Pmnt Transactn in Pmnt Currency
	FiscalYear		FiscalYear	G/L Fiscal Year
	ChequeType		ChequeType	Type of Check for China Specific
	VoidedChequeUsage		VoidedChequeUsage
	ChequeStatus		ChequeStatus	Status of Check Document
	ChequeIssuingType		ChequeIssuingType	Outgoing Check Output Field
	BankName			Name of Financial Institution
	CompanyCodeCountry	_Company	Country	Country/Region Key
	CompanyCodeName	_Company	CompanyCodeName	Name of Company Code or Company
	_Country		_Country
	_Company		_Company
	_Supplier		_Supplier
	_VoidReason		_VoidReason
	_HouseBank		_HouseBank

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_OutgoingCheck.
-- 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: IOUTGOINGCHECK

CREATE VIEW I_OutgoingCheck AS
SELECT
  PaymentCompanyCode,
  HouseBank,
  HouseBankAccount,
  PaymentMethod,
  OutgoingCheque,
  IsIntercompanyPayment,
  ChequeIsManuallyIssued,
  ChequebookFirstCheque,
  PaymentDocument,
  ChequePaymentDate,
  PaymentCurrency,
  PaidAmountInPaytCurrency,
  Supplier,
  PaymentDocPrintDate,
  PaymentDocPrintTime,
  ChequePrintDateTime,
  PaymentDocPrintedByUser,
  ChequeEncashmentDate,
  ChequeLastExtractDate,
  ChequeLastExtractDateTime,
  PayeeTitle,
  PayeeName,
  PayeeAdditionalName,
  PayeePostalCode,
  PayeeCityName,
  PayeeStreet,
  PayeePOBox,
  PayeePOBoxPostalCode,
  PayeePOBoxCityName,
  Country,
  Region,
  ChequeVoidReason,
  ChequeVoidedDate,
  ChequeVoidedByUser,
  ChequeIsCashed,
  CashDiscountAmount,
  FiscalYear,
  ChequeType,
  VoidedChequeUsage,
  ChequeStatus,
  ChequeIssuingType,
  _HouseBank._Bank.BankName AS BankName,
  _Company.Country AS CompanyCodeCountry,
  _Company.CompanyCodeName AS CompanyCodeName
FROM P_OutgoingCheck
LEFT OUTER JOIN I_CompanyCode AS _Company ON _Company.CompanyCode = PaymentCompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Housebank AS _HouseBank ON _HouseBank.CompanyCode = PaymentCompanyCode AND _HouseBank.HouseBank = HouseBank  -- association [0..1]
LEFT OUTER JOIN I_APVoidReasonText AS _VoidReason ON _VoidReason.ChequeVoidReason = ChequeVoidReason  -- association [1..*]
LEFT OUTER JOIN I_Country AS _Country ON _Country.Country = Country  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
;

Depth:

I_OutgoingCheck view

P_OutgoingCheck view

C_OutgoingCheck view