I_BILLOFEXCHANGE

CDS View

Bill of Exchange

I_BILLOFEXCHANGE is a CDS View in S/4HANA. Bill of Exchange. It contains 2 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 2 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_InventoryGLAcctBalCube view left_outer CONSUMPTION Turkey Inventory CDS cube view
I_BillOfExchangeUsageData view_entity from COMPOSITE Bill of Exchange Usage Data
P_AR_SuplrPaymentEndorsedCheck view_entity inner CONSUMPTION

Fields (2)

KeyField CDS FieldsUsed in Views
BillOfExchangeDomicileText EndorsedBankTaxNumber 1
Cheque Cheque 1 
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Bill of Exchange'
@Metadata.ignorePropagatedAnnotations: true
@Analytics.dataExtraction.enabled: true
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.personalData.blockingIndicator: ['IsBusinessPurposeCompleted']
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XXL,
  dataClass: #MIXED
}
@ObjectModel.supportedCapabilities:  [  #CDS_MODELING_DATA_SOURCE,
                                        #CDS_MODELING_ASSOCIATION_TARGET,
                                        #SQL_DATA_SOURCE,
                                        #EXTRACTION_DATA_SOURCE                ]
@ObjectModel.modelingPattern:           #ANALYTICAL_DIMENSION        
define view entity I_BillOfExchange as select from bsed
  association [1..1] to E_BillOfExchange          as _Extension               on  $projection.CompanyCode            = _Extension.CompanyCode
                                                                              and $projection.FiscalYear             = _Extension.FiscalYear
                                                                              and $projection.AccountingDocument     = _Extension.AccountingDocument
                                                                              and $projection.AccountingDocumentItem = _Extension.AccountingDocumentItem

  association [1..1] to I_OperationalAcctgDocItem as _OperationalAcctgDocItem on  $projection.CompanyCode            = _OperationalAcctgDocItem.CompanyCode
                                                                              and $projection.FiscalYear             = _OperationalAcctgDocItem.FiscalYear
                                                                              and $projection.AccountingDocument     = _OperationalAcctgDocItem.AccountingDocument
                                                                              and $projection.AccountingDocumentItem = _OperationalAcctgDocItem.AccountingDocumentItem
                                                                                         
{
  key bukrs                                                                           as CompanyCode,
  key belnr                                                                           as AccountingDocument,
  key cast(gjahr as fis_gjahr_no_conv preserving type)                                as FiscalYear,
  key buzei                                                                           as AccountingDocumentItem,
      cast(boeno as chect)                                                            as Cheque,
      wdate                                                                           as BillOfExchangeIssueDate,
      wverd                                                                           as BillOfExchangeUsageDate,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'PlannedBillOfExchangeUsage'
      cast( wevwv as farp_wverw preserving type )                                     as BillOfExchangeUsage,
      wevwv                                                                           as PlannedBillOfExchangeUsage,
      wname                                                                           as BillOfExchangeDrawer,
      wort1                                                                           as BillOfExchangeDrawerCityName,
      wbzog                                                                           as BillOfExchangeDrawee,
      wort2                                                                           as BillOfExchangeDraweeCityName,
      wbank                                                                           as BillOfExchangeDomicileText,
      @Semantics.booleanIndicator: true
      xaktz                                                                           as BillOfExchangeIsAccepted,
      regio                                                                           as Region,
      wstat                                                                           as BillOfExchangeDocumentStatus,
      @Semantics.booleanIndicator: true
      wgbkz                                                                           as BillOfExchangeIsProtested,
      @Semantics.booleanIndicator: true
      xsiwe                                                                           as BillOfExchangeIsOnDemand,
      bupla                                                                           as BusinessPlace,
      secco                                                                           as BusinessSectionCode,
      portf                                                                           as BillOfExchangePortfolio,
      _dataaging                                                                      as BillOfExchangeDataAgingDate,
      @Semantics.booleanIndicator: true
      cast( ' ' as cvp_xblck preserving type ) as IsBusinessPurposeCompleted,
      cast( '    ' as brgru preserving type ) as AuthorizationGroup,

      _OperationalAcctgDocItem
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BSED"
],
"ASSOCIATED":
[
"I_OPERATIONALACCTGDOCITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More