P_CN_REQNPAYNOTEBILLOFEXCHANGE

DDL: P_CN_REQNPAYNOTEBILLOFEXCHANGE SQL: PCNREQNPAYBOE Type: view COMPOSITE Package: GLO_FIN_PAY_REQN_CN
45 Fields 1 Data Sources

China Bill of Exchange document

P_CN_REQNPAYNOTEBILLOFEXCHANGE is a Composite CDS View that provides data about "China Bill of Exchange document" in SAP S/4HANA. It reads from 1 data source (I_CN_BillOfExchange) and exposes 45 fields with key field BillOfExchangeUUID. Part of development package GLO_FIN_PAY_REQN_CN.

Data Sources (1)

SourceAliasJoin Type
I_CN_BillOfExchange boe from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCNREQNPAYBOE view
AbapCatalog.compiler.compareFilter true view
EndUserText.label China Bill of Exchange document view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY BillOfExchangeUUID I_CN_BillOfExchange BillOfExchangeUUID UUID
CompanyCode I_CN_BillOfExchange CompanyCode Receiver Company Code
CompanyName
BillOfExchangeNumber I_CN_BillOfExchange BillOfExchangeNumber BoE Number
BillOfExchangeStatus I_CN_BillOfExchange BillOfExchangeStatus Bill of Exchange Sta
BillOfExchangeType I_CN_BillOfExchange BillOfExchangeType Acceptance Type
IsOutgoingPayment I_CN_BillOfExchange IsOutgoingPayment BoE Kind
BillOfExchangePostingStatus I_CN_BillOfExchange BillOfExchangePostingStatus FI Status
BillOfExchangeReceiveDate I_CN_BillOfExchange BillOfExchangeReceiveDate Receive Date
BillOfExchangeIssueDate I_CN_BillOfExchange BillOfExchangeIssueDate Issue Date
BillOfExchangeDrawer I_CN_BillOfExchange BillOfExchangeDrawer Drawer
BOEDrawerBankKey I_CN_BillOfExchange BOEDrawerBankKey BOE Drawer Bank Key
BOEDrawerBankCountryKey I_CN_BillOfExchange BOEDrawerBankCountryKey Bank Ctry/Reg.
BOEDrawerBankName I_CN_BillOfExchange BOEDrawerBankName Bank Name
BillOfExchangeDrawee I_CN_BillOfExchange BillOfExchangeDrawee Drawee
BOEDraweeBankKey I_CN_BillOfExchange BOEDraweeBankKey BOE Drawee Bank Key
BOEDraweeBankCountryKey I_CN_BillOfExchange BOEDraweeBankCountryKey Bank Ctry/Reg.
BOEDraweeBankName I_CN_BillOfExchange BOEDraweeBankName Bank Name
BOEAcceptanceBankName I_CN_BillOfExchange BOEAcceptanceBankName Bank Name
BOEAcceptanceBankKey I_CN_BillOfExchange BOEAcceptanceBankKey BOE Accptc Bank Key
BOEAcceptanceBankCountryKey I_CN_BillOfExchange BOEAcceptanceBankCountryKey Bank Ctry/Reg.
BillOfExchangeDueDate I_CN_BillOfExchange BillOfExchangeDueDate Payment date
BillOfExchangeAmtInTransCrcy I_CN_BillOfExchange BillOfExchangeAmtInTransCrcy Gross Amount
Currency I_CN_BillOfExchange Currency Valuation Crcy
Supplier I_CN_BillOfExchange Supplier Supplier
SupplierName
BPSupplierName
Customer I_CN_BillOfExchange Customer Sold-to Party
CustomerName
BPCustomerName
ProfitCenter I_CN_BillOfExchange ProfitCenter Profit Center
BillOfExchangeIsBlocked I_CN_BillOfExchange BillOfExchangeIsBlocked BoE Blocked
BillOfExchangeBlockingTypeText
BlockReasonDesc I_CN_BillOfExchange BlockReasonDesc Block Reason
ReferenceTransactionCode I_CN_BillOfExchange ReferenceTransactionCode Transaction Name
BillOfExchangeIsAllowSplit I_CN_BillOfExchange BillOfExchangeIsAllowSplit BoE Split
BillOfExchangePackageRangeFrom I_CN_BillOfExchange BillOfExchangePackageRangeFrom Range Lower
BillOfExchangePackageRangeTo I_CN_BillOfExchange BillOfExchangePackageRangeTo Range Upper
BillOfExchangePackageIsActive I_CN_BillOfExchange BillOfExchangePackageIsActive
BusinessTransactionDocUUID
_Company I_CN_BillOfExchange _Company
_Customer I_CN_BillOfExchange _Customer
_BillOfExchangeStatusText I_CN_BillOfExchange _BillOfExchangeStatusText
_BillOfExchangeBlockText I_CN_BillOfExchange _BillOfExchangeBlockText
_Supplier I_CN_BillOfExchange _Supplier

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 P_CN_REQNPAYNOTEBILLOFEXCHANGE.
-- 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: PCNREQNPAYBOE

