What is I_BillOfExchangeUsageData in SAP S/4HANA?

I_BillOfExchangeUsageData is a composite CDS view in SAP S/4HANA. Bill of Exchange Usage Data It contains 26 fields.

Which tables does I_BillOfExchangeUsageData read from?

I_BillOfExchangeUsageData reads data from: I_BillOfExchange.

What VDM layer is I_BillOfExchangeUsageData?

I_BillOfExchangeUsageData is classified as a Composite view that combines data from multiple basic views.

I_BillOfExchangeUsageData

DDL: I_BILLOFEXCHANGEUSAGEDATA Type: view_entity COMPOSITE Package: GLO_FIN_BOE_POSTING

26 Fields 1 Data Sources

Bill of Exchange Usage Data

I_BillOfExchangeUsageData (Composite)

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

Country or Region-Specific Functions for Finance

I_BillOfExchangeUsageData is a Composite CDS View that provides data about "Bill of Exchange Usage Data" in SAP S/4HANA. It reads from 1 data source (I_BillOfExchange) and exposes 26 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem. Part of development package GLO_FIN_BOE_POSTING.

SAP Help Documentation

Category	Bill of Exchange

Purpose
This CDS view provides access to all details of bill of exchange data in database table BSED and BESG . This CDS view provides the data to answer the following business questions: What is the bill of exchange number of a bill of exchange document? What is the status of a bill of exchange document? Who is the drawer of a bill of exchange document? What is the usage data of a bill of exchange document? 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 Users who want to use this CDS view must have a role with the following restriction types set to read access: BUKRS (Company Code) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Parameters The parameters of the CDS view are as follows: CompanyCode : This parameter is used to represent company code of bills of exchange. AccountingDocument : This parameter is used to represent accounting document number of bills of exchange. FiscalYear : This parameter is used to represent fiscal year of bills of exchange. AccountingDocumentItem : This parameter is used to represent accounting document item number of bills of exchange. Cheque : This parameter is used to represent number of bills of exchange. BillOfExchangeIssueDate : This parameter is used to represent issue date of bills of exchange. BillOfExchangeUsageDate : This parameter is used to represent usage date of bills of exchange. PlannedBillOfExchangeUsage : This parameter is used to represent planned usage of bills of exchange. BillOfExchangeDrawer : This parameter is used to represent drawer name of bills of exchange. BillOfExchangeDrawerCityName : This parameter is used to represent drawer city name of bills of exchange. BillOfExchangeDrawee : This parameter is used to represent drawee name of bills of exchange. BillOfExchangeDraweeCityName : This parameter is used to represent drawee city name of bills of exchange. BillOfExchangeIsAccepted : This parameter is used to indicate whether a bill of exchange is accepted. Region : This parameter is used to represent the region code of journal entries. BillOfExchangeDocumentStatus : This parameter is used to represent document segment status of bills of exchange. BillOfExchangeIsProtested : This parameter is used to indicate whether a bill of exchange is protested. BillOfExchangeIsOnDemand : This parameter is used to indicate whether a bill of exchange is on demand. BusinessPlace : This parameter is used to represent business place. BusinessSectionCode : This parameter is used to represent business section code. BillOfExchangePortfolio : This parameter is used to represent bill of exchange portfolio, Typically, each branch of a business has its own portfolio, possibly with separate portfolios for long-term and short-term checks and bills. Each portfolio is linked to an account for bills receivable. BillOfExchangeDataAgingDate : This parameter is used to represent data aging date of bills of exchange. IsBusinessPurposeCompleted : This parameter is used to indicate whether the business purpose is completed. AuthorizationGroup : This parameter is used to represent the authorization group for accessing usage data of bills of exchange. • • BillOfExchangeUsageDocument : This parameter is used to represent usage document of bills of exchange. • • BillOfExchangeUsage : This parameter is used to represent usage type of bills of exchange.

View on SAP Help Portal →

SAP API Hub

Category	Composite
State	C1
Line of Business	Country or Region-Specific Functions for Finance
Application Component	FI-LOC-BOE
Capabilities	Data Source for Defining CDS Entities,Association Target for Defining CDS Entities,Data Source in SQL Select
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Country/Region-Specific Functions for Finance for SAP S/4HANA Cloud Public Edition
Description	<p>This CDS view provides access to all details of bill of exchange data in database table BSED and BESG.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What is the bill of exchange number of a bill of exchange document?</p></li> <li><p>What is the status of a bill of exchange document?</p></li> <li><p>Who is the drawer of a bill of exchange document?</p></li> <li><p>What is the usage data of a bill of exchange document?</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
I_BillOfExchange	_BillOfExchange	from

