I_BillOfExchangeUsageData

DDL: I_BILLOFEXCHANGEUSAGEDATA Type: view_entity COMPOSITE

Bill of Exchange Usage Data

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.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
I_BillOfExchange _BillOfExchange from

Annotations (11)

NameValueLevelField
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
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
KEY AccountingDocumentItem AccountingDocumentItem
Cheque Cheque
BillOfExchangeIssueDate BillOfExchangeIssueDate
BillOfExchangeUsageDate BillOfExchangeUsageDate
PlannedBillOfExchangeUsage PlannedBillOfExchangeUsage
BillOfExchangeDrawer BillOfExchangeDrawer
BillOfExchangeDrawerCityName BillOfExchangeDrawerCityName
BillOfExchangeDrawee BillOfExchangeDrawee
BillOfExchangeDraweeCityName BillOfExchangeDraweeCityName
BillOfExchangeIsAccepted BillOfExchangeIsAccepted
Region Region
BillOfExchangeDocumentStatus BillOfExchangeDocumentStatus
BillOfExchangeIsProtested BillOfExchangeIsProtested
BillOfExchangeIsOnDemand BillOfExchangeIsOnDemand
BusinessPlace BusinessPlace
BusinessSectionCode BusinessSectionCode
BillOfExchangePortfolio BillOfExchangePortfolio
BillOfExchangeDataAgingDate BillOfExchangeDataAgingDate
IsBusinessPurposeCompleted
AuthorizationGroup
BillOfExchangeUsageDocument _OperationalAcctgDocItem BillOfExchangeUsageDocument
BillOfExchangeUsage _OperationalAcctgDocItem BillOfExchangeUsage
_OperationalAcctgDocItem _OperationalAcctgDocItem 
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Bill of Exchange Usage Data'
@Metadata.ignorePropagatedAnnotations: true
@Analytics.dataExtraction.enabled: false
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.personalData.blockingIndicator: ['IsBusinessPurposeCompleted']
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XXL,
  dataClass: #MIXED
}
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities:  [  #CDS_MODELING_DATA_SOURCE,
//                                        #EXTRACTION_DATA_SOURCE,

                                        #CDS_MODELING_ASSOCIATION_TARGET,
                                        #SQL_DATA_SOURCE                ]
define view entity I_BillOfExchangeUsageData
  as select from I_BillOfExchange as _BillOfExchange
{
  key CompanyCode,
  key AccountingDocument,
  key FiscalYear,
  key AccountingDocumentItem,
      Cheque,
      BillOfExchangeIssueDate,
      BillOfExchangeUsageDate,
      PlannedBillOfExchangeUsage,
      BillOfExchangeDrawer,
      BillOfExchangeDrawerCityName,
      BillOfExchangeDrawee,
      BillOfExchangeDraweeCityName,
      @Semantics.booleanIndicator: true
      BillOfExchangeIsAccepted,
      Region,
      BillOfExchangeDocumentStatus,
      @Semantics.booleanIndicator: true
      BillOfExchangeIsProtested,
      @Semantics.booleanIndicator: true
      BillOfExchangeIsOnDemand,
      BusinessPlace,
      BusinessSectionCode,
      BillOfExchangePortfolio,
      BillOfExchangeDataAgingDate,
      @Semantics.booleanIndicator: true
      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,
      _OperationalAcctgDocItem
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLOFEXCHANGE",
"I_OPERATIONALACCTGDOCITEM"
],
"ASSOCIATED":
[
"I_OPERATIONALACCTGDOCITEM"
],
"BASE":
[
"I_BILLOFEXCHANGE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More