CREATE VIEW P_CN_REQNPAYNOTEBILLOFEXCHANGE AS
SELECT
  boe.BillOfExchangeUUID AS BillOfExchangeUUID,
  boe.CompanyCode AS CompanyCode,
  boe._Company.CompanyCodeName AS CompanyName,
  boe.BillOfExchangeNumber AS BillOfExchangeNumber,
  boe.BillOfExchangeStatus AS BillOfExchangeStatus,
  boe.BillOfExchangeType AS BillOfExchangeType,
  boe.IsOutgoingPayment AS IsOutgoingPayment,
  boe.BillOfExchangePostingStatus AS BillOfExchangePostingStatus,
  boe.BillOfExchangeReceiveDate AS BillOfExchangeReceiveDate,
  boe.BillOfExchangeIssueDate AS BillOfExchangeIssueDate,
  boe.BillOfExchangeDrawer AS BillOfExchangeDrawer,
  boe.BOEDrawerBankKey AS BOEDrawerBankKey,
  boe.BOEDrawerBankCountryKey AS BOEDrawerBankCountryKey,
  boe.BOEDrawerBankName AS BOEDrawerBankName,
  boe.BillOfExchangeDrawee AS BillOfExchangeDrawee,
  boe.BOEDraweeBankKey AS BOEDraweeBankKey,
  boe.BOEDraweeBankCountryKey AS BOEDraweeBankCountryKey,
  boe.BOEDraweeBankName AS BOEDraweeBankName,
  boe.BOEAcceptanceBankName AS BOEAcceptanceBankName,
  boe.BOEAcceptanceBankKey AS BOEAcceptanceBankKey,
  boe.BOEAcceptanceBankCountryKey AS BOEAcceptanceBankCountryKey,
  boe.BillOfExchangeDueDate AS BillOfExchangeDueDate,
  boe.BillOfExchangeAmtInTransCrcy AS BillOfExchangeAmtInTransCrcy,
  boe.Currency AS Currency,
  boe.Supplier AS Supplier,
  boe._Supplier.SupplierName AS SupplierName,
  boe._Supplier.BPSupplierName AS BPSupplierName,
  boe.Customer AS Customer,
  boe._Customer.CustomerName AS CustomerName,
  boe._Customer.BPCustomerName AS BPCustomerName,
  boe.ProfitCenter AS ProfitCenter,
  boe.BillOfExchangeIsBlocked AS BillOfExchangeIsBlocked,
  boe._BillOfExchangeBlockText[1: Language = $session.system_language].BillOfExchangeBlockingTypeText AS BillOfExchangeBlockingTypeText,
  boe.BlockReasonDesc AS BlockReasonDesc,
  boe.ReferenceTransactionCode AS ReferenceTransactionCode,
  boe.BillOfExchangeIsAllowSplit AS BillOfExchangeIsAllowSplit,
  boe.BillOfExchangePackageRangeFrom AS BillOfExchangePackageRangeFrom,
  boe.BillOfExchangePackageRangeTo AS BillOfExchangePackageRangeTo,
  boe.BillOfExchangePackageIsActive AS BillOfExchangePackageIsActive,
  bintohex( PaymentNote.BusinessTransactionDocUUID ) AS BusinessTransactionDocUUID,
  boe._Company AS _Company,
  boe._Customer AS _Customer,
  boe._BillOfExchangeStatusText AS _BillOfExchangeStatusText,
  boe._BillOfExchangeBlockText AS _BillOfExchangeBlockText,
  boe._Supplier AS _Supplier
FROM I_CN_BillOfExchange AS boe
;

Learn More