C_CN_ReqnPayNoteBillOfExchange

DDL: C_CN_REQNPAYNOTEBILLOFEXCHANGE SQL: CCNREQNPAYBOE Type: view CONSUMPTION
39 Fields 1 Data Sources

China Bill of Exchange document

C_CN_ReqnPayNoteBillOfExchange is a Consumption CDS View that provides data about "China Bill of Exchange document" in SAP S/4HANA. It reads from 1 data source (P_CN_REQNPAYNOTEBILLOFEXCHANGE) and exposes 39 fields with key field BillOfExchangeUUID.

Data Sources (1)

SourceAliasJoin Type
P_CN_REQNPAYNOTEBILLOFEXCHANGE boe from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CCNREQNPAYBOE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label China Bill of Exchange document view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY BillOfExchangeUUID P_CN_REQNPAYNOTEBILLOFEXCHANGE BillOfExchangeUUID
CompanyCode P_CN_REQNPAYNOTEBILLOFEXCHANGE CompanyCode Receiver Company Code
CompanyName
BillOfExchangeNumber P_CN_REQNPAYNOTEBILLOFEXCHANGE BillOfExchangeNumber BoE (Package) Number
BillOfExchangeStatus P_CN_REQNPAYNOTEBILLOFEXCHANGE BillOfExchangeStatus Bill of Exchange Status
BillOfExchangeType P_CN_REQNPAYNOTEBILLOFEXCHANGE BillOfExchangeType
IsOutgoingPayment P_CN_REQNPAYNOTEBILLOFEXCHANGE IsOutgoingPayment
BillOfExchangePostingStatus P_CN_REQNPAYNOTEBILLOFEXCHANGE BillOfExchangePostingStatus Posting Status
BillOfExchangeReceiveDate P_CN_REQNPAYNOTEBILLOFEXCHANGE BillOfExchangeReceiveDate
BillOfExchangeIssueDate P_CN_REQNPAYNOTEBILLOFEXCHANGE BillOfExchangeIssueDate
BillOfExchangeDrawer P_CN_REQNPAYNOTEBILLOFEXCHANGE BillOfExchangeDrawer
BOEDrawerBankKey P_CN_REQNPAYNOTEBILLOFEXCHANGE BOEDrawerBankKey Drawer Bank Key
BOEDrawerBankCountryKey P_CN_REQNPAYNOTEBILLOFEXCHANGE BOEDrawerBankCountryKey Drawer Bank Country/Region
BOEDrawerBankName P_CN_REQNPAYNOTEBILLOFEXCHANGE BOEDrawerBankName Drawer Bank Name
BillOfExchangeDrawee P_CN_REQNPAYNOTEBILLOFEXCHANGE BillOfExchangeDrawee
BOEDraweeBankKey P_CN_REQNPAYNOTEBILLOFEXCHANGE BOEDraweeBankKey Drawee Bank key
BOEDraweeBankCountryKey P_CN_REQNPAYNOTEBILLOFEXCHANGE BOEDraweeBankCountryKey Drawee Bank Country/Region
BOEDraweeBankName P_CN_REQNPAYNOTEBILLOFEXCHANGE BOEDraweeBankName Drawee Name
BOEAcceptanceBankName P_CN_REQNPAYNOTEBILLOFEXCHANGE BOEAcceptanceBankName Acceptance Bank Name
BOEAcceptanceBankKey P_CN_REQNPAYNOTEBILLOFEXCHANGE BOEAcceptanceBankKey Acceptance Bank Key
BOEAcceptanceBankCountryKey P_CN_REQNPAYNOTEBILLOFEXCHANGE BOEAcceptanceBankCountryKey Acceptance Bank Country/Region
BillOfExchangeDueDate P_CN_REQNPAYNOTEBILLOFEXCHANGE BillOfExchangeDueDate Due Date
BillOfExchangeAmtInTransCrcy P_CN_REQNPAYNOTEBILLOFEXCHANGE BillOfExchangeAmtInTransCrcy
Currency P_CN_REQNPAYNOTEBILLOFEXCHANGE Currency Valuation Crcy
Supplier P_CN_REQNPAYNOTEBILLOFEXCHANGE Supplier Supplier
SupplierName
BPSupplierName
Customer P_CN_REQNPAYNOTEBILLOFEXCHANGE Customer Sold-to Party
CustomerName
BPCustomerName
ProfitCenter P_CN_REQNPAYNOTEBILLOFEXCHANGE ProfitCenter Profit Center
BillOfExchangeIsBlocked P_CN_REQNPAYNOTEBILLOFEXCHANGE BillOfExchangeIsBlocked Lock
BillOfExchangeBlockingTypeText P_CN_REQNPAYNOTEBILLOFEXCHANGE BillOfExchangeBlockingTypeText
BlockReasonDesc P_CN_REQNPAYNOTEBILLOFEXCHANGE BlockReasonDesc Lock Reason
ReferenceTransactionCode P_CN_REQNPAYNOTEBILLOFEXCHANGE ReferenceTransactionCode
BillOfExchangeIsAllowSplit P_CN_REQNPAYNOTEBILLOFEXCHANGE BillOfExchangeIsAllowSplit Allow Split
BillOfExchangePackageRangeFrom P_CN_REQNPAYNOTEBILLOFEXCHANGE BillOfExchangePackageRangeFrom Subpackage Range From
BillOfExchangePackageRangeTo P_CN_REQNPAYNOTEBILLOFEXCHANGE BillOfExchangePackageRangeTo Subpackage Range To
BillOfExchangePackageIsActive P_CN_REQNPAYNOTEBILLOFEXCHANGE BillOfExchangePackageIsActive

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 C_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: CCNREQNPAYBOE

CREATE VIEW C_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.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
FROM P_CN_REQNPAYNOTEBILLOFEXCHANGE AS boe
;

Learn More