Annotations (10)

Name	Value	Level
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Bill of Exchange Usage Data	view
Metadata.ignorePropagatedAnnotations	true	view
Analytics.dataExtraction.enabled	false	view
AccessControl.personalData.blocking	#REQUIRED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (26)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode		CompanyCode	Receiver Company Code
KEY	AccountingDocument		AccountingDocument	Document Number of an Accounting Document
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	AccountingDocumentItem		AccountingDocumentItem	Number of Line Item Within Accounting Document
	Cheque		Cheque	Check number
	BillOfExchangeIssueDate		BillOfExchangeIssueDate	Bill of Exchange Issue Date
	BillOfExchangeUsageDate		BillOfExchangeUsageDate	Date of Bill of Exchange Usage
	PlannedBillOfExchangeUsage		PlannedBillOfExchangeUsage	Planned Usage of the Bill of Exchange
	BillOfExchangeDrawer		BillOfExchangeDrawer	Name of Bill of Exchange Drawer
	BillOfExchangeDrawerCityName		BillOfExchangeDrawerCityName	City of Bill of Exchange Drawer
	BillOfExchangeDrawee		BillOfExchangeDrawee	Bill of Exchange Drawee
	BillOfExchangeDraweeCityName		BillOfExchangeDraweeCityName	City of Bill of Exchange Drawee
	BillOfExchangeIsAccepted		BillOfExchangeIsAccepted	Indicator: Bill of Exchange Was Accepted
	Region		Region	Region (State, Province, County)
	BillOfExchangeDocumentStatus		BillOfExchangeDocumentStatus	Bill of Exchange Status
	BillOfExchangeProtest		BillOfExchangeProtest	Indicator for the Bill of Exchange Protest
	BillOfExchangeIsOnDemand		BillOfExchangeIsOnDemand	Indicator: Bill on Demand
	BusinessPlace		BusinessPlace	Business place
	BusinessSectionCode		BusinessSectionCode	Section Code
	BillOfExchangePortfolio		BillOfExchangePortfolio	Bill of Exchange Portfolio
	BillOfExchangeDataAgingDate		BillOfExchangeDataAgingDate	Data Filter Value for Data Aging
	IsBusinessPurposeCompleted			Business Purpose Completed Flag
	AuthorizationGroup			Authorization Group
	BillOfExchangeUsageDocument	_OperationalAcctgDocItem	BillOfExchangeUsageDocument	Bill of Exchange Usage Document
	BillOfExchangeUsage	_OperationalAcctgDocItem	BillOfExchangeUsage	Bill of Exchange Usage Type
	_OperationalAcctgDocItem		_OperationalAcctgDocItem

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_BillOfExchangeUsageData.
-- 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_BillOfExchangeUsageData AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  Cheque,
  BillOfExchangeIssueDate,
  BillOfExchangeUsageDate,
  PlannedBillOfExchangeUsage,
  BillOfExchangeDrawer,
  BillOfExchangeDrawerCityName,
  BillOfExchangeDrawee,
  BillOfExchangeDraweeCityName,
  BillOfExchangeIsAccepted,
  Region,
  BillOfExchangeDocumentStatus,
  BillOfExchangeProtest,
  BillOfExchangeIsOnDemand,
  BusinessPlace,
  BusinessSectionCode,
  BillOfExchangePortfolio,
  BillOfExchangeDataAgingDate,
  cast ( IsBusinessPurposeCompleted as cvp_xblck preserving type ) AS IsBusinessPurposeCompleted,
  cast ( AuthorizationGroup as brgru preserving type ) AS AuthorizationGroup,
  _OperationalAcctgDocItem.BillOfExchangeUsageDocument AS BillOfExchangeUsageDocument,
  _OperationalAcctgDocItem.BillOfExchangeUsage AS BillOfExchangeUsage
FROM I_BillOfExchange AS _BillOfExchange
;

Depth:

I_BillOfExchangeUsageData view_entity

I_BillOfExchange view_